Power BI Developer

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

Benefits offered by this job

Health coverage

Life insurance

401(k) with match

Paid time off

Learning & development

Job summary

Consertus-US is seeking a Power BI Developer to design, develop and maintain BI solutions for client engagements. You will gather requirements, model data, and deliver dashboards that drive analytics and digital transformation in a fast-paced consulting environment.

The role emphasizes strong technical skills, client interaction, and ownership of deliverables, with on-site work in a dynamic team setting and opportunities for growth in BI and data architecture.

Qualifications

• Bachelor's degree in CS/IS/Engineering or related field.
• 2–4 years of Power BI dashboard/report development experience.
• 2+ years of capital programs, project controls, or PM data analysis.
• Strong SQL/T‑SQL, DAX, and data modeling skills.

Responsibilities

• Design and develop Power BI dashboards and paginated reports.
• Build DAX measures, Power Query transformations, and security.
• Gather requirements and translate to scalable data models.
• Create SSRS reports and contribute to SSAS tabular modeling.
• Develop ETL with SSIS or equivalent tools; ensure data quality.
• Define KPIs, perform testing, and support UAT.
• Engage stakeholders, manage tasks, and document designs.

Skills

Power BI development

DAX

SQL

Data modeling

Stakeholder communication

Education

Bachelor's degree in Computer Science

Tools

SSRS

SSIS

Azure Data Factory

Power Query (M)

Job description

About Us

Consertus is a global capital program management and advisory firm that combines deep human expertise with advanced digital tools to deliver smarter, faster, and more sustainable outcomes. Headquartered in Miami, Florida, and supported by a team of more than 1,000 professionals worldwide, we help clients plan, execute, and optimize large-scale capital programs. Our integrated services span digital, advisory, and delivery, empowering organizations to navigate complexity, manage risk, and achieve strategic goals in sectors including aviation, transportation, transit, water, healthcare, energy, education, government, commercial, life sciences, and technology. At Consertus, we celebrate individual strengths, foster strong relationships, and promote flexibility in how and where we work. Join us to grow your career, develop your skills, and make a lasting impact as we transform how the world is built. Discover how Consertus is driving transformative change for our clients, our people, and the communities we serve at www.consertus.com

About this Role

As a Power BI Developer, you will be part of a consulting team delivering data and analytics solutions across client engagements. You will design, develop, and maintain business intelligence solutions that transform complex data into actionable insights. Working closely with project teams and client stakeholders, you will gather requirements, develop data models, and deliver dashboards that support broader analytics and digital transformation initiatives. This role requires strong technical expertise, attention to detail, and the ability to operate effectively in a fast-paced, client-facing environment. This is a full-time, on-site position.

Key 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

Qualifications / Requirements

• 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 required.
• Minimum of 2 years of experience supporting capital programs, construction projects, or project management initiatives, with demonstrated experience analyzing project performance, schedules, costs, risks, and key project metrics.
• Minimum of 2 years of experience working with project controls data, including cost management, scheduling, forecasting, budgeting, resource planning, earned value management (EVM), or project performance reporting within Power BI or similar business intelligence platforms.
• Previous experience designing and developing Power BI semantic models, dashboards, and paginated reports aligned to client needs strongly required
• Strong experience with DAX, Power Query (M), and semantic data modeling
• Solid understanding of star schema and tabular modeling principles
• Hands-on experience with SQL Server Reporting Services (SSRS)
• Experience with ETL tools such as SSIS or equivalent data integration technologies, required.
• Strong SQL / T-SQL skills, including joins, aggregations, and performance tuning
• Experience working with large datasets and multiple data sources
• Strong analytical and problem-solving skills
• Effective written and verbal communication skills

Additional Requirements / Skills

• Microsoft certifications such as PL-300, or progress toward DP-500 / DP-600
• Experience with Microsoft Fabric (Lakehouse, Warehouse, Direct Lake)
• Familiarity with Azure data services (Azure SQL, Synapse, Data Lake)
• Experience with Git-based version control and deployment pipelines
• Exposure to additional BI tools (e.g., Tableau, Qlik, Oracle BI Publisher)
• Experience working with APIs (REST/SOAP) and handling JSON/XML data structures is a plus
• Exposure to data warehousing concepts, including staging, data marts, and dimensional modelling
• Understanding of capital project, construction, or asset lifecycle data is a plus
• Ability to manage multiple priorities and work effectively in a consulting environment

What’s In It For You

• Comprehensive health coverage (medical, dental, and vision)
• Company-paid life and disability insurance
• Optional benefits like pet insurance, legal, and supplemental health plans
• 401(k) with day-one eligibility, 3% safe harbor, plus up to 2.5% company match
• Generous time off: 10 paid holidays and PTO starting at 15 days, growing up to 25
• Access to Consertus Academy for continuous learning and development

Equal Employment Opportunity Statement

Consertus is proud to be an Equal Opportunity Employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. We welcome applicants from all backgrounds and identities, and we do not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability, age, veteran status, or any other protected status.

Consertus drives positive outcomes for capital programs around the world through transformative advisory and delivery solutions and digital innovations. By leveraging leading-edge technology and embracing a collaborative, client-first spirit, Consertus works smarter to deliver results that offer higher performance, more longevity, and greater value for clients.

Consertus is made up of 800+ full-time employees located across the United States, Puerto Rico, United Kingdom, Kingdom of Saudi Arabia, UAE, and India. An international client base, in sectors such as transportation, manufacturing, utilities, government, and healthcare, partners with Consertus for tailored solutions that help them achieve their goals.