Senior Data Engineer

Talentify; Detroit (MI); On-site; USD 120,000 - 160,000; Full time

Job summary

Rocket, a Detroit-based company, seeks a Senior Data Engineer to design, develop and maintain data platforms and solutions. You will build ingestion/transformation pipelines across a hybrid data environment, mentor teammates, and promote best practices throughout the data engineering lifecycle.

You will lead ETL/ELT development, data modeling, and scalable data processing jobs, while addressing data quality, security and performance concerns across large-scale platforms.

Qualifications

• 7+ years building data solutions with relational/non-relational databases and batch/real-time pipelines in cloud environments.
• 5+ years with dimensional or tabular data modeling.
• Experience designing and developing complex data transformation pipelines.
• 5+ years of CI/CD and automated deployments.
• Expertise writing complex SQL/NoSQL queries.
• Expertise in performance tuning, debugging, and troubleshooting data processing jobs (ETL).
• 5+ years of Python development, including AWS Lambda.

Responsibilities

• Develop ETL/ELT processes to source and curate data from enterprise systems with fast, reliable delivery.
• Create tabular and dimensional models to support analytical and operational use cases.
• Build and maintain data processing jobs to refresh data on a regular cadence.
• Identify and resolve data quality issues, ensuring data security and reliability.
• Troubleshoot complex data pipeline issues with advanced debugging techniques.
• Lead code reviews focusing on performance, scalability and maintainability.
• Work across on-premises and cloud data platforms in a hybrid environment.

Skills

SQL/NoSQL

Data modeling (dimensional/tabular)

ETL/ELT development

CI/CD

Python development (AWS Lambda)

REST APIs

Linux shell scripting

Performance tuning

Cloud services (AWS)

Problem solving

Education

Bachelor's degree in CS/IT or related field

Tools

AWS Lambda

CI/CD pipelines

Job description

As a Senior Data Engineer, you'll engage in the design, development, and maintenance of data platforms and solutions. This includes applying data management principles to pipelines and delivering analytical and operational solutions to enable data-driven decision-making and data activation use cases.

You’ll design and develop data ingestion and transformation solutions, working across a hybrid data environment to build scalable products and services that meet business needs. As a senior member of the team, you’ll also mentor and support the growth of your teammates while helping drive best practices across the data engineering lifecycle.

About the role

• Develop ETL and ELT processes to source and curate data from various enterprise systems, ensuring speed and quality of delivery
• Develop tabular and dimensional data models to support analytical and operational use cases
• Build and maintain data processing jobs to refresh data on a regular cadence
• Guide the identification, investigation, and resolution of data quality issues, ensuring data is secure and reliable
• Utilize advanced debugging techniques to troubleshoot complex data pipeline and processing issues
• Lead code review sessions with a focus on performance, scalability, and maintainability
• Work in a hybrid data environment spanning on-premises and cloud data platforms
• Develop relational and non-relational data models to meet user and business needs
• Proactively identify upstream and downstream dependencies that may impact pipeline performance or reliability
• Monitor and address performance and scalability issues across large-scale data platforms
• Participate in on-call rotations for incident management and production support
• Mentor team members and contribute to their technical development
• Partner with leadership to identify and address technical debt and improve team processes
• Stay current on industry trends and promote adoption of best practices across the team
• Contribute to engineering community initiatives to increase visibility into data engineering work

About you

Minimum Qualifications

• 7 years of experience building data solutions, including relational and non-relational databases and batch/real-time data pipelines using cloud services
• 5 years of experience with dimensional or tabular data modeling
• Experience designing and developing complex data transformation pipelines
• 5 years of experience with CI/CD and automated deployments
• Expertise writing complex queries (SQL/NoSQL)
• Expertise in performance tuning, debugging, and troubleshooting data processing jobs, including ETLs
• 5 years of experience in Python development, including AWS Lambda functions
• Proficiency in a functional or object-oriented programming language
• Strong understanding of database and server internals
• Knowledge of Linux system administration, shell scripting, and basic networking
• Experience developing and consuming REST APIs

Preferred Qualifications

• Degree (or equivalent experience) in computer science, information technology, or a related field
• Knowledge of disaster recovery and backup strategies for data systems
• Experience mentoring and developing other engineers

What you’ll get

Our team members fuel our strategy, innovation and growth, so we ensure the health and well-being of not just you, but your family, too! We go above and beyond to give you the support you need on an individual level and offer all sorts of ways to help you live your best life. We are proud to offer eligible team members perks and health benefits that will help you have peace of mind. Simply put: We’ve got your back. Check out our full list of Benefits and Perks.

About us

Rocket is a Detroit-based company made up of businesses that provide simple, fast and trusted digital solutions for complex transactions. The name comes from our flagship business, now known as Rocket Mortgage®, which was founded in 1985. Today, we’re a publicly traded company involved in many different industries, including mortgages, fintech, real estate and more. We’re insistently different in how we look at the world and are committed to an inclusive workplace where every voice is heard.

This job description is an outline of the primary responsibilities of this position and may be modified at the discretion of the company at any time. Decisions related to employment are not based on race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity or expression, age, military or veteran status or any other characteristic protected by state or federal law. The company provides reasonable accommodations to qualified individuals with disabilities in accordance with applicable state and federal laws. Applicants requiring reasonable accommodations in completing the application and/or participating in the application process should contact a member of the Human Resources team, at [e-mail].