Primary Location: 1001 Summit Blvd, North Hills, NY, US

Division: Cox Automotive

Job Level: Individual Contributor

Travel: Yes, 5 % of the Time

Schedule: Full-time

Shift: Day Job

Requisition Number: 202202647_25290552

At Cox, we're forward-thinking innovators who put people first. Our award-winning workplace culture is centered on inclusion and kindness, and we're looking for people to join our mission to be a force for good in the world. Come build a better future with us across automotive, communications, the environment and more.

We want to do everything we can to keep our employees safe and healthy. Therefore, where permitted by applicable law, you will need to be fully vaccinated against COVID-19 to be considered for this U.S.-based job. Reasonable accommodations for medical and religious objections will of course be considered.

Keep reading to learn more about this opportunity to join the Cox family of businesses.

Cox Automotive is looking for a Senior Data Analyst to join an enterprise reporting and analytics team supporting Cox Automotives 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.

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:

• Masters 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

Who We Are

About Cox Automotive

Theres nothing ordinary about Cox Automotive. We are people of every background driven by our passion for mobility, innovation, client success and community outreach. We make buying, selling and owning (or simply using) cars easier for everyone. Touching more than 40,000 clients across five continents, we bring together the best brands and the best teams to propel the automotive industry forward. Some of those team members work for our iconic consumer brands like Autotrader and Kelley Blue Book, while others are creating the future of automotive at industry-facing brands like Dealer.com, Manheim and vAuto.

About Cox

We are the Cox family of businesses. Weve been making our mark since 1898 by building and evolving world-class businesses, staying true to our values, and encouraging top talent to always look for growth and impact while building a career with us. Our primary divisions - Cox Communications and Cox Automotive - are driving a new wave of innovation, powering smart cities with powerhouse broadband communications and pioneering greener, more progressive transportation alternatives for individuals and fleet operators. Were also expanding into new spaces like cleantech and healthcare to rev up our momentum toward building a better future for the next generation. Were looking for the talent today who will be our leaders tomorrow. Sound intriguing? Learn more about where we are today, where we hope youll be going with us, and the common purpose that unites us at coxenterprises.com.

Benefits of working at Cox may include health care insurance (medical, dental, vision), retirement planning (401(k), and paid days off (sick leave, parental leave, flexible vacation/wellness days, and/or PTO). For more details on what benefits you may be offered, visit our benefits page .

Cox is an Equal Employment Opportunity employer - All qualified applicants/employees will receive consideration for employment without regard to that individuals age, race, color, religion or creed, national origin or ancestry, sex (including pregnancy), sexual orientation, gender, gender identity, physical or mental disability, veteran status, genetic information, ethnicity, citizenship, or any other characteristic protected by law. Cox provides reasonable accommodations when requested by a qualified applicant or employee with disability, unless such accommodations would cause an undue hardship.

Statement to ALL Third-Party Agencies and Similar Organizations: Cox accepts resumes only from agencies with which we formally engage their services. Please do not forward resumes to our applicant tracking system, Cox employees, Cox hiring manager, or send to any Cox facility. Cox is not responsible for any fees or charges associated with unsolicited resumes.