Job Description Summary

Become part of the team that is transforming CDK Data & Analytics capabilities which will be a boost the company's operating efficiency. If you are a highly motivated and experienced Developer who works in the big data space and is very familiar with Snowflake, then we want to talk with YOU. The mission is to implement a unified view of CDK enterprise data for sales, revenue, customer, employee, vendor, and contracts; just to name a few. This unified visibility will help to drive new revenue opportunities, improve productivity, accelerate data visualizations, and allow for the retirement or consolidation of multiple systems. Please submit your resume and a cover letter detailing your relevant experience and qualifications. If you want to share your Blog, Gist or GitHub account please do!

Job Description

We are currently seeking an experienced Senior Snowflake Developer for our corporate applications data & integration transformation team. The ideal candidate will have experience with Snowflake, excellent SQL skills, strong experience in using one or more RDMS. This position entails working on the full lifecycle of data development projects including design and implementation from white board to ELT to Snowflake. You will be part of a team of developers, analysts, SMEs, and architects designing and building Snowflake data warehouses and analytical solutions which draw from legacy and modern data sources stored in various cloud and on-premises databases such as Oracle and Salesforce.com. You will leverage tools such as DBT, FiveTran, Coalesce, AirByte, Airflow and GitHub to develop the next generation data mesh platform for CDK Global LLC.

Key Responsibilities

• Be a key contributor in projects that include a mix of application and/or data integration, data warehousing, analytics, governance, and reporting solutions.
• Help design and implement user stories working in an Agile Scrum 2-week spring cadence.
• Participate in PI Planning and long-range roadmap planning.
• Collaborate with cross-functional teams in the US and India, including developers, scrum masters, data engineers, data scientists, and business stakeholders to define requirements and build analytics.
• Good understanding of dimensional data modelling.
• Follow Snowflake best practices.
• Understand the SQL performance best practices around JOINS, VIEWS, and other SQL syntax.
• Identify ways to improve performance or value of the data and analytical platform and tools.

Candidate Requirements

• Data Warehousing / DBMS developer experience of 5 years.
• Experience as Snowflake senior developer 2+ years.
• Positive attitude and can-do attitude.
• Able to work in a large organization with a mix of onshore, offshore, employee, vendor, and contract employees in multiple departments and time zones.
• Comfortable working in Zoom meetings with Camera On.
• Attention to detail, producing high quality work product.
• Ability to contribute both independently and as part of a team.
• Excellent listening, communication, interpersonal and presentation skills.
• Strong analytical and problem-solving skills.
• College Degree in Computer Science, Information Technology, Economics, Engineering or similar.
• Snowflake Certification required other certifications a plus.
• Working understanding of relational theory, Kimball, Inman, and Snowflake design patterns.
• You may be asked for writing samples, code examples and other examples as part of the interview process.

Skill Requirements

• Experience with other data warehouse platforms like Red Shift, Vertica, or Teradata plus.
• Working knowledge of Snowflake internals including warehouse management, stages, Role based security, zero share cloning, time travel, stored procedures, python, UDFs, external tables.
• Knowledge and working experience connecting Snowflake with ETL tools like FiveTran, Airflow or similar.
• Knowledge and working experience of writing ETL/ELT processes using Python connector, SnowSQL, Snowpark, Tasks, Streams.
• Working knowledge in python.
• Experience in using S3 as a source and target for Snowflake data loads.
• Familiarity with ELT, ETL and other best practice data development approaches.
• Experience with tuning large volume loads in Snowflake.
• Database skills including SQL DDL/DML statement development, table/view design/implementation, SQL performance tuning, data analysis and integration.
• Write well performing SQL to perform complex joins.
• Experience with data related to corporate applications (such as CRM, HR, Finance, Sales, Marketing, Procurement) a plus.
• Experience working a CI/CD full lifecycle environment a plus.

CDK Global is committed to fair and equitable compensation practices. Compensation packages are based on several factors, including but not limited to skills, experience, certifications, and work location. The total compensation package for this position may also include annual performance bonus, benefits and/or other applicable incentive compensation plans.We offer Medical, dental, and vision benefits in addition to:

• Paid Time Off (PTO)
• 401K Matching Program
• Tuition Reimbursement

At CDK, we believe inclusion and diversity are essential in inspiring meaningful connections to our people, customers and communities. We are open, curious and encourage different views, so that everyone can be their best selves and make an impact.

CDK is an Equal Opportunity Employer committed to creating an inclusive workforce where everyone is valued. Qualified applicants will receive consideration for employment without regard to race, color, creed, ancestry, national origin, gender, sexual orientation, gender identity, gender expression, marital status, creed or religion, age, disability (including pregnancy), results of genetic testing, service in the military, veteran status or any other category protected by law.

Applicants for employment in the US must be authorized to work in the US. CDK may offer employer visa sponsorship to applicants.