Data Analyst

About Patra

If you're good at what you do, work anywhere. If you're the best at what you do, come to work at

Patra! We are leading the way in providing Technology-Enabled Services to the insurance industry. We have a culture first approach that puts inclusivity and work/life balance at the forefront.

About this job

As part of the Data, Analytics & Reporting team, the Data Analyst will be responsible for collecting, organizing and analyzing the business data. This individual will work closely with divisions throughout the organization to develop and implement strategies that leverage data to enable enhanced decision making. The ideal candidate will possess sound technical skills in BI & RDBMS, as well as sound exposure in analytics and generating business insights.

Core Responsibilities:

• Data Collection:

• Assist in collecting, cleansing, and organizing data from various sources
• Research opportunities for data acquisition and new uses for existing data
• Recommend ways to improve data reliability, efficiency and quality
• Design, build, maintain and optimize ETL for loading data marts and the EDW

• Data Modeling:

• Prototype the development of databases, data collection systems and data analytics
• Design, implement and maintain logical and physical data models for operations data stores and the enterprise data warehouse

• Data Analysis:

• Identify, analyze, and interpret trends or patterns in datasets
• Interpret data, analyze results using statistical techniques and provide ongoing insights

• Report Generation:

• Design and build comprehensive reports/dashboards to inform business decisions
• Prepare reports and visualizations
• Communicate findings to business users
• Leadership
• Train data analysts on proper use of data models and ETLs

• Support:

• Train end users on new reports and dashboards
• Monitors and maintains data load jobs
• Responds to end user requests for data or help with reports

Minimum Requirements - Education & Experience

• A bachelors degree or equivalent in relevant fields such as Engineering, Economics, Finance, Computer Science or Statistics.
• Minimum 5 years of relevant experience in data analytics with basic knowledge of Relational Database Management Systems.
• P&C insurance and consulting experience preferred.

Knowledge, Skills and Abilities:

• Ability to create basic data visualisation outputs for business users
• Proficiency in Excel or other visualisation tools
• Capable of working under deadlines while maintaining accuracy
• Aware of workflow in CRM / support / service ticketing systems
• Entry-level data analyst skilled in transforming raw data into actionable insights and efficiently handling ad-hoc data queries
• Experience with the following tools: Tableau and databases SQL Server

Compensation:

• Competitive Salary / Benefits / PTO

Physical Requirements*

• Constantly perform desk-based computer tasks
• Frequent sitting
• Occasionally stand/walk, writing by hand, use of telephone, lift/carry/push/pull objects that weigh 11-20 pounds
• Sort/file paperwork, rarely twist/bend/stoop/squat

* Consistent with its obligations under the law, the Patra Corp will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.

Work Standards

• Interpersonal Skills: Demonstrates the ability to work well with Patra colleagues and clients and with external organizations
• Promotes Culture of Respect & Safety: Demonstrates commitment to personal responsibility and value for safety and respect; communicates concerns; uses and promotes safe respectful behaviors based on training and lessons learned
• Subject to and expected to comply with all applicable Patra Corp policies and procedures