Data Engineer, Data Governance & Compliance

Rocket; Detroit (MI); Hybrid; USD 120,000 - 150,000; Full time

Job summary

Rocket Mortgage® was founded in 1985. Today, we’re a Detroit-based, publicly traded company with a mission to Help Everyone Home. At Rocket Mortgage, we believe that home is more than the house you live in.

Our wide variety of home loan options, tools and resources empower our clients to achieve their homeownership dreams. This role involves designing, developing and maintaining data platforms, ELT pipelines, and data models in a hybrid environment, with on-premises and cloud data warehouses, to

Qualifications

• 5+ years building data solutions, including relational and non-relational databases, and batch/real-time pipelines using cloud services.
• 3+ years analyzing data to identify deliverables, gaps and inconsistencies.
• Proficiency in writing simple and complex SQL/NoSQL queries.
• Expertise debugging and troubleshooting applications.
• Proficiency in a programming language (functional or OO).

Responsibilities

• Identify, investigate and solve data quality issues to ensure data security and reliability.
• Develop ELT processes from various data repositories and APIs across the enterprise.
• Create data processing scripts and workflows.
• Work in a hybrid data environment with on-premises and cloud data warehouses.
• Develop relational and non-relational data models to fit user needs.
• Monitor performance and scalability in a large-scale data lake environment.

Skills

SQL/NoSQL

Data pipelines

Programming languages

Debugging

Data analysis

Education

Bachelor's degree in CS/IT

Tools

Python

AWS Lambda

CI/CD

REST APIs

Job description

As a Data Engineer, you engage in the design, development and maintenance of data platforms and solutions, including applying data management principles to pipelines and delivering analytical and operational solutions to provide visibility and enable decision-making. You develop data integration solutions and work with cross-functional teams to build products and services to meet business needs.

About The Role

• Identify, investigate and solve data quality issues and ensure data is secure and reliable
• Develop Extract, Load, Transform (ELT) processes from various data repositories and APIs across the enterprise, ensuring data quality and process efficiency
• Develop data processing scripts
• Work in a hybrid data environment with on-premises and cloud data warehouses
• Develop relational and non-relational data models to shape data to meet user needs
• Monitor performance and scalability issues in a large-scale data lake environment

About You

Minimum Qualifications

• 5 years of experience or equivalent competency building data solutions, including relational and non-relational databases, and supporting implementation and maintenance of batch and real-time data pipelines using cloud services
• 3 years of experience or equivalent competency analyzing data to identify deliverables, gaps and inconsistencies
• Expertise writing simple and complex queries (SQL/NoSQL)
• Expertise debugging and troubleshooting applications
• Proficiency in a functional or object-oriented programming language

Preferred Qualifications

• Degree or equivalent competency in computer science, information technology, or a related field
• 3 years of experience with big data and distributed data tools, such as Python and Lambda
• 3 years of experience with continuous integration and continuous delivery (CI/CD) and automated deployments
• Knowledge of Linux system administration, shell scripting and basic networking skills
• Experience accessing and developing REST APIs

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 Mortgage® was founded in 1985. Today, we’re a Detroit-based, publicly traded company with a mission to Help Everyone Home. At Rocket Mortgage, we believe that home is more than the house you live in. Our wide variety of home loan options, tools and resources empower our clients to achieve their homeownership dreams. We’re known as experts in the mortgage industry, but we’re also innovators - we strive to create the best experiences for our clients from beginning to end. And we’re not your typical employer. 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].