Data Analytics Specialist

Mid-Senior Level
Toronto
Contract
, Remote Friendly

Job Description

ADGA has a current opportunity for a Data Analytics Specialist who will be responsible for the design, development, implementation, and testing of the IPA SQL Server solution to support new and improved data management processes. The Data Analytics Specialist has subject matter expertise in data architecture and modeling.

Data Analytics Specialist Responsibilities:

  • Undertake a needs assessment for data warehousing, integration, and modeling by listening to the client’s business and application (Tableau) requirements and interpreting those requirements into actionable, operational objectives and related data architecture;
  • Design methods to capture, structure, transform, and process data to be used to generate models;
  • Lead design, development, implementation, and testing related to the IPA SQL Server solution;
  • Ensure successful and timely deployment of the IPA SQL Server solution configured to meet the needs of the business with minimal customization; and
  • Ensure process continuity and drive IR team maturity through knowledge transfer, standardization, documentation, end-user training, and presentations.

Qualifications

  • Degree, or equivalent, in a computer-related area and continued education in current Information Technology, Computer Science, Information Management Science, Business, or related field;
  • Preferred certification(s) include AWS and/or Azure or equivalent experience;
  • 5 years of practical experience designing, delivering, and maintaining platforms, including SQL Server, and SQL Server Management Studio;
  • Experience in structured methodologies for the design, development, implementation, and testing of data warehousing and management solutions;
  • Experience developing data extraction, transformation, and load functionality for large relational and multi-dimensional data stores;
  • Proficiency in query languages and experience constructing complex query statements (T-SQL is a must-have),
  • Experience in one or more programming or scripting languages; and
  • Understanding of data management, financial and business analysis, database architecture, and information visualization.

Additional Information

ADGA commits to putting diversity into action to build a stronger, more representative team and help our customers and communities thrive. We are a proudly Canadian company, striving to further diversity, equity, and inclusion in the workplace and provide every individual with the opportunities and resources to help them reach their full potential.

ADGA s'engage à mettre la diversité en action pour bâtir une équipe plus forte et plus représentative et aider nos clients et nos communautés à prospérer. Nous sommes une entreprise fièrement canadienne. Nous nous engageons pour promouvoir la diversité, l'équité et l'inclusion dans le milieu de travail et d'offrir à chaque personne les possibilités et les ressources qui lui permettront de réaliser son plein potentiel.

Other Open Positions

Data Analytics Specialist
Analyst
Mid-Senior Level
Toronto
Contract
Project Manager - CRM
Project Management
Mid-Senior Level
Toronto
Contract
Senior Business Analyst
Information Technology
Mid-Senior Level
Ottawa
Contract
Intermediate Systems Engineer
Information Technology
Mid-Senior Level
Ottawa
Full-time
Senior Project Manager
Project Management
Mid-Senior Level
Ottawa
Full-time
Network Systems Engineer
Information Technology
Mid-Senior Level
Ottawa
Contract
View All

Become a client

Reach out to discuss how we can help with your critical business challenges.

Get In Touch

Work with ADGA

With positions from coast to coast, find the perfect opportunity for you as part of our 600+ member team.

Design Your Career
 
ISO 9001:2015 – Quality Management Systems – certified
ISO 27001:2013 – Information Security Management – certified