Data Engineer Salt Lake

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.

Bachelor’s degree in Information Systems, Business, Computer Science, or Engineering.

• 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.

• 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.
• Self‑starter with exceptional critical thinking and 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.
• 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 ad‑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 in remote business units.
• Ability to translate business needs into digestible information for end users.

• Social Acumen – exhibiting strong emotional intelligence skills.
• Develops Self & Others – taking action to continuously improve.
• Ensures Fairness – concerned with the welfare of others.
• Safety – acting as a safety ambassador by working safely.
• Integrity – acting with honesty, strong ethics, and accountability.
• 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.
• Empowerment – creating a workplace environment where people are properly resourced and motivated to do their best.
• Accountability – taking ownership of self‑actions, decisions and performance.

Pay Range: $82,400 or more depending on experience. Full‑time administrative employee. Total rewards benefits package includes:

• Health, dental, vision, life/AD&D, short‑term and long‑term disability insurance, with Flexible Spending and Dependent Care accounts.
• 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).
• 10 paid holidays and two floating holidays per year.
• Retirement options – pension plan with 5‑year vesting schedule and 457 contribution plan with company matching.
• Generous tuition reimbursement for higher education.
• 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 and dependents.
• Employee assistance program – counseling, legal services, financial planning, and more.
• UTA Well – comprehensive wellness program.
• Free onsite fitness facilities and discounted memberships to local fitness centers.
• Discounted cell phone plans.
• Pet insurance plan options.

Must be able to come into UTA Front Lines Headquarters in downtown Salt Lake City during work hours.

Utah Transit Authority is an equal opportunity employer. Women, minorities, and people with disabilities are encouraged to apply.