Senior Data Engineer - IGEN

POSITION SUMMARY

The Senior Data Engineer is the technical leader for IGEN's Data Foundation - architecting, building, and operating the Snowflake data platform, Azure-native ingestion infrastructure, and governed data products that the broader organization depends on for trusted decision-making and AI-powered capability. Owns the architectural integrity of the platform - ingestion patterns, transformation frameworks, schema governance, lineage, and pipeline SLAs - and partners directly with the Director, Data & Analytics on platform strategy.

Operates with AI-assisted development capabilities as a standard part of the discipline, builds within the broader Microsoft and Azure ecosystem, and mentors Data Engineers as the function scales. Works inside the AI governance framework developed in partnership with U.S. Venture Legal, Info Sec, Privacy, and Compliance, ensuring the data foundation supports IGEN's SOC 2 Type 2 obligations and the responsible deployment of AI capabilities across the platform.

IGEN, a division of U.S. Venture, is a leading tax compliance software company trusted by industry leaders. Our tax compliance platform, powered by a data engine, gives you the complete toolkit for reducing redundancy and risk while managing tax compliance implications across the organization.

Preferred location for this position is our Corporate Headquarters in Appleton, WI, with hybrid work options available.

JOB RESPONSIBILITIES

* Leads the design and implementation of enterprise-grade data pipelines on Snowflake and Azure - owning ingestion, transformation, and serving layers for governed data products that support leadership reporting, client experience analytics, product usage analytics, and the regulatory intelligence pipeline.

* Architects ingestion and integration patterns across IGEN's source systems - including operational databases, SaaS platforms, regulatory data sources, and product telemetry - applying CDC, batch, and streaming patterns where appropriate.

* Establishes and maintains transformation frameworks using dbt as the modeling standard, defines layering and naming conventions, and ensures all pipelines are version-controlled, tested, and observable.

* Owns pipeline SLAs across the platform - defining and tracking freshness, completeness, and error-rate targets for every data product, with documented runbooks and on-call rotation for production-critical pipelines.

* Drives schema governance and data modeling discipline - including conceptual, logical, and physical data models, naming conventions, and the management of breaking changes across consuming Power BI dashboards and downstream AI capabilities.

* Implements and maintains data lineage, catalog, and metadata management - ensuring every governed KPI has a traceable source, definition, owner, and certification status.

* Partners with the Director, Data & Analytics on the Center of Excellence operating model - including intake processes, prioritization, stakeholder reviews, and the technical roadmap for the data platform.

* Uses AI development assistants - Git Hub Copilot, Microsoft Copilot, Claude, and emerging agent-based tooling - as a standard part of daily engineering practice. Applies sound judgment in reviewing, validating, and securing AI-generated transformation logic and pipeline code.

* Designs and operates the regulatory intelligence pipeline - ingesting jurisdictional updates from federal, state, and local sources and structuring them for downstream AI-assisted change-impact analysis against Comply

IQ, Tax Determination, and Reconciliation modules.

* Implements data security, privacy, and compliance controls aligned with SOC 2 Type 2 obligations and the AI governance framework - including data classification, access controls, encryption at rest and in transit, PII handling, and audit trail requirements. Partners with U.S. Venture Info Sec, Privacy, and Compliance as required.

* Drives engineering best practices across the data function - including CI/CD for data, version control, automated testing of transformation logic, observability, and incident response.

* Mentors Data Engineers - through code review, architectural pairing, and knowledge sharing - and contributes to the growth of the team's technical capability as IGEN scales the function.

* Optimizes cost and performance across the Snowflake platform - including warehouse sizing, query optimization, storage management, and chargeback visibility for consuming functions.

* Continuously develops professionally - particularly in AI-assisted development, agentic data workflows, and emerging Microsoft and Azure data platform capabilities. Stays current as the boundary between human and agent work continues to evolve.

* Lives the company values of High Performance, Caring Relationships, Strategic Foresight, and Entrepreneurial Spirit. Champions continuous improvement and quality.

* Supports corporate efforts for safety, government compliance, and all other company policies and procedures.

* Live…