POWER BI & CLOUD DATA ENGINEER

POWER BI & CLOUD DATA ENGINEER

Primary focus: Power BI analytics delivery | Supporting capability: Databricks data engineering

Experience : 7 to 11 Years

Role emphasis

This role is intended for a strong Power BI developer or analytics engineer who can also work effectively with Databricks, Spark SQL, Delta Lake, and cloud data engineering patterns.

At TE

At TE, you will unleash your potential working with people from diverse backgrounds and industries to create a safer, sustainable, and more connected world.

Job Overview

This position is primarily responsible for designing, developing, and supporting enterprise Power BI analytics solutions on TE's Databricks platform. The role partners closely with business stakeholders, product owners, data architects, analytics engineers, and governance teams to deliver intuitive dashboards, semantic models, governed reporting assets, and actionable insights that support business decisions.

In addition to Power BI development, the role contributes to Databricks-based data engineering activities, including data transformation, analytical data modeling, optimization of reporting datasets, and migration of legacy logic into scalable cloud-based solutions. The position owns the end-to-end analytics lifecycle from requirements gathering and data modeling through dashboard development, deployment, performance optimization, governance, documentation, production support, and continuous improvement.

What Your Background Should Look Like

Responsibilities

Power BI & Analytics Delivery, Primary Responsibility

Expected emphasis: approximately 60 to 70 percent of the role

• Design, develop, test, and deploy enterprise Power BI dashboards, reports, scorecards, semantic models, and reusable analytical solutions using Databricks as the primary data platform.
• Partner with business stakeholders and product owners to translate KPIs, reporting needs, and analytical questions into technical designs and delivery plans.
• Build scalable semantic models using star schemas, conformed dimensions, reusable measures, and clearly defined business logic.
• Develop advanced DAX measures, calculation groups, time-intelligence logic, and Power Query transformations.
• Connect Power BI with Databricks SQL Warehouses, Delta Lake tables, governed views, and composite models.
• Evaluate and optimize data models, including star, snowflake, and flattened structures, for performance, usability, and scalability.
• Design intuitive report experiences including drill-through, bookmarks, tooltips, conditional formatting, mobile layouts, accessibility, and user-friendly navigation.
• Tune report and semantic model performance using Power BI Performance Analyzer, DAX Studio, VertiPaq Analyzer, aggregations, query diagnostics, and incremental refresh.
• Implement row-level security, object-level security, workspace security, app distribution, and governance controls.
• Publish and manage Power BI workspaces, semantic models, reports, apps, refresh schedules, gateways, and deployment pipelines.
• Develop paginated reports using Power BI Report Builder where required.
• Perform data validation, reconciliation, regression testing, UAT support, troubleshooting, user enablement, and production support.
• Document report specifications, semantic model designs, KPI definitions, measure catalogs, data dictionaries, support guides, and reusable reporting standards.

Databricks & Cloud Data Engineering, Supporting Responsibility

Expected emphasis: approximately 30 to 40 percent of the role

• Analyze existing data warehouse implementations and support migration, modernization, and consolidation efforts.
• Reverse-engineer legacy PL/SQL and SQL logic, then translate business rules into scalable Spark SQL within Databricks notebooks.
• Design and develop AWS S3 and Delta Lake-based analytical data solutions using Databricks.
• Build and maintain ETL and ELT data pipelines, ingestion frameworks, and transformation processes that support reporting and analytics needs.
• Collaborate with data architects to implement enterprise ingestion, transformation, and governance frameworks.
• Collaborate with engineers to define gold-layer datasets and ensure data quality, lineage, and business-rule consistency.
• Support Unity Catalog, Medallion Architecture, Delta Lake table design, governed views, and cloud data warehouse design patterns.
• Tune Spark SQL, Databricks notebooks, SQL Warehouses, pipelines, and table structures to improve performance, scalability, and reliability.
• Support CI/CD, Git, version control, release automation, DevOps practices, job scheduling, backup coordination, and production support.

Collaboration, Delivery, and Governance

• Participate in Agile ceremonies, roadmap planning, architecture reviews, sprint activities, production readiness reviews, and continuous improvement activities.
• Work cross-functionally with business stakeholders, product owners, data architects, analytics engineers, governance teams, and support teams.
• Mentor developers through design reviews, code reviews, reusable engineering standards, Power BI best practices, and documentation standards.
• Promote consistency across reporting solutions by aligning semantic models, measures, data definitions, security, and release practices.

Skills, Experience, and Education

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Analytics, Information Technology, or a related field.
• 6 to 10 years of relevant experience across business intelligence, analytics delivery, and data engineering.
• 5+ years of hands-on Power BI development experience, including dashboards, reports, semantic models, DAX, Power Query, Power BI Service, and enterprise deployment practices.
• 3+ years of Databricks, Spark SQL, and Delta Lake experience supporting enterprise analytics and reporting solutions.
• Strong experience integrating Power BI with Databricks SQL Warehouses, Delta Lake tables, governed views, and cloud-based data platforms.
• Expert knowledge of Power BI Desktop, Power BI Service, Power BI Report Builder, DAX, Power Query, semantic modeling, dimensional modeling, and BI performance optimization.
• Strong SQL and PL/SQL skills, including experience refactoring or migrating legacy warehouse logic into modern cloud analytics platforms.
• Proficiency in Python, Scala, or Java, with practical experience supporting data transformation and automation needs.
• Strong experience with AWS S3, Databricks, Unity Catalog, Medallion Architecture, ETL and ELT, metadata management, and data warehouse design.
• Experience with Import mode, DirectQuery, composite models, query folding, incremental refresh, aggregations, and Power BI performance tuning.
• Experience with Git, CI/CD, REST APIs, deployment pipelines, Agile methodologies, governance, testing, and production support.
• Strong stakeholder communication, requirements analysis, leadership, mentoring, and cross-functional collaboration skills.
• Microsoft PL-300 certification is strongly preferred. Databricks certification is preferred or a strong plus.

Preferred Profile

• A senior Power BI developer, BI engineer, or analytics engineer who is comfortable working directly with business users and technical data teams.
• Strong ability to design business-friendly reporting experiences while also understanding the Databricks data structures that support them.
• Practical experience balancing semantic model design, report usability, data quality, governance, and performance.
• Ability to move between business requirements, Power BI modeling, Databricks SQL, data validation, and production support without losing sight of the business outcome.