Power BI Developer: Data Modeling & Dashboards

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

Job summary

Consertus, a global capital program management firm, seeks a Power BI Developer to design, develop, and maintain BI solutions for client engagements. You will gather requirements, model data, and deliver dashboards that enable data-driven insights in fast-paced environments.

join an on-site team in Austin, bring 2–4 years of Power BI experience, strong SQL/T-SQL, and expertise in DAX, SSIS, and data modeling to support capital program performance and risk management.

Qualifications

• 2–4 years of experience building Power BI dashboards/reports.
• 2+ years supporting capital programs or project management metrics.
• Experience with project controls data (cost, scheduling, earned value).
• Strong SQL/T-SQL, joins, aggregations, and performance tuning.
• Experience with ETL tools (SSIS) and data integration platforms.

Responsibilities

• Design and develop Power BI semantic models, dashboards, and paginated reports.
• Build and optimize DAX measures and Power Query transformations.
• Gather requirements from stakeholders and translate into data models.
• Develop SSRS reports and contribute to SSAS tabular models.
• Create ETL processes using SSIS, Azure Data Factory, or similar tools.
• Define KPIs and performance metrics for operations and strategy.
• Assist in testing, validation, and user acceptance testing.

Skills

Power BI dashboards

DAX

Power Query (M)

SQL / T-SQL

SSRS

SSIS

Data modeling

Communication

Education

Bachelor's degree in Computer Science/Information Systems/Engineering/Mathematics/Business

Tools

SSAS

Azure data services

Git-based version control

Job description

Consertus, a global capital program management firm, seeks a Power BI Developer to design, develop, and maintain BI solutions for client engagements. You will gather requirements, model data, and deliver dashboards that enable data-driven insights in fast-paced environments.

join an on-site team in Austin, bring 2–4 years of Power BI experience, strong SQL/T-SQL, and expertise in DAX, SSIS, and data modeling to support capital program performance and risk management.