Senior Data Engineer/Data Analyst Job at IGNITE, Huntsville, AL

VE1STmlJbkp2c1B0NGVhVDdVd2RvR2hUZFE9PQ==
  • IGNITE
  • Huntsville, AL

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,

Similar Jobs

Domino's

Delivery Driver06206 - 2930 W Jewell Avenue Job at Domino's

ABOUT THE JOB Do you know why Dominos Pizza hires so many drivers Well aside from the fact that our delicious pizza is the perfect solution for dinner for families all across the nation we do it because we can. What do we mean by that you ask We mean that we offer a...

Freelance

Virtual Assistant Job at Freelance

 ...Agency Role Description This is a full-time role for a Virtual Assistant. The Virtual Assistant will be responsible for managing...  ...Proficiency in Microsoft Office Suite and Google Workspace Experience in a virtual assistant or administrative support role is a plus... 

Washington State University

Teaching Assistant Professor-Career Track, School of Economic Sciences, College of Agricultural, Human, and Natural Resource Sciences, Vancouver Campus | Washington State University Job at Washington State University

 ...to undergraduate students, with minimal research expectations that may focus on teaching...  ...issues of just, equitable, and inclusive education Preferred Qualifications...  .... More information on WSU's policies and procedures to respond to discrimination... 

Marvel Medical Staffing

Travel Nurse RN - PICU in Orange, CA Job at Marvel Medical Staffing

Specialty: PICU RN Location: Orange, CA Start date: ASAP Shifts per week: Duration: 13 weeks Shift type: Nights Weekly gross pay: Contact us for more information

MSCCN

Meter Service Rep_Canarsie Job at MSCCN

 ...are bound by the terms of the collective bargaining agreement as well as other agreements between the Company and the local union.National Grid is an equal opportunity employer that values a broad diversity of talent, knowledge, experience and expertise. We foster a...