Data Analyst – Data Integration & Enablement

Hybrid in Salt Lake City, UT
, System One is hiring a Data Analyst to help connect business goals with data integration and reporting outcomes. In this role, you will translate stakeholder needs into clear data requirements, analyze source systems, and strengthen transparency through lineage, metadata, and validation. You will also support modernization efforts using modern data technologies.

• Partner with business and technology stakeholders to understand business needs and convert them into actionable requirements for data integration, reporting, and analytics
  .
• Profile and analyze source systems, data structures, and business rules using SQL and Python to identify relationships, anomalies, quality issues, and integration needs.
• Analyze and document source-to-target data flows that support 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 traceability and support regulatory compliance.
• Develop and execute data validation and testing, including data reconciliation
  , transformation validation, test cases, and data quality controls.
• Build and enhance automated processes using SQL
  , Python
  , and modern data technologies to improve efficiency across profiling, validation, reconciliation, and reporting.
• Collaborate with data engineers, architects, business analysts, and end users to troubleshoot data issues, conduct root cause analysis, and verify solutions meet functional and business requirements.
• Support data modernization and continuous improvement using approaches and tools such as dbt
  , Databricks on GCP
  , Data Mesh
  , and AI/GenAI
  .
• Promote data quality and documentation best practices, share knowledge with the team, and provide guidance or mentorship as appropriate.

• Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business, or a related discipline, plus 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 analysis, automation, data quality validation, and integration activities.
• Experience analyzing source and target models and documenting source-to-target mappings, transformation logic, metadata, data lineage, and business rules.
• Solid understanding of data quality, testing, reconciliation, and ETL/ELT within enterprise data environments, including troubleshooting.
• Strong analytical and problem-solving skills, with the ability to investigate complex issues, identify root causes, and recommend solutions.
• Requirements gathering, documentation, and stakeholder communication skills to translate business needs into actionable data requirements.
• Ability to collaborate effectively with both business and technology teams in a complex enterprise environment.

• SQL
  , Python
  , dbt
  , Databricks on GCP
  , GCP
• Enterprise Data Warehouse, Data Lake, Data Mesh, ODS
• ETL/ELT,
  AI/GenAI

• Health and welfare benefits coverage options including medical, dental, vision
  , spending accounts,
  life insurance
  , and voluntary plans
• Participation in a 401(k) plan

• 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