Consultant, Data Analyst

Description

Join the Technology team at a Fortune 100 company with nearly $70 billion in annual sales, where data work supports adopting new technologies that drive business results.

This data designer role gathers and analyzes business and data requirements for Guidewire ClaimCenter and PolicyCenter, which are being implemented for commercial lines of business.

The team builds data solutions that are secure, reliable and efficient. Its work spans data analysis, quality, visualization, governance, engineering, AI engineering and machine learning, in an agile, collaborative setting.

As a data analyst, you will organize, structure and present data so it supports business decisions and helps data-heavy projects succeed. You will work within projects or teams, identify what business partners need analytically, collect and interpret data, and share insights and recommendations through maps, reports, charts, tables and other visualizations.

Responsibilities

• Gather and analyze business and data requirements for Guidewire ClaimCenter and PolicyCenter commercial lines implementations.
• Write source-to-target data mappings, including cleaning and transformation rules, for PolicyCenter third-party integrations and downstream applications.
• Validate data with complex SQL queries, filter data in Oracle, and work through data quality issues.
• Help database modelers build logical and physical data models, and create class diagrams and entity relationship diagrams.
• Turn business and data requirements into models for enterprise data models, the data warehouse and analytical systems.
• Develop best practices, standards and methods for implementing and running data governance.
• Identify and document the sources of existing and new data, and map the data flows, business processes and technical interfaces that are created or affected, recommending solutions.
• Work with enterprise partners on complex data profiling using standard tools, evaluate information from several sources, resolve conflicts, clean it and sort it into logical categories.
• Lead or review conceptual, logical and physical data models, choosing the best way to represent data for business use and tuning models for performance on each DBMS platform.
• Document source-to-target mappings for data integration and web services, confirm they match quality and transformation rules, and build tools to share them with relevant groups.
• Create thematic maps, reports, charts, tables and other visualizations, using moderate to complex techniques to present data exploration findings.
• Manage data acquisition and analysis, give internal clients insights and recommendations, and proactively advise on data needs.
• Apply secure software and systems engineering practices across the delivery lifecycle to protect data and technology solutions from threats and vulnerabilities.
• Ensure compliance with the enterprise data governance policy and standards, including information risk and data protection guidelines.
• Recommend and make changes to analytics methods, practices and tools.
• Perform other duties as assigned.

Requirements

• Bachelor's degree in computer science or computer information systems, plus 5 years performing the duties listed above.
• Six to eight years of relevant experience with data quality rules, data management organization, standards or practices.
• Experience with statistical analysis and interpreting results to judge data quality and fitness for use.
• Wide experience using data quality results to decide whether existing data sources meet business needs, and experience recommending alternate sources and data modeling.
• Undergraduate study in computer science, management information systems, business, statistics, math or a related field, or comparable experience and education, is strongly preferred.
• Graduate study in business, statistics, math, computer science or a related field is a plus.
• Insurance or financial services industry knowledge is a plus.
• Certifications are not required but are encouraged.
• Knowledge of data applications and practices, strong decision making and communication skills, and the ability to influence, negotiate and set priorities.
• Leadership skills, competencies and experience may outweigh the criteria above.
• Exceptions to these requirements must be approved by the hiring manager's leader and an HR Business Partner.
• Consistently demonstrate the company's values.

Conditions

This is an exempt position and is not eligible for overtime.

You will report to a Manager or Director of Data Management.

The company is an equal opportunity employer that prohibits discrimination and harassment, and it restricts smoking under the Iowa Smokefree Air Act, allowing it only in designated areas.

Benefits

• Medical, dental and vision coverage, life insurance, and short and long term disability coverage.
• 401(k) with company match and a company-paid pension plan.
• Newly hired associates receive at least 18 days of paid time off each full calendar year, prorated quarterly from the hire date.
• 9 paid holidays, 8 hours of Lifetime paid time off and 8 hours of Unity Day paid time off.
• Business casual attire, plus other benefits.
• National salary range of $118,000.00 to $222,000.00, with an expected starting range of $118,000.00 to $178,000.00.
• Starting pay within the range depends on skills, education, training, credentials, experience, the scope, complexity and location of the role, local labor costs, and other employment conditions.
• Salaries shown are for full-time work. Part-time pay is prorated by hours worked compared with a full-time schedule.