Data Analyst

The position of Sr. Data Analyst is a key team member in contributing to the development and execution of the Data Analytics group strategy. The successful candidate will bring their innovation, a mindset for critical thinking, curiosity and functional expertise, leveraged through data management and advanced analytics to drive the success of this initiative.

This is an opportunity to join a new initiative of the company and would fit someone who enjoys working in an undefined setting that needs to be built from scratch.


Key Accountabilities:

• Lead the analytical project planning with audit teams to establish scope and deliverables, particularly for research and data collection tasks
• Collaborate with IT and Business Unit application users to understand the data structure, availability and accessibility
• Extract, transform and load relevant data and data files from various applications and databases
• Evaluate the appropriateness of data sources for quality and accuracy
• Perform or consult audit teams on data validation, consolidation and cleansing processes
• Perform complex data analytics to evaluate controls and business objectives Analytics should be designed to identify outliers, anomalies, patterns, or other compliance indicators that may be hidden in the data
• Develop data delivery processes for both structured and unstructured data types utilizing various internal and external data sources; interface with data experts & data sourcing resources
• Develop detailed business and system knowledge within supported areas. Document business, system, and data knowledge to help build a robust knowledge-base for future efforts
• Train and support audit teams in the analysis of captured data as well as technical training to auditors across all levels
• Automate processes to increase turnaround time on data availability and increase efficiencies in the audit process
• Build & maintain effective working relationships with business and IT teams across the organization

• Bachelor's Degree in a technical (statistics, math, etc.) or business discipline or equivalent technical expertise
• 5+ years business experience including data analytics/data management/programming experience.
• Significant experience with data gathering, storing, and retrieval methods
• Competency in data analysis
• Expertise in programming languages and databases: SQL server, Python, VBA, Advanced Excel, Access
• Experience with web scrapping, and statistical tools R or SAS Experience with statistical techniques (e.g., regression analysis, cluster analysis, and decision trees)
• Experience with visualization tools such as Tableau or Qlikview and writing procedural logic such as script development
• Experience with other BI and ETL tools an advantage
• Insurance or Financial Services industry experience preferred

Competencies:

• Strong technical knowledge of data and data concepts
• Detailed oriented with a problem solving mind set
• Displays strong relationship building mindset and skills
• Employ analytical, conceptual, and creative thinking skills to problem solve and get results
• Able to prioritize, meet deadlines, and be results orientated
• Demonstrated ability to communicate complexity with clarity to diverse technical and non-technical stakeholders at multiple levels of the organization
• Turn statistical and computational analysis into user-friendly graphs, charts, and animation. Ability to communicate results and educate others through reports and presentations
• Strong commitment to organizational success, share resources and leverages knowledge across the organization
• Adaptable and open to change