Remote Data Analyst: Snowflake & SQL

Latentbridge; Snowflake (AZ); Ibrido; USD 70.000 - 110.000; Tempo pieno

Descrizione del lavoro

LatentBridge is seeking a Data Analyst to support data analysis, profiling, lineage validation, reporting, and regulatory data initiatives using Snowflake and SQL. You will handle large datasets, analyze source-to-target mappings, validate report lineage, and contribute to onboarding regulatory reports.

The role requires strong SQL, data analysis, and collaboration with business and technical stakeholders to translate requirements into data solutions.

Competenze

• Strong hands-on SQL with complex joins, subqueries, CTEs and data validation queries.
• Experience with Snowflake or a comparable cloud data warehouse.
• 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 translating BRDs and reporting specifications into data requirements.
• Experience supporting regulatory reporting, risk, compliance, or audit-related data activities is preferred.

Mansioni

• Analyze data across source systems, transformations, 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 data is correctly mapped through data flows.
• Validate report-to-source lineage, including data flow from source systems through transformations to final reports.
• Trace data elements across systems to support impact analysis and regulatory reporting requirements.
• Support 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 on 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.

Conoscenze

SQL

Snowflake

Data profiling

Data analysis

Data quality

Stakeholder communication

Strumenti

Power BI

Descrizione del lavoro

LatentBridge is seeking a Data Analyst to support data analysis, profiling, lineage validation, reporting, and regulatory data initiatives using Snowflake and SQL. You will handle large datasets, analyze source-to-target mappings, validate report lineage, and contribute to onboarding regulatory reports.

The role requires strong SQL, data analysis, and collaboration with business and technical stakeholders to translate requirements into data solutions.