Lead Developer (onsite)

STAND 8 provides end to end IT solutions to enterprise partners across the United States and with offices in Los Angeles, New York, New Jersey, Atlanta, and more including internationally in Mexico and India. Define and lead the strategic architecture and implementation of a Snowflake-based data platform, guiding the transition from legacy Oracle PL/SQL systems to modern cloud-based data solutions. This role is responsible for establishing governance, security, and development standards while ensuring alignment between technical solutions and business objectives. The Sr/Lead Developer will collaborate closely with stakeholders to drive data migration efforts, resolve critical issues, and ensure seamless delivery. Additionally, this position plays a key role in leading technical teams and ensuring high-quality execution across all phases of the project. Location & Work Type Location: Los Angeles, CA Work Type: Onsite Key Responsibilities • Define and implement target Snowflake architecture, including Bronze, Silver, and Gold data layers • Lead migration strategy from Oracle PL/SQL to Snowflake's columnar SQL approach • Establish and enforce dbt project standards, including macros, materialization strategies, and CI/CD pipelines • Implement and manage Snowflake security using Role-Based Access Control (RBAC) • Coordinate onsite with cross-functional teams, vendors, and partners to ensure alignment • Lead User Acceptance Testing (UAT) processes and validate data availability with business users • Translate technical gaps into business impact and communicate effectively with stakeholders • Serve as primary escalation point for critical migration issues and data discrepancies • Own and execute cutover planning, including final data synchronization during production deployment • Lead and manage offshore development teams, ensuring delivery quality and timelines Qualifications Required: • Extensive experience with Snowflake data platform architecture and implementation • Strong expertise in Oracle PL/SQL and data migration strategies • Proven experience with dbt, including macros, materializations, and CI/CD integration • Deep understanding of data security and RBAC implementation • Experience leading large-scale data migration or transformation initiatives • Strong stakeholder management and communication skills • Experience leading distributed or offshore teams Preferred (Optional): • Experience with enterprise data warehouse modernization projects • Familiarity with cloud-based data ecosystems and best practices • Experience with large-scale UAT coordination and execution • Strong problem-solving skills in high-pressure production environments Benefits • Medical coverage and Health Savings Account (HSA) through Anthem • Dental/Vision/Various Ancillary coverages through Unum • 401(k) retirement savings plan • Paid-time-off options • Company-paid Employee Assistance Program (EAP) • Discount programs through ADP WorkforceNow Additional Details The base range for this contract position is $82.92 - $92.92 / per hour, depending on experience. Our pay ranges are determined by role, level, and location. The range displayed on each job posting reflects the minimum and maximum target for new hires of this position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training. Qualified applicants with arrest or conviction records will be considered. About Us STAND 8 provides end-to-end IT solutions to enterprise partners across the United States and globally with offices in Los Angeles, Atlanta, New York, Mexico, Japan, India, and more. STAND 8 focuses on the "bleeding edge" of technology and leverages automation, process, marketing, and over fifteen years of success and growth to provide a world-class experience for our customers, partners, and employees. Our mission is to impact the world positively by creating success through PEOPLE, PROCESS, and TECHNOLOGY. Check out more at www.stand8.io; and reach out today to explore opportunities to grow together! By applying to this position, your data will be processed in accordance with the STAND 8 Privacy Policy.