Data Product Analyst - AWS Data Ingestion & Snowflake

Heitmeyer Consulting; Richardson (TX); On-site; USD 80,000 - 110,000; Full time

Job summary

Heitmeyer Consulting is seeking a Data Product Analyst to support the analysis and migration of disparate data sources into AWS, leveraging expert SQL knowledge. This role requires hands-on experience in ingesting data into AWS and familiarity with Snowflake, focusing on data quality and documentation.

Located in Dallas, TX, the Data Product Analyst will engage in data refinement, troubleshooting, and enterprise migration efforts within the Chief Data Office.

Qualifications

• Experience executing smoke tests of data pipelines.
• Proven background in a banking or financial services environment is beneficial.
• Ability to troubleshoot data ingestion issues.

Responsibilities

• Ingest data from Microsoft SQL Server into AWS Bronze layer.
• Support data transformation in Silver and Gold layers.
• Troubleshoot source data anomalies and ingestion constraints.
• Participate in enterprise data migration efforts.
• Ensure high data quality standards by executing smoke tests.
• Develop advanced SQL for data profiling and validation.
• Collaborate with architects and data modelers.

Skills

Expert SQL skills

AWS ingestion experience

Snowflake familiarity

Medallion Architecture understanding

Data quality assurance

Agile/scrum experience

Data modeling capabilities

Excellent documentation skills

Tools

Microsoft SQL Server

Job description

Heitmeyer Consulting is seeking a Data Product Analyst to support the analysis and migration of disparate data sources into AWS, leveraging expert SQL knowledge. This role requires hands-on experience in ingesting data into AWS and familiarity with Snowflake, focusing on data quality and documentation.

Located in Dallas, TX, the Data Product Analyst will engage in data refinement, troubleshooting, and enterprise migration efforts within the Chief Data Office.