Lead Data Warehouse Engineer

Green Dot Corporation•Los Angeles, CA

5d•$139,900 - $199,300•Hybrid

About The Position

This is an opportunity for an experienced senior data warehouse developer to help deliver a next-generation, cloud-hosted data platform. The role focuses on implementing cloud data solutions and transformation pipelines for large-scale organizations, with hands-on work across data warehouse technologies and domains. Responsibilities span 24/7/365 enterprise and cloud data warehouse and reporting solutions, data warehouse design and development, ETL, performance tuning, service delivery, incident tracking, and change management. The position is classified as structured hybrid, with an expectation of three days per week in the office and flexibility to work remotely on the remaining days. On-site expectations may change to support business needs, with advance communication.

Requirements

Bachelor’s and/or master’s degree in Computer Science, Computer Engineering, or a related field is preferred.
At least 8 years of overall software development experience, primarily with data warehouse and Business Intelligence applications.
At least 8 years of hands-on development experience with cloud-based data warehouse platforms, such as Azure or AWS Databricks, AWS Redshift, Snowflake, or similar.
At least 8 years of development experience with the Informatica IDMC platform, including data integration, Data Quality, and Data Governance.
At least 5 years of hands-on development experience with relational databases such as MS SQL Server, PostgreSQL, or Oracle.
Experience with complex stored procedures and functions using SQL, optimization of SSIS packages, and Redshift database queries.
At least 5 years of development experience with Python, Windows batch scripting, or Unix shell scripting.
Strong knowledge and experience in OLAP data modeling and design.
Demonstrated expertise in performance tuning in various database environments with large data volumes.
Experience building and scaling distributed, highly available systems in Azure or AWS cloud environments.
Expertise in understanding complex business needs and analyzing, designing, and developing solutions.
Strong communication and professional skills, with the ability to navigate relationships across business units.

Nice To Haves

Financial technology domain knowledge.
Knowledge of NoSQL databases such as MongoDB, Cassandra, or Azure Cosmos DB, or similar.
Microsoft Azure Data Engineer or other cloud certifications.

Responsibilities

Architect and maintain operational data stores (ODS), the Enterprise Data Warehouse (EDW), and associated data intelligence environments, including data lakes, data marts, and metadata repositories.
Design and implement high-performance data movement pipelines using multiple ETL tools and batch and real-time event data streams.
Develop reusable, scalable frameworks for structured and semi-structured data ingestion, and implement large-scale settlement and reconciliation frameworks.
Gather business and information requirements from product owners across functional units.
Design data architecture and data flow diagrams, and collaborate with peers to translate requirements into logical and physical data models.
Conduct design reviews and communicate design artifacts with stakeholders.
Create source-to-target data mappings, including multi-step transformations.
Incorporate database features and capabilities into data models and ETL pipelines to optimize performance, resiliency, and scalability.
Deliver and present proofs of concept for key technology components to project stakeholders and internal technology leaders.
Lead and coordinate the design and operationalization of Master Data Management, Data Quality, and Data Governance initiatives, including end-to-end data lineage.
Support delivery of additional project components associated with cloud data platforms.
Troubleshoot data warehouse and ODS application issues and production errors, including critical production issues requiring immediate attention.
Perform other assigned duties, including work on major new project initiatives.