Sr. Business Intelligence Analyst

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

We are currently seeking an experienced Senior Business Intelligence Analyst for our enterprise applications data & analytics transformation team. The ideal candidate will have experience with business applications such as Workday, Oracle Financials, Salesforce as well as legacy and modern databases. This position involves working on the full lifecycle approach for data - from requirements gathering through design and implementation. You will be part of a team of analysts, SMEs, architects, and developers 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. In this role you will collaborate with various departments (such as Sales, Customer Experience, Finance, HR) to understand and document requirements. You will participate in scrum teams that will use these requirements to build out our new modern Data Platform. You will analyze legacy analytical tools such as Cognos and others and work to develop the next generation analytical platform for CDK Global LLC.

Key Responsibilities

• Understand the best practices around JOINS, VIEWS and other SQL techniques.
• Collaborate with cross-functional teams in the US and India, including data engineers, data scientists, and business stakeholders to define requirements and build analytics.
• Analyze legacy business processes and reports to design new and improved modern solutions.
• Participate in projects that include a mix of application and/or data integration, data warehousing, analytics, governance, and reporting solutions.
• Participate in modernization projects moving to tools such as Snowflake, PowerBI, Airbyte, Boomi, DBT.
• Identify ways to improve performance or value of the data and analytical platform and tools.
• Use low-code BI tools such as Power Bi to develop reports.
• Write well performing SQL to perform complex joins.
• Participate in legacy migration projects moving off legacy tools such as Cognos, DataStage, Oracle DB and others.
• Participate in scrum teams.
• Collect, document, and analyze business requirements for data and analytical purposes.
• Develop User stories for the implementation teams.

Candidate Requirements

• Positive attitude and a strong desire to be a positive force for transformation.
• Attention to detail, producing high quality documents and work product.
• Comfortable working in Zoom meetings with Camera On.
• College Degree in Computer Science, Information Technology, Economics, Engineering or similar.
• You will be asked for writing samples, code examples and other examples as part of the interview process.
• Excellent analytical and problem-solving skills.
• Ability to contribute both independently and as part of a team.
• Able to work in a large organization with a mix of onshore, offshore, employee, vendor and contract employees in multiple time zones.
• Excellent listening, communication, interpersonal and presentation skills.

Skill Requirements

• Experience using Power Bi, Power Platform, Power Apps to connect to Oracle, Postgres, SQL Server or Snowflake, Alation for data governance and Boomi for integrations.
• Experience with Jira, Confluence, GitHub, VSCode, DBT, Liquibase, SQL Developer or similar a plus.
• Database skills including SQL statement development, performance tuning, data analysis and integration.
• Ability to read code and support applications, reports and processes.
• Ability to put together project deliverables in Confluence, MS Excel and PowerPoint.
• Oracle, Postgres, SQL Server, or Snowflake experience mandatory.
• Experience with reporting related to CRM, HR, Finance, Procurement a plus.
• Experience working a CI/CD full lifecycle environment a plus.
• Experienced working on scrum teams 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:

• 401K Matching Program
• Paid Time Off (PTO)
• 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.