Sr. Software Engineer (Snowflake & ELT/ET))

*THIS IS A REMOTE POSITION BUT PREFER CST LOCATION**

At this time, we are seeking applicants that are eligible to work in U.S without any sponsorship requirements either now or in the future.

We are currently seeking an experienced Senior Snowflake Developer for our corporate applications data & integration transformation team. 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, Postgres, SQL Server, Snowflake.

You will leverage tools such as SQLDBM, DBT, FiveTran, Airflow, AWS Glue, Boomi, Liquibase, GitHub to develop the next generation analytical platform for CDK Global LLC.

The ideal candidate will have experience with Snowflake, excellent SQL skills, strong experience in BI using one or more RDMS, and experience with corporate applications data such as Workday, Oracle Financials, Salesforce or similar. This position entails working on the full lifecycle of data development projects including design and implementation from white board to ELT to Snowflake.

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.
• Participate in modernization projects moving to Snowflake leveraging a stack including AWS Glue, FiveTran, PowerBI, Airbyte, Boomi, DBT, Liquibase, and GitHub.
• Collaborate with cross-functional teams in the US and India, including data developers, project managers, scrum masters, data engineers, data scientists, and business stakeholders to define requirements and build analytics.
• Good understanding of security procedures and principles withing Snowflake
• Ability to define the right warehouse strategy in Snowflake and setup autoscaling in a cost-effective manner wherever applicable.
• Follow Snowflake best practices to produce cost-effective and high-performance Snowflake data warehouses.
• Understand the best practices around JOINS, VIEWS, and other SQL techniques.
• Analyze legacy business processes and reports to design new and improved modern solutions.
• Identify ways to improve performance or value of the data and analytical platform and tools.

Experience Requirements

• 5+ years of Data Warehousing / DBMS developer experience is required.
• At least 2 + years of experience as Snowflake senior developer is required.

Skills Requirements:

• 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.
• Strong analytical and problem-solving skills.
• 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.
• Able to meet ongoing and overlapping deadlines, handle multiple assignments simultaneously, and can coordinate work and dependencies with other groups.
• Working understanding of relational theory, Kimball, Inman, and Snowflake design patterns.
• You will be asked for writing samples, code examples and other examples as part of the interview process.
• Positive attitude and can-do attitude.

Platforms:

• Experience with other data warehouse platforms like Red Shift, Vertica, or Teradata plus.

Snowflakes Experience:

• Experience in data modeling within Snowflake
• Working knowledge of Snowflake including Warehouse management, Stages, Cluster, Role based security, zero share, cloning, time travel, file formats, UDFs, external tables.
• Experience in using S3 as a source and target for Snowflake data loads.
• Experience with fine tuning large volume loads in Snowflake.

ELT/ETL Experience:

• Work experience connecting Snowflake with ETL tools like DataStage, FiveTran, Airflow, AWS Glue or similar.
• Working experience of writing ETL/ELT processes using Python connector, SnowSQL, Snowpark, Tasks, Streams.
• Other best practice data development approaches related to ETL / ELT

Power BI or Tableau

• Experience of connecting reporting tools like PowerBI or Tableau to Snowflake.
• Experience with designing efficient connections for reporting tools.

Data/Databases/Other Technologies:

• 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 using various development IDEs to connect to Oracle, Postgres, SQL Server, or Snowflake.
• 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.
• Experience with Jira, Confluence, GitHub, VSCode, Azure Data Studio, DBT, Liquibase, SQL Developer.
• MS Office - Ability to use Excel and Word when needed.

Education / Certification:

• College Degree in Computer Science, Information Technology, Economics, Engineering or similar.
• Snowflake Certification required other certifications a plus.

Salary Range: $85,500 - $110,000

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.