Job Description

What you\'ll do:

• Reporting to the Manager, Actuary & Analytics, the Data Analyst will support the SCIC Operations team in bringing actionable analysis and insights through data mining and analysis, allowing the team to utilize data driven decision making processes, and reporting of metrics and dashboards for our core business. The Data Analyst will become a subject matter expert, and help guide the team in improving processes, programs, and building tools and resources to support SCIC\xe2\x80\x99s customer service strategy. An outward focus and ability is to translate complex problems into simple concepts, using visualization tools, will be essential to the role\xe2\x80\x99s success.
• Collaborate with the Operations team to prioritize data, information requests, and to analyze requirements and set scope of analytic projects.
• Build and maintain detailed and accurate Datamart\'s of historical SCIC data, to meet the current and future actuarial and analytical needs of SCIC.
• Design and build models that manipulate and explore data and business insights to identify key opportunities or business risk.
• Conduct research projects and contribute to SCIC\xe2\x80\x99s Business Modernization journey.
• Proactively assess the quality of data and implement processes to address data anomalies.
• Prepare and present data in charts, graphs, tables, dashboards and presentations to translate insights into actionable business solutions.
• Leverage understanding of the business needs to proactively identify opportunities through data analysis.
• Engage with stakeholders to ensure that data and statistical insights are effectively communicated through the most appropriate data visualization and navigation tools.
• Support initiatives and projects as they pertain to data warehouse environments; assist with managing and aggregating transactional data to ensure there is a \xe2\x80\x98single version of the truth\xe2\x80\x99 for forecasting and reporting.
• Detailed tasks may include supporting the Research and Development team to enhance redundancy testing processes for audit assurance on our actuarial products, and to validate customer-facing documents in near-production testing conditions.
• Replicate the premium rate calculation spreadsheets created by the actuarial team to validate results.
• Create the load documents that IT uses to load tables values required for upcoming sales and crop year.
• Recreate calculations to test the loaded values and the system calculated, customer-facing documents against the original calculations in the automated system.

• To be successful in this position you will need degree in Computer Science with a minimum of two years\xe2\x80\x99 experience in data analytics within a business environment. An equivalent combination of education and experience may be considered. (i.e. A degree in Applied Math, Statistics and Agriculture economics, with 4 years\xe2\x80\x99 experience in data analytics).
• Demonstrated experience with dashboards and reporting tools.
• Analytical skills, with the ability to gather, manipulate, analyze and synthesize large volumes of data, facts, figures and numbers.
• Organizational skills, and keen attention to detail to complete a variety of complex and detailed tasks effectively.
• Advanced experience in data analysis and visualization tools (i.e. Pivot tables, charts, lookup tables).
• Verbal and written communication skills, with the ability to translate complex data into reports and/or verbal presentations that speak effectively to business audiences at varying levels of understanding.
• Technical skills inclusive of, but not limited to creating SQL Queries with python and/or R considered an asset.

• Service Excellence: Delivers and provides additional information or service beyond customer expectations. Builds rapport and committed relationships. Responds to customers with an appropriate level of urgency.
• Personal Leadership and Development: Models integrity and inclusiveness by being open, acting with empathy, sharing resources/knowledge across teams and being respectful of all skills and viewpoints. Seeks out continuous learning opportunities to further develop skills. Balances organizational, team and individual commitments.
• Strategic Thinking: Commits to achieving success at the team and organizational level. Ensures that individual objectives reflect the organizational direction. Translates high level and complex information into realistic plans.
• Decision Making: Identifies and plans for the impacts or implications of decisions in the current and future environment. Acknowledges personal responsibility for outcomes from decisions made. Explains the rationale for decisions and how it may impact the workplace.
• Innovation: Adapts methodology and ideas quickly for immediate or anticipated changes in the environment. Seeks opportunities for innovation and continuous improvement. Looks for incremental improvements in work processes and results.
• Analytical Thinking: Asks pointed questions and does research to learn more about the issue. Reflects on past experience and organizational practices and processes to develop consistent action plans. Makes intelligent assumptions to develop explanations and determine possible steps and options.
• Team Collaboration: Capitalizes on the strengths and skill sets of team members by aligning tasks with individual strengths. Encourages, supports and motivates team members to share ideas, knowledge, solutions or concerns. Develops relationships by establishing respect, trust, support and understanding.
• Building Organizational Community: Actively builds relationships by establishing respect, trust, support and understanding. Ensures cross-team collaboration for organizational effectiveness. Builds rapport and ensures others are informed.
• Communication: Communicates complex issues clearly and with credibility. Uses open-ended questions, active listening and dialogue to encourage others to provide information about underlying needs or issues. Seeks input and sees things from others\xe2\x80\x99 perspectives.
• Accountability: Enables a culture where people hold themselves personally accountable for results. Takes personal responsibility for fulfilling own commitments and the commitments of the team. Promotes integrity in others by maintaining consistent values and performance standards.
• Performance Management: Continuously strives to meet or exceed organization and unit goals and objectives. Completes all assigned duties on a consistent basis with energy and drive. Participates in setting attainable team goals, priorities and work plans.
• Planning and Risk Management: Continually adapts priorities and responsibilities in response to changing needs. Establishes internal controls, within own work unit/team, to detect problems or issues as they occur and make necessary corrections. Clarifies outcomes and provides ongoing feedback to team members to achieve plans.