Position Overview:
Responsible for supporting business intelligence and analytics needs within Mercedes-Benz Financial Services, partnering with business stakeholders and contributing to the transformation from a legacy on-prem BI environment (DB2 / Informatica / Cognos) to a modern Azure and Microsoft Fabric–based analytics platform (Databricks, Fabric, Power BI). This role will focus on developing modern BI solutions while supporting and migrating existing Cognos assets.
Key Responsibilities:
- Develop and support dashboards and reports using Power BI (primary) and Cognos Analytics (legacy support during the transition).
- Lead and support migration of reports, dashboards, and data models from Cognos to Power BI / Microsoft Fabric, ensuring accuracy, performance, and consistency.
- Design and build scalable Power BI semantic models aligned with Microsoft Fabric and modern BI best practices.
- Use Python for data transformation, automation, and analytics within Databricks and Microsoft Fabric environments.
- Collaborate with Data Engineering teams to support Fabric Lakehouse and Warehouse solutions and Azure-based data pipelines.
- Provide production support and root cause analysis across legacy and modern BI platforms.
- Convert end-user reporting solutions (Excel, Access, SAS) into governed, automated Power BI solutions.
- Gather, document, and translate business requirements into technical specifications, including data mappings and transformation logic.
- Support unit testing and UAT, ensuring data quality and reporting accuracy.
- Provide guidance and enablement for Power BI self-service analytics.
- Support enterprise analytics transformation initiatives and evolving BI standards.
Skills and Qualifications:
- Hands-on experience with Cognos Analytics and Power BI, including DAX, data modeling, and report migration.
- Strong Python skills for data manipulation, automation, and analytics.
- Experience with Microsoft Fabric (Lakehouse, Warehouse, semantic models).
- Experience with Azure data platforms, including Databricks and Azure Data Lake.
- Strong SQL and data warehousing fundamentals.
- Familiarity with ETL / ELT tools (Informatica experience a plus).
- Strong analytical, problem-solving, and communication skills.
- Comfortable working in a transformational, fast-evolving environment.
- Financial Services experience preferred.
Additional Information:
- What will the training schedule look like? First week onsite in Farmington Hills for onboarding.
- Will this position be fully onsite or hybrid? Hybrid: 4 days a week onsite in Atlanta starting August 2026. Remote until then.
- When is the start of the assignment? Asap
- Please note this is a contract-to -hire position.