Senior Data Analyst

Dealer.com

Location: Burlington, Vermont

Type: Full Time

Education: Bachelor's Degree

Experience: 5 - 10 Years

Cox Automotive (Dealer.com) is looking for a Senior Data Analyst to join an enterprise reporting and analytics team supporting Cox Automotive’s Contact Center Operations (CCO) group. This person should be comfortable in a data engineering role building data pipelines and ETL processes, have enough business acumen to understand context and intent, and apply these concepts to data solutions.  This role will assist in data strategy and design, and develop data-sets for the CCO ecosystem to support reporting, analysis & analytical modeling.

Recognized as a Subject Matter Expert (SME) and authority on issues related to Business Intelligence applications reporting, analysis, and metrics.  This person will exercise a natural curiosity and inquisitive mindset to transform business questions into actionable data exploration exercises and data sets using data analysis, modeling, automation, and optimization techniques. Has opportunity to operate with considerable latitude for independent judgment.  Provides influence and expertise to contact center operation teams and other stakeholders on ideas and solutions that impact results.

Primary Responsibilities:

  • Supports and/or leads projects with multidisciplinary teams to collect functional business requirements, scoping analytical projects, manage expectations and deadlines, and translate needs into technical specifications.
  • Supports and/or leads technical development of solutions to expedite delivery of new datasets, process automation, production of complex models and analyses, including gap assessments, and works to deliver strategies.
  • Serves as an organizational consultant on matters relating to data and databases by providing expertise to assist users in meeting their needs.
  • Initiates the identification of actionable insights and contribute to the development of business recommendations through effective presentations and communication of results.
  • Develops processes and solutions to speed up / expedite the development of datasets, report automation, production of dashboards, complex models, and analyses.
  • Extract and manipulate data from a variety of cloud and on-premise based systems for reporting and analytical purposes, including: Snowflake, APIs, financial data cubes, Tableau, and various data sources as needed.
  • Report automation and self-service dashboard solutions using combination of tools such as SQL, Tableau, Power BI, Alteryx, Informatica, and Python.
  • Develops automated processes that preserve data integrity by managing the alignment of data availability and integration processes.
  • Expertise in creating and optimizing Tableau/PowerBI Datasets and Visualizations.
  • Identifies, researches, and resolves discrepancies in an analytical procedure or cross-functional methods.
  • Establish and maintain design and development best practices including keeping written procedures to document data processes and ensure best data governance practices are maintained.
  • Liaises with CAI Technology partners for both data-sourcing needs when/as-needed.
  • Leads data collection, cleansing, and validation.
  • Conducts day-to-day activities with minimum supervision.
  • Facilitates meetings and presentations to leadership.

Qualifications:

Minimum Qualifications:

  • BS/BA degree in related discipline OR an equivalent combination of education and work related experience
  • 5 or more years of experience required in related field (developing and implementing analytical solutions for business).

Preferred Qualifications:

  • Master’s degree in a related discipline preferred
  • Requires strong skills in SQL writing and query optimization.
  • Requires experience building data workflows, manipulation of large data sets, or developing data pipelines in analytical tools such as Snowflake, Informatica, Alteryx, Tableau Prep, Power BI, SQL, SSIS, etc.
  • Requires strong skills and experience with reporting and data visualization in analytical tools such as Tableau, Power BI, SQL, Oracle RPD/BI, etc.
  • Requires effective proficiency in teamwork, communication, presentation, and time management to work effectively with teams throughout organization, including strong verbal and written communication.
  • Experience manipulating large datasets and the ability to extrapolate conclusions from the data.
  • Demonstrated problem solving and analytical thinking skills.
  • Excellent interpersonal, leadership, presentation, and collaborative skills to work effectively with teams throughout organization.
  • 3 or more years’ experience with Call Center, Technical Support, Collections, and Customer Experience Analytics
  • Experience with Genesys Call Platform
  • Working knowledge of Tableau and/or visual analytics software tools and best practices
  • Working knowledge of Alteryx and/or data transformation/modeling tools and best practices
  • 3 or more years using Tableau/PowerBI for analysis, visualization & dashboard development
  • 3 or more years of experience in database administration and SQL, including SQL tuning/performance optimization
  • 2 or more years of experience in Data Warehousing, ETL Development, Data Management tools such as SSIS, Informatica, Datastage, Snowflake/Snowpipe etc
  • 1 or more years of experience using Onestream or integration with data cubes
  • 1 or more years of experience in Java, Python, or other programming or scripting languages
  • Knowledge of Big Data querying tools, such as Pig, Hive, and Impala

© 2022 Vermont Technology Alliance

Site by Scout Digital