Power BI Technical Lead & Analytics Architect

Compunnel, Inc.; Texas; On-site; USD 95,000 - 135,000; Full time

Job summary

Compunnel, Inc. is seeking a Power BI Developer to design, develop, and enhance enterprise reporting and analytics solutions.

You will lead technical efforts, create interactive dashboards, and optimize data models while collaborating with cross-functional teams to deliver scalable BI solutions. The ideal candidate will have strong Power BI expertise, Snowflake experience, SQL skills, and modern data engineering practices.

Qualifications

• Bachelor's degree or equivalent professional experience in a technical field.
• Proven Power BI Developer with a strong portfolio of reports and dashboards.
• Hands-on experience with Power BI Desktop, Power BI Service, DAX, and Power Query (M language).
• Experience embedding Power BI in enterprise applications or portals.
• Strong understanding of Power BI governance, security, and RLS.
• Hands-on Snowflake data integration, modeling, SQL development, and optimization.
• Experience in data engineering, data modeling, and analytics.
• Familiarity with star and snowflake schemas and dimensional modeling.
• Advanced SQL skills for large datasets and BI optimization.
• Experience implementing CI/CD pipelines for BI solutions.
• Familiarity with AWS and Azure cloud platforms.
• Hands-on Java and/or Python development for data tooling.

Responsibilities

• Design, develop, and maintain interactive Power BI reports, dashboards, and visualizations.
• Provide technical leadership for reporting initiatives.
• Collaborate with Architects, Product Owners, Analysts, and developers to deliver BI solutions.
• Develop semantic models, data models, and custom visuals.
• Build scalable reporting using Power BI Desktop, Service, DAX, and M language.
• Integrate Power BI with Snowflake and other enterprise data platforms.
• Design and optimize star and snowflake schemas.
• Develop efficient SQL queries and optimize Snowflake performance.
• Implement Row-Level Security, governance, and user access management.
• Support embedding Power BI reports in enterprise portals.
• Establish BI development standards, governance, and best practices.
• Troubleshoot data quality and visualization issues.
• Collaborate on CI/CD pipelines for BI and data solutions.
• Work with cloud platforms to support reporting initiatives.
• Mentor developers and analysts and support Agile delivery.

Skills

Power BI

DAX

Power Query

SQL

Snowflake

Data modeling

Dimensional modeling

CI/CD

AWS

Azure

Java

Python

Agile

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI Desktop

Power BI Service

Snowflake

SQL

Python

Java

AWS

Azure

Job description

We are seeking a Power BI Developer to design, develop, and enhance enterprise reporting and analytics solutions. This role will provide technical leadership, develop interactive dashboards and visualizations, optimize data models, and collaborate with cross-functional teams to deliver scalable business intelligence solutions. The ideal candidate will have strong expertise in Power BI, Snowflake, SQL, data modeling, and modern data engineering practices.

Key Responsibilities

• Design, develop, and maintain interactive Power BI reports, dashboards, and visualizations.

• Provide technical leadership and guidance for reporting and analytics initiatives.

• Collaborate with Architects, Product Owners, Analysts, and development teams to deliver business intelligence solutions.

• Develop and maintain semantic models, data models, and custom Power BI visualizations.

• Build scalable reporting solutions using Power BI Desktop, Power BI Service, DAX, and Power Query (M Language).

• Integrate Power BI solutions with Snowflake and other enterprise data platforms.

• Design and optimize star schema, snowflake schema, and other scalable data models.

• Develop efficient SQL queries and optimize Snowflake query performance.

• Implement Row-Level Security (RLS), governance policies, security settings, and user access management within Power BI.

• Support embedding Power BI reports into enterprise portal environments.

• Implement Power BI development standards, best practices, and governance frameworks.

• Troubleshoot reporting, data quality, and visualization issues.

• Collaborate with engineering teams to implement CI/CD pipelines for BI and data solutions.

• Work with cloud platforms and enterprise data services to support reporting and analytics initiatives.

• Mentor developers and analysts while removing technical blockers and supporting Agile delivery.

Required Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related technical field, or equivalent professional experience.

• Proven experience as a Power BI Developer with a strong portfolio of reports, dashboards, and data visualizations.

• Strong hands-on experience with Power BI Desktop, Power BI Service, DAX, Power Query (M Language), semantic models, and custom visuals.

• Experience embedding Power BI reports into enterprise applications or portal environments.

• Strong understanding of Power BI governance, security, user access management, and Row-Level Security (RLS).

• Hands-on experience with Snowflake, including data integration, data modeling, SQL development, and query optimization.

• Strong experience in data engineering, data modeling, and data analysis.

• Strong understanding of dimensional modeling concepts, including star schema and snowflake schema.

• Advanced SQL skills with experience optimizing queries against large datasets.

• Experience implementing BI development standards and reporting best practices.

• Strong analytical, troubleshooting, and problem-solving skills.

• Experience implementing CI/CD pipelines for business intelligence and data solutions.

• Experience with Snowflake features such as Snowpipe, Data Sharing, and Snowflake Streams.

• Familiarity with AWS and Azure cloud platforms.

• Hands-on experience with Java and/or Python.

• Excellent communication, collaboration, and stakeholder management skills.

• Experience working in Agile software development environments.

Preferred Qualifications

• Experience serving as a technical lead for reporting and analytics projects.

• Experience leading teams of developers and analysts.

• Strong understanding of enterprise architecture and business intelligence best practices.

• Experience coordinating with Architects, Product Owners, and cross-functional technical teams to deliver enterprise reporting solutions.