Developer III (Lead Architect – Snowflake & Data Engineering)

Role Overview:

We are seeking a highly experienced Developer III (Lead/Architect level) to drive strategic design complex data architecture and stakeholder alignment for a large-scale data migration initiative. This role will focus on transitioning legacy Oracle-based systems to a modern Snowflake data platform while ensuring scalability governance and business continuity.

Key Responsibilities:

1. Strategic Design & Governance:

• Lead architecture design and define target Snowflake data models (Bronze/Silver/Gold layers).
• Drive migration from Oracle PL/SQL (row-based) to Snowflake SQL (columnar architecture).
• Establish and enforce data governance security and compliance frameworks including RBAC (Role-Based Access Control).
• Define and standardize DBT frameworks including macros materialization strategies (Incremental vs. Table) and CI/CD pipelines.
• Ensure alignment with enterprise data architecture and best practices.

2. Stakeholder & Change Management:

• Lead User Acceptance Testing (UAT) efforts particularly for inbound data and availability validation.
• Act as a bridge between technical teams and business stakeholders translating technical gaps into business impact.
• Serve as the primary escalation point for critical (P0) issues including migration failures and data discrepancies.
• Own cutover planning and execution including Go-Live runbooks and final data synchronization from Oracle to Snowflake.

3. Leadership & Delivery Management:

• Lead and manage offshore development teams ensuring timely delivery and quality of work.
• Provide technical guidance code reviews and mentorship to engineering teams.
• Coordinate across cross-functional teams including data engineering business users and external vendors.

Project Deliverables:

• Weekly status reports outlining progress risks and milestones.
• Timely submission of timesheets and project documentation.
• Successful execution of migration milestones and production deployment.

Required Qualifications:

• Extensive experience in Snowflake architecture and data warehousing.
• Strong expertise in Oracle PL/SQL and migration to cloud-based platforms.
• Hands-on experience with DBT CI/CD pipelines and modern data engineering practices.
• Proven experience in enterprise data migration and transformation projects.
• Strong understanding of data security governance and RBAC models.
• Excellent stakeholder management and communication skills.
• Experience leading onsite offshore delivery models.

Preferred Qualifications:

• Experience working with public sector or large enterprise environments.
• Familiarity with Agile/Scrum methodologies.
• Strong problem-solving skills with the ability to manage high-impact production issues.

Trinus Corporation a leading provider of technology solutions and services with over 25 years of experience is a certified WBE/MBE/SBE/SDB firm accredited by WBENC NMSDC and SBA. Our mission is to shape the future of work by aligning the right mix of people process technology and innovation to efficiently meet our clients business objectives. At Trinus we understand that finding the right opportunity is pivotal in your career journey. Our staffing services go beyond mere placements; they are about matching your skills and aspirations with the perfect fit. To learn more about us please visit our website