Senior Data Analyst / Power BI Developer

Job Description Job Description Local Candidates Only - Onsite Role About the Role 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. Key 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. Required Qualifications Bachelor’s degree in Data Analytics, Information Systems, Computer Science, or related field (or equivalent experience). Expert Level at Power BI. Minimum 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. What We Offer Advanced Ground Systems Engineering (AGSE) offers an excellent benefits package, which includes healthcare, a 401(k) plan, and tuition reimbursement. To learn more about AGSE and our products or services, please visit AGSE is required by law in certain jurisdictions to include a pay scale in the job posting for this position. "Pay scale" means the salary or hourly range that AGSE reasonably expects to pay for this position; it is neither a promise nor a guarantee of the compensation that the successful candidate will receive. The pay scale for this position considers the wide range of factors that AGSE considers in making compensation decisions, including, without limitation: skill set, experience, and training, licensure and certifications, and other business and organizational needs. Please note that it is not typical for AGSE employees to be at or near the top of the pay scale for their role - especially as a new hire - and compensation decisions are dependent on the facts and circumstances of each case. Subject to the foregoing, the current pay scale for this position is $100,000–$120,000 per year. Job Type: Full-Time Employment Pay: $100,000–$120,000 per year PLUS discretionary bonus up to 10% of Base. Total compensation up to $132,000 based on experience and education. Benefits 401(k) 401(k) matching Dental insurance Employee assistance program FSA “Flexible Spending Account.” Health insurance Life insurance Paid time off Tuition reimbursement Vision insurance