Job Title: Data Analyst
Location: Huntsville, AL (On-site up to 5 days a week)
Relocation assistance available for qualified candidates
Salary Range: $100,000 - $130,000
Top Technical Skills (Must Haves):
- Active Secret Clearance
-
Power BI proficiency, including dashboards, reports, and advanced DAX (Data Analysis Expressions) for real-time data calculations and analysis.
- Strong SQL knowledge for data extraction and analysis.
- Experience with data modeling and ETL processes.
- Proven experience in data analysis, visualization, and reporting, preferably in a government or defense-related environment.
Job Overview:
We are seeking a highly analytical and detail-oriented Data Analyst to support a government customer and multiple teams within the program. This role primarily focuses on providing data visualization solutions and advanced Power BI analytics for the Control Systems team. The ideal candidate will possess strong technical skills, problem-solving abilities, and excellent organizational capabilities to drive data-driven decision-making.
In addition to core responsibilities, the Data Analyst will collaborate with multiple teams, assist in various initiatives, and contribute to workflow optimization to ensure program success.
Key Responsibilities:
Data Analysis and Visualization:
- Conduct research, planning, analysis, and organization of technical and statistical data for reports, briefings, and publications.
- Integrate data from multiple sources to generate accurate, actionable insights.
- Utilize Power BI to develop dynamic dashboards and interactive reports.
- Optimize Power BI solutions using advanced DAX functions and real-time data filtering.
- Connect and integrate data from various sources using APIs for seamless visualization.
- Define and monitor Key Performance Indicators (KPIs) aligned with program objectives.
Data Modeling and Reporting:
- Design, develop, and maintain complex data models to enhance business intelligence capabilities.
- Create, test, and deploy Power BI scripts using advanced DAX queries.
- Develop and optimize SQL queries for data extraction, transformation, and analysis.
- Document data workflows, algorithms, and parameters to ensure clarity and reproducibility.
Program Support:
- Coordinate with stakeholders, facilitate meetings and working groups, and support Control Systems team objectives.
- Track, monitor, and complete tasks in ETMS2, ensuring alignment with program goals.
- Maintain program documentation, organize files, and manage briefing schedules.
- Develop and deliver clear, concise, and compelling presentations that communicate complex data insights.
- Utilize data visualizations, charts, and graphs to enhance clarity and impact.
- Collaborate with cross-functional teams to refine content and ensure accuracy.
ETL and Data Management:
- Analyze and optimize ETL processes to improve data flow efficiency and reliability.
- Design and implement new ETL solutions for streamlined data extraction and transformation.
- Maintain data integrity, accuracy, and consistency across multiple sources.
- Define data requirements and align ETL processes with program objectives.
Ideal Candidate Profile:
- Strong problem-solving and analytical skills.
- Ability to translate business needs into technical solutions.
- Experience working in government or defense-related environments.
- Excellent communication and collaboration skills.
- Highly organized and able to manage multiple priorities in a fast-paced setting.
If you are a data-driven professional with expertise in Power BI, SQL, ETL processes, and data visualization, we encourage you to apply!