Data Engineer I - (Salt Lake City)

About the role

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.

Responsibilities

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

Requirements

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

Qualifications

• UTA Competencies: Social Acumen, Develops Self & Others, Ensures Fairness, Safety, Integrity, Belonging, Teamwork, Empowerment, Accountability.

Skills

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

Benefits

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

Pay

Pay Range: $82,400.00 or more depending on experience

Schedule

Regular Admin Full-Time