Hybrid Data Integration & Analytics Analyst

DataJobs; Salt Lake City (UT); Hybrid; USD 65,000 - 100,000; Full time

Benefits offered by this job

Health insurance

401(k) plan

Job summary

System One is seeking a Data Analyst in Salt Lake City to connect business goals with data integration and reporting outcomes. You will translate stakeholder needs into clear data requirements, analyze source systems, and enhance transparency through lineage, metadata, and validation.

You will work with SQL, Python, and modern data technologies to support a modern Data Warehouse, Data Lake, and Data Mesh architecture while ensuring data quality and regulatory compliance.

Qualifications

• Bachelor’s degree in a related field with 2+ years of data analysis/BI experience.
• Strong SQL skills including complex queries, joins, and data profiling.
• Proficiency in Python for analysis, automation, and data validation.
• Experience documenting source-to-target mappings, metadata, and data lineage.
• Understanding of ETL/ELT in enterprise data environments and data quality.

Responsibilities

• Collaborate with stakeholders to translate business needs into data requirements for integration, reporting, and analytics.
• Profile and analyze source systems, data structures, and business rules using SQL and Python.
• Document data flows and lineage supporting data warehouse, data lake, and downstream reporting solutions.
• Define mappings, transformation rules, and metadata to improve traceability and compliance.
• Develop data validation tests, reconcile data, and ensure data quality across pipelines.
• Build automated profiling, validation, reconciliation, and reporting processes using SQL and Python.
• Work with data engineers, architects, and analysts to troubleshoot data issues and verify solutions.
• Support data modernization using tools like dbt, Databricks on GCP, and AI/GenAI.

Skills

SQL

Python

dbt

Databricks on GCP

Data Mesh

ETL/ELT

AI/GenAI

Education

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

Tools

GCP

Databricks

DBT

Job description

System One is seeking a Data Analyst in Salt Lake City to connect business goals with data integration and reporting outcomes. You will translate stakeholder needs into clear data requirements, analyze source systems, and enhance transparency through lineage, metadata, and validation.

You will work with SQL, Python, and modern data technologies to support a modern Data Warehouse, Data Lake, and Data Mesh architecture while ensuring data quality and regulatory compliance.