Lead Data Warehouse Engineer

Green Dot; Los Angeles, San Francisco (CA, CA); Hybrid; USD 140,000 - 199,000; Full time

Job summary

Green Dot Corporation is seeking an experienced Senior Data Warehouse Developer to join our team delivering a next‑gen cloud hosted data platform. You will design and implement data warehouse models, ETL pipelines, and governance across 24x7 enterprise data environments.

The role requires deep cloud data warehousing expertise (Azure/AWS, Databricks, Redshift, Snowflake) and strong SQL and Python skills. Structured hybrid work with three days in-office and two remote days is expected within

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Computer Engineering or related field preferred 8+ years of overall software development experience is required primarily with Data warehouse and BI applications.
• 8+ years of hands-on development experience in Cloud-based data warehouse platforms – Azure/AWS Databricks, AWS Redshift, Snowflake or similar
• 5+ years of hands-on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle)
• 5+ years of development experience with Python, Windows batch scripting or Unix Shell scripting.
• Strong knowledge in OLAP data modeling & design; performance tuning in large data volumes.

Responsibilities

• Architecting and maintaining ODS, EDW and data intelligence environments
• Designing and implementing data pipelines using ETL tools and streaming data
• Developing scalable ingestion frameworks for structured and semi-structured data
• Designing data architectures and models from business requirements across units
• Leading design reviews and communicating artifacts with stakeholders
• Creating source-to-target data mappings with multi-step transformations
• Ensuring data models and ETL pipelines maximize performance and resiliency
• Delivering proofs of concept for key technology components to stakeholders
• Leading MDM, Data Quality & Data Governance initiatives including data lineage
• Collaborating with project team to deliver cloud data platforms components
• Solving production issues and supporting major initiatives

Skills

Cloud data platforms

ETL development

Data modeling

Performance tuning

Stakeholder collaboration

Problem solving

Data governance

Education

Bachelor’s or Master’s in CS/Engineering or related field

Tools

Azure

AWS Databricks

AWS Redshift

Snowflake

Informatica IDMC

SQL Server

PostgreSQL

Oracle

Python

Unix Shell Scripting

Windows Batch Scripting

Job description

We’re looking for talented professionals to join us in bringing smart money management and payment solutions to everyone’s fingertips. This position is classified as structured hybrid, with an expectation of three (3) days per week working in the office and flexibility to work remotely on the remaining days. On-site expectations may evolve over time to support business needs, with clear communication provided in advance.

Location Requirement

This position is open only to candidates who currently reside in one of the following approved locations: West Los Angeles, CA

Summary

This is an exciting opportunity for an experienced senior data warehouse developer of large-scale data solutions. You will join a team delivering a transformative next-gen cloud hosted data platform. The ideal candidate will have a proven track record in implementing next-gen cloud data solutions and transformation pipelines for large scale organizations. We are seeking someone with deep technical skills in a variety of data warehouse related technologies to play an important role in developing and delivering early proofs of concept and production implementation. The successful candidate will have hands‑on experience in a multitude of data domains; including but not limited to; 24 x 7 x 365 enterprise and cloud data warehouse and reporting solutions and management, design and build data warehouse models, ETL development, performance tuning, service delivery, incident tracking, and change management.

Responsibilities

• Architecting and maintaining the Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories
• Designing and implementing performance data movement pipelines using multiple ETL tools with batch and real‑time event data streams (Informatica, Databricks, Apache Kafka, Azure Event Hub, SQL Packages, etc.)
• Developing scalable and re‑usable frameworks for ingestion of structured and semi‑structured data; and implementing various large‑scale settlement and reconciliation frameworks
• Gathering business and information requirements from various product owners across various functional units
• Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
• Conducting design review sessions and communicating design artifacts with stakeholders.
• Creating source to Target data mappings including multi step transformations
• Ensures database features and capabilities are incorporated into data model designs and ETL pipelines to optimize performance, resiliency, and scalability.
• Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders
• Developing scalable and re‑usable frameworks for ingestion of structured and semi‑structured data; and implementing various large‑scale settlement and reconciliation frameworks
• Leading and coordinating the design and operationalization of Master Data Management, Data Quality & Data Governance initiatives including end to end data lineage
• Working with other members of the project team to support delivery of additional project components associated with cloud data platforms.
• Problem‑solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.
• Perform other duties as assigned including major new project initiatives.

Qualifications

• Bachelor’s and/or Master’s degree in Computer Science, Computer Engineering or related field preferred 8+ years of overall software development experience is required primarily with Data warehouse and Business Intelligence applications.
• 8+ years of hands‑on development experience in Cloud‑based data warehouse platform – combination of Azure/AWS Databricks, AWS Redshift, Snowflake or similar
• 8+ years of development experience with Informatica IDMC platform including data integration, Data Quality, Data Governance
• 5+ years of hands‑on development experience with Relational DBs (MS SQL Server, PostgreSQL, Oracle, etc.); experience with complex stored procedures and functions using SQL, optimization of SSIS packages and Redshift database queries.
• 5+ years of development experience with Python, windows batch scripting or Unix Shell scripting.
• Strong knowledge and experience in OLAP data modeling & design Demonstrated expertise in performance tuning in various DB environments with large volumes of data.
• Experience building and scaling distributed, high available systems in cloud env (Azure / AWS) Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Communication and professional skills and the ability to navigate relationships across business units.

Pluses

• Financial technology domain knowledge
• Knowledge of NoSQL DBs (MongoDB / Cassandra / Azure Cosmos DB or similar)
• Microsoft Azure Data Engineer or other cloud certifications
• **Ability to work in the U.S. without sponsorship**
• **Ability to meet the location requirement outlined above**

POSITION TYPE

Regular PAY RANGE The targeted full-time base salary for this position is $139,900 to $199,300 per year. The final compensation will be determined by a number of factors such as qualifications, expertise, and the candidate’s geographical location.

We’re Here to Support You—Accommodations Upon Request

Green Dot is committed to providing an inclusive and accessible hiring experience for all candidates. If you require a reasonable accommodation during any part of the application or interview process, we encourage you to let us know. We will work with you to meet your needs in a way that respects your privacy and ensures equal opportunity. Our goal is to support every applicant in showcasing their talents and potential.

Work Authorization Requirement

At Green Dot Corporation, we value diversity and strive for fair and inclusive hiring practices. However, we are currently unable to offer visa sponsorship. All applicants must be legally authorized to work in the United States at the time of application and throughout the duration of employment, without the need for current or future sponsorship.

Important Notice on Application Accuracy

We value integrity in our hiring process. Please ensure that all information provided in your resume and application is accurate and authentic. Submissions found to be fraudulent or misleading will result in disqualification from consideration, and any offers extended may be rescinded.

Green Dot Corporation (NYSE: GDOT) is a financial technology and registered bank holding company committed to transforming the way people and businesses manage and move money, and making financial wellbeing and empowerment more accessible for all. Our proprietary technology enables faster, more efficient electronic payments and money management, powering intuitive and seamless ways for people to spend, send, control and save their money. Through our retail and direct bank, we offer a broad set of financial products to consumers and businesses including debit, prepaid, checking, credit and payroll cards, as well as robust money processing services, tax refunds, cash deposits and disbursements. Our Banking as a Service ("BaaS") platform enables a growing list of America's most prominent consumer and technology companies to design and deploy their own customized banking and money movement solutions for customers and partners in the US and internationally. Founded in 1999 and headquartered in Provo, UT, our company has served more than 33 million customers directly, and now operates primarily as a "branchless bank" with more than 90,000 retail distribution locations nationwide. Green Dot Bank is a subsidiary of Green Dot Corporation and member of the FDIC.

What We Do

We build simple, seamless and secure financial tools for our customers and powerful solutions that fuel engagement, trust and value for partners.

Our Mission

We give you the power to bank seamlessly, affordably and with confidence.

Our Purpose

Access should not be a privilege, and we envision a world where modern banking and money management are at everyone’s fingertips—where banking enhances the flow of life.

Our Values

Stewardship, Trust, Action, High Performance, and Teamwork.