Team recruiter


Data Architect (Government)

Reference id:948070
Posted on: 4/9/2024
  Location: Canada (Remote - MST)

Job Description

One of our Government clients is looking for a Data Architect (Government)
Length: 12 months with a possibility of extension
Location: Canada (Remote - MST) - Resource will work remotely in Canada, though must be available for onsite meetings when required (Once every 3-4 months)
Hours of Work Per Day: 7.25, 08:15 - 16:30 Alberta time, Monday through Friday
Business Unit: Technology and Innovation
Project Name: Justice Information Management System
Security Clearance: Proposed resource must agree to an Enhanced Security Check upon contract award. Must have the last 3 years continuous residency in either Canada or United States as minimum.


'The start date of this job is flexible and in order to find the best candidate the job may remain open much longer than the date mentioned on this posting... or you may be asked to start sooner than the expected start date if you are able to do so !'

Please read the job description below. If this interests you, please send a MS-Word version copy of your resume (ASAP) along with a telephone contact number: E-mail to talent@teamrecruiter.com

Please mention the job title above in the subject line
The recruiter in charge of this role is San

After you have submitted your resume via e-mail please complete the application for this specific job by clicking 'Submit Your Resume for this Job' at the bottom of this page to match your resume to the job.

If you are interested in further opportunities, why not also do a general registration in our database. By visiting our website and clicking on 'Database Registration'

If you do not think you are a match for this opportunity, but know someone who is, feel free to forward this email to them and you will be eligible for a referral bonus upon a successful hire.

Requirements:
ROLE MANDATE:
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 (internal and/or external).

ROLE RESPONSIBILITIES INCLUDE (but are not limited to):
 Design the data architecture, including the EDW structure, data marts, and conformed dimensions, to support reporting and analytical needs.
 Develop logical and physical data models for the EDW and data marts, ensuring they are optimized for performance and aligned with business processes.
 Plan and oversee the integration of data from various sources into the EDW, designing ETL processes that ensure data quality and consistency.
 Establish data governance policies and practices to manage data access, quality, and security throughout the project.
 Support the development, adoption, and implementation of best practices in data management, which includes data architecture, data sharing, data integration, data quality, common data, and standardized methodologies.
 Lead or assist in communicating activities surrounding the Data architecture.
 Document the data architecture, models, and processes, and ensure knowledge transfer to IT and business teams for ongoing operations and maintenance.
 Contribute to development of data sharing, data integration, data quality, common data and standardized methodologies.
 Participate in design reviews, regular or ad-hoc architectural reviews - ensuring correct interpretation of the data architecture.
 Respond to requests for extensions to the scope of the data architecture, as needed.
 Work with developers and supporting information technology (IT) resources to manage ongoing data assets and process changes, as needed.
 Work with IT and business stakeholders to ensure the data architecture meets business requirements and is aligned with the organization's strategic goals.

DELIVERABLES:
 Specific deliverables and due dates will be determined by the client team.
 Status reports - weekly and monthly.

EQUIPMENT REQUIREMENTS:
 Resource will require own equipment.
 Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD/remote-related software will be installed on the resource's computer.

EDUCATIONAL BACKGROUND:
The proposed resource must meet or exceed one of the following:
 University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience;
OR
 2-yr diploma in business, management or a related discipline and 4-yr DA experience;
OR
 1-yr certificate in business, management or a related discipline and 5-yr DA experience;
OR
 6-yr DA experience

Qualifications:
MUST-HAVE SKILLS:
 2 years of experience dealing with clients and explaining complex data principles in a thoughtful manner.
 2 years of experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government
 2 years of experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government
 5 years of experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management
 6 years of experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
 5 years of experience working directly with clients, and coordinating with both external stakeholders and internal business areas to ensure communications are relayed to all parties.
 6 years of experience with enterprise business intelligence and performance management products. Specifically Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View) or MicroStrategy.

NICE TO HAVE SKILLS:
 2 years of direct, hands-on experience with design and implementation of data security, data privacy, policies, data de-identification/anonymization, data audits/reviews, synthetic data
 2 years of experience and understanding of software quality assurance QA, Testing and Defect Lifecycle.
 2 years of experience designing and implementing enterprise architecture database plans and models that help align an organization's data, information or technology with its required business capabilities in a large enterprise IT environment equivalent in size and complexity to the Government
 2 years of experience in Agile Projects
 3 years of experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
 2 years of experience providing leadership, planning, estimating, and presentations of ideas and solutions.
 2 years of experience with building, testing and deploy Artificial Intelligence models and knowledge of Artificial Intelligence Infrastructure
 1 year of experience with cloud computing or big data platforms and infrastructure
 1 year of experience working in or for the public sector
 2 year of experience working with querying data with Microsoft Transact-SQL Server.
 2 year of experience with advanced Data Warehouse and business Intelligence planning, and architecture skills in Microsoft technology stack.
 0.5 years of experience working with Justice Courts data marts or data warehousing

SOFT SKILLS:
 Excellent verbal and written communication skills and ability to interact professionally with a diverse group.
 Ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
 Ability to manage stress and conflict.
 The ability to establish and maintain effective working relationships with team members, management and vendors.


Please note that this is the most up to date version of job description available at this time - During Client Interview you will receive additional information - variance may apply!

When you have some time please register in our database (5 minutes process) to be considered for future openings; the link is available on our website at http://www.teamrecruiter.com in the Candidate section. Please follow us on LinkedIn at https://www.linkedin.com/company/teamrecruiter.com/, or on Twitter at https://twitter.com/TeamRecruiter.

We thank all applicants for their interest. Only those who meet the qualifications will be contacted through telephone/email. You are encouraged to register with us in our database to be considered for future positions available.

Have a great day.

......At Teamrecruiter.com we offer some of the most highly qualified professionals in the workforce. We dedicate an industry trained recruitment specialist to the following areas: IT, Finance, Admin, Sales, Executive Search and Contractors. If you would like to learn more about our full-service recruiting firm please visit our website at www.teamrecruiter.com.

CAMSC and ACSESS certified

"...All Offers are conditional on Client Post-Offer Conditions being met and removed by end client prior to written offer signing"

"Please note that emails from our Recruitment Firm may inadvertently be sent to your Spam Folder. When contacted regarding an employment opportunity, please keep an eye on your Spam/Junk Folder to avoid missing important communication."

THE EMPLOYER OF RECORD FOR THIS ROLE WILL BE TEAM RECRUITER / SE.


Accommodations are available upon request for all individuals with disabilities taking part in the recruitment and selection process.