Job Description
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.
• 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.
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.
• 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.
💡 Quick Summary
Seeking a career-building opportunity? The Developer III (Lead / Architect – Snowflake & Data Engineering) position is now open for candidates interested in the IT Engineer & Developer Jobs sector. This role in Los Angeles offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in IT Engineer & Developer Jobs is a plus.
