Senior Power BI & Data Automation Developer

Senior Power BI & Data Automation Developer

Build the Data Solutions That Drive Smarter Decisions

Are you a senior technology professional who enjoys transforming complex data into powerful business insights? At ERM, you'll have the opportunity to lead the development of innovative analytics, automation, and business intelligence solutions that support some of the world's most impactful environmental, infrastructure, and sustainability projects. If you thrive at the intersection of data engineering, analytics, and problem-solving, this is your chance to make a measurable impact while shaping the future of data-driven decision making.

Why This Role Matters?

Data is at the core of how organizations make informed decisions, improve operational efficiency, and deliver value to clients. As a Senior Power BI & Data Automation Developer, you will play a critical role in designing scalable reporting platforms, automating business processes, and creating high-quality data products that empower teams across ERM and our client organizations.

What Your Impact Is:

• Develop enterprise-grade business intelligence solutions that transform complex datasets into actionable insights.
• Drive automation initiatives that reduce manual effort and improve operational efficiency.
• Design scalable data architectures that support reporting, analytics, and decision-making at scale.
• Integrate diverse data sources, including SQL databases, APIs, SharePoint, and geospatial platforms, into unified solutions.
• Enhance data quality, governance, and system reliability across critical business applications.
• Serve as a technical leader, mentoring colleagues and championing best practices in analytics, development, and automation.

What You'll Bring:

Required

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Engineering, GIS, Geography, or a related discipline, or equivalent professional experience.
• 5+ years of experience delivering business intelligence, data engineering, analytics, or automation solutions.
• Advanced expertise in Power BI, including data modeling, DAX, Power Query, report development, and performance optimization.
• Strong SQL experience, including complex query development, database design, troubleshooting, and performance tuning.
• Proficiency in Python for data transformation, automation, systems integration, and analytics.
• Hands-on experience developing and supporting ETL/ELT pipelines and automated data workflows.
• Experience building solutions using Power Apps and Power Automate.
• Understanding of relational databases, data quality controls, and data governance principles.
• Strong communication skills and the ability to collaborate effectively with both technical and non-technical stakeholders.
• Proven ability to manage multiple priorities and deliver high-quality solutions in a fast-paced environment.

Preferred

• Microsoft certifications in Power BI, Fabric, Azure, Power Platform, or Data Engineering.
• Experience with Microsoft Fabric, Azure Data Factory, Azure SQL, Dataverse, data lakes, notebooks, and CI/CD practices.
• Expertise in dimensional modeling, semantic-layer design, and enterprise BI governance.
• Experience integrating Power BI with GIS platforms, spatial services, or Esri technologies.
• Background supporting environmental, engineering, infrastructure, energy, utilities, or consulting projects.
• Experience with APIs, JSON, authentication frameworks, and system integrations.
• Demonstrated experience mentoring developers, conducting code reviews, or leading technical initiatives.
• Knowledge of data security, privacy, metadata management, and production support environments.

Key Responsibilities:

• Design, develop, and maintain Power BI dashboards, reports, applications, and reusable data products.
• Own end-to-end BI development, from data ingestion and modeling through dashboard delivery and ongoing support.
• Build and optimize relational and dimensional data models that enable scalable, high-performing analytics.
• Develop, review, and troubleshoot SQL queries, stored procedures, views, and reporting structures.
• Create and maintain Python-based solutions for data processing, integration, validation, and automation.
• Design and support ETL/ELT pipelines, automated refresh processes, and data integration workflows.
• Develop Power Apps and Power Automate solutions that streamline business processes and improve productivity.
• Integrate information from enterprise systems, databases, APIs, SharePoint, flat files, and geospatial platforms.
• Perform data validation, quality assurance, reconciliation, and troubleshooting activities.
• Document system architectures, business rules, technical designs, and support procedures.
• Collaborate with project managers, scientists, GIS specialists, and client stakeholders to translate business needs into technical solutions.
• Mentor team members, promote development standards, and contribute to a culture of continuous improvement and innovation.

Who We Are:

As the largest global pure play sustainability consultancy, we partner with the world’s leading organizations, creating innovative solutions to sustainability challenges and unlocking commercial opportunities that meet the needs of today while preserving opportunity for future generations.

At ERM we know that creating a diverse, equitable and inclusive work environment is an essential part of making our company a great place to build a career. We also see our diversity as a strength that helps us create better solutions for our clients. Our diverse team of world-class experts supports clients across the breadth of their organizations to operationalize sustainability, underpinned by our deep technical expertise in addressing their environmental, health, safety, risk and social issues. We call this capability our “boots to boardroom” approach for its comprehensive service model that allows ERM to develop strategic and technical solutions that advance objectives on the ground or at the executive level.

Please submit your resume and brief cover letter.

ERM does not accept recruiting agency resumes. Please do not forward resumes to our jobs alias, ERM employees or any other company location. ERM is not responsible for any fees related to unsolicited resumes.

ERM is proud to be an Equal Employment Opportunity employer. We do not discriminate based upon race, religion, color, national origin, gender, sexual orientation, gender identity, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

Thank you for your interest in ERM

At ERM, sustainability is our business. We are the world’s largest advisory firm focused solely on sustainability, offering unparalleled expertise across business and finance. ERM partners with clients to operationalize sustainability at pace and scale, through our unique combination of strategic transformation and technical delivery capabilities. Our diverse global team of experts works with the world’s leading organizations to help them set clear sustainability targets, measure progress and operationalize strategy through deep implementation and business transformation. With more than 50 years of experience, our ability to integrate sustainability solutions and our depth and breadth of technical knowledge are why organizations choose to partner with us as their trusted advisor. Every one of us firmly believes in the potential to create value for our clients through an integrated approach to sustainability (because we have personally seen it and professionally achieved it). Our team members are passionate about client service. We work closely with our clients to help them operationalize their sustainability goals and meet their environmental, health and safety objectives while advancing ERM’s purpose through delivering tangible progress in what the United Nations coined The Decade of Action. Organizing our people across globally integrated communities of technical and strategic talent positions ERM to be a “boots to boardroom” leader in bringing that value creation to our clients, partners, and the world. We recruit exceptional professionals with a personal and professional passion for sustainability and nurture them to even greater success as specialists. We prepare our consultants to bring integrated, innovative and sustainable solutions to our clients and provide opportunities for ongoing development across a variety of subject areas related to technical, business, and personal growth. At ERM, effort pays off and becomes career defining work that leaves a positive imprint on our planet.

ERM Homepage Explore All Open Roles Explore Early Careers Roles Explore Experienced Professional Roles Explore Partnership Roles Quick guides for accessing and managing your ERM Candidate Home account. Create a New Candidate Account Reset Your Candidate Home Password Processing Notice