SENIOR APPLICATION DEVELOPER (Enterprise Data Warehouse / Data Fabric)

SENIOR APPLICATION DEVELOPER (Enterprise Data Warehouse / Data Fabric)

Requisition #: R25-3265 (GOAPRDJP00000520)

Location: Remote (within Canada)

Engagement Type: Contract

Number of Resources required: 1

Rate (CAD): Up to $100 per hour / Commensurate with related experience and market competitiveness

Term: 13 months (2025-03-04 to 2026-03-31) with 12 month extension available (up to 25-month contract)

Hours per day: 7.25

Security Screening: Enhanced Security Clearance (Requires last 3 years continuous residency in either Canada or USA)

Submission Deadline/Closing Date: February 10, 2025 (9:00 AM Mountain Time)

————————————————————————

Tri-global Solutions Group Inc. is seeking one (1) Senior Application Developer (Enterprise Data Warehouse / Data Fabric) to join our talented Service Delivery team at Ministry of Technology and Innovation (Government of Alberta).

WORK MODEL: The successful contractor will be working remotely, though must be available for onsite meetings if required. It is anticipated that this role will be 100% remote. Work must be done from within Canada at all times due to network and data security policies. Applicants must be authorized to work in Canada to apply (Canadian Citizen or Permanent Resident). Standard Hours of work are 08:00 – 16:30 Alberta time, Monday through Friday excluding observed holidays.

ENHANCED SECURITY CLEARANCE: An Enhanced Security Check is required upon contract award. Must have the last 3 years continuous residency in either Canada or United States as minimum.

REMINDER: Candidates must ensure each job/project on their resume contain the term of the job/project in a format similar to MMM/YYYY to MMM/YYYY (e.g., JUL/2020 to JUN/2023). This will ensure your application is scored accurately.

Please review the project overview and requirements below. If you meet the requirements and are interested in submitting for this role, please reply to this job posting.

If you know other consultants who may be interested in this opportunity kindly share this job posting.

Thank you.

Tri-global Solutions Group Inc.

Email: work@tri-global.com
Website: https://tri-global.com

————————————————————————

PROJECT OVERVIEW

Project Name:
JIMS 3.0 (Justice Information Management System)

Scope:
The Data Unit requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.

The position will be responsible for performing technical strategic functions, ensuring the architecture supports Justice data analytics and reporting needs.

Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.

The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
• Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
• Create both logical and physical data models that efficiently store data and support business processes.
• Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
• Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
• Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
• Interact with clients/partners (GOA-internal and/or external).

DESCRIPTION OF SERVICES

Deliver applications programming and analysis tasks as part of a system development process as well as provide application support, maintenance and enhancements. An Application Developer applies a broad knowledge of various technical areas to foresee and rectify certain problem areas within technology or with a mix of technologies, but the focus is to ensure a certain business/functional use case is solved with the help of technology.

• Liaise with business units and program areas to ensure solutions meet current and strategic ministry needs.
• Align development team to follow Application and Data Architecture.
• Write code for the most complex Functional and Technical Designs with minimal defects.
• Hands – on experience with building and managing data solutions using SQL and/or Python.
• Experience in data modelling (star or snowflake schema), including designing and developing data models to support business requirements.
• Develop and implement data warehouse solutions to support business intelligence and analytical needs.
• Demonstrate strong commitment to Data Security and Compliance to protect sensitive information and enforce data governance in enterprise platforms (access control, security policies across platforms etc.).
• Conduct data profiling to identify data trends, patterns and data quality issues.
• Experience with software development best practices including code reviews, unit testing and documentation.
• Define non-functional requirements (Performance, Availability, Portability, Recovery / Recoverability etc.).
• Assess technical impacts up front and recommend better ways of designing application to ease the development.
• Produce Technical Design, Database structure and Application Architecture for a new average to high complex application.
• Seek for the best technical design solution that respects budget and timeline. Advocate the re-use of existing components/frameworks.
• Innovate in providing better efficient ways to design application.
• Review Technical Designs from other developers and recommend optimization if necessary.
• Evaluate, with assistance, the quality of the product being delivered, and take action to improve situations.
• Assist/Execute performance/penetration tests and troubleshoot issues at the system level.
• Isolate root cause of issues and provide solution options/recommendations.
• Provide tracking and reporting of time and status on all work, as required.
• Contribute to the creation of the Application Lifecycle Planning.
• Identify and coordinate release schedules.
• Identify service requests and priorities with customers.
• Ensure planned releases remain on schedule.

MANDATORY SKILLS

– The proposed resource must meet or exceed one of the following: (8 years+) • University graduation in computer science or a related discipline and 4-yr relevant experience; OR • 2-yr diploma in computer science or a related discipline and 6-yr relevant experience; OR • 1-yr certificate in computer science or a related discipline and 7-yr relevant experience; OR • a currently active professional certification or accreditation and 8-yr relevant experience
– Experience in designing, building, testing, deploying, and supporting applications in an enterprise IT environment equivalent in size and complexity to the Government of Alberta. (8 years+)
– Experience using Microsoft SQL. (3 years+)
– Experience with Python development (3 years+)
– Experience with software development processes, and all associated best practices, methods, standards, tools, and policies. (8 years+)
– Experience working with various software development methodologies (i.e. agile, waterfall, scrum, Kanban, etc.). (8 years+)
– Experience working in a data warehouse / datalake / business intelligence or relevant data environment in a development role (8 years+)
– Knowledge of ETL processes and tools, with hands-on experience designing and implementing data pipelines for transforming and loading data from multiple sources into data warehouses. (8 years+)

DESIRABLE / NICE TO HAVE SKILLS

– Experience assisting in overall project planning and providing advice on system development opportunities. (5 years+)
– Experience making decisions and recommendations on highly technical or complex issues without formal guidelines or precedents and exercises resourcefulness and ingenuity (5 years+)
– Experience translating data from multiple sources to a single solution, including planning for historical, current, and future data needs (5 years+)
– Experience with cloud computing or big data platforms and infrastructure (5 years+)
– Experience working in the public sector (2 years+)

NOT FOR YOU?

Check out our other opportunities at https://tri-global.com or follow us on LinkedIn. We thank all candidates in advance. Only candidates selected for an interview will be contacted.

WHY WORK WITH TRI-GLOBAL?

– Empower positive change by enabling our clients to revolutionize innovation and technology, elevating them to a higher level of excellence and efficiency.
– Join an exceptional and committed team that redefines the landscape, forging a distinctive path towards success.
– Engage in stimulating and captivating projects that push boundaries and keep you constantly motivated.

DIVERSITY & INCLUSION

Tri-global Solutions Group (Tri-global) is an equal opportunity employer, committed to meeting the needs of all individuals in accordance with Accessibility Standards and the Human Rights Act, where we evaluate applicants without regard to race, colour, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity, or other characteristics protected by law. We are committed to the creation of an exceptional work environment wherein we maintain values of mutual respect, integrity, dignity, and inclusivity; and encourage the open exchange of ideas and opinions.

If you require a specific accommodation because of a disability or a medical need, please inform us. This ensures that the appropriate accommodations are in place at time of your interview and before you begin your employment.

Tri-global’s head office is located in Edmonton, Alberta. Tri-global respectfully acknowledges that we are located on Treaty 6 territory, a traditional gathering place for diverse Indigenous peoples including the Nehiyaw (Cree), Denesuliné (Dene), Nakota Sioux (Stoney), Anishinabae (Saulteaux) and Niitsitapi (Blackfoot), and many others whose histories, languages, and cultures continue to enrich our vibrant community.