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…