Power BI Analytics Engineer - Dashboards & Data Models

Consertus, Inc.; Austin (TX); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Health, dental & vision insurance

401(k) with company match

Paid holidays & PTO

Professional development opportunities

Job summary

Consertus, Inc. is seeking a Power BI Developer to join our client-facing BI team in Austin. You will design, develop, and maintain BI solutions that convert complex data into actionable insights across capital programs.

Responsibilities include building semantic models, dashboards, and paginated reports, with strong emphasis on DAX, M, and data modeling. On-site role offering growth through Consertus Academy and defined career paths.

Qualifications

• 2–4 years of experience developing Power BI dashboards and reports.
• Experience supporting capital programs, construction projects, or project management initiatives.
• Experience working with project controls data, cost management, scheduling, budgeting, EVM, or project reporting.
• Designing and developing Power BI semantic models, dashboards, and paginated reports.

Responsibilities

• Design and develop Power BI semantic models, dashboards, and paginated reports aligned to client requirements.
• Build and optimize DAX measures, Power Query transformations, and row-level security.
• Gather requirements and translate needs into scalable data models and technical specs.
• Develop KPIs and performance metrics to support decision making.
• Create and maintain SSRS reports and contribute to SSAS tabular modeling.
• Develop ETL processes using SSIS, Power Query, Azure Data Factory, or similar tools.

Skills

Power BI

DAX

Power Query (M)

Semantic data modeling

SSRS

SSIS

SQL / T-SQL

Star schema

Tabular modeling

Azure data services

Data warehousing concepts

Git/version control

APIs/JSON/XML

ETL tools

Education

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

Tools

SSRS

SSIS

Azure Data Factory

SQL Server

Power BI

Job description

Consertus, Inc. is seeking a Power BI Developer to join our client-facing BI team in Austin. You will design, develop, and maintain BI solutions that convert complex data into actionable insights across capital programs.

Responsibilities include building semantic models, dashboards, and paginated reports, with strong emphasis on DAX, M, and data modeling. On-site role offering growth through Consertus Academy and defined career paths.