Data Analyst, SQL, Snowflake

3Core Systems, Inc

. Analyze data across source systems, transformation layers, data warehouses, and reporting platforms using advanced SQL .

Posted 10/23/2026contractRemote • United StatesMid-LevelSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates strong expertise in SQL for data analysis, validation, and reporting, with a focus on data quality and lineage. Proficient in collaborating with cross-functional teams to support regulatory reporting and continuous improvement of data processes.

Highest-signal resume keywords

Advanced SQL ProficiencyData Analysis and ProfilingData Lineage and MappingRegulatory Reporting ExperiencePower BI or BI Tool Experience

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData ProfilingData ValidationRoot Cause AnalysisData AnalysisData TransformationsData Quality InvestigationData ReconciliationETL/ELT ConceptsData Governance

Soft Skills

Strong Documentation SkillsEffective CommunicationCollaboration with Technical Teams

Tools & Technologies

SnowflakePower BIBI Reporting Tools

Industry Keywords

Financial ServicesBankingInsuranceRegulatory ComplianceAudit

Tech Stack

Tools & technologies

CloudETLSQL

About the role

Key responsibilities & impact

Analyze data across source systems, transformation layers, data warehouses, and reporting platforms using advanced SQL
Perform data profiling, validation, reconciliation, and exploratory analysis to assess data structures, relationships, completeness, and quality
Analyze and validate source-to-target mappings and report-to-source lineage
Trace data elements across systems for impact analysis, issue investigation, and regulatory reporting
Support onboarding of new regulatory reports by analyzing data requirements, source systems, mappings, transformations, and reporting logic
Review reports and data flows to identify lineage gaps, inconsistencies, and undocumented transformations
Investigate data quality issues involving completeness, accuracy, consistency, timeliness, and validity
Conduct root cause analysis and work with technology and business teams on remediation
Develop SQL queries and analytical outputs for data investigations, reporting, and governance activities
Create and maintain analytical metrics, operational reports, and dashboards
Support audit, risk, compliance, and regulatory reporting activities, including data validation and evidence preparation
Translate business requirements, reporting specifications, and BRDs into data and analytical requirements
Collaborate 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

Requirements

What you’ll need

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
Strong documentation and communication skills
Ability to collaborate effectively with technical teams, business users, data owners, and reporting stakeholders
Experience supporting regulatory reporting, risk, compliance, or audit-related data activities is preferred
Experience with Power BI or other BI/reporting tools is preferred
Experience working with regulatory reporting datasets and controls is preferred
Exposure to data governance, metadata management, or data catalog platforms is preferred
Experience with financial services, banking, insurance, or other highly regulated industries is preferred
Knowledge of ETL/ELT concepts and modern cloud data architectures is preferred
Familiarity with data reconciliation and control frameworks is preferred

Benefits

Comp & perks

Contract role with a stated duration of 12+ months
Remote work arrangement