Data Analyst, SQL, Snowflake

This is a fully remote position, open to applicants in United States.

📋 Description

• Evaluate data across various source systems, transformation layers, data warehouses, and reporting platforms utilizing advanced SQL techniques.

• Conduct data profiling, validation, reconciliation, and exploratory analysis to examine data structures, relationships, completeness, and quality.

• Assess and authenticate source-to-target mappings and report-to-source lineage.

• Track data elements across systems for impact analysis, issue investigation, and compliance reporting.

• Assist in the onboarding process of new regulatory reports by analyzing data requirements, source systems, mappings, transformations, and reporting logic.

• Analyze reports and data flows to pinpoint lineage gaps, inconsistencies, and undocumented transformations.

• Investigate data quality issues concerning completeness, accuracy, consistency, timeliness, and validity.

• Perform root cause analysis and collaborate with technology and business teams on remediation efforts.

• Develop SQL queries and analytical outputs for data investigations, reporting, and governance tasks.

• Create and sustain analytical metrics, operational reports, and dashboards.

• Aid in audit, risk, compliance, and regulatory reporting activities, including data validation and preparing evidence.

• Convert business requirements, reporting specifications, and BRDs into data and analytical needs.

• Work in conjunction 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 outcomes of issue resolution.

• Contribute to the continuous enhancement of data analysis, reporting, and data quality processes.

⛳️ Requirements

• Proficient hands-on experience with SQL, including complex joins, subqueries, CTEs, aggregations, window functions, and data validation queries.

• Familiarity with Snowflake or a similar cloud data warehouse.

• Extensive experience in data analysis and data profiling.

• Knowledge of data lineage, data flows, source-to-target mappings, and data transformations.

• Experience in investigating data quality issues and conducting root cause analyses.

• Capacity to analyze large datasets and detect patterns, anomalies, inconsistencies, and data gaps.

• Experience in working with business and technical requirements and interpreting BRDs, reporting specifications, and data requirements.

• Solid understanding of reporting and data processes within enterprise environments.

• Excellent documentation and communication skills.

• Ability to effectively collaborate with technical teams, business users, data owners, and reporting stakeholders.

• Preferred experience in supporting regulatory reporting, risk, compliance, or audit-related data activities.

• Preferred experience with Power BI or other BI/reporting tools.

• Preferred experience working with regulatory reporting datasets and controls.

• Preferred exposure to data governance, metadata management, or data catalog platforms.

• Preferred experience in financial services, banking, insurance, or other highly regulated sectors.

• Preferred knowledge of ETL/ELT concepts and modern cloud data architectures.

• Preferred familiarity with data reconciliation and control frameworks.

🏝️ Benefits

• Contract role with a specified duration of 12+ months.

• Remote work arrangement.