Position Overview
The Sr. Automation and Data Partner helps lead and directly builds automation and data solutions that improve how Summit Line Construction operates. Reporting to the Business Process Manager, this role partners with department/operational stakeholders to translate business needs into reliable workflows, connected systems, and trusted reporting.
This position provides senior technical guidance for Microsoft Power Platform, Databricks, and Power BI and helps oversee the corporate data analysis effort. The role uses artificial intelligence (AI) extensively in hands-on development and combines solution design with responsibility for data pipelines, tables and schemas, quality auditing, and ongoing platform buildout. It also guides team members and supports adoption so solutions deliver measurable business value.
This role may report out of our Heber or Provo, UT offices. Remote arrangements are not available for this role.
Roles and Responsibilities
Process Automation with Technology
- Partner with process owners to assess workflows, define requirements, and prioritize automation opportunities based on business value, feasibility, and risk.
- Design, build, and maintain solutions using Power Automate, Power Apps, Dataverse, SharePoint, and approved AI tools; connect business systems through APIs and supported integrations.
- Develop AI-assisted workflows for document processing, information extraction, and decision support, with output validation and human review appropriate to the business process.
- Establish reusable development practices, technical documentation, and testing standards; coordinate version control, environment separation, deployment, and support handoffs with IT.
- Monitor solution performance, troubleshoot failures, and improve reliability; apply company security, access, data protection, and customer requirements to automation and AI use.
Corporate Data and Analytics
- Help oversee the corporate data and analytics roadmap across Databricks and Power BI, aligning development priorities and technical designs with departmental and company needs.
- Design, build, and maintain data pipelines, transformations, tables, schemas, and relationships that support reliable reporting and business system integrations.
- Develop and review Power BI semantic models, calculations, reports, and dashboards; align shared datasets and key performance indicator definitions across departments.
- Audit data from source systems through reporting outputs for accuracy, completeness, consistency, and timeliness; resolve discrepancies with system and business owners.
- Maintain data dictionaries, source-to-report lineage, ownership, and refresh documentation; improve pipeline and model performance and coordinate access controls with IT.
Business Partnership and Technical Leadership
- Serve as a technical partner to operations and corporate teams, including finance, safety, fleet, People Team, and project management; translate business questions into clear solution requirements.
- Guide and mentor analysts and automation contributors, review technical work, and coordinate internal resources and external partners under the Business Process Manager.
- Lead assigned initiatives from discovery through rollout, including scope, schedules, testing, stakeholder updates, training, process documentation, and ongoing support.
- Measure adoption, time savings, error reduction, and reporting improvements; recommend enhancements and support leadership reporting and other departmental initiatives.
Qualifications:
- Bachelor's degree in information systems, computer science, data analytics, business, or a related field, or an equivalent combination of education and relevant experience.
- Five or more years of progressive experience in automation, data analytics, business systems, or related technical work, including delivery and support of solutions used across departments.
- Strong hands-on experience with Power Automate and Power Apps, including integrations, troubleshooting, testing, and deployment of business-critical solutions.
- Strong SQL and Power BI skills, including data modeling, Power Query, and DAX; practical experience developing or supporting Databricks pipelines, tables, and schemas.
- Experience applying AI tools to business workflows and evaluating output quality; working knowledge of APIs, authentication, data governance, and secure handling of business information.
- Ability to work independently, manage competing priorities, investigate complex issues, and explain technical concepts clearly to business users and leadership.
- Demonstrated ability to guide technical work, mentor others, document solutions, and carry projects through implementation and ongoing support.
Desired Experience
- Construction, utility services, or a related operational environment, including exposure to JD Edwards, HCSS, Salesforce, or comparable business systems.
- Python or PySpark, Azure data services, Databricks governance tools, and source control or automated deployment practices.
- Copilot Studio or other approved AI platforms, process improvement and change management, or relevant Microsoft and Databricks certifications.
Benefits:
We offer an extremely competitive and comprehensive benefits package including:
- PTO that starts accruing DAY 1
- 401K Immediate Vesting; employer match starting same day
- Several medical plans to choose from
- Dental Plan and Vision Plan
- Life insurance, short term & long-term disability
- Paid Holidays
- Pet Insurance
- Employee discounts, EAP and Wellness Program
- Identity Theft Protection and so much more!
