Data Analyst (SQL/Snowflake) at 3Core Systems

Job description

Role: Data Analyst (Snowflake / SQL) Location: REMOTE Duration: 12+ Months Role Overview We are looking for a Data Analyst (Snowflake / SQL) to support data analysis, data profiling, lineage validation, reporting, and regulatory data initiatives. The role will involve working with large and complex datasets in Snowflake, analyzing source-to-target data flows, validating report and data lineage, identifying data quality issues, and supporting the onboarding and maintenance of regulatory reports. The ideal candidate should have strong SQL and data analysis capabilities, a good understanding of data flows and lineage, and the ability to work with both business and technical stakeholders to investigate data issues and translate reporting requirements into actionable data requirements. Key Responsibilities · Analyze data across source systems, transformation layers, data warehouses, and reporting platforms using advanced SQL. · Perform data profiling, validation, reconciliation, and exploratory analysis to understand data structures, relationships, completeness, and quality. · Analyze and validate source-to-target mappings, ensuring that data is correctly mapped through different stages of the data flow. · Validate report-to-source lineage, including the flow of data from source systems through transformations to final reports. · Trace data elements across systems to support impact analysis, issue investigation, and regulatory reporting requirements. · Support the onboarding of new regulatory reports by analyzing data requirements, source systems, mappings, transformations, and reporting logic. · Review existing reports and data flows to identify lineage gaps, inconsistencies, or undocumented transformations. · Perform data quality assessments and investigate issues related to completeness, accuracy, consistency, timeliness, and validity. · Conduct root cause analysis for data and reporting issues and work with technology and business teams to identify appropriate remediation. · Develop SQL queries and analytical outputs to support data investigations, reporting requirements, and governance activities. · Create and maintain analytical metrics, operational reports, and dashboards to communicate data quality and reporting outcomes. · Support audit, risk, compliance, and regulatory reporting activities, including data validation and evidence preparation. · Interpret business requirements, reporting specifications, and BRDs and translate them into data and analytical requirements. · Work closely with Data Analysts, Business Analysts, Data Engineers, Data Governance teams, Report Owners, and business stakeholders. · Document data findings, mappings, lineage, business rules, analytical logic, and issue-resolution outcomes. · Contribute to continuous improvement of data analysis, reporting, and data quality processes. Required Skills & Experience · Strong hands-on experience with SQL, including complex joins, subqueries, CTEs, aggregations, window functions, and data validation queries. · Experience working with Snowflake or a comparable cloud data warehouse. · Strong experience in data analysis and data profiling. · Understanding of data lineage, data flows, source-to-target mappings, and data transformations. · Experience investigating data quality issues and performing root cause analysis. · Ability to analyze large datasets and identify patterns, anomalies, inconsistencies, and data gaps. · Experience working with business and technical requirements and interpreting BRDs, reporting specifications, and data requirements. · Good understanding of reporting and data processes within enterprise environments. · Experience supporting regulatory reporting, risk, compliance, or audit-related data activities is preferred. · Strong documentation and communication skills. · Ability to collaborate effectively with technical teams, business users, data owners, and reporting stakeholders. Key Deliverables · Accurate and validated source-to-target mappings. · Documented and validated report and data lineage. · Data profiling and quality assessment outputs. · Root-cause analysis and resolution of data issues. · Data requirements and mapping documentation for regulatory reports. · Data validation and reconciliation results. · Audit and regulatory evidence. · Meaningful data quality and reporting metrics. · Clear documentation of data flows, transformations, and business rules. Preferred Skills · Experience with Power BI or other BI/reporting tools. · Experience working with regulatory reporting datasets and controls. · Exposure to data governance, metadata management, or data catalog platforms. · Experience with financial services, banking, insurance, or other highly regulated industries. · Knowledge of ETL/ELT concepts and modern cloud data architectures. · Familiarity with data reconciliation and control frameworks.

Requirements

Requirements not extracted — see the original description below.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sql

Platform: zoho-recruit
Effort: medium