Senior Data Warehouse Architect (Computer Services Officer 4)



Competition # : 39264 

Department: Service Nova Scotia and Internal Services

Location: HALIFAX

Type of Employment: Permanent

Union Status: NSGEU - NSPG 

Closing Date: 6/9/2023​ (Applications are accepted until 11:59 PM Atlantic Time)

About Us


The Nova Scotia Digital Service (NSDS), a division of Service Nova Scotia and Internal Services (SNS-IS) is a team within government, and we are putting people first. We are called a “digital” service for a reason – because we are helping government work the way that people expect things to work these days.


Our team is large, diverse, and passionate about making a difference in peoples’ lives. We believe in user-centered iterative digital service design. Working at the NSDS means you will be a part of a team whose work makes a difference through designing, continuously improving and delivering the programs and services people need, alongside caring, compassionate, highly skilled people.


At the NSDS, we don't just accept difference - we celebrate a supportive culture of diversity, inclusion and belonging!


The people who use government programs and services come from all walks of life. It is important that the NSDS reflects the people that we serve – so we can deliver better, and more accessible, and inclusive public services. We work hard to create an environment where different perspectives and experiences are valued. We are committed to helping diverse talent thrive.

About Our Opportunity


A Day in the Life Senior Data Warehouse Architect


Under the direction of the Manager of Business Intelligence and Data Analytics, the Senior Data Warehouse Architect is a team leader, responsible for the deployment of business intelligence solutions that support the applications of several Departments. The team is committed to a client-focused strategy ensuring end users have the tools to access their operational data as well as make informed and predictive business decisions.


As the Senior Data Warehouse Architect, you will participate in all phases of implementation of the data warehouse roadmap.  In the Business Intelligence team, you will:


  • Design and create Framework and Data Warehouse models, data marts, and data stores, while ensuring high levels of data availability.
  • Participate in data migration, metadata creation and data validation.
  • Make presentations to the business; attend team meetings and communicate (verbally and in writing) team and project issues to appropriate direct reports and management.
  • Present findings, recommendations, and specifications both verbally and in writing.
  • Develop project plans.
  • Assign tasks and responsibilities.
  • Conduct status reporting.
  • Recognise and resolve problems.
  • Monitor and maintain operational and project schedules.
  • Complete resource planning, staff development, training and mentoring, and prepare business cases.

Primary Accountabilities


  • Lead and/or participate in the development and maintenance of the architecture of enterprise/corporate services, which includes vision, policies, guidelines, standards, reference models and tools. These services will be use across government. 
  • Supervises, sets priorities and monitors the efficiency of a team of specialist and analysts in a given area, ensuring that users’ needs and requirements are met, and service levels are attained.
  • Develops and implements IT guidelines and procedures for their area of expertise, keeping in line with the objectives of the NSDS to ensure consistency and reliability of the services provided. 
  • Develops IT standards in conjunction with other Data Warehouse Architects to align the work methods of NSDS ensuring that services are effective and timely.
  • Analyses trends in IT issues and performs root cause analysis over extended periods to provide sound long-term solutions while considering the impact on other areas.
  • Develops, modifies or enhances databases, programs, networks, administrative applications and/or electronic tools to facilitate and improve services. 
  • Provides expert advice and training to users on the optimal use of computer equipment and software to increase effective and efficient use by clients.
  • Provides tier 3 level technical support, working directly with end users and other technical teams, by troubleshooting and repairing software (web-based applications, databases, productivity software) and implementing corrective action to ensure timely resolution of users’ IT issues 
  • May perform some or all of the duties above and any other related duties as assigned.

Qualifications and Experience


Bachelor’s degree in computer science and five years related experience or a minimum of successful completion of a recognized Information Technology course plus a minimum of five years and six months related experience (or the equivalent combination of training and experience).


This position requires someone with the following skills and work experience:


  • Experience designing, developing, and supporting data assets including data warehouse, real time database, and metadata.
  • Data migration, metadata creation and data validation.
  • Design and creation of Framework Manager models and data marts.
  • Analysis and interpretation of business reporting requirements. Report authoring capabilities (canned and ad hoc) using IBM Cognos tools is considered an asset. Experience developing dashboards and reports in Tableau is considered an asset.
  • Implementation, maintenance, security strategy, performance monitoring and best practice methodology of IBM Cognos tools.
  • Oracle, SQL, PL/SQL; ETL tools (Extract Transform Load), data extraction. Experience with Microsoft SSIS is considered an asset.
  • Able to work independently as well as collaborate and coach team members.
  • Show exceptional communication and presentations skills at a technical and user/client level, both written and verbal.
  • Effective problem-solving skills, capable of prioritizing tasks and organizing work efficiently to meet tight deadlines.
  • Capable of handle stressful situations.
  • Provide clients service excellence.



Applicants relying on education and experience equivalencies must demonstrate such equivalencies in their application.


We recognize that everyone brings different skills and experiences to the table and that not everyone “checks all the boxes”. So, apply anyway! Tell us why you’re the right fit for the job.



Based on the employment status and Union agreement, the Government of Nova Scotia offers its employees a wide range of benefits such as Health, Dental, Life Insurance, Pension, General Illness (Short and Long Term), Vacation and Employee and Family Assistance Programs. Click here to learn more about our various benefits offering and eligibility criteria. 

Working Conditions


  • Normal work week is 35 hours/week, 7 hours/day
  • May be required to work overtime on occasion 
  • 24 hours standby rotational shift with other co-workers on weekends and holidays
  • Hybrid working arrangement (includes both partially remote and partially on-site work)

What We Offer


  • Career development where you have access to career guidance, tools, resources, and ongoing training for every stage of your career
  • Engaging workplace: our employees feel valued, respected, connected, and tuned in, we have forward-thinking policies and strategies
  • Countless career paths
  • Department specific flexible working schedules


Pay Grade:  PR 17  

Salary Range:  $3,091.70 - $3,631.17 Bi-Weekly


Employment Equity Statement:

Our goal is to be a diverse workforce that is representative, at all job levels, of the citizens we serve.  The Government of Nova Scotia has an Employment Equity Policy, and we welcome applications from Indigenous People, African Nova Scotians and Other Racially Visible Persons, Persons with Disabilities and Women in occupations or positions where they are under-represented.  If you are a member of one of these equity groups, you are encouraged to self-identify on your electronic application.


This is a bargaining unit position initially restricted to current civil service employees represented by the Nova Scotia Government Employees Union (NSGEU). If applying from outside a government office, employees must apply correctly via this link:



 Failure to apply correctly means that your application will not be given first consideration as a bargaining unit applicant, and will only be included if external applications are pursued. 


External applicants and current casual employees will only be considered if there are no qualified civil service bargaining unit candidates. PLEASE NOTE: Candidates will not be considered for an interview if applications are incomplete or are missing information. 


Offer of employment is conditional upon the completion of all applicable background checks and confirmation of credentials, the results of which must be satisfactory to the employer. We thank all applicants for the interest, however, only those selected for an interview will be contacted. All questions and concerns may be directed to