The Business Intelligence Analyst II plays a critical role in gathering, transforming, and analyzing data to deliver actionable insights that drive strategic and operational decisions across Client Operations. This position blends technical execution with stakeholder engagement, building scalable analytics solutions and translating findings into clear, compelling data narratives. The role involves full project lifecycle management with minimal oversight, including data manipulation, dashboard development, and report generation. Analysts work closely with leaders, users, and cross-functional teams to communicate requirements and deliver value-added solutions. Responsibilities include applying industry-standard Business Intelligence methodologies, ensuring adherence to data governance protocols, and managing the integrity, efficiency, and availability of data. Candidates must demonstrate strong analytical and problem-solving skills, proficiency in BI tools and an ability to collaborate effectively in a team environment. Excellent communication and interpersonal skills are essential for facilitating discussions, organizing workstreams, and serving as a trusted advisor to stakeholders. This role requires familiarity with project management concepts and agile methodologies to execute activities that meet project objectives. Specific Responsibilities: Data Analysis & Reporting: - Design and implement scalable Business Intelligence solutions using tools such as Domo, SQL and Excel. - Collaborate with stakeholders to translate business needs and requirements into technical specifications and analytical solutions. - Determine data requirements and gather, synthesize, and transform data from multiple sources in compliance with data governance standards. - Generate and distribute well-structured datasets, dashboards, and reports tailored to business needs and aligned to project requirements. - Create compelling data-driven narratives that translate complex findings into clear, actionable recommendations. - Monitor data integrity, efficiency, and availability. - Assist in the development and enhancement of business intelligence reporting and data handling processes and best practices. Project Management & Support: - Collaborate with business owners, leadership, and cross-functional teams to identify and document project requirements and data needs. - Manage and execute full project lifecycles including data acquisition, data wrangling, modeling, analysis, and visualization. - Establish and manage project plans, delivery timelines, and sprint presentations. - Proactively communicate progress, challenges, and risks to leaders and stakeholders. - Manage individual workload including defining and prioritizing assigned tasks across multiple projects. - Maintain documentation and ensure timely delivery of project deliverables. - Provide training and documentation for generated reports and dashboards. - Engage with and support other Business Intelligence team members as needed. Minimum Qualifications: - Bachelor's degree in a related discipline and 3 years of experience in a related field. The right candidate could also have a different combination, such as an advanced degree or additional years of experience in lieu of a degree. - Proficiency in Business Intelligence tools and Microsoft Office suite. - Clear understanding of data modeling, ETL processes, and data governance. - Solid understanding of data governance standards and best practices for maintaining data integrity and compliance. - Proven ability in dashboard and analytical report development. - Ability to analyze datasets and deliver clear and actionable insights. - Ability to manage full project lifecycles and break down assigned projects into reasonable scheduled deliverables. - Must have excellent communication and interpersonal skills with a demonstrated ability to effectively deliver presentations to diverse audiences. - Must be highly organized and have strong time management skills. - Must be assertive, confident, self-motivating, and able to work both independently and collaboratively with a team depending on project requirements. - Strong organizational skills to handle multiple simultaneous assignments and meet established task deadlines. - Ability to work cross-functionally and engage stakeholders effectively. - Proven ability to identify and resolve problems. Preferred Qualifications: - A demonstrated analytical mindset along with extensive experience and understanding of Customer Care business practices, data, processes, and terminology may be considered in lieu of previous business intelligence reporting experience. - Previous Domo experience. - Agile Development methodologies and practices. - Experience working with Snowflake data warehousing. - Exposure to other Business Intelligence reporting tools and technologies. - Experience with front-end development using JavaScript, HTML, and CSS with the ability to apply these skills to enhance reporting capabilities. About Us: Through groundbreaking technology and a commitment to stellar experiences for drivers and dealers alike, Cox Automotive employees are transforming the way the world buys, owns, sells - or simply uses - cars. Cox Automotive employees get to work on iconic consumer brands like Autotrader and Kelley Blue Book and industry-leading dealer-facing companies like vAuto and Manheim, all while enjoying the people-centered atmosphere that is central to our life at Cox. 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 individual's 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. USD 74,000.00 - 111,000.00 per year Compensation: Compensation includes a base salary in the range of $74,000.00 - $111,000.00. The base salary may vary within the anticipated base pay range based on factors such as the ultimate location of the position and the selected candidate's knowledge, skills, and abilities. Position may be eligible for additional compensation that may include an incentive program. Benefits: The Company offers eligible employees the flexibility to take as much vacation with pay as they deem consistent with their duties, the company's needs, and its obligations; seven paid holidays throughout the calendar year; and up to 160 hours of paid wellness annually for their own wellness or that of family members. Employees are also eligible for additional paid time off in the form of bereavement leave, time off to vote, jury duty leave, volunteer time off, military leave, and parental leave. Applicants must currently be authorized to work in the United States for any employer without current or future sponsorship.

• Design, develop, and deploy advanced Power BI reports and interactive dashboards aligned with business requirements • Maintain and optimize data analytics platforms to ensure consistently high query and model performance • Work with complex Power BI semantic models and large datasets, ensuring scalability, accuracy, and efficiency • Connect to various data sources and transform data into actionable insights through Power Query • Conduct analysis with a strong focus on query optimization and data efficiency • Evaluate, refactor, and enhance existing BI solutions to improve performance, maintainability, and scalability • Present information through high-performance reports and complex visualizations tailored to business needs • Create technical documentation to support scalable Power BI solutions • Work closely with business stakeholders to understand their business requirements and translate them into scalable BI solutions • Train and support end-users on Power BI functionality, ensuring they can utilize the tools effectively • Collaborate with cross-functional teams, including data engineering

• Desarrollo de informes y dashboards en Power BI (modelado, DAX, visualización). • Diseño de modelos de datos eficientes orientados a negocio. • Uso de Microsoft Fabric (Dataflows Gen2, Lakehouse, Semantic Models). • Integración y transformación de datos desde diferentes fuentes. • Optimización de rendimiento en modelos y reportes. • Colaboración con equipos de negocio para entender necesidades analíticas.

• Create interactive dashboards, reports, and analyses in Power BI; • Analyze data to identify trends, patterns, and valuable insights; • Data Modeling – Develop and implement analytical models to support and inform decision-making, using multidimensional modeling and data denormalization techniques; • Collect, clean, and integrate data from multiple sources to ensure data quality and consistency; • Perform exploratory data analyses to identify relevant trends, patterns, and insights; • Interpret and communicate analysis results clearly and concisely to internal and external stakeholders; • Collaborate with cross-functional teams to understand data needs and deliver effective analytical solutions; • Provide support in the implementation and maintenance of data analysis systems and tools; • Stay up to date with trends and advances in data analysis, contributing to continuous innovation; • Present analyses, reports, and dashboards in strategic meetings;