Senior Data Engineer - Data Proposition Products

About the Role Gen II is launching multiple data proposition products that extract, validate and normalize data from our fund administration platforms and financial statements. We are looking for a Senior Data Engineer to lead the extract → validate → normalize → store pipeline and own the journey from raw source data to client‑ready assets. Validation & QC Rules – Ensuring Data Clients Can Trust Build and maintain dbt models that implement comprehensive validation and QC rules on source data. Design rule sets for key fund administration entities—funds, investors, GL accounts, NAV components—ensuring data integrity at ingestion. Monitor and alert on data quality issues before normalized assets reach clients. Document validation rules and exceptions so clients understand what they can rely on. Data Normalization in Snowflake – From Raw to Client-Ready Build and maintain the Medallion architecture (Bronze ingestion, Silver transformation via dbt with validation/QC rules, Gold normalization) to create curated datasets aligned to Gen II's core data model. Enable multi‑channel data delivery: make Gold layer datasets available through Sensr Portal’s Analytics & Databridge for client consumption while powering internal analytics, reporting, and AI‑driven services. Build Snowflake Streams and Tasks for incremental processing, keeping normalized datasets fresh without full reprocessing. Client Data Enablement – Making Data Self‑Serve Build Streamlit applications for client‑facing data access—dashboards, export tools, data validation status, usage metrics. Create and maintain data dictionaries and lineage documentation that clients need to onboard and trust. Collect client feedback on data quality, schema design, and access patterns to drive continuous improvement. AI‑Assisted Development & Factory Patterns Use AI tooling (LLMs, Claude) across all work—generating dbt rules, transformation SQL, Streamlit scaffolding, test cases, and documentation. Build reusable, metadata‑driven patterns for validation, transformation, and deployment so the team can scale the pipeline without reinventing each step. Delivery & Cross‑Functional Collaboration Take data workstreams from requirement to production with minimal hand‑holding. Work closely with product, integration, and client success teams to understand what data clients need and how to deliver it. Collaborate with the Head of Data Product to ensure data flows cleanly from source through normalization to client delivery. Contribute to data governance practices—lineage, cataloguing, access control, and quality standards that support both internal ops and external consumption. Ideal Background for this Role 5+ years of hands‑on data engineering experience. Bachelor’s or Master’s degree in Computer Science, Software Engineering, or a related field. Deep practical dbt expertise—writing and maintaining transformation logic at scale, testing, and documentation. Strong Snowflake knowledge—data modelling, SQL optimization, Streams/Tasks for incremental processing, Secure Data Shares. Strong Python development—data processing scripts, utilities, and Streamlit applications. Experience building and owning data pipelines from ingestion to consumption. Hands‑on experience with Fivetran or equivalent ELT tooling for source system integration. Active use of AI‑assisted development in data engineering delivery, embedded in daily work. Experience thinking about data as a product; designing schemas, documentation, and access patterns that external or cross‑team consumers depend on. Ability to own workstreams independently and drive delivery without close management. Experience with data quality frameworks and validation rule design (desirable). Exposure to fund administration, private capital, or financial services data environments (desirable). Familiarity with client onboarding processes or APIs (desirable). Strong communication skills with the ability to translate technical decisions into client‑friendly language. Compensation and Benefits The salary range for this position is $140,000 – $170,000, in addition to a discretionary bonus and comprehensive benefits package. The actual salary offered within that range will depend on the candidate’s experience level. Work Arrangement All applicants applying to Gen II Fund Services, LLC must be legally authorized to work in the United States. This role follows a flexible hybrid schedule, with the resource expected in the office 1–4 days per week on a need basis. #J-18808-Ljbffr