Senior Developer (ETL)

Senior Developer (ETL)

9300BR - Senior Developer (ETL)

Halifax Regional Municipality is inviting applications for the temporary full-time position (up to 18 months) of Senior Developer (ETL) in Information Technology.

Halifax Regional Municipality (HRM) is committed to reflecting the community it serves and recognizing Diversity and Inclusion as one of the Municipality's core values. We have an Employment Equity Policy and we welcome applications from African Nova Scotians and Other Racially Visible Persons, Women in occupations or positions where they are underrepresented in the workforce, Indigenous/Aboriginal People, Persons with Disabilities and 2SLGBTQ+ Persons. Applicants are encouraged to self-identify on their electronic application.







Looking to make a difference? Do you enjoy enabling the collection of data and ensuring it gets to the right people to make evidence-based decisions to help solve municipal challenges? As a member of HRM's Digital Services team, the Senior Developer will work closely with our Planning & Development Division to design, build and maintain enterprise-level, scalable data models, flows and custom solutions that support the creation of advanced reporting and analytics; data collection and system integration capabilities.

The Senior Developer will utilize standard coding tools and processes to ensure that development solutions meet defined technical, functional, and service level requirements and standards. They oversee consistent quality in handoffs between development to deployment and operations while incorporating continuous process improvement and feedback.

DUTIES AND RESPONSIBILITIES:

- Provides expertise, mentorship and adheres to software design patterns,





application lifecycle management and software development lifecycle
- Works with key stakeholders to review/recommend options for systems solutions based on business and technical requirements
- Designs, develops, implements and maintains custom data collection applications, ETL packages, interfaces and integrations using a variety of database platforms, programming languages, tools and technologies targeted towards multiple platforms, formats and clients
- Customizes and integrates third party and common off-the-shelf (COTS) applications to ensure streamlined integration with the HRM data and systems landscape
- Reviews and provides guidance to others regarding design and development
- Prepares technical documentation such as entity relationship diagrams, application flow diagrams, use cases,





user guides, test plans, and maintenance procedures
- Recommends, maintains and enhances technical or operational policies, procedures, standards related to system application programming
- Assists with technical documentation and training material regarding process and data flows and proper use of applications and systems
- Participates in the development of non-functional requirements and integration architecture for RFPs and participates in assessing RFP responses as required
- Provides input into SLA's with vendors as required
- Other duties, as assigned

QUALIFICATIONS

Education and Experience:

- Post-secondary degree in Computer Science Information Systems, Data/Information Management, Business, Data Science, Software Engineering,





Computer Engineering, GIS Program or an equivalent combination of education and experience
- A minimum five (5) years hands-on experience in application software and/or ETL development and operational support
- Developer related certifications considered an asset

Technical / Job Specific Knowledge and Abilities:

- Strong interpersonal and communication skills, both written and verbal
- Strong logic, analysis and problem-solving skills
- Strong knowledge with current, industry best practice, n-tier application architecture and design patterns
- Strong knowledge of the software development lifecycle
- Demonstrated ability with ETL tools (SAP Data Services, Microsoft SSIS) and concepts
- Demonstrated ability to expose and consume API's (RESTful & SOAP)






- Demonstrated knowledge of relational databases and standards (SQL, NoSQL, xDBC, etc.)
- Demonstrated ability and expert skills with a variety of current programming and scripting languages (.NET, SQL, C++, Java, PHP, JavaScript, Python, Drupal, R, Visual Basic, DAX, etc)
- Demonstrated ability in developing applications/integrations/ETL for platforms (Windows/.NET, Linux/Unix, Web platforms for browsers, native Mobile applications, Web Services, GIS, Windows Services, etc)
- Demonstrated ability with Business Intelligence tools (SAP Business Objects, Microsoft Power BI) and concepts
- Ability to create system design specifications, solution architecture specifications, hardware requirement specifications from captured business requirements,





functional and non-functional requirements and security requirements
- Ability to produce entity relationship diagrams, application flow diagrams, UML, and use case documentation
- Ability to self-manage to task and schedule
- Familiarity with analytic data structure standards and architecture
- Familiarity with project management methodologies (Waterfall, Agile, etc.)
- Familiarity with Business Process Re-engineering, & Business Process Modeling/Mapping
- Familiarity with GIS tools and spatial intelligence concepts
- Familiarity with Web Server software including IIS, Apache and Tomcat
- Familiarity with Master Data Management practices
- Familiarity with Data Governance practices
- Familiarity with change and release management procedures






- Familiarity with Azure DevOps, Azure Data Studio

Security Clearance Requirements: Applicants may be required to complete an employment security screening check.

Please note - Testing may be conducted as a component of the selection process to assess technical and job specific knowledge. Candidates, who are selected for testing, may be tested in a group setting, scheduled at the employer's discretion.

COMPETENCIES: Analytical Thinking, Communication, Conflict Management, Customer Service, Decision Making, Developing Others, Networking and Relationship Building, Organizational Awareness, Organization and Planning, Teamwork and Cooperation, Valuing Diversity, Visioning, Strategic Thinking, and Innovation.
WORK STATUS: Temporary,





full-time (up to 18 months, possibility of extension to 24)
HOURS OF WORK: 8:30 am to 4:30 pm, Monday to Friday. Some overtime may be required. (flexibility to work variable hours is an option) OR (Flex options to work outside these hours under a hybrid work model may be available).
SALARY: $51.35 per hour as per the NSGEU Local 222 Collective Agreement.
WORK LOCATION: 14th Floor Barrington Tower, Halifax
CLOSING DATE: Applications will be received up to 11:59 pm on October 15th, 2024.

This is a bargaining unit position. External applicants will only be considered if there are no qualified bargaining unit candidates.

Please note: We thank all applicants for their interest. Only those applicants selected for interview/testing will be contacted.

During the recruitment process, applicants have the right to request an accommodation. Applicants invited to participate in an assessment process (such as an interview or testing) and who require accommodation, should discuss their needs with the Recruiter when invited to the assessment process.