Data Engineer I - (Salt Lake City)

Utah Transit Authority Description JOB SUMMARY Designs, builds, and maintains UTA’s business intelligence data and reporting solutions to deliver trusted metrics and actionable insights across the agency. Partners with business and technical stakeholders to translate analytics needs into reliable data models, curated datasets, and dashboards/visualizations for audiences ranging from frontline teams to executive leadership. Supports data governance and data quality efforts to ensure appropriate use, definitions, and stewardship of enterprise data for decision-making. Develops documentation, standards, and enablement processes that help users adopt BI tools and self-service reporting responsibly. Provides backup support for BI reporting platforms, including scheduling, publishing/QA, and monitoring of automated reporting and BI ETL processes. MINIMUM QUALIFICATIONS EDUCATION/TRAINING: Bachelor’s degree in Information Systems, Business, Computer Science, or Engineering. EXPERIENCE: Experience (2-3 years preferred) in data analytics and demonstrated aptitude with Information Builders or similar data visualization software. Experience (2-3 years preferred) in data modeling, data scrubbing, and data quality reviews. Experience (2-3 years preferred) working with large corporate-wide business data sets and critical business metrics. Experience in eliciting business requirements from stakeholders and translating into working technical solutions. Knowledge, Skills and Abilities: Strong understanding of data visualization and data storytelling. Strong working knowledge of business intelligence tools and data query tools. knowledge of SQL and Relational database concepts. Strong business acumen A self-starter who is dedicated with exceptional critical thinking, Problem-solving abilities. Proficient in Microsoft Business Intelligence stack (Fabric, PowerBI, TSQL, SSIS, SSAS and SSRS). Analytical skills Excellent presentation, communication, and interpersonal skills, with strong attention to detail. Must have a customer-focused mindset. Ability to write queries in SQL to extract meaningful information from complex data sets. Strong Microsoft Excel skills to build data models and perform hoc data tasks. Ability to work with others and participate in a team environment. Self-motivated; willing to work under pressure and stress at times. Occasionally, working unscheduled hours and/or weekend work will be required to support critical Agency needs. Local travel may be required to support business users remote business units. Ability to translate business needs into digestible information for end users UTA Competencies: Social Acumen – Exhibiting strong Emotional Intelligence skills (self-awareness, self-management, social awareness, relationship management). Relating comfortably with people across levels, functions, culture, and geography. Partnering with others to get work done. Navigating conflict. Seeking feedback without being defensive. Develops Self & Others – Taking action to continuously improve. Accepting assignments that broaden capabilities. Placing a high priority on developing others. Developing others through coaching, feedback, exposure, and stretch assignments. Ensures Fairness – Concerned with the welfare of others and expressing that concern on a personal level. Distributing resources fairly. Giving others a voice prior to reaching decisions that affect them. Reaching decisions through a fair process. Explaining to others why and how decisions were made that impact them. Safety – Acting as a Safety Ambassador by working safely, complying with requirements and serving as an example to others. Wearing required personal protective equipment. Integrity – Acting with honesty, strong ethics, and accountability and taking responsibility for actions and mistakes. Belonging – Creating a culture where employees are seen, heard, valued and safe to be authentic. Teamwork – Building strong teams that create an environment where everyone’s unique skills and perspectives contribute to shared purpose , connection and achievement of goals. Empowerment – Creating a workplace environment where people are properly resourced and motivated to do their best in solving problems and taking ownership of their work. Accountability – Taking ownership of self-actions, decisions and performance. UTA Competencies: Social Acumen – Exhibiting strong Emotional Intelligence skills (self-awareness, self-management, social awareness, relationship management). Relating comfortably with people across levels, functions, culture, and geography. Partnering with others to get work done. Navigating conflict. Seeking feedback without being defensive. Develops Self & Others – Taking action to continuously improve. Accepting assignments that broaden capabilities. Placing a high priority on developing others. Developing others through coaching, feedback, exposure, and stretch assignments. Ensures Fairness – Concerned with the welfare of others and expressing that concern on a personal level. Distributing resources fairly. Giving others a voice prior to reaching decisions that affect them. Reaching decisions through a fair process. Explaining to others why and how decisions were made that impact them. Safety – Acting as a Safety Ambassador by working safely, complying with requirements and serving as an example to others. Wearing required personal protective equipment. Integrity – Acting with honesty, strong ethics, and accountability and taking responsibility for actions and mistakes. Belonging – Creating a culture where employees are seen, heard, valued and safe to be authentic. Teamwork – Building strong teams that create an environment where everyone’s unique skills and perspectives contribute to shared purpose , connection and achievement of goals. Empowerment – Creating a workplace environment where people are properly resourced and motivated to do their best in solving problems and taking ownership of their work. Accountability – Taking ownership of self-actions, decisions and performance. - OR - An equivalent combination of relevant education and experience. [UTA reserves the right to determine the equivalencies of education and experience.] Regular Admin Full-Time As a full-time Administrative Employee, your Total Rewards Benefits Package will include: Health, dental, vision, life/AD&D, short-term and long-term disability insurance, with Flexible Spending and Dependent Care accounts. Choice between Traditional Co-Pay or High Deductible Health Plans for medical coverage. HSA with company match available to employees enrolled in the HDHP. Benefit plans include coverage for domestic partners (eligibility affidavit required for coverage). Onsite Health and Wellness Clinics for medical care at no cost to employees, spouses, domestic partners, and dependent children. 22 days of accrued paid time off (13 vacation days and 9 sick days), which increases with tenure at UTA. 10 paid holidays and two paid (2) floating holidays per year. Retirement options - Pension Plan with 5-year vesting schedule and 457 Contribution Plan, available for immediate contributions and company matching. Generous tuition reimbursement for higher education, available for any higher education degree (bachelor, master, or PHD). Course of study must be approved prior to enrollment. Training, development, and career advancement opportunities. Paid parental leave for birth, adoption, and child placement (after 12 months of employment). Free transit passes for employees, their spouses, and their dependent children. Employee assistance program – includes counseling, legal services, financial planning, etc. UTA Well – a comprehensive wellness program designed to support employees and dependents in their health and wellness goals. Free on-site fitness facilities and discounted membership to VASA Fitness and EoS Fitness. Discounted cell phone plans with T-Mobile and AT&T. Pet insurance plan options (tailored plan coverage based on pet’s health and needs). For more information on UTA’s Total Rewards benefits package, please visit: Pay Range: $82,400.00 or more depending on experience If interested, apply before: 7/20/2026 Must be able to come into UTA FrontLines Headquarters in downtown Salt Lake City during work hours. PM21 Utah Transit Authority is an Equal Opportunity Employer of all persons regardless of race, color, religion, sex, national origin, age, disability, covered veterans, sexual orientation, and gender identity. Women, minorities, and people with disabilities are encouraged to apply. Applicants needing an accommodation under the Americans with Disabilities Act for any part of the application process should contact UTA Human Resources at View phone number on adzuna.com. A minimum of two work days' notice prior to the need for the accommodation is required. Utah Transit Authority is a drug-free workplace, subject to federal drug and alcohol testing regulations under 49 CFR Part 40, 655, and 219. All offers for employment are contingent upon a successful pre-employment drug test. If a pre-employment test returns a non-negative result, an application for employment may be rejected. All employees are subject to reasonable suspicion and post-accident testing for drug and alcohol use. All safety sensitive employees are subject to random testing for drug and alcohol use. Summary Designs, builds, and maintains UTA’s business intelligence data and reporting solutions to deliver trusted metrics and actionable insights across the agency. Partners with business and technical stakeholders to translate analytics needs into reliable data models, curated datasets, and dashboards/visualizations for audiences ranging from frontline teams to executive leadership. Supports data governance and data quality efforts to ensure appropriate use, definitions, and stewardship of enterprise data for decision-making. Develops documentation, standards, and enablement processes that help users adopt BI tools and self-service reporting responsibly. Provides backup support for BI reporting platforms, including scheduling, publishing/QA, and monitoring of automated reporting and BI ETL processes. PIda80e3c41fb5-25448-40984981