Associate Data Analytics Engineer
Allstate - Northbrook, IL

This job posting is no longer available on Allstate. Find similar jobs:Associate Data Analytic Engineer jobs - Allstate jobs

The Marketing Science Data Analytics Engineer is the technical resource to work with stakeholders to determine and refine data requirements; apply the requirements to properly document and write program code to extract the data needed; ensure consistent, high-quality delivery of model and analytic datasets and communicate results to stakeholders.

Key Responsibilities
Work with business users to understand their business functions and processes in order to help them define analytic and reporting requirements, including data requirements for their research and analysis that are complete and unambiguous
· Manage quality of dataset delivery
· Analyze generational data-sets and develop cumulative sum control charts and related control statistics to test quality and consistency of data deliveries overtime, flag out-of-control situations, investigate the source of out-of-control issues and take corrective action
· Develop specification limits and statistically-derived tolerances for dataset CUSUM charts
· Develop sequential and multiple attribute sampling plans
· Provide reports to management and programmers on statistical quality control issues
· Construct and execute complex SQL queries to verify business data rules and fit-for-use status of data under analysis, and to extract data needed for marketing analysis and research requests based on detailed data requirements
· Utilize Allstate Data Guide (Metadata Viewer) to validate the appropriateness of data elements and tables in their use
· Function as subject matter expert (SME) for marketing data used for analysis and research
· Maintains current understanding of Allstate data models and structures including the Allcorp Data Warehouse (ADW) and other internal data stores used for data extraction
· Review and validate each other’s requirements and code
· Maintains current understanding of software industry news and trends, and how new technology can best be used to enhance the data gathering and extraction process for expeditious and accurate deliver to our research and modeling clients
Bachelor’s Degree in a field such as Computer Science or Data Architecture
2-4 years of related experience
Strong technical skills in a statistical analysis software package, business intelligence applications, decision support systems, SQL, UNIX, Oracle, TOAD, MS Office Suite
Ability to deal with an array of data sources, all in different forms and be willing to use an array of tools or methods to create a solution
Solid experience in time and task management
Strong attention to detail
Job Marketing
Primary Location IL-Northbrook

About this company
1,909 reviews
Your career awaits at Allstate. We’re 70,000 professionals strong, working each day to help protect nearly 16 million households....