Skills

SQL Apache Airflow GitHub CI/CD Jenkins Change Management Analytics and Reporting apache power bi Analytics Snowflake CI/CD Pipelines

Job Specifications

Job Title: Snowflake Developer (Data Warehouse Design & SQL)

Years of Experience: 5-7

Snowflake Developer with strong expertise in Data Warehouse design and SQL development. The candidate will be responsible for designing and building a scalable data warehouse layer on Snowflake, creating schemas, views and optimizing data models for analytics and reporting.

Required Skills & Experience

• Strong hands-on experience with Snowflake, including schema design, performance tuning, and platform best practices.

• Advanced SQL skills with experience building complex views and transformations, alongside a strong understanding of data modeling, clustering, partitioning, and query optimization techniques.

• Proven expertise in data warehouse design, including star and snowflake schemas and fact and dimension modeling.

• Workflow orchestration experience using Apache Airflow for data ingestion pipelines, including DAG design, scheduling, dependency management, and operational troubleshooting.

• Experience implementing and managing CI/CD pipelines using Jenkins.

• Working knowledge of GitHub for source control, code reviews, and deployment workflows.

Preferred Skills

• Demonstrated experience leveraging Liquibase for automated and auditable database change management.

• Experience with AI-enabled solution development and implementation.

• Expertise in building and maintaining Power BI semantic models and dashboards.

About the Company

Established in 2000, LanceSoft is a pioneer in delivering top-notch Global Workforce Solutions and IT Services to a diverse clientele. As a Certified MBE and Woman-Owned organization, we pride ourselves on fostering global cross-cultural connections that advance both the careers of our employees and the success of our clients' businesses. At LanceSoft, our mission is clear: to leverage our global network to seamlessly connect businesses with the right talent and individuals with the right opportunities, all without bias. We... Know more