View all jobs

Data Analyst III

Calgary, Alberta
The Data Analyst will provide expertise, guidance and advice for initiatives, promote adoption, education and continuous improvement as well as, identify gaps with operational or project initiatives and provide recommendations to meet objectives.

Accountabilities / Responsibilities:
The Data Analyst will:
• Clearly communicates project statuses with leaders and project teams
• Engages in quality assurance processes to create a high standard of accuracy
• Ensures exception and error handling techniques are used
• Uses understanding of business rules to enhance logic used in reporting and analysis
• Seeks out new technology and processes to improve team ability and reach
• Verbally and visually presents reporting and analysis findings to leaders and stakeholders of various levels
• Work submitted for QA is returned with a low number of errors
• Prioritizes multiple projects within own work stream to deliver with little impact to timelines
• Manages relationships with data source providers for issues and support
• Consistently incorporates reconciliation in published reports and datasets
• Proves or disproves relationships between variables (causal)
• Forecasts business measures with confidence and accuracy
• Assists with development planning with other team members
• Takes on and seeks out opportunities to mentor and coach
• Champions best practices in quality and reliability

Required Skills, Experience, and Qualifications:
• 8+ years relevant industry experience
• 5+ yrs exp with a solid understanding of SQL, and other DB constructs including stored procedures, functions, views and execution plans. Advanced knowledge of code optimization, including development/coding best practices.
• 5+ yrs experience creating automated reports, using advanced techniques with various systems and tools, and with emphasis on efficient, high quality code and identification/mitigation of data integrity problems.
• 5+ yrs experience, a solid understanding, and demonstrated ability to apply Data Warehouse and Data Modeling methodologies into practice. With a focus on understanding relational and dimensional data models for analysis and reporting of data.
• Hands on experience developing reports and architecture layer objects in MicroStrategy and Tableau, along with experience creating data and using data transformation processes through the use of Alteryx or other ETL tools.
• Strong communication skills - ability to communicate with technical teams as well as business user
Powered by