Power BI Developer / Senior Data Analytics in Santa Fe Springs, California at Advanced Ground Systems Engineering LLC

Job Summary

As a Power BI Developer / Senior Data Analytics professional, you will be responsible for transforming complex datasets into actionable insights that drive strategic decision-making across the organization. You will partner closely with Operations, Finance, Engineering, Sales, and Executive Leadership to design robust dashboards, automate reporting pipelines, and elevate the company’s business intelligence capabilities.

Job Responsibilities

• Business Intelligence Development – Design, develop, and maintain interactive Power BI dashboards, reports, and data models optimized for performance and usability.
• Data Modeling & Architecture – Build efficient semantic models, create relationships, implement row-level security, and apply DAX to support advanced analytics.
• Data Integration – Extract, transform, and load (ETL) datasets from ERP, CRM, SaaS platforms, SQL databases, APIs, and flat files using Power Query, SQL, and automation tools.
• Analytics & Insights – Conduct deep-dive analyses, identify key trends, forecast outcomes, and translate business questions into data-driven recommendations.
• Process Automation – Automate manual reporting processes through Power BI, Power Automate, and scheduled data refresh strategies.
• Cross-Functional Collaboration – Work directly with Operations, Supply Chain, Engineering, Manufacturing, and Executive stakeholders to define KPIs, requirements, and success metrics.
• Data Governance & Quality – Ensure data accuracy, consistency, and compliance through validation, documentation, and best-practice governance standards.
• Performance Optimization – Troubleshoot and optimize large data models, complex DAX expressions, and slow-performing reports.
• User Training & Adoption – Provide training, documentation, and best-practice guidance to end-users and departmental leaders to increase BI adoption.
• Project Delivery – Lead analytics initiatives from concept to deployment, ensuring on-time delivery and alignment with business objectives.
• Advanced Reporting – Create paginated reports, drill-through views, comparative dashboards, and automated KPI scorecards.
• ERP Analytics Support – Partner with the ERP team to extract and analyze production, inventory, purchasing, and financial datasets.
• Data Strategy Support – Help define long-term BI strategy, tool standardization, and company-wide reporting frameworks.
• Stakeholder Communication – Present insights, trends, and recommendations to leadership in a clear and compelling manner.
• Documentation & Compliance – Develop SOPs, data dictionaries, architectural diagrams, and reporting standards for cross-team consumption.

• Bachelor’s degree in Data Analytics, Information Systems, Computer Science, or related field (or equivalent experience).
• 3+ years of experience developing Power BI dashboards and analytics solutions.
• Strong proficiency with Power BI Desktop, Power BI Service, DAX, and Power Query.
• Experience with data modeling, relational databases, and SQL query development.
• Demonstrated ability to work with large datasets and complex, multi-source data pipelines.
• Strong analytical skills with the ability to interpret business needs and translate them into technical solutions.
• Experience with KPI creation, forecasting, trend analysis, and performance reporting.
• Excellent communication skills with the ability to explain complex analytical concepts to non-technical stakeholders.

Preferred / Bonus Skills

• Experience with Azure, SQL Server, Synapse, or Data Lake environments.
• Experience with Python, R, or other scripting languages for analytics and automation.
• Familiarity with ERP systems such as Global Shop Solutions (GSS), Epicor Kinetic or similar manufacturing ERPs.
• Experience with Power Automate and the Microsoft 365 ecosystem.
• Experience supporting manufacturing, engineering, or operations environments.
• Knowledge of data governance, MDM, and BI security standards.
• Experience with predictive analytics, statistical modeling, or machine learning concepts.
• Bilingual (English and Spanish) is a plus.