Data Analyst (Snowflake / SQL)

Latentbridge; United States; Presencial; USD 80.000 - 110.000; Jornada completa

Descripción de la vacante

Latentbridge is seeking a Data Analyst specialized in Snowflake and SQL to support data analysis, profiling, lineage validation, reporting, and regulatory data initiatives. You will work with large datasets and validate data flows and reports, translating business requirements into data needs.

You will collaborate with data engineers, governance teams, and stakeholders, develop SQL queries, dashboards, and metrics, and contribute to data quality and regulatory reporting efforts.

Formación

• Strong hands-on SQL with joins, subqueries, CTEs, and validations.
• Experience with Snowflake or a comparable cloud data warehouse.
• Proven ability in data analysis, profiling, and quality assessment.
• Understanding of data lineage, data flows, mappings, and transformations.
• Ability to translate BRDs and reporting specs into data requirements.
• Experience supporting regulatory, risk, compliance, or audit data activities preferred.

Responsabilidades

• Analyze data across source systems, transformations, warehouses, and reporting platforms.
• Perform data profiling, validation, reconciliation, and exploratory analysis.
• Analyze and validate source-to-target mappings and data lineage.
• Validate report-to-source lineage and data flow to final reports.
• Trace data elements to support impact analysis and regulatory reporting.
• Develop SQL queries and analytical outputs for investigations and governance.
• Create metrics, operational reports, and dashboards for data quality and reporting.
• Support audit, risk, compliance data activities and evidence gathering.
• Document data findings, mappings, lineage, and business rules.
• Collaborate with Data Analysts, Engineers, Governance teams and stakeholders.
• Contribute to continuous improvement of data analysis and quality processes.

Conocimientos

SQL

Data analysis

Data profiling

Data lineage

Reporting

Herramientas

Snowflake

Power BI

Descripción del empleo

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.

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.