Database Integrator

Company Description

ADGA Group is a proudly Canadian-owned and operated defence and security technology company. Our core services include value-added program management, agile software engineering development, and integrated security solutions. As an industry partner to the Canadian Government and Canadian Armed Forces (CAF) for decades, ADGA is actively supporting ongoing and emerging requirements for operational readiness, reconstitution, and modernization.

For decades, we have recruited veterans to integrate their unique skillsets and highly specialized training into our workforce and work culture. At ADGA, we are united by our social purpose to create meaningful employment opportunities for veterans of the CAF and RCMP, their families, and fellow citizens who share a passion to contribute to the security and well-being of Canadians.

ADGA’s social purpose empowers us to reinvest in our employees as well as to donate generously to veteran and military family causes in our community.

Join our team at ADGA, where we prioritize your success by fostering internal movement and growth in a safe, inclusive, and agile work environment. We offer a wide variety of career and developmental opportunities, including the option to work on different projects and technologies, on-the-job training, cross-training, access to business and technical online courses, and formal education subsidies.

Job Description

REF: 001

ADGA is currently hiring a Database Integrator for one of our largest Defence programs and provide Business Intelligence Reporting support to the directorate’s program reporting dashboards!

Tasks will include:

• Collaborate with project stakeholders to gather and analyze projects’ data and requirements.
• Design and maintain data models, ensure their accuracy and consistency for directorate’s program reporting.
• Design, develop dashboards and reports using Business Intelligence tools such as Power BI to track projects’ data, projects’ status, milestones, interdependencies, etc.
• Optimize data models and queries for optimal performance.
• Provide support and enhance to the reports and their data.
• Provide user training on navigating and using the reports.
• Produce documentation, brief notes, reports, and presentations with regards to reporting work.
• Advise, make recommendations, and contribute to the organization's reporting strategies and initiatives.
• Produce project documents, brief notes, reports, and presentations.
• Coach, mentor, and train the organization to perform any of the above; and
• Perform any other work related to this category.

Qualifications

• Must hold a valid PSPC Secret level clearance and a Controlled Goods Certificate.
• Our team must work on-site on a full-time basis in Gatineau office.
• Proof of a university degree or college diploma or a suitable application database work experience required to support the Land C4ISR.
• Minimum of 12 months experience in the last 48 months in the preparation of technical concept documents, system specifications, and technical proposals in the field of IT/IM or engineering (System, Data Analysis, Database, Data mapping) experience.
• Minimum 24 months of experience within the last 48 months performing at least 4 of the following tasks:
  • Data mapping for application systems.
  • Extract Transform Load process for data migration.
  • System integration, hardware, and software, (COTS and/or custom developed) components into new or existing systems.
  • Database architecture and system interfaces.
  • System life-cycle management.
  • Experience in business process improvement and knowledge of business intelligence tool sets.
  • Data analysis and problem-solving expertise.
  • Database design.
• Minimum 24 months experience in at least 3 of the following tasks:
  • Communicating database mapping and/or data conversion process.
  • Ability to clearly communicate in writing and orally.
  • Collaborating with multidisciplinary teams in the development of IT systems.
  • Communicate information mapping, and conversion procedures for application interaction and integrations.
  • Communicate information flow and application interaction and integration.

Additional Information

Work-Life Balance

We strongly support a healthy and productive work-life balance. This starts with a flexible approach to work, and policies designed to support employees through their day-to-day routines and major life events. For example, we offer a Maternity/Parental Top-Up (up to 52 weeks) and a Reservist Leave Top-Up (up to 180 days).

Belong@ADGA

ADGA continuously strives to integrate advanced Diversity, Equity & Inclusion (DEI) approaches and practices into our work culture. Our employee-based DEI Committee explores activities and invites discussions that foster an environment where all employees feel valued, respected, and heard.

Compensation

Above and beyond our commitment to offer a competitive base salary, ADGA has a company-wide profit-sharing plan for all full-time and part-time employees.

Comprehensive Benefits and Total Rewards

We offer a comprehensive benefit program, providing employees with the choice between base or enhanced plans. Depending on the plan, ADGA pays for Health & Dental, a Health Spending Account, Short-Term Disability, an Employee Assistance Program, and a Telemedicine service. Also offered: discounts on gym memberships, 5,000+ perks through Perkoplis, a Deferred Profit Sharing Plan, and access to a wide range of other employee-centric services and savings programs.