Data Analyst – Data Integration & Enablement

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

Job Title: Data Analyst – Data Integration & Enablement
Location: Salt Lake City, UT
Type: Permanent Full Time
Compensation: 0
Work Model: Hybrid – onsite and remote
Hours: 40.0
Security Clearance: None

Overview

Leave placeholder text here for recruiter to input

Responsibilities

• Partner with business and technology stakeholders to understand business needs and translate them into clear, actionable data integration, reporting, and analytics requirements.
• Profile and analyze source systems, data structures, and business rules using SQL and Python to identify data relationships, anomalies, quality issues, and integration requirements.
• Analyze and document source-to-target data flows supporting the Enterprise Data Warehouse, Data Lake, Data Mesh, ODS, and downstream reporting and analytics solutions.
• Define and maintain source-to-target mappings, transformation rules, metadata, business definitions, and data lineage to improve data transparency, traceability, and regulatory compliance.
• Develop and execute comprehensive data validation and testing activities, including data reconciliation, transformation validation, test cases, and data quality controls.
• Develop and enhance automated processes using SQL, Python, and modern data technologies to improve the efficiency of data profiling, validation, reconciliation, and reporting.
• Collaborate with data engineers, architects, business analysts, and end users to troubleshoot data issues, perform root cause analysis, and ensure delivered solutions meet business and functional requirements.
• Contribute to data modernization and continuous improvement initiatives using technologies and approaches such as dbt, Databricks on GCP, Data Mesh, and AI/GenAI.
• Promote data quality and documentation best practices, share knowledge across the team, and provide guidance or mentorship to team members as appropriate.

Requirements

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Business, or a related discipline, along with 2+ years of experience in data analysis, data integration, business intelligence, or a related data-focused role.
• Strong hands-on SQL skills, including complex queries, joins, aggregations, data profiling, transformation analysis, reconciliation, and data validation.
• Working proficiency in Python for data analysis, automation, data quality validation, and data integration activities.
• Experience analyzing source and target data models and documenting source-to-target mappings, transformation logic, metadata, data lineage, and business rules.
• Solid understanding of data quality, data testing, reconciliation, ETL/ELT, data integration, and troubleshooting within enterprise data environments.
• Strong analytical and problem-solving skills, with the ability to investigate complex data issues, identify root causes, and recommend solutions.
• Strong requirements gathering, documentation, and stakeholder communication skills, with the ability to translate business needs into actionable data requirements.
• Ability to collaborate effectively with both business and technology teams in a complex enterprise environment.

Desired Qualifications

• Exposure to modern data platforms and technologies such as Databricks, dbt, GCP, Enterprise Data Warehouses, Data Lakes, Data Mesh, and Operational Data Stores (ODS).
• Experience supporting data environments within financial services, banking, regulatory reporting, or another highly regulated industry.
• Experience coordinating project activities, supporting workstreams, or mentoring team members.
• Exposure to AI/GenAI concepts, AI-enabled data solutions, or prompt engineering.

System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, Marital status, or any other characteristic protected by applicable federal, state, or local law.

Ref: #404-IT Pittsburgh