Power BI Developer

TCS • Phoenix, AZ

3d

About The Position

This role focuses on designing, developing, and maintaining enterprise-grade Power BI dashboards, reports, and semantic models. The developer will build intuitive interactive visualizations to translate complex datasets into actionable business insights. Key responsibilities include developing advanced DAX calculations and business logic, using Power Query/M for data transformation, and configuring/optimizing semantic models, RLS, Import/DirectQuery/composite models, incremental refresh, and data gateways. The role also involves establishing reusable reporting standards, templates, KPI definitions, and visualization best practices, as well as supporting deployment, lifecycle management, and troubleshooting various Power BI components. Additionally, the position involves data engineering tasks such as designing and maintaining scalable ETL/ELT pipelines, integrating data from diverse sources, developing optimized SQL queries, and building data warehouse, data lake, or lakehouse solutions. Data cleansing, transformation, validation, and quality control processes are essential. The role requires developing reusable pipelines using Python, PySpark, SQL, and cloud-native services, and implementing monitoring, error handling, logging, alerting, and operational support. Optimization of large datasets and processing workloads for performance, reliability, and cost efficiency is crucial, along with supporting metadata, lineage, governance, data quality, CI/CD, and version control practices.

Requirements

• Proficiency in Power BI development, including dashboard and report design.
• Experience with DAX calculations and Power Query/M for data transformation.
• Knowledge of semantic model configuration and optimization (RLS, Import/DirectQuery/composite models, incremental refresh, data gateways).
• Experience in designing and maintaining ETL/ELT pipelines.
• Ability to integrate data from various sources (databases, APIs, files, cloud platforms, enterprise applications).
• Proficiency in SQL, including writing optimized queries, stored procedures, and views.
• Experience with data warehousing, data lake, or lakehouse solutions.
• Skills in data cleansing, transformation, validation, and quality control.
• Experience developing pipelines using Python, PySpark, SQL, and cloud-native services.
• Familiarity with monitoring, error handling, logging, and alerting for pipelines.
• Understanding of metadata, lineage, governance, data quality, CI/CD, and version control practices.

Responsibilities

• Design, develop, and maintain enterprise-grade Power BI dashboards, reports, and semantic models.
• Build intuitive interactive visualizations that translate complex datasets into actionable business insights.
• Develop advanced DAX calculations and business logic; use Power Query / M for transformation, cleansing, and preparation.
• Configure and optimize semantic models, RLS, Import/DirectQuery/composite models, incremental refresh, and data gateways.
• Establish reusable reporting standards, templates, KPI definitions, and visualization best practices.
• Support deployment and lifecycle management across development, testing, and production; troubleshoot report, refresh, gateway, semantic-model, and performance issues.
• Design, build, and maintain scalable ETL/ELT pipelines supporting analytics and reporting.
• Integrate data from databases, APIs, files, cloud platforms, and enterprise applications.
• Develop optimized SQL queries, stored procedures, views, and transformation logic.
• Build and maintain data warehouse, data lake, and/or lakehouse solutions.
• Implement data cleansing, transformation, validation, reconciliation, and quality-control processes.
• Develop reusable pipelines/frameworks using Python, PySpark, SQL, and cloud-native services.
• Implement monitoring, error handling, logging, alerting, and operational support for pipelines.
• Optimize large datasets and processing workloads for performance, reliability, and cost efficiency.
• Support metadata, lineage, governance, data-quality, CI/CD, and version-control practices.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed