To Apply for this Job Click Here
Heitmeyer Consulting has a banking client that has a need within their Chief Data Office for a strong Data Product Analyst to support the analysis and migration of multiple disparate data sources into the AWS environment. Role must be based in Dallas, TX or Tulsa, OK.
Top Required Skills:
- Expert SQL skills with ability to write and optimize complex queries across large datasets.
- Hands-on experience ingesting data into AWS (S3, Glue, Athena, Lambda, Redshift, EMR, or equivalent).
- Strong understanding of Medallion Architecture (Bronze – Silver – Gold).
- Experience extracting and modeling data from Microsoft SQL Server.
- Proven track record working within agile/scrum frameworks.
- Ability to diagnose data ingestion or modeling issues from source through cloud landing zones.
- Excellent documentation capability (data dictionaries, metadata, lineage).
Nice-to-have:
- Experience in banking or financial services.
- Exposure to fraud data across deposits, loans, ATM, or digital channels.
- Experience with Snowflake, Azure, or GCP (AWS strongly preferred).
Key Responsibilities
- Ingest data from diverse operational systems—primarily Microsoft SQL Server—into the AWS Bronze layer following best practices for quality, performance, and lineage.
- Support data refinement and transformation through Silver and Gold layers within a Medallion Architecture.
- Troubleshoot issues related to source data anomalies, AWS ingestion constraints, pipeline performance, and platform-level challenges.
- Participate in enterprise data migration efforts and modernization initiatives within AWS.
- Develop and optimize advanced SQL for profiling, validation, and data transformation.
- Partner with Architects and Data Modelers to align data structures, business logic, and operational use cases.
- Ensure data documentation—including data dictionaries, lineage, metadata, and quality rules—is complete and accurate.
- Collaborate with the Data Product Owner to convert business needs into actionable user stories.
- Participate fully in sprint ceremonies and agile routines.
- Identify opportunities to improve data architecture and ingestion patterns.
Heitmeyer Consulting is an equal opportunity employer, and we encourage all qualified candidates to apply. Qualified applicants will be considered without regard to minority status, gender, disability, veteran status or any other characteristic protected by law.