Senior Data Engineering

3 days ago

Remote, United States or Detroit, MI, USASenior

H1B sponsor

Responsibilities

Design, develop, and maintain scalable data pipelines and data integration solutions across enterprise systems and APIs.
Build and support ELT processes using AWS services, including S3 and AWS Glue.
Develop data ingestion frameworks, ETL processes, and reporting datasets within Snowflake.
Identify, investigate, and resolve data quality issues while supporting data security, reliability, and governance.
Develop Python-based data processing scripts and automation solutions.
Create and maintain relational and non-relational data models for analytical and operational use cases.
Monitor and optimize performance, scalability, and reliability in large-scale cloud data environments.
Participate in standups, story refinement, sprint planning, and requirements-gathering sessions.
Use AI-powered development tools such as GitHub Copilot to improve productivity and code quality.
Mentor team members on data engineering practices and help address technical debt and process issues.
Potentially participate in an on-call rotation supporting production systems, including nights and weekends as needed.

At least 7 years of experience building and supporting data solutions in cloud environments.
At least 5 years of experience analyzing data to identify deliverables, gaps, and inconsistencies.
Hands-on experience with AWS services, particularly S3, AWS Glue, and ETL development.
Experience building and maintaining batch and/or real-time data pipelines.
Expertise writing simple and complex SQL queries and working with structured and unstructured data.
Proficiency in Python or another object-oriented programming language.
Experience troubleshooting and resolving data quality and application issues.
A degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
Strong Snowflake architecture and SQL development skills, including performance tuning, security and roles, data loading and unloading, and best practices.
Strong Python programming experience for ETL/ELT frameworks, API and file ingestion, automation, unit testing, and logging.
Experience with Git, CI/CD practices, big data and distributed processing technologies, and REST APIs.
Knowledge of Linux administration, shell scripting, and basic networking concepts.
Experience mentoring and developing others.
Strong communication, collaboration, self-directed learning, and proactive problem-solving abilities.

Eligible team members receive health benefits and wellness support for themselves and their families.
The role is fully remote.
The role may include an on-call rotation, with frequency and scheduling determined by team needs and possible nights-and-weekends coverage.
The company offers career growth and additional benefits and perks.

10,000+ employees

Own the Dream. Mortgage services provided by Rocket Mortgage, LLC. NMLSConsumerAccess.org, NMLS #3030