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
Work experience placement, Interim role,