Job Requirements
Tools & Technologies:
- Power BI (Primary Skill)
- SQL Databases
- Microsoft Excel (Advanced)
- Tableau (Secondary / Nice to Have)
- Python (Optional Advantage)
Job Summary
We are seeking a detail-oriented mid-level Data Analyst to support operations and engineering program management through data analysis, dashboard development, and actionable insights. The role involves building and maintaining Power BI dashboards, analyzing operational and financial datasets, and collaborating with cross-functional teams to enable data-driven decision making for project performance, cost management, and capacity planning.
Key Roles & Responsibilities
- Perform data exploration, querying, and analysis using SQL and Excel
- Extract, clean, manipulate, and integrate datasets from multiple data sources
- Ensure data accuracy, consistency, integrity, and conduct data quality checks
- Identify anomalies, inconsistencies, and validate datasets against source systems
- Analyze operational and financial data including cost, utilization, and performance metrics
- Design, develop, and maintain interactive dashboards using Power BI
- Build dashboards such as EAC Erosion, LCV Risk, Demand-Capacity, VSL, Hoshin, and Kaizen
- Convert complex datasets into clear visual insights for leadership decision-making
- Support ad-hoc reporting and deliver timely insights for operational planning
- Consolidate and transform data from SQL databases and operational systems
- Support automation initiatives and improve reporting processes using Excel or Python
- Review existing dashboards, SQL queries, and data pipelines to understand data flows
- Reverse engineer dashboards and reports to maintain and enhance reporting solutions
- Identify opportunities to optimize or consolidate reporting assets and dashboards
- Collaborate with program managers, engineers, analysts, and business stakeholders
- Respond to user queries related to dashboards, reports, and data discrepancies
- Translate analytical findings into clear insights for technical and non-technical users
- Participate in operational meetings and support regular reporting cycles
- Communicate project status, risks, dependencies, and escalate issues when necessary
Collaborate with project engineers to build Powe BI dashboards that consolidate data from multiple sources (including SQL databases) to support:
- Detailed engineering data studies
- Process improvement initiatives
- Automation projects
- Translate complex data into clear, actionable insights for leadership teams.
- Ensure accuracy, consistency, and integrity of dashboard content by validating against source systems.
Work Experience
Required Qualifications:
- Bachelor's degree in Engineering, Data Analytics, Computer Science, or related field.
- 35 years of professional experience in data analysis or business analytics
- Strong proficiency in SQL for querying, joining, and manipulating datasets
- Hands-on experience developing dashboards using Power BI
- Advanced Microsoft Excel skills (pivot tables, formulas, data modeling, analysis)
- Experience cleaning, integrating, and validating data from multiple sources
- Strong analytical, problem-solving, and data interpretation skills
- Ability to translate complex data into actionable insights for business stakeholders
Desired Skills & Characteristics
Technical Skills
- Experience with Power BI for advanced visualization and dashboard development
- Basic to intermediate Python for automation and advanced analytics
- Ability to interpret complex SQL queries and understand data lineage
- Experience reviewing and maintaining existing dashboards and reporting frameworks
- Familiarity with operational metrics reporting and engineering data environments
Soft Skills & Competencies
- Strong stakeholder communication and collaboration skills
- Ability to explain technical data concepts to non-technical audiences
- Analytical mindset with strong attention to detail
- Ability to manage multiple priorities and meet tight deadlines
- Self-motivated, proactive, and adaptable in a dynamic environment
- Strong problem-solving and continuous improvement mindset
