Engineer, Enterprise Data

• 2301610

Job Summary

Under the direction of the Manager, Enterprise Data, the Data analyst responsibilities include conducting full lifecycle activities to include requirements analysis and design, developing analysis and reporting capabilities, and continuously monitoring performance and quality control plans to identify improvements. Assists the business in turning data into information, turning information into insight and insight into decisions.

Essential Duties and Responsibilities

• Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality;
• Acquire data from primary or secondary data sources and maintain databases and data systems;
• Compile documentation of requirements and data mapping;
• Filter and “clean” data, review computer reports, printouts, and performance indicators to locate and correct code problems;
• Profile data sources using SQL and other data discovery tools in support of data quality analysis and business intelligence design efforts;
• Create detailed business requirements for functional (e.g., business processes, rules) and non-functional (e.g., data, security) capabilities;
• Work closely with management to prioritize business and information needs;
• Locate and define new process improvement opportunities;
• Partner with team members to develop project schedules, reports and documentation; and
• Perform other duties and responsibilities as assigned, with occasional on-call responsibilities.

Qualifications

Knowledge, Skills, and Abilities

Knowledge of

• Relational databases, data models, database design principles, data profiling, data mapping, data mining and segmentation techniques;
• Reporting packages, databases (SQL, etc.); and
• Database reporting tools (Report server, Power BI server) is an asset.

Skill in

• Queries, report writing and presenting findings;
• Using software packages for analyzing large datasets;
• Analysis: Identify and understand issues, problems and opportunities; compare data from different sources to draw conclusions; and
• Communication: Clearly convey information and ideas through a variety of media to individuals or groups in a manner that engages the audience and helps them understand and retain the message.

Ability to

• Collect, organize, analyze, and disseminate complex information with attention to detail and accuracy
• Use effective approaches for choosing a course of action or developing appropriate solutions; recommend or take action that is consistent with available facts, constraints and probable consequences;
• Demonstrate a satisfactory level of technical and professional skill or knowledge in position-related areas; remain current with developments and trends in areas of expertise;
• Develop and use collaborative relationships to facilitate the accomplishment of work goals; and
• Make internal and external clients and their needs a primary focus of actions; develop and sustain productive client relationships.

Educational/Previous Experience Requirements

• Diploma of Technology, Bachelor’s degree in Computer Science, MIS, Business or a related field;
• Minimum of three (3) years of relevant experience;
• Database design and development experience is an asset;
• Broadridge Dataphile experience is an asset; and
• Experience in the financial services industry preferred but not required.

Depending on eligibility, we offer:

• Competitive Wages
• Health Benefits Program including Life Insurance and Disability from start date
• RRSP Matching Program from start date
• Employee Stock Purchase Plan
• Paid Time Off & Other Time Off such as Volunteer Day
• Discretionary Bonuses
• Tuition Reimbursement Program
• Top Up Plan
• Employee Investment Accounts
• Flexible Work Styles