Senior Data Engineer – Investments Data Platform (Snowflake)
Senior Data Architect designing scalable Snowflake-based investment data platforms with ELT pipelines, data modeling, governance, and performance optimization. Who are we looking for? 20+ years of experience building enterprise‑scale data platforms, preferably within asset management, capital markets, or financial services, who will play a critical role in shaping the architecture, development standards, and long‑term scalability of this strategic investments data platform. Key Responsibilities Data Platform & Pipeline Engineering Design, build, and maintain robust, scalable ELT pipelines on Snowflake to ingest data from IBOR/ABOR systems, custodians, market data providers, and internal platforms. Implement end‑to‑end ingestion, standardization, and transformation logic using Airflow, dbt, Python, and Snowflake stored procedures. Manage schema evolution, metadata, and versioning to support changing upstream data structures without disrupting downstream consumers. Data Modeling & Analytics Enablement Design and implement investment‑focused data models to support holdings, transactions, cash flows, exposure analytics, and performance reporting. Build analytics‑ready, well‑documented data structures optimized for portfolio management, finance, risk, and regulatory use cases. Partner with reporting, analytics, and investment operations teams to translate business reporting requirements into scalable technical designs. Data Quality, Governance & Controls Establish and enforce data quality checks, reconciliation controls, and validation frameworks to ensure accuracy and completeness of financial data. Implement governance standards including lineage, auditability, and data certification aligned with regulatory and internal control expectations. Support operational readiness by enabling monitoring, alerting, and issue resolution across data pipelines. Performance & Scalability Optimize Snowflake performance and cost efficiency for large‑scale financial datasets through clustering, partitioning, and query tuning. Contribute to platform architecture decisions, development standards, and best practices to ensure long‑term scalability and maintainability. Collaboration & Leadership Work closely with investment operations, finance, reporting, and analytics stakeholders to ensure platform alignment with business needs. Act as a senior technical contributor in a lean, high‑impact environment, influencing design decisions and mentoring junior engineers as needed. Required Qualifications 10–15 years of experience building enterprise‑scale data platforms, preferably within asset management, capital markets, or financial services. Deep hands‑on experience with Snowflake, including performance optimization and advanced SQL development. Strong experience with modern ELT frameworks such as dbt and orchestration tools like Airflow. Advanced proficiency in SQL and Python for data transformation, automation, and control frameworks. Proven experience designing complex financial data models supporting holdings, transactions, cash flows, and exposure analytics. Solid understanding of IBOR/ABOR concepts, investment operations, and downstream reporting requirements. Experience implementing data quality, reconciliation, and governance controls in regulated environments. Preferred Qualifications Experience working with custodian data feeds, market data, and investment accounting platforms. Familiarity with regulatory reporting and audit requirements in investment management. Exposure to cloud‑native data architectures and cost optimization strategies. Strong documentation and stakeholder communication skills. Behavioral & Leadership Competencies Strong analytical problem‑solving; able to resolve complex technical and operational issues. Executive‑level communication and stakeholder management. Self‑motivated, outcome‑oriented, with a strong transformation and delivery focus. Collaborates effectively across matrixed teams; drives client satisfaction and trust.
Senior Test Lead (Annuity)
Test Lead responsible for test strategy, manual and automation testing, SQL data validation, and ensuring quality in insurance and retirement systems such as pensions and annuities. Who are we looking for? Require a Test Lead with 10 to 14 years of experience (Level 6) in software testing, with at least 5 years in Life Insurance or Retirement services (Pension/401k). Strong knowledge in Retirement Services , insurance domain with focus on validating applications that manage pensions, annuities, 401(k) plans, and other retirement benefits. Technical Skills: Test Lead Primary Skills : Test Strategy and Execution: Develop comprehensive test plans, test cases, and test scenarios based on business requirements, Functional Specification Documents (FSDs), and User Stories. Annuity knowledge: Fixed, Variable & Indexed Annuities. Should know IRA plans e.g. Traditional IRA, Roth IRA, 401(k), 403 (b), 457, SEP, SIMPLE Have hands on exposure to policy admin systems like Vantage, ALIP, Navisys, FAST, OIPA, EXL Life Pro, etc. Insurance domain SME with US based ANNUITY domain knowledge Technical Skills: Manual testing proficiency is mandatory; experience in automation tools (Selenium, UFT) is highly preferred Database: Strong SQL skills for data validation Secondary Skills: Automation testing knowledge on UFT or LeanFT, API Testing, Performance testing, Functional test design. Insurance domain knowledge Automation frameworks and reporting tools. Writing, executing, monitoring and maintenance of automated test suites. CI/CD tools knowledge and Agile process OOPs and JDBC Concepts. Tools: Experience with Test Management tools (e.g., Jira, TestRail, ALM) Problem-solving and analytical skills; Strong programming skills Verbal, both one-on-one and with a group, and written