Lead Business Systems Analyst

Job Summary

We are seeking a highly skilled and collaborative Analytics Engineer to join our growing data team. In this role, you will be responsible for designing, building, and maintaining scalable data models and transformation pipelines that power analytics and business intelligence across the organization. You will work closely with data analysts, data engineers, and business stakeholders to ensure data is accurate, accessible, and actionable.

Key Responsibilities

Data Modeling & Transformation

• Develop and maintain modular, well-documented data models using dbt
• Write efficient, maintainable SQL transformations across Snowflake and SQL Server
• Apply best practices in dimensional modeling and ELT architecture

Cloud & Platform Integration

Data Quality & Governance

Testing & Deployment

Analytics Enablement

Project & Workflow Management

Security & Performance

Qualifications

Nice to Have

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.

Skills Required

Github, Power Bi, Sql Server, Jira, Ssis, Sql, Azure Data Factory, Confluence, dbt, snowflake , Postgres, Oracle, Python