Data Analytics Specialist

Company Description

Founded in 1967, ADGA is a privately owned and operated Canadian company. We employ over 700 highly skilled team members who apply their knowledge and expertise in service delivery of advanced technology solutions for clients in the Defence, Security and Enterprise Computing markets across Canada. Celebrating over 50 years in business, we are proud to be one of Canada’s most trusted professional engineering and consultancy firms. Our clients continue to rely on ADGA to provide subject matter expertise, and quality talent to fulfill their business objectives. We have done so successfully by anticipating and responding to the constant changes in technology, and evolving with agility. Our culture of commitment, trust, and accountability guides our business, fosters our growth, and is at the core of our relationships with clients, employees and consultants. Whether your projects are complex, large-scale requirements, or dependable, professional resources to execute on time, and on budget, you can count on ADGA to deliver. We are dedicated to your success.

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.