Share this Job

Business Intelligence Analyst II

Apply now »
Apply now

Apply for Job

Date: Dec 28, 2018

Location: Seattle, WA, US, 98104

Company: CDK

Job Description

Accelerate Your Career

Drive global technology


With more than $2 billion in revenues, CDK Global is a leading global provider of integrated information technology and digital marketing solutions to the automotive retail and adjacent industries. Focused on enabling end-to-end automotive commerce, CDK provides solutions to dealers in more than 100 countries around the world, serving approximately 28,000 retail locations and most automotive manufacturers.   CDK Global solutions automate and integrate critical processes from pre-sale targeted advertising to the sale, financing, insurance, parts supply, repair and maintenance of vehicles, with an increasing focus on utilizing data analytics and predictive intelligence.   


We’re large enough to make a difference but small enough for your voice to be heard. This means that we are an organization where every person matters. You can make an impact on the success of our business and that of our customers regardless of what career you decide to pursue.


From data scientists to sales and client service experts, we’re hiring to support your growth and ours - Green light your career.  




CDK Digital Marketing is seeking a BI Data Analyst II who will help guide stakeholders media optimization & financial forecasting, while having the technical skills to build and implement those solutions through our Enterprise Data Warehouse and Tableau visualization tools.  This role will report directly to the Director of Media & Partnerships through the Product Management Organization.   


The successful candidate will be able to think strategically about business issues and will have a strong command of data warehousing platforms, reporting automation, data visualization, digital marketing analytics and basic statistics.


The BI Data Analyst II should be able to think strategically about business issues and understand CDK’s Product & Service portfolios and how they relate to our Clients.  Candidates with a history of owning data driven projects and overcoming obstacles are desired.  The BI Data Analyst II will be able to take direction, but will also pro-actively drive projects to completion.


The BI Data Analyst II is curious about data.  The ideal candidate is not intimidated by large and complex data sets and is naturally inclined to view things from an analytical perspective.  Digital Advertising experience is desired.


The successful candidate will work closely with advertising product managers, agency senior leadership, BI engineers, and other data analysts.  Because of this, they must be able to present the results of complex data analytics to a non-technical audience in a clear and concise manner.


The BI Data Analyst II must be able to extract data from CDK’s data warehouses, data lake, ad platform, pixel logs, and other data sources.  A comfortable relationship with various flavors of SQL and experience with a fact/dimension based Data Warehouse is essential.

Extracted data will be manipulated, merged, and analyzed to produce reports, graphs, dashboards and other output to ultimately reveal performance of our products for internal and external users.


The successful candidate will have a history of simplifying and/or automating labor intensive, data based projects. The BI Data Analyst II will strive to reduce the number of day-to-day reporting tasks, allowing them to focus on strategic projects and deliver insights to stakeholders.


CDK embraces Agile Development methodology.  As a member of the Analyst team, the Candidate will help define requirements, identify roadblocks and track the progress of all open projects. 


At CDK Digital Marketing, we are the leading provider of digital marketing solutions to the automotive industry. CDK’s customers are all part of the Automotive ecosystem, ranging from Manufacturers, Agencies, Dealer Groups and Dealers.   The CDK Data Warehouse, which is at the center of CDK’s analytics products & solutions, is the largest "in-market" automotive data warehouse in the world.  Desired candidates will have experience analyzing websites, advertising or digital media performance.






Education:                   BA/BS in a business or technical field; an Advanced Degree is a plus

Experience Level:       3-6 Years


  • Experience with Data Warehousing platforms (Oracle, SQL Server, Etc...)
  • Experience with multiple reporting & visualization techniques.
  • Experience with website and digital media analytics.
  • Strong MS Excel and Database skills.
  • Strong SQL skills.
  • Experience with digital marketing concepts, cookies (1st & 3rd party), pixel tags, privacy standards, SEO, social media, advertising attribution methods & models.
  • Proven ability to multi-task, handle multiple priorities and adapt to a fast-paced environment.
  • Experience defining products & solutions containing large data sets from multiple sources.
  • 3+ years’ experience in a Data Analyst role.
  • 3+ years’ experience writing SQL queries against a data warehouse or similar data store.
  • 3+ years’ experience with data visualization using tools such as R, Tableau, Excel
  • Demonstrated ability to communicate technical topics to non-technical audiences
  • Comfortable presenting results to stakeholders and writing technical summaries
  • Background in web analytics, online advertising, or ad agency experience a plus
  • Automotive vertical experience a plus
  • Prior software engineering experience a plus





  • Communicate with business consultants, agency partners and enterprise sales to gather and understand requirements.
  • Visualization of data using tools such as Tableau, Excel, R, etc...
  • Ability to manage a backlog, establish priorities, multi-task and work proactively and independently.
  • Data mining from data warehouse, using SQL, RegEx, json, pixel logs, and other big data formats.
  • Analyze web analytics and other quantitative and qualitative data.
  • Data discovery and data cleansing.
  • Communicate complex technical issues to non-technical team members.
  • Improve the efficiency of the team by automating data projects.


CDK Global knows you have passions outside of work.  You have family, friends, sporting events, and lots of things going on.   That’s why we offer a comprehensive benefits package to not only take care of you but your family as well.   All of our benefits are effective the first day of employment including 401K matching, paid time off to re-energize, donate your time to volunteer in your community, and tuition reimbursement to name a few.

At CDK, we pride ourselves on having a diverse workforce. We value and celebrate the uniqueness of individuals and the different perspectives they provide. We offer equal opportunity employment regardless of race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, marital status, or protected veteran status.  

Nearest Major Market: Seattle

Job Segment: Business Intelligence, Database, Oracle, Outside Sales, ERP, Technology, Sales

Apply now »
Apply now

Apply for Job