hotskills.tech

About Job

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 perk: Posted At: 12 hours ago, job perk: Schedule Type: Full-time