Business Intelligence Server & Application Specialist

Competition:           #42988

Salary:                     $2,653.85 – $3,231.58 Bi-Weekly / $69,000.10 – $84,021.08 Annually (PR 14)

Position Type:        Permanent

Benefits:                 Paid Holidays, Vacation, Sick/Family Leave, Health, Dental, and Defined Benefits Pension

Location:                Halifax

Department:           Cyber Security and Digital Solutions

Union Status:         NSGEU-NSPG

Closing Date:          June 10, 2024 @ 11:59PM Atlantic Time

About the Department of Cyber Security and Digital Solutions (CSDS)

Welcome to the Department of Cyber Security and Digital Solutions (CSDS), the guiding force behind digital transformation within the Government of Nova Scotia. Formerly known as the Nova Scotia Digital Service (NSDS) within the Department of Service Nova Scotia and Internal Services (SNSIS), we have evolved into a standalone department with a focused mission.

At CSDS, we support government departments and partners in their digital transformation journeys. We don’t just implement digital solutions; we navigate the complexities of digital transformation, modernizing outdated systems and ways of working. Our role is to ensure that digital services are user-centered, efficient, and make a real difference to Nova Scotians.

Our team is diverse and passionate, championing innovation and embracing the richness of multiple perspectives. We’re not just an IT department; we’re a community dedicated to enabling digital transformation and bolstering cybersecurity across the province.

Join us at CSDS as we shape the future of digital services in Nova Scotia, supporting our partners in their journey towards a digital future.

About Our Opportunity

The Business Intelligence Server & Application Specialist is responsible for the deployment and maintenance of environments and applications that host or support the data analytics and science needs across government. They are part of a team committed to a client-centered strategy ensuring developers and end-users have the tools to access and analyze their data to make informed business decisions.

Primary Accountabilities

Under the direction of the Manager, Data & Analytics, this position is responsible for:

Maintenance and effective operation of application servers (including but not limited to Tableau and Cognos) to ensure security and optimal performance:

– Configuration of users, roles, and maintaining/ensuring security.

– Performing regular checks and remediations; identifying and resolving issues that may arise in the servers.

– Applying patches or updates, and ensuring that any new features are made available.

– Data backups and disaster recovery; ensuring that there are mechanisms in place to restore the server applications and their data in the event of a failure.

– Identifying and communicating opportunities for optimization and enhancements to management.

– Ensuring the maintenance of any other related software components, including for example conducting regular updates and ensuring they are compatible with the current version of the application.

– Conducting and communicating impact assessments for any other impacted software prior to installing updates and keeping management informed.

Primary Accountabilities will also include:

• Monitoring and maintaining operational and project schedules.

• Participating in data migration, metadata creation and data validation activities, as well as in all phases of implementation of the data warehouse roadmap.

• Designing and creating framework and data warehouse models, data marts, and data stores, while ensuring high levels of data availability.

• Developing, modifying or enhancing databases, programs, networks, administrative applications and/or electronic tools to facilitate and improve services.

• Provision of 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.

• Developing and implementing IT guidelines and procedures for their area of expertise, keeping in line with the objectives of the CSDS to ensure consistency and reliability of the services provided

• Attending team meetings and communicating (verbally and in writing) team and project issues to management

• Presenting findings, recommendations, and specifications both verbally and in writing.

• May perform other duties as assigned.

The successful candidate will:

• Possess excellent problem-solving and communication skills, and work independently as well as collaborate with team members.

• Have excellent time management skills and be able to prioritize tasks to meet tight deadlines, in consultation with the Manager.

• Strive to provide excellent client service as part of a team.

Qualifications & Experience

Bachelor’s degree in computer science and three years’ related experience, or successful completion of a recognized information technology course plus a minimum of three years and six months related experience, or an equivalent combination of training and experience.

Candidates must demonstrate the following skills and work experience in their resumes:

•  Implementation, maintenance, security strategy, performance monitoring and best practice methodology of IBM Cognos or Tableau tools.

• Administration of multiple Cognos or Tableau servers.

• Ongoing operational support for multiple clients.

• Design, development and support of data assets including data warehouses, real time databases, and metadata.

• Data migration, metadata creation and data validation; design and creation of data models and data marts.

• Proficiency in Oracle, SQL, PL/SQL; ETL tools (Extract Transform Load), data extraction.

• Analysis and interpretation of business requirements; data analysis authoring capabilities (canned and ad hoc) using IBM Cognos or Tableau tools.

Equivalency

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

Working Conditions

• Normal work week is 35 hours/week, 7 hours/day.

• May be required to work overtime on occasion.

• Hybrid working from home/office policy.

• 24 hours standby rotational shift with other co-workers on weekends with specific compensation.

Benefits & Perks

At the CSDS with the Government of Nova Scotia, we are committed to providing a fulfilling work environment with numerous benefits and opportunities:

• Work-Life Balance: Maintain a healthy work-life balance with a 35-hour work week.

• Secure Your Future: Take advantage of our defined benefits pension plan for a stable retirement.

• Generous Time Off: Enjoy all national/civic holidays, 18 sick days, and family leave provisions.

• Flexible Work Arrangements: Accommodate your needs with various options for flexibility, such as hybrid schedules.

• Employee and Family Support: Access our Employee and Family Assistance Programs for resources and guidance.

• Support in Times of Need: Receive short- and long-term disability assistance when required.

• Cross-Sector Collaboration: Experience the power of collaboration as you engage with various government departments. Unlock a world of knowledge, expertise, and connections, contributing to the betterment of our province.

• Growth & Development: Open doors to professional growth within the department and beyond. Explore diverse career paths in specialized areas such as digital service design, cybersecurity, enterprise risk, digital platform services, and mission IT.

• Lifelong Learning: Continuously expand your knowledge and skills through training and development programs.

• Professional Advancement: Immerse yourself in the government landscape and discover endless opportunities for learning, advancement, and making a meaningful impact.

Join the Department of Cyber Security & Digital Solutions and experience the benefits of a fulfilling career, supported by comprehensive perks, career development opportunities, and a diverse range of paths to explore within our department and across the government.

Pay Grade:  PR 14  

Salary Range:  $2,653.85 – $3,231.58 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 [email protected].