Senior Data Engineer, Digital Transformation

Bounteous United State
Visa Sponsorship
Apply
AI Summary

Bounteous seeks a Senior Data Engineer to lead pipeline and consumption pattern migration to a Lakehouse environment. Responsibilities include refactoring logic, data transfer, and stakeholder engagement. Requires 5+ years of coding experience, Python/Java proficiency, and expertise in data modeling and SQL.

Key Highlights
Lead migration of data pipelines and consumption patterns to a Lakehouse environment.
Ensure data integrity and functional equivalence through rigorous validation and reconciliation.
Act as a technical liaison, facilitating stakeholder sign-offs and ensuring business requirements are met.
Key Responsibilities
Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
Executing the physical migration of underlying datasets while ensuring data integrity.
Acting as a technical liaison to internal clients, facilitating "handoff and sign-off" conversations with data owners to ensure migrated assets meet business requirements.
Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
Understanding usage patterns to deliver the required data products.
Working with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows.
Promote and enforce awareness of key information security practices, including acceptable use of information assets, malware protection, and password security protocols.
Identify, assess, and report security risks, focusing on how these risks impact the confidentiality, integrity, and availability of information assets.
Understand and evaluate how data is stored, processed, or transmitted, ensuring compliance with data privacy and protection standards (GDPR, CCPA, etc.).
Ensure data protection measures are integrated throughout the information lifecycle to safeguard sensitive information.
Technical Skills Required
Python Java SQL Spark Kafka ANSI SQL FTP JSON Avro Parquet Hadoop HDFS Hive Snowflake Apache Iceberg Sybase IQ CI/CD K8s
Benefits & Perks
$110,000 - $125,000 a year

Job Description


Bounteous is a premier end-to-end digital transformation consultancy dedicated to partnering with ambitious brands to create digital solutions for today’s complex challenges and tomorrow’s opportunities. With uncompromising standards for technical and domain expertise, we deliver innovative and strategic solutions in Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing.

Our Co-Innovation methodology is a unique engagement model designed to align interests and accelerate value creation. Our clients worldwide benefit from the skills and expertise of over 4,000+ expert team members across the Americas, APAC, and EMEA. By partnering with leading technology providers, we craft transformative digital experiences that enhance customer engagement and drive business success.

Information Security Responsibilities

  • Promote and enforce awareness of key information security practices, including acceptable use of information assets, malware protection, and password security protocols
  • Identify, assess, and report security risks, focusing on how these risks impact the confidentiality, integrity, and availability of information assets
  • Understand and evaluate how data is stored, processed, or transmitted, ensuring compliance with data privacy and protection standards (GDPR, CCPA, etc.)
  • Ensure data protection measures are integrated throughout the information lifecycle to safeguard sensitive information

Responsibilities

  • Pipeline Migration
  • Logic & Scheduling: Refactoring and migrating extraction logic and job scheduling from legacy frameworks to the new Lakehouse environment.
  • Data Transfer: Executing the physical migration of underlying datasets while ensuring data integrity.
  • Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "handoff and sign-off" conversations with data owners to ensure migrated assets meet business requirements
  • Consumption Pattern Migration
  • Code Conversion: Translating and optimizing legacy SQL and Spark-based consumption patterns (raw and modeled) for compatibility with Snowflake and Iceberg.
  • Usage analysis: Understand usage patterns to deliver the required data products.
  • Stakeholder Engagement: Acting as a technical liaison to internal clients, facilitating "handoff and sign-off" conversations with data owners to ensure migrated assets meet business requirements.
  • Data Reconciliation & Quality

A rigorous approach to data validation is required. Candidates must work with reconciliation frameworks to build confidence that migrated data is functionally equivalent to that already used within production flows.

Technical Skills

  • Basic Qualifications
  • Education: Bachelor’s or Master’s degree in Computer Science, Applied Mathematics, Engineering, or a related quantitative field.
  • Experience: Minimum of 5 years of professional "hands-on-keyboard" coding experience in a collaborative, team-based environment. Ability to trouble shoot (SQL) and basic scripting experience.
  • Languages: Professional proficiency in Python or Java.
  • Methodology: Deep familiarity with the full Software Development Life Cycle (SDLC) and CI/CD best practices & K8s deployment experience.
  • Core Data Engineering Competencies: Candidates must demonstrate a sophisticated understanding of the following modeling concepts to ensure data correctness during reconciliation:
  • Temporal Data Modeling: Managing state changes over time (e.g., SCD Type 2).
  • Schema Management: Expertise in Schema Evolution (Ref: Iceberg Apache) and enforcement strategies.
  • Performance Optimization: Advanced knowledge of data partitioning and clustering.
  • Architectural Theory: Balancing Normalization vs. Denormalization and the strategic use of Natural vs. Surrogate Keys.
  • Technical Stack Requirements:

Extraction & Logic: Kafka, ANSI SQL, FTP, Apache Spark

Data Formats: JSON, Avro, Parquet

Platforms: Hadoop (HDFS/Hive), Snowflake, Apache Iceberg, Sybase IQ

Candidate will also need to work with our internal data management platform, and must have an aptitude for learning new workflows and language constructs is essential.

$110,000 - $125,000 a year

We invite you to stay connected with us by subscribing to our monthly job openings alert here .

Bounteous is proud to be an equal opportunity employer. Bounteous does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, physical or mental disability, national origin, veteran status, or any other status protected under federal, state, or local law. Bounteous is willing to sponsor eligible candidates for employment visas.

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Similar Jobs

Explore other opportunities that match your interests

Senior Policy Data Scientist

Data Science
4h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

anthropic

United State

Lead Data Analyst - Property Claims Control Home

Data Science
13h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

Progressive Insurance

United State

Safeguards Data Science and Analytics Lead

Data Science
17h ago

Premium Job

Sign up is free! Login or Sign up to view full details.

•••••• •••••• ••••••
Job Type ••••••
Experience Level ••••••

anthropic

United State

Subscribe our newsletter

New Things Will Always Update Regularly