Experian Data Analyst in Costa Mesa, California
Experian® is the leading global information services company, providing data and analytical tools to our clients around the world. We help businesses to manage credit risk, prevent fraud, target marketing offers and automate decision-making. We also help people to check their credit report and credit score and protect against identity theft.
Experian is searching for a talented Data Analyst to join our Global Web Analytics & Optimization team. The Data Analyst will be responsible for analyzing and reporting on the performance of Experian’s global web properties. The Data Analyst will collect and analyze data from a variety of internal systems to understand how site visitors engage with our websites, thereby helping drive higher conversion and revenue.
The ideal candidate must possess a strong understanding of relational databases as well as the use of data warehousing and ETL methodology.
The Data Analyst will support Experian’s global B2B business lines by performing a variety of critical data functions, including data acquisition, data processing, data blending, and web data analysis. You will support a variety of business units and regions around the world, which includes responsibility for producing and distributing ongoing monthly reports.
Collect, process, cleanse, and standardize data from multiple sources.
Develop, maintain, and enhance a marketing attribution model.
Perform quality control on data by analyzing patterns and data discrepancies. Resolve related issues.
Produce ongoing reports, using business intelligence (BI) tools, that highlight sales and marketing KPIs, trends, and potential issues.
Perform ad-hoc data gathering and research, primarily with Excel, Access or BI tools.
Understand internal business users’ needs and translate them into technical requirements for deploying new marketing analytics reporting.
Identify ways to improve data analysis/reporting processes, via automation or other means.
Coordinate with other global marketing teams, such as Engineering, Sales, and Demand Operations.
Generate and present multiple monthly marketing performance reports for a variety of business units and products.
Help define, implement, and maintain the company’s global standards for web analytics reporting.
Knowledge, Experience & Qualifications
B.S. degree in computer science, mathematics, statistics or a similar quantitative field
Expert in relational databases (2+ years’ experience)
In-depth knowledge and understanding of ETL methodology and design
Proficiency in a major programming language (e.g. Java, VB.NET)
Proficiency in SQL
Superb analytical skills, persistence in problem solving, and ability to learn quickly and independently.
Excellent communication skills and the ability to tell a clear story using data--both verbal and written communication skills are critical
Produce data visualizations that communicate and distill complex data
Ability to work with APIs
Strong presentation skills
Experience with third-party business intelligence (BI) tools, particularly Power BI, Qlik, or Tableau
Understand fundamental concepts of statistics
Independent problem solver
Advanced proficiency in Windows and MS Office, with an emphasis on the use of Excel and Access
A strong sense of integrity, work ethic, and positive attitude
ADDITIONAL SKILLS (NICE TO HAVE)
Experience with Alteryx
Project management experience
Salesforce reporting/data extraction
Familiarity working with web analytics or clickstream data
Understanding of attribution modeling
Proficiency with data visualization tools
Experience with Adobe Analytics
Understanding of A/B and multivariate testing techniques and measurements