Data Engineer Salt Lake

Utah Transit Authority

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.

EDUCATION/TRAINING: Bachelor's degree in Information Systems, Business, Computer Science, or Engineering.

EXPERIENCE:

• 2-3 years preferred in data analytics with Information Builders or similar data visualization software.
• 2-3 years preferred in data modeling, data scrubbing, and data quality reviews.
• 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 them 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.
• 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 collaborate within a team environment.
• Self‑motivated; willing to work under pressure and stress at times.
• Occasional unscheduled or weekend work may be required to support critical agency needs.
• Local travel may be required to support remote business units.
• Ability to translate business needs into digestible information for end users.

• Social Acumen – exhibiting strong emotional intelligence across levels, functions, and cultures.
• Develops Self & Others – continuously improving and developing others through coaching and exposure.
• Ensures Fairness – distributing resources fairly and engaging others in decision-making.
• Safety – working safely, complying with requirements, and serving as an example.
• Integrity – acting with honesty, ethics, and accountability.
• Belonging – creating a culture where employees are valued and authentic.
• Teamwork – building strong teams that achieve shared goals.
• Empowerment – providing resources and motivation to solve problems and own work.
• Accountability – taking ownership of actions, decisions, and performance.

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, Flexible Spending and Dependent Care accounts; choice between Traditional Co‑Pay or High Deductible Health Plans; HSA with company match for HDHP enrollees.
• 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), increasing with tenure.
• 10 paid holidays and two floating holidays per year.
• Retirement options – Pension Plan with 5‑year vesting and 457 Contribution Plan with company matching.
• Generous tuition reimbursement for higher education (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…