
Sr. Data Warehouse ETL (26-02253) -
InterSources · Location not stated · Hybrid
Strong hiring record · median 28 days open
- First seen
- 17 November 2026
- Reposted
- Not since September 2026
All reasons
- No location stated
In its favour
- Posted today
- Still listed on the employer's own board
Locals highly preferred; open for relocation (Candidate must be willing to relocate on their own expense)
Location
West Los Angeles, CA (hybrid)
Duration
Long Term
Job Information Job Taxonomy
Data Warehouse ETL
Job Title
Job Description
This position is classified as structured hybrid, with an expectation of a minimum 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.
JOB DESCRIPTION
Job Summary
Green Dot Corporation is seeking for a Lead Data Architect 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 building data warehouse models, ETL development, automated testing framework, performance tuning, service delivery, incident resolution tracking, and change management.
Key Responsibilities
Architecting and maintaining Operational data stores (ODS), Enterprise Data Warehouse (EDW) and associated data intelligence environments including data lakes, data marts, and metadata repositories.
Designing and implementing high performance data movement pipelines using multiple ETL tools (Informatica, Azure Data Factory, SQL Packages, etc) with batch and real-time event data streams.
Developing scalable and re-usable frameworks for ingestion of structured and semi-structured data; and implementing various large-scale settlement and reconciliation frameworks.
Designing and creating data architecture and data flow diagrams and collaborating with peers to translate requirements into logical and physical data models.
Ensures data warehouse features and capabilities are incorporated into data model designs to optimize performance, resiliency, and scalability.
Delivering and presenting proofs of concept to of key technology components to project stakeholders and internal technology leaders.
Leading and coordinating the design and operationalization of Data Governance capabilities like data lineage, data catalog, data quality, etc.
Problem-solving of Data warehouse and ODS application issues and production errors, including high level critical production issues that require immediate attention.
Write, test and produce production grade ETL data pipeline code in financial services without relying on testing by other groups.
Implement intelligent testing frameworks that auto-generate test cases, predict bugs, and enable self-healing.
Leads the creation of test strategy, test planning, and test execution related to all aspects of testing like functional, integration, systems, end-to-end testing, accessibility, database validations, and automation.
Integrate test suites into CI/CD pipelines (Jenkins, Github).
Required Qualifications
Bachelors and/or masters degree in computer science, Computer Engineering or related field preferred.
8+ years of overall software development experience is required primarily with Data warehouse applications, with 3+ years in a technical leadership role.
3+ years of hands-on development experience in Cloud-based data warehouse platform (AWS Redshift preferred) and experience with ETL tools (Informatica Cloud preferred).
3+ years of development experience with Python scripting experience.
Strong knowledge and experience in OLAP data modeling & design.
Knowledge of data governance, security, and compliance standards (e.g., SOC 2, PCI DSS).
Demonstrated expertise in performance tuning in various DB environments with large volumes of data.
Familiarity with CI/CD pipelines (e.g., Jenkins, GitHub Actions) and infrastructure-as-code tools.
Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
Communication and professional skills and the ability to navigate relationships across business units.
Preferred Qualifications
Experience in fintech or enterprise data warehouse platforms.
Familiarity with data warehouse operational domains such as partner reporting, compliance analytics, and business intelligence.
Contributions to open-source QA frameworks or technical publications.
Demonstrated leadership in building scalable QA practices, as outlined in internal QA leadership guidance.
About Us
InterSources Inc, a Certified Diverse Supplier, was founded in 2007 and offers innovative solutions to help clients with Digital Transformations across various domains and industries. Our history spans over 19 years and today we are an Award-Winning Global Software Consultancy solving complex problems with technology. We recognize that our employees and our clients are our strengths as the diverse talents and opportunities they bring to the table enable us to grow as a global platform and they are causally linked with our success. We provide strategic and technical advice, and we have expertise in areas covering Artificial Intelligence, Cloud Migration, Custom Software Development, Data Analytics Infrastructure & Cloud Solutions, Cyber Security Services, etc. We make reasonable accommodations for clients and employees and we do not discriminate based on any protected attribute including race, religion, color, national origin, gender sexual orientation, gender identity, age, or marital status. We also are a Google Cloud partner company. We align strategy with execution and provide secure service solutions by developing and using the latest technologies that thrive our resources to deliver industry-leading capabilities to our clients and customers, making it convenient for our clients to do business with InterSources Inc. Our teams also drive growth by refining technology-driven client experiences that put the users first, providing an unparalleled experience. This results in strengthening the core technologies of clients, enabling them to scale with flexibility, create seamless digital experiences and build lifelong relationships.
Skills
More jobs at InterSources
All 178- Programmer Analyst 4InterSources · Glen Allen, VAtoday
- Senior Linux Administrator (26-02255) -InterSources · Remotetoday
- Microsoft Copilot Studio Developer (26-02254) -InterSources · Location not statedtoday
- Technical Support Analyst 4InterSources · Richmond, VAtoday
- Software Tester/QA Analyst 3InterSources · Richmond, VAyesterday
Similar roles
- Data Architect (Adobe Analytics to Customer Journey Analytics)Jobgether · Germanytoday
- Principal Data AnalystCARFAX · Reston, Virginia · USD 100,000–140,000/yrtoday
- Data EngineerBenchling · San Francisco, CAtoday
- Azure Data EngineerBluetab, an IBM · San Isidro, Perutoday
- Principal Data ScientistAlice · Ramat Gan, Tel Aviv District, Israeltoday
- State Street Investment Management - Data Scientist - Summer Internship 2027State Street · Boston, Massachusetts, United States of America · USD 41,600–65,000/yrtoday