Job Description

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 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 solutions and dashboards.

Job Requirements

Work Experience, Knowledge, Skills & Abilities:

• Education: BS or equivalent experience in Computer Science, Data Engineering, Management, or Computer Information Systems (MIS or CIS) or
• Experience: 72 months related experience specific to the position requirements
• Certification: Must hold/obtain a CompTIA Security+ Certificate, or higher, prior to onboarding
• Clearance: Must have Active, Interim, or capable of obtaining SECRET before joining

Other Responsibilities:

• Perform other duties as assigned.

Job Tags

Similar Jobs