Senior Data Analytics Specialist

Position: Senior Data Analytics Specialist

Position Type: Full-time, Permanent, Excluded

Location: Edmonton, Alberta

Classification:Pay Group V

Salary Range: $77,335.00 to $110,479.00

Closing Date: Open until suitable candidate is found

If you're a Master of SQL,

elevate your career by joining Alberta Pensions Services!

What you're passionate about

Driven by your passion for data solutions, you excel in transforming complexity into actionable insights. Your expertise in T-SQL, SQL, SSRS, SSIS, and SSAS is truly inspirational for your teammates. You strive for excellent, understandable visual analytics, knowing great outcomes are based on a solid data-value pipeline, people and technology. Great results are no accident. You know that when meeting with end users, you need to know what they need and why so that you can deliver the highest quality solution and drive business value. You document requirements not because you must, but because you believe in getting it right. Besides, it allows you to work with subject matter experts and business leaders to enable you to bounce ideas around with other people who love building solutions.

A typical day for the Senior Data Analytics Specialist

• Start your day with a stand-up meeting with the team to review progress, priorities and any issues.
• SQL, SQL, and more SQL development.
• Collaborate, design, develop and problem-solve with a supportive team.
• Check requirements, ask questions, think, explore, verify.
• Collaborate on design solutions with our data architect.
• Gain an understanding of data relationships, definitions, rules and nuances.
• Develop a solution in Visual Studio or SSMS.
• Identify opportunities to achieve high-quality data and enrichment.
• Work with our quality assurance analyst to validate data and processes.
• Provide new insights into data by visualizing trends and identifying data correlations.
• Identifying data issues and building remediation solutions.
• Contribute ideas on presenting data, key performance metrics, reporting, insights, interface interactions and dashboards.
• Build technical and business knowledge.
• Transform data to leverage our Insights platform.
• Support operations promptly, fulfilling data requests, improving performance, gaining efficiency and sharing knowledge.
• Juggle multiple tasks concurrently in a timely manner, including large, complex analytical projects.
• Document and present relevant material clearly and concisely to a target audience.
• Follow information management standards and maintain the security and privacy of identifiable personal data.
• Work with the Analytics Centre of Excellence manager to establish and achieve goals.

What you bring

• Expert working knowledge in database querying (SQL) data analysis and visualization.
• Degree or diploma in computer science or information systems.
• Seven years of data analysis and business intelligence experience.
• Highly developed analytical skills.
• Flexibility to work from home or in the APS office.
• Belief in doing the right thing, taking responsibility and making interactions count.
• Live within one hour commute to Edmonton and occasionally attend an in-person meeting at the office.

Experience with:

• Agile, Scrum or comparable process methodology
• Microsoft SQL Server, SSRS, SSIS, SSAS, SQL, T-SQL
• Microsoft TFS or Agile DevOps
• Office 365 and Teams
• Data Analytics: Incorta or alternatives like SAS, Tableau or Power BI
• Large cross-functional corporate project

Experience in these areas is an asset:

• Pension or financial systems
• Programming or scripting languages such as: Python, R, C# and Powershell
• SharePoint and SharePoint integration (Power Automate, Nintex)
• Linux and Windows integration
• Data architecture: data lakes, unstructured data, data warehouses

Candidates who have less experience may be considered for a position at a lower level.

APS is made up of hard-working, respectful and talented people who understand and invite diversity to the workplace. We take pride in holding ourselves accountable and continuing to meet or exceed service levels for plan members, pensioners and employers. We ensure they receive quality services because they-along with our people-are the reason we endure and succeed.

And it sure feels good helping hard-working Albertans receive their well-deserved pensions.

• Flexible work arrangements that make sense to you: work from home, relocation and more
• Community-minded workplace with a friendly team environment
• Vacation starting at 15 days per year, 13 statutory holidays, personal days, plus office closure between Christmas and New Year's Day
• Competitive benefit package featuring extended health and dental benefits and a 100% employer-paid flexible spending account
• In-house training programs, extensive career development and coaching program, access to external education opportunities and wellness programs
• Discount programs through various partner agencies