Snowflake Engineer

TITLE: Snowflake Engineer
LOCATION: Remote
ANTICIPATED DURATION: 12 months

Responsibilities:

• Develop, test, and maintain SQL supporting applications, reporting, analytics, and business workflows.
• Build and maintain Snowflake tables, views, transformations, mappings, and application-supporting data structures.
• Design, build, and enhance data-driven internal applications using technologies such as Streamlit and Snowflake.
• Use Python for data transformation, validation, file processing, automation, application business logic, and analytical calculations.
• Perform source-to-target reconciliation, record-count validation, field-level testing, and investigation of data discrepancies.
• Convert spreadsheet-, email-, document-, and manual processes into structured applications and workflows.
• Collaborate with business subject-matter experts, analysts, data engineers, architects, and technology partners to develop practical solutions.

Requirements:

• Strong working knowledge of Snowflake, advanced SQL, relational data modeling, tables, views, data transformations, complex joins, CTEs, and window functions.
• Strong proficiency with Python for data manipulation, application development, file processing, automation, business logic, data validation, and reusable modular code.
• Experience with data reconciliation, validation, query troubleshooting and optimization, and development, testing, and production concepts.
• Understanding of data relationships and keys, data quality, source-to-target mapping, historical and trended data, business metrics, and reporting logic.
• Demonstrated ability to build meaningful business applications with data validation, database interaction, write-back functionality, and interactive data visualization.
• Ability to analyze source data, identify keys and relationships, map fields, identify data-quality concerns, and work with engineering teams.
• Ability to diagnose issues across source data, Snowflake, transformations, business logic, applications, reports, and user experience.

Preferred Experience:

• Experience with Streamlit, including multi-page or modular applications, interactive forms, session and state management, application performance, and reusable components.
• Experience with Power BI or a comparable enterprise business intelligence platform.
• Experience with Power Query, DAX, Excel, and related analytical tools.
• Experience in commercial banking, corporate banking, lending, credit, risk, or financial services.
• Exposure to nCino, Salesforce, commercial loan servicing platforms, credit underwriting systems, document management systems, or financial market and data providers.
• Experience with Git or version control, VS Code, Snowpark, Snowflake Cortex, REST APIs, JSON, semi-structured data, Excel automation, or AI and document-intelligence technologies.
• Exposure to Snowflake AI capabilities or other enterprise AI technologies, including semantic models, natural-language analytics, AI agents, document extraction, and automated summarization.

The hourly pay rate range for this position is $70 to $73.36 (dependent on factors including but not limited to client requirements, experience, statutory considerations, and location). Benefits available to full-time employees: medical, dental, vision, disability, life insurance, 401k and commuter benefits. Synergis is proud to be an Equal Opportunity Employer. We value diversity and do not discriminate on the basis of race, color, ethnicity, national origin, religion, age, gender, gender identity, political affiliation, sexual orientation, marital status, disability, military/veteran status, or any other status protected by applicable law. Qualified applicants with arrest or conviction records will be considered for employment in accordance with the requirements of applicable state and local laws, including but not limited to, the San Francisco Fair Chance Ordinance, the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance, the Los Angeles County Fair Chance Ordinance for Employers, and the California Fair Chance Act. For immediate consideration, please forward your resume to Applications@Synergishr.com. If you require assistance or an accommodation in the application or employment process, please contact us at Applications@Synergishr.com. Synergis is a workforce solutions partner serving thousands of businesses and job seekers nationwide. Our digital world has accelerated the need for businesses to build IT ecosystems that enable growth and innovation along with enhancing the Total Experience (TX). Synergis partners with our clients at the intersection of talent and transformation to scale their balanced teams of tech, digital and creative professionals. Learn more about Synergis at www.synergishr.com.