Data Integration & Analytics Specialist (Hybrid)

System One; Salt Lake City (UT); Hybrid; USD 65,000 - 95,000; Full time

Job summary

System One is seeking a Data Analyst specializing in data integration and enablement in Salt Lake City. You will partner with business and technology teams to translate needs into robust data pipelines, quality checks, and insightful analytics across enterprise data environments.

You will profile source systems, map data flows, and document lineage while advancing automated validation and testing. A hybrid work model and ongoing modernization initiatives await.

Qualifications

• 2+ years of data analysis, data integration, BI, or related role.
• Strong SQL skills with complex queries, joins, and validation.
• Working Python for data analysis and automation.
• Experience documenting data mappings, lineage, and rules.

Responsibilities

• Collaborate with stakeholders to translate business needs into data requirements.
• Profile source systems and data structures to identify relationships and quality issues.
• Analyze and document data flows for data warehouse, lake, mesh, and downstream reports.
• Define source-to-target mappings, rules, and metadata for transparency and compliance.
• Develop data validation, testing, and reconciliation processes.
• Build automated data profiling, validation, and reporting processes.
• Troubleshoot data issues with engineers and analysts to meet requirements.
• Contribute to data modernization using dbt, Databricks on GCP, and AI/GenAI.

Skills

SQL

Python

Data analysis

Data integration

ETL/ELT

Data quality

Documentation

Stakeholder comms

Education

Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business

Tools

dbt

Databricks

GCP

Job description

System One is seeking a Data Analyst specializing in data integration and enablement in Salt Lake City. You will partner with business and technology teams to translate needs into robust data pipelines, quality checks, and insightful analytics across enterprise data environments.

You will profile source systems, map data flows, and document lineage while advancing automated validation and testing. A hybrid work model and ongoing modernization initiatives await.