Technical expert that will build and manage agile data architecture to serve analysis needs of Westchester Business Analytics team. This role will be responsible for all aspects of data management from defining data models to integrating data into reports, visualizations, and dashboards. This includes managing existing data and reporting processes that harness, manipulate, and integrate data into analytics. This role will also work on building the next level of advanced analytical processes and automations, enabling more accurate and faster information delivery to support critical business decision-making.
Critical factors for success include delivering results while maintaining a detailed focus, ability to take ownership and meet deadlines, and being a self-motivated team player coupled with the ability to work independently. Successful candidates will be adept at identifying issues and developing sound recommendations for remediation, demonstrate a willingness and desire to continuously build on insurance and product knowledge, and thrive in a fast-paced environment.
RESPONSIBILITIES:
Support data management function of Westchester Business Analytics team related to recurring and ad-hoc reporting and analysis. This includes utilization of all available data from various systems via extraction, transformation and loading into analytical applications.
Using data mining steps, proactively prepare data models that address common business questions and measure impact of business initiatives.
Assemble data from multiple sources including underwriting, claims, actuarial, and product databases to create integrated views that can be easily consumed to drive decision-making.
Work with several large and complex databases, including scripting (e.g., SQL, Netezza, SAS, Python).
Design and build reports and analyses in various data analytics tools (e.g., QlikView, Microsoft BI). This includes producing ad-hoc and automated recurring reports.
Identify opportunities to improve data quality, validation, automation, efficiency, and overall process improvement.
Explore new data models, software, and algorithms that continue to improve data visualization, presentation, and ease of information delivery to our business partners.
Technical Skills and Requirements:
Bachelor’s degree with focus on Computer Science, Statistics, Mathematics, Programming, or other related fields of study.
Minimum of 7 - 10 years related experience. Preferred experience in Insurance industry with in-depth knowledge of Insurance Financials and Data Applications.
Strong data management skills with an attention to detail.
Proficiency in end-user applications (e.g., Excel, PowerPoint, Access).
Experience with dashboarding tools (e.g., QlikView, QlikSense, Tableau, Haddoop).
Experience with cubes, and relation-based databases and tools/languages (e.g., Hyperion, Cognos, SQL, SAS, Python, AWS).
Excellent problem-solving skills with the ability to exercise sound judgment and make solid recommendations.
Ability to adjust quickly to meet business priorities.
Strong written and oral communication skills with the ability to present information in differing degrees of detail and form depending on the audience.
Strong interpersonal skills, ability to build relationships with cross-functional teams.
