Data Engineer & Power BI Analyst (PWR40SF RM 4584)

Position: Data Engineer & Power BI Analyst (PWR40SF RM 4584)

Role Objective:
To design, develop, and maintain end-to-end data engineering and business intelligence solutions by building scalable data pipelines using Bronze, Silver, and Gold data layers on GCP or equivalent cloud data platforms, and delivering insightful Power BI dashboards that support business and management decision-making. The role will work closely with stakeholders and management to gather requirements, identify and recommend meaningful KPIs, translate business needs into data solutions, and provide regular progress updates through weekly review and Steering Committee meetings.

Key Responsibilities

• Gather and analyze business requirements in collaboration with stakeholders, functional teams, and management.
• Translate business processes and requirements into data engineering, reporting, analytical, and KPI requirements.
• Proactively identify and recommend relevant KPIs, metrics, trends, and analytical views for Power BI dashboards.
• Design, develop, and maintain end-to-end data pipelines for ingestion, transformation, validation, and consumption using GCP or equivalent cloud data platforms.
• Implement Medallion Architecture using Bronze for raw/source ingestion, Silver for cleansed and integrated data, and Gold for business-ready analytics and reporting datasets.
• Use relevant GCP data services such as BigQuery, Cloud Storage, Dataflow, Dataproc, Cloud Composer and/or equivalent technologies as appropriate to the solution.
• Integrate data from relational databases, files, APIs, SharePoint, and enterprise applications.
• Develop transformation logic, data quality checks, reconciliation mechanisms, monitoring, and error handling.
• Design dimensional models including Star Schema, fact tables, dimensions, relationships, and aggregations.
• Design and develop interactive Power BI reports, dashboards, and executive/management views.
• Develop DAX calculations and Power Query transformations; configure semantic models, Row-Level Security, refreshes, and gateways where applicable.
• Validate dashboards against source and transformed datasets to ensure accuracy and consistency.
• Coordinate dashboard reviews, KPI validation, UAT, feedback, and sign-off with stakeholders.
• Maintain functional and technical documentation for data sources, transformation rules, KPI definitions, data models, and dashboard logic.
• Track progress, dependencies, risks, issues, and action items, and present status in weekly review and Steering Committee meetings.

Skills & Competencies

• Strong hands-on experience with Power BI Desktop and Power BI Service, DAX, and Power Query (M).
• Strong SQL skills for data extraction, transformation, reconciliation, and validation.
• Demonstrated hands-on experience designing and developing production-grade ETL/ELT data pipelines on GCP or equivalent cloud data platforms.
• Practical experience implementing Bronze, Silver, and Gold layers / Medallion Architecture.
• Relevant experience with GCP data engineering services such as BigQuery, Cloud Storage, Dataflow, Dataproc, Cloud Composer and/or equivalent technologies.
• Good understanding of data cleansing, transformation, integration, data quality, orchestration, and monitoring.
• Strong understanding of dimensional modeling, Star Schema, fact/dimension modeling, and data warehousing concepts.
• Ability to understand business requirements and convert them into data and BI solutions.
• Ability to identify, recommend, define, and validate business KPIs with management and process owners.
• Strong analytical, problem-solving, stakeholder communication, and presentation skills.
• Ability to independently communicate status, risks, dependencies, and action items to management and Steering Committees.

Tools & Technologies

• BI Platform: Power BI Desktop, Power BI Service
• Data Engineering Platform: Google Cloud Platform (GCP) or equivalent cloud data platform
• GCP Data Services: BigQuery, Cloud Storage, Dataflow, Dataproc, Cloud Composer and related services as applicable
• Data Architecture: Bronze, Silver, Gold / Medallion Architecture
• Data Preparation: Power Query, Power BI Dataflows, SQL-based transformations
• Database / Warehouse: BigQuery, SQL Server, other relational or cloud data stores as applicable
• Scripting / Queries: SQL / T-SQL; Python is desirable for data engineering use cases
• Data Sources: Databases, files, Excel, SharePoint Lists, APIs, and enterprise applications
• Data Modeling: Dimensional Modeling, Star Schema, Fact & Dimension Models
• Data Gateways: On-premises Data Gateway where required
• Visualization: Power BI custom visuals, bookmarks, drill-through, tooltips

Additional Preferred Experience

• Experience delivering end-to-end BI solutions spanning requirement gathering, data engineering, semantic modeling, dashboard development, UAT, deployment, and production support.
• Experience working directly with business stakeholders and senior management.
• Relevant implementation experience on GCP is preferred; comparable experience on equivalent modern cloud data platforms is acceptable.
• Experience defining KPI calculation logic and business definitions with process owners.
• Experience presenting project status, milestones, risks, dependencies, and mitigation plans in weekly governance or Steering Committee forums.

*************************************************************************************************************************