SR. DATA ENGINEER / DATA ANALYST

Job Description

Ignite is an ISO 9001 : 2015 and CMMI Services Level 3 certified, Service-Disabled Veteran-Owned Small Business (SDVOSB), headquartered in Huntsville, AL. By design, Ignite is a provider of professional services to customers in educational, federal, and commercial industries and in every action seeks to be the preeminent provider within this business space. Ignite upholds our values of competency, collaboration, innovation, reliability, and results through everything we do.

Ignite Fueling Innovations is seeking an experienced Senior-level Data Engineer – Data Analyst with an active SECRET clearance to support our government customer on-site in Huntsville, AL.

Position Overview :

Under the guidance of the Program Manager, assists in achieving data analysis milestones under an agile design and development process. The Data Engineer-Analyst must manage data analytics projects using Power BI to design and develop business intelligence solution efforts to support multiple complex Line of Business (LoB) projects. The Data Engineer-Analyst will partner with and assist project teams, including the Power Platform Developers, through all phases of the application development process in a DoD secure environment. Data Engineer-Analyst will develop, support, test, and maintain functionality, resolve issues, and enhance security. Position is a weekly hybrid schedule consisting of 3 days on-site and 2 days remote.

Essential Functions, Responsibilities & Duties may include, but are not limited to :

• Analyze business requirements, functional requirements, and data specifications to develop.
• Business Intelligence solutions that leverage MS SQL Server, Power Application, and Power BI. Design and build reporting and transactional models. Develop dashboards utilizing Power BI connecting to a SQL database. Develop SQL procedures to perform data transformation.
• Troubleshoot BI tools, systems, and software, including the timely resolution of production issues.
• Must be familiar and efficient with the following transformation and load functions in Power BI software : Selecting appropriate column data types. Creating and transforming columns. Grouping and aggregating rows. Pivot, unpivot, and transpose data. Convert semi-structured data to a table. Create fact tables and dimension tables. Identify when to use reference or duplicate queries and the resulting impact. Merge and append queries. Identify and create appropriate keys for relationships. Configure data loading for queries.
• Proficient using Power Query and Data Analysis Expressions (DAX).
• Experience installing, configuring, and maintaining Power BI On-Prem Data Gateway.
• Must possess excellent verbal and written communication skills, proven business acumen, exceptional interpersonal capabilities and possess an attention to detail.
• Accomplish computing environment certificate relevant to the roles specified within six months of onboarding, specifically the PL-300, Power BI Data Analyst, or equivalent.
• Provide meaningful business value through easy-to-comprehend data solutions and visualizations.
• Prepare, Model, Visualize, and Analyze data to provide relevant reporting capabilities based on customer and business needs.
• Collaborate with analytics and solutions teams to identify and acquire data as well as contribute to solution design and architecture reviews.
• Incorporate all DOD security requirements at every level of modernization.
• Demonstrated understanding of database architecture design patterns and complete application development lifecycle.
• Hands on experience building end-to-end data and analytics solutions in each of the following areas : data modeling, data warehousing, reporting, and analytics.
• Develop, document, and implement data models for transactional systems and / or reporting solution and dashboards.

Job Requirements

Work Experience, Knowledge, Skills & Abilities :

Other Responsibilities :

We are equal opportunity / affirmative action employers, committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, disability, or protected veteran status, or any other protected characteristic under state or local law. Accommodation Request : If you are a qualified individual with a disability or are a disabled veteran and are unable or limited in your ability to use or access our Careers sites as a result of your disability, you have the right to receive assistance in completing the application process. Please send your request to