Data Warehouse Developer (Secret Eligible)

Our reputable client in the defense sector is seeking a skilled Data Warehouse Developer to join their team in Ottawa on a permanent basis. This role would be hybrid (1 day a week in office) in Ottawa. The successful candidate would meet eligibility for Canadian Secret Security Clearance along with the following technical requirements.

Roles and Responsibilities

• Develop and maintain the organization’s Data Warehouse.  Includes but not limited to SSMS, SSAS and SSIS solutions.
• Model various complex data sources using the Kimball methodology.
• Provide data as a service to end users via the Data Warehouse.
• Provides analytical and technical support for complex requests, projects, or initiatives.
• Perform Database Administration tasks for the various Data Warehouse environments and objects.
• Document and maintain the existing Data Warehouse environments.
• Work with the business to ensure appropriate governance is applied and adhered to in accordance with IT best practices.
• Carry out data validation with the Applications Manager to ensure reports are pulling all correct data accurately and achieving customer needs.
• Where applicable, develop the reports within the existing Data Warehouse and ERP.
• Develop reports and extract from multiple data sources & perform other duties as directed.

Qualifications and Skills

• 4+ years of relevant experience including experience with data repository design and maintenance and database administration and complex reporting analysis.
• Eligible for a Canadian Secret Security and ITAR Clearance.
• Minimum of 3 years’ experience of Data Warehouse technology - SSMS, SSIS, SSAS.
• Thorough understanding of the Kimball data modelling methodology.
• Minimum of 3 years’ experience of working with Microsoft technologies.
• Experience of report writing using SQL, Crystal, Power BI, SSRS, Business Intelligence or other reporting tools is preferable.
• Experience working in a large-scale organization with ERP systems.

Benefits

• Comprehensive employee benefits, supportive work-life balance, vacation time-off, bonus and more.