Power BI Developer: Analytics, Dashboards & Data Modeling

Consertus-US; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Health coverage

Life and disability insurance

401(k) with company match

Generous paid time off

Job summary

Consertus is seeking a Power BI Developer to join a consulting team delivering data and analytics solutions. You will design, develop, and maintain BI solutions that transform complex data into actionable insights for client engagements.

This full-time, on-site role requires gathering requirements, building data models, and delivering dashboards that support analytics and digital transformation initiatives. You’ll work closely with stakeholders in a fast-paced, client-facing environment.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field.
• 2-4 years of experience developing Power BI dashboards and reports.
• Strong experience with DAX, Power Query (M), and semantic data modeling.
• Hands-on experience with SQL Server Reporting Services (SSRS).
• Experience with ETL tools such as SSIS or equivalent data integration technologies.
• Strong SQL / T-SQL skills, including joins, aggregations, and performance tuning.
• Experience with large datasets and multiple data sources.
• Exposure to Azure data services (Azure SQL, Synapse, Data Lake).
• Experience with Git-based version control and deployment pipelines.
• Exposure to data warehousing concepts, including staging, data marts, and dimensional modeling.
• Understanding of capital project, construction, or asset lifecycle data is a plus.

Responsibilities

• Design and develop Power BI semantic models, dashboards, and paginated reports aligned to client requirements.
• Build and optimize DAX measures, Power Query (M) transformations, and row-level security.
• Engage with stakeholders to gather requirements and translate functional needs into technical specifications and scalable data models.
• Build SSRS reports and contribute to SSAS tabular model development as part of broader BI architectures.
• Develop and maintain ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools, including data profiling and quality validation.
• Develop KPIs and performance metrics to support operational and strategic decision-making.
• Perform testing, validation, performance tuning, and support user acceptance testing (UAT).
• Manage assigned tasks and workstreams across concurrent client engagements, proactively communicating progress, risks, and blockers.
• Demonstrate ownership of assigned deliverables, ensuring quality, timeliness, and alignment with client expectations.
• Participate in client-facing meetings, demos, and walkthroughs, presenting solutions clearly and professionally.
• Produce clear, well-structured documentation including data dictionaries, technical designs, and user guides.
• Contribute to internal best practices, reusable assets, and continuous improvement initiatives.

Skills

DAX

Power Query

Semantic modeling

SQL / T-SQL

SSRS

SSIS

Azure Data Services

Git

APIs

Data warehousing

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, Business, or a related field

Tools

SSRS

SSIS

Azure Data Factory

Azure Synapse

Power BI

Git

Tableau

Job description

Consertus is seeking a Power BI Developer to join a consulting team delivering data and analytics solutions. You will design, develop, and maintain BI solutions that transform complex data into actionable insights for client engagements.

This full-time, on-site role requires gathering requirements, building data models, and delivering dashboards that support analytics and digital transformation initiatives. You’ll work closely with stakeholders in a fast-paced, client-facing environment.