Data Analyst II

Company Description

Experian is the world’s leading global information services company, unlocking the power of data to create more opportunities for consumers, businesses and society. We are thrilled to share that FORTUNE has named Experian one of the 100 Best Companies to work for. In addition, for the last five years we’ve been named in the 100 “World’s Most Innovative Companies” by Forbes Magazine.

This position will be supporting the Experian Consumer Services (ECS) – a passionate and innovative team with a mission to provide Financial Power to All™. Our portfolio offers credit education and identity protection solutions to consumers and helps businesses manage the impact of a data breach.

Job Description

Experian Consumer Services is seeking a Data Analyst II focusing on user behavior reporting and analysis on our website. As a Data Analyst II, you will be preparing reports/dashboards, analyzing data, and optimizing our reporting processes. You will also be working with the business stakeholders to provide performance updates, actionable insights, and deep-dive analyses. A successful candidate should be able to work under minimal supervision, translate business requirements to data questions, write complex SQL queries to extract the appropriate data from the data warehouse, compile and cleanse the information, analyze the data, and provide information/insights to the business stakeholders. In addition, the candidate must be able to thrive in a complex and fast-paced environment.

Responsibilities

• Develop and maintain Tableau dashboards that adapt to changing business needs.
• Evaluate and analyze comprehensive member activity from marketing traffic sources. Such as on-site engagement behavior, acquisition rates, communication touch points, billing persistency and correlate with member retention and revenue to provide actionable insight to business leaders.
• Leverage analytical tools to understand end-to-end customer behavior from marketing sources and conduct pathing analysis to optimize customer experience, e.g. website and app user behavior, email engagement, conversion analysis, and marketing effectiveness.
• Monitor performance, identify changes in business trends and provides timely updates to the stakeholders. Perform investigation and deep-dive analyses on any performance issues and ad-hoc questions.
• Manage data workflows, queries, processes and scheduling to ensure dashboards are updated with accurate and timely data. Be able to trouble shoot the process when the reports fail or when the data shows anomalies.
• Work closely with Data Engineering and BI teams on data validations to prioritize and resolve data issues.
• Regularly examine data reports to locate and resolve mistakes throughout.

Qualifications

• Bachelor’s or advanced degree in business or quantitative (math, engineering, economics, or statistics) field of study.
• 3+ years in an analytical/statistics focused position, preferably from an internet environment.
• Proficient in SQL, MS Excel, and data visualization tools (Tableau preferred). Basic understanding of cloud data warehousing theory.
• Must be able to understand and analyze data, synthesizing large volumes of data and complex questions into clear analyses and actionable findings using quantitative reasoning.
• Strong analytical thinker, flexible problem solver and team player with ability to effectively multi-task and prioritize in deadline-driven atmosphere.
• Excellent oral and written communication skills with the ability to effectively interact with all levels within the organization.
• Familiarity with data processing/automation tools (Alteryx) a plus.

Expertise with the following applications:

• SQL
• Data visualization tools (e.g. Tableau)
• Web Analytics tools (e.g. Adobe Analytics, Google Analytics)
• Microsoft Excel and PowerPoint
• Reporting automation tools (e.g. Alteryx) – nice to have

Additional Information

Experian is proud to be an Equal Opportunity and Affirmative Action employer. Our goal is to create a thriving, inclusive and diverse team where people love their work and love working together. We believe that diversity, equity and inclusion is essential to our purpose of creating a better tomorrow. We value the uniqueness of every individual and want you to bring your whole, authentic self to work. For us, this is The Power of YOU and it ensures that we live what we believe.