Sr. Data & Reporting Analyst

Company Description Lumentis is a global designer and manufacturer of advanced automotive lighting solutions that enhance safety and brand identity for leading automakers. With decades of industry experience, Lumentis delivers headlamps, tail lamps, signal, and ambient lighting systems from concept through series production. The company integrates optical engineering, electronics, and software to develop innovative LED, adaptive, and dynamic lighting technologies. Lumentis offers opportunities to work on cutting-edge products in a collaborative, technology-focused environment with global impact.

Location

Novi, Michigan

Work Environment

Hybrid (in-office and remote); up to 25% travel

Reports To

Senior Manager – ERP, Applications, and Data

Overview of the Role

The Sr Data & Reporting Analyst is responsible for designing, implementing, and supporting Lumentis enterprise data platform and reporting landscape. This role will establish modern data architectures, build robust data pipelines, and deliver insightful reporting and dashboards that enable data driven decision making across Lumentis global automotive manufacturing operations.

Key Responsibilities

• Enable and support a scalable data platform to support analytics, reporting, and data driven decision making across Lumentis.
• Contribute to building and maintaining Lumentis data warehouse and data lake solutions, leveraging modern principles such as medallion architecture.
• Develop and manage data pipelines and integration flows, ensuring data quality, lineage, and governance.
• Develop reusable semantic models, star schemas, and subject-area data sets (e.g., Finance, Operations, Supply Chain, Commercial) to support both standardized reporting and self-service analytics.
• Define and maintain business logic, calculation rules, KPIs, and metrics within the data platform to ensure consistency of reporting across functions and regions.
• Implement robust data validation and reconciliation routines to ensure that aggregated data aligns with source systems, supporting finance close, operational reporting, and management dashboards.
• Build and maintain reports, dashboards, and self-service data models in Power BI for key functions, including Finance, Operations, Supply Chain, and Commercial.
• Collaborate with business and functional stakeholders to translate reporting needs into detailed data transformation requirements, including data mapping, enrichment, and harmonization across entities and plants.
• Work closely with the Senior Manager - ERP, Applications and Data and the Sr Applications Analyst to ensure consistent, trusted data across systems.
• Implement and enforce data standards, definitions, and best practices for data management and reporting.
• Serve as the primary administrator for the data platform, including monitoring performance, security, and cost of data solutions, optimizing architecture and design as needed.
• Provide guidance and support to power users and analysts across the organization using Power BI and other analytics tools.
• Create and manage automated workflows to streamline business processes and enhance productivity, leveraging Microsoft Power Platform

Required Qualifications

• Typically requires 5 years of experience in data engineering, data platform management, or business intelligence roles.
• Strong experience with Azure based data technologies such as Azure Fabric and/or Databricks.
• Experience implementing data models and working with various data sources, including SharePoint, Office 365, SQL Server, and other on-premises and cloud-based systems
• Hands-on expertise in data warehouse design and implementation, including medallion architecture concepts.
• Proven experience building and maintaining Power BI reports, dashboards, and data models.
• Solid understanding of ETL and ELT processes, data integration, and data quality management.
• Ability to collaborate effectively with business stakeholders to understand requirements and deliver actionable insights.
• Familiarity with security, privacy, and governance considerations for enterprise data platforms.
• Applicants must be legally authorized to work in the United States at the time of hire and maintain work authorization throughout their employment.

Desired Skills

• Experience in data and reporting within manufacturing or automotive environments.
• Knowledge of integrating ERP and SaaS source systems (for example SAP S/4HANA, Infor Trans4M, OneStream, Kyriba, Dayforce) into data platforms.
• Experience implementing or contributing to data governance frameworks and data catalogs.
• Strong SQL and scripting skills, with exposure to Python or similar languages for data engineering tasks.
• Excellent communication skills with the ability to explain technical concepts to non technical stakeholders.

Equal Opportunity Employer

We are committed to building a diverse workforce and fostering an inclusive workplace where everyone feels respected, valued, and empowered to succeed. Employment decisions are based on qualifications, merit, and business needs. We prohibit discrimination and harassment of any kind and provide equal employment opportunities to all applicants and employees regardless of any characteristic protected by applicable federal, state, or local law.