Senior Data Engineer

Who is Gen II?

With 13 offices and more than 1,900 employees in the U.S., Canada, the UK, and Europe, we’re looking for do-ers, problem-solvers, and entrepreneurs like you who want to make an impact in our industry, grow with us, and create a community where everyone thrives.

Careers mean more at Gen II – more opportunity, more innovation, and more ideas! You’ll have the opportunity to grow in ways that are meaningful to you and work alongside some of the best people in their field. You’ll also receive training which will advance your skill set, both technically and personally allowing you to achieve your career aspirations with us.

Be part of our community that recognizes achievements, promotes from within, and receive meaningful benefits which focus on your physical, mental and financial well-being.

Gen II is building out its Data & Integration Platform – the central data backbone that powers data integration, analytics, reporting, and AI capabilities across our fund administration technology estate. At the heart of DIP is a Snowflake-based medallion data architecture – Bronze, Silver, and Gold – fed by integrations across 40+ systems and consumed by business intelligence, client‑facing products, and AI-driven services.

We are looking for a Senior Data Engineer to join the DIP team and take direct ownership of data layer delivery – building and maintaining the Bronze, Silver and Gold layers that turn raw system data into trusted, analytics‑ready assets. Like our integration practice, our data engineering function is AI‑assisted: we expect you to use AI tooling as a natural part of how you work, whether that’s generating transformation logic, scaffolding Streamlit applications, or accelerating documentation.

You will be expected to come in, get up to speed quickly, and drive data work streams forward with minimal oversight. You will report to and work closely with the Associate Director of Data Engineering to establish and maintain the data platform standards and patterns.

• Building and maintaining Bronze à Gold layers within Snowflake – effectively moving data throughout Snowflake for reporting, analytics and egress to downstream systems.
• Designing and implementing Snowflake data models aligned to the Gen II canonical domain model – fund structures, investors, GL, NAV, compliance.
• Developing and maintaining Snowflake Streams, Tasks, and Stored Procedures for pipeline orchestration and incremental processing.
• Owning data quality – implementing validation, monitoring, and alerting within the pipeline to ensure Gold layer data is trustworthy.
• Working with Fivetran‑synced data from source systems and Snowflake Secure Data Shares, building clean ingestion patterns at the Bronze/Silver boundary.

• Using AI tooling (LLMs, codegen, Claude) across all data engineering work – generating transformation SQL, scaffolding Python scripts, producing test cases, and automating documentation; AI assistance is the default mode of working, not a selective shortcut.
• Contributing to a data factory approach – reusable, metadata‑driven patterns for transformation, testing, and deployment that can be applied consistently across data streams.
• Building Streamlit applications in Snowflake for internal operational tooling – data review queues, reconciliation dashboards, client provisioning workflows, and similar.
• Writing Python scripts and utilities to support data processing, validation, and operational tasks within the DIP ecosystem.
• Contributing to pytest‑based test suites for data pipeline validation, aligned to DIP QA standards.

• Structuring Gold layer outputs to serve downstream consumers – Power BI, Qlik, and client‑facing analytics products.
• Collaborating with BI specialists to ensure data models support reporting requirements without duplication or technical debt.
• Supporting the establishment of master data management and golden record patterns across key fund administration entities.

• Taking data work streams from requirement to production with minimal hand‑hanging.
• Working closely with the Associate Director of…