Data Analyst – Data Integration & Enablement

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

Leave placeholder text here for recruiter to input

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

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

• 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 work streams, 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…