Analytics & Automation Lead

Analytics & Automation Lead

At HDR, our employee-owners are fully engaged in creating a welcoming environment where each of us is valued and respected, a place where everyone is empowered to bring their authentic selves and novel ideas to work every day. As we foster a culture of inclusion throughout our company and within our communities, we constantly ask ourselves:
What is our impact on the world? Each and every role throughout our organization makes a difference in our ability to change the world for the better. Read further to learn how you could help make great things possible not only in your community, but around the world.

This position is not eligible for employment-based visa sponsorship now or in the future, including F-1 OPT, CPT, H-1B, or other employment-based visa sponsorship. As an Analytics & Automation Lead, you will play a key role in helping HDR leverage data, reporting, and automation to improve operational effectiveness and support data-driven decision-making.

Working within the Global Technology Group, this position partners with stakeholders across the organization to evaluate business needs, identify opportunities for process improvement, and deliver reporting and automation solutions that provide measurable value. The role combines analytics, workflow automation, solution design, and business partnership, requiring both strong technical skills and the ability to translate complex business challenges into scalable solutions.

The Analytics & Automation Lead is responsible for designing, developing, and supporting enterprise reporting and automation solutions using Microsoft Power BI, Power Automate, and related technologies. This individual will work with business and technical teams to identify the most effective approach to solving problems through analytics, automation, or process improvement initiatives.

Analytics & Reporting Solutions

• Lead the planning, design, development, and support of enterprise Power BI dashboards, reports, and data models.
• Create intuitive visualizations that transform complex data into meaningful business insights and executive-level reporting.
• Develop reporting solutions and KPI dashboards that enable stakeholders to monitor performance and support operational and strategic decision-making.
• Optimize report performance through effective use of DAX, Power Query, data modeling, and reporting best practices.
• Develop scalable reporting solutions that support both technical and non-technical audiences.

Automation & Process Improvement

• Design, develop, test, and deploy automated workflows using Microsoft Power Automate and related technologies, partnering with business teams to support solution adoption and transition to ongoing ownership.
• Integrate automation solutions across enterprise applications, SharePoint, Teams, databases, APIs, and other business systems.
• Identify and recommend automation opportunities that improve efficiency, reduce manual effort, and enhance user experience.
• Monitor, maintain, troubleshoot, and enhance production automation solutions.

Data Management & Solution Development

• Design and maintain secure, scalable data models using Power Query, DAX, SQL, and other reporting technologies.
• Prepare and transform data from multiple enterprise systems while ensuring data quality, consistency, and integrity.
• Apply enterprise data governance, privacy, and security standards across reporting and automation solutions.
• Develop sustainable solutions that balance business requirements, scalability, maintainability, and long-term value.

Business Partnership & Solution Assessment

• Partner with leadership and stakeholders to understand business objectives, clarify requirements, and evaluate proposed requests.
• Assess reporting, automation, and process improvement opportunities to determine the most effective solution approach.
• Analyze business processes and recommend solutions that align with departmental goals and organizational priorities.
• Help establish business value, expected outcomes, and success measures for analytics and automation initiatives.

Collaboration, Documentation & Knowledge Sharing

• Collaborate with cross-functional teams, including Support…