Data Architect - Senior

Description

Le projet est un projet d'intgration de donnes visant regrouper, repenser et mettre en ?uvre plusieurs data marts de reporting disparates contenant des donnes des tribunaux dans un Entrept de Donnes d'Entreprise (EDW) ainsi qu'un ensemble de data marts et de vues dpendants. Ce projet remplacera les six data marts IBM Cognos BI autonomes existants (JIMS, Crown File Ownership CFO, Court Case Management CCM, Courtroom Utilization, Courtroom Activity et Case Adjournment) par un entrept de donnes bien intgr.
Les data marts existants extraient, restructurent et agrgent les donnes ncessaires aux rapports stratgiques, oprationnels et ad hoc partir de la base de donnes Justice Online Information Network (JOIN). L'objectif du projet est d'amliorer la disponibilit, la gouvernance et le reporting des donnes judiciaires en mettant en place une architecture de reporting plus efficace, conviviale, rapide et rentable.
Les avantages suivants seront raliss grce au projet :

• Architecture intgre et dynamique
• Reporting interactif
• Rduction du dlai de production des rapports
• Prservation des donnes historiques
• Amlioration de la gouvernance des donnes

Responsabilits du rle de Data Architect

• Examiner les data marts existants
• Effectuer un profilage dtaill des donnes
• Analyser et crer des spcifications de conception et de mapping
• Identifier les dimensions ncessaires pour les tables de faits
• Effectuer un profilage dtaill des tables incluses dans les tables de faits
• Dvelopper et tester les processus ETL (Extract Transform Load)
• Dvelopper des rapports Power BI pour les tests de plusieurs dimensions
• Tester les dimensions et les tables de faits pour l'assurance qualit
• Mettre jour les modles de donnes JOIN actuels avec de nouveaux attributs de faits
• Mettre en place les donnes ncessaires en staging
• Corriger les anomalies mineures dans les data marts livrs
• Fournir des retours et leons apprises la clture du projet

Tches

• Dfinir et grer efficacement l'architecture des donnes (principes, stratgies, mthodes, modles, normes, directives, plans, etc.)
• Promouvoir des modles de donnes rduisant la redondance via la rutilisation et le partage
• Identifier et documenter les exigences de donnes de l'entreprise
• Favoriser les pratiques amliorant la qualit des donnes
• laborer et diriger les plans de transition vers l'tat cible des donnes
• Participer aux communications lies l'architecture des donnes de l'entreprise (GAEA)
• Contribuer au dveloppement du cadre d'architecture d'entreprise et des mthodes de conception
• Rpondre aux demandes d'extension du primtre de l'architecture
• Fournir conseils et expertise aux projets pour assurer leur alignement
• Participer aux revues d'architecture et de conception
• Soutenir les autres membres de l'quipe d'architecture

quipements et installations

• Les ressources doivent fournir leur propre quipement (ordinateur, logiciels, accessoires, etc.)
• L'ordinateur doit tre compatible avec Azure Virtual Desktop (AVD), Windows tant recommand
• La province fournit les accs et identifiants aux systmes
• En cas de travail sur site, l'espace de bureau est fourni, mais pas l'quipement informatique
• L'outil principal de runion est Microsoft Teams (Zoom utilis occasionnellement)
• Le taux propos doit inclure tous les cots (quipement, administration, etc.)

Lieu de travail

• Travail principalement distance
• Prsence possible Edmonton sur pravis raisonnable (environ 15% du temps)
• Les frais de dplacement ne sont pas couverts
• Possibilit de modification du mode de travail
• Travail obligatoire depuis le Canada

Scurit

• Fournir une vrification de scurit renforce avant de commencer
• Possibilit de demander une habilitation de scurit suprieure (RCMP Top Secret)
• Acceptation conditionnelle aux vrifications de scurit

valuation

• Tarification : 20%
• Qualifications : 20%
• Entrevue : 60%

Informations supplmentaires

• Nouveau poste
• Entrevues prvues environ 2 semaines aprs la clture
• Formation obligatoire (POPA, ATIA, cyberscurit, etc.)

Exigences de candidature

• Exprience documente dans le CV
• Format des dates obligatoire (mmm/yyyy mmm/yyyy)
• Trois rfrences

Comptences requises

Exigences obligatoires

• Conflit d'intrt : Oui
• Diplme en informatique ou domaine connexe : Oui
• 8 ans d'exprience en architecture et solutions d'entreprise
• 8 ans en documentation de bases de donnes
• 3 ans en analyse des risques et menaces
• 8 ans en principes d'architecture d'entreprise
• Exprience en leadership et communication

Atouts

• Certification TOGAF
• Comptences interpersonnelles solides
• Rsolution de problmes et travail en quipe

Exprience technique

• 5 ans en architecture de bases de donnes
• 2 ans avec outils de modlisation (PowerDesigner, ER Studio)
• 3 ans en gestion de projet Agile
• 5 ans en cloud ou big data
• 5 ans en BI et performance
• 5 ans comme Data Architect
• 5 ans avec SQL et data warehouse
• 5 ans avec Transact-SQL

Niveau d'exprience

Expert
Description
The project is a data integration project aimed to amalgamate re-design and implement several disjointed reporting data marts containing court data into an Enterprise Data Warehouse EDW and a set of dependent data mart and views. This project will replace the existing six stand-alone IBM Cognos BI data marts JIMS Crown File Ownership CFO Court Case Management CCM Courtroom Utilization Courtroom Activity and Case Adjournment with a well-integrated data warehouse. The existing data marts extract process re-structure and aggregate data required for strategic operational and ad hoc reporting of court data stored in the Justice Online Information Network JOIN database. The goal of the project is to evolve availability governance and reporting of court data by implementing a more efficient user-friendly faster and cost-effective reporting architecture. The following benefits will be realized through the project:

- Integrated and dynamic architecture
- Interactive reporting
- Reporting lag
- Preservation of historical data
- Improved data governance

This Data Architect role will:
- review existing data marts
- perform detailed data profiling
- analyze and create design and mapping specifications
- identify Dimensions required for Facts
- complete detailed data profiling of tables included in Facts
- develop and test Extract Transform Load ETL processes
- develop Power BI reports for testing for several Dimensions
- testing of Dimensions and Fact for quality assurance
- update JOIN as-is data models for new Fact attributes
- stage the required data
- address minor fixes in delivered data marts
- provide feedback and lessons learned at project close out.

Duties:
- Facilitate the effective definition and management of the data architecture e.g. principles strategies architectures methods design principles models standards guidelines plans etc.
- Encourage data models and practices that reduce data redundancy by promoting reuse/sharing in keeping with the IMT strategy
- Identify and document enterprise data requirements
- Encourage practices that improve data quality
- Develop and lead the transition plans that will guide current data to its ideal future state
- Lead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture GAEA data architecture
- Contribute to the definition and development of the enterprise architecture framework and associated corporate solution design and delivery methods thus improving the proactive alignment of data architecture
- Respond to requests for extensions to the scope of the data architecture
- Provide information advice guidance and consultancy to initiatives/projects that are defining or aligning to the data architecture - thus promoting compliance to the data architecture and IMT strategies
- Establish and participate in design reviews regular or ad-hoc architectural reviews - ensuring correct interpretation of the data architecture and IMT strategies and
- Provide support to other members of the enterprise architecture team as required

Facilities and Equipment:
- Resources shall be responsible for providing all of their equipment including computers software printers supplies desks and chairs. The computer's OS must be a modern version of Windows or MacOS 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. The Province shall ensure that resources have the necessary access and credentials to the GoA system.
- In the event that resources are directed to work in-person the Province shall provide the requisite office space furniture and office supplies. However the resources shall continue to be responsible for providing computers and software and the Province shall continue to ensure that resources have the necessary access and credentials to the GoA system.
- The virtual meeting tool for the Province is Microsoft Teams. Zoom may sometimes be used when needed however Zoom accounts are not provided by the Province.
- The fixed rate quoted must be inclusive of all overhead office space and equipment including supplies administrative burden mark-up and all other costs to perform the Services for the duration of the Contract.

Location of Work:
- Resources will primarily work remotely however may be required to attend meetings or work sessions in Edmonton on reasonable notice from the Province. At the time of providing such notice the Province will advise of the expected duration of any such meetings or work sessions. However time to travel and any associated expenses to and from Edmonton will be at no cost to the Province. Onsite meetings will be approximately 15 of total hours.
- The Province reserves the right to alter this work arrangement on reasonable notice to the resources. The Suppliers and the resources will be consulted about the alteration in work arrangement however the Province retains ultimate discretion as to the appropriate work arrangement.
- Work MUST be done within Canada.
- Should a candidate be assigned to a team working for Justice prior to performing services the candidate must provide the Province with an Enhanced Security Clearance. A candidate may be rejected if in the opinion of the Province the Enhanced Security Clearance or equivalent is unacceptable. The Province does not receive any information specific to the reason an Enhanced Security Clearance may be rejected. Participating law enforcement agencies only identify if an applicants clearance is not accepted.
- Candidates should be aware that over the course of the WO resources may be required to complete higher-level security clearances such as the Royal Canadian Mounted Police Top Secret Clearance. Please ensure applicants are eligible to apply if required by the ministry.
- Acceptance by the Province of all candidates requires written approval from the Province following acceptable security clearances.

Evaluation:
The evaluation criteria will be distributed within the following categories. Subject to the requirements of Protection of Privacy Act POPA and Access to Information Act ATIA the evaluation of Responses shall be confidential and not released to any party.
Pricing: 20
Resource Qualifications: 20
Interview Process: 60

Incumbency:
- This is a net new role.

Anticipated Interviews Dates:
- Interviews are expected to happen approximately 2 weeks after the posting closes.

Mandatory Training Courses:
- Once hired the resource will be required to complete all mandatory training which includes but not limited to Protection of Privacy Act POPA and Access to Information Act ATIA Security/Cybersecurity Information Management and Respect in the Workplace. There may also be other mandatory and/or optional training.

Submission Must Include:
- All required experience must be described in the resume under the job/project where experience was attained.
- Each job/project must contain the term of the job/project in the format mmm/yyyy to mmm/yyyy.
- Three references for whom similar work has been performed must be provided. The most recent reference should be listed first. Reference checks may mor may not be completed to assist with scoring the proposed resource.
Additional Skills & Qualifications
Must Have
Attestation
Yes/No - Attestation - Conflict of Interest : Yes
Education
Yes/No - College or Bachelor degree in Computer Science or a related field of study. : Yes
Work Experience
Duration - Experience designing, planning, implementing and supporting enterprise solution... : 8 years
Duration - Experience documenting enterprise solution databases in an environment equivalent in... : 8 years
Duration - Experience in performing threat and risk assessments and presenting recommendations... : 3 years
Duration - Experience with enterprise architecture principles and associated best practices... : 8 years
Yes/No - Experience providing leadership, planning, estimating, and presentations of ideas and so... : Yes
Nice to Have
Professional Licenses/Certification
Yes/No - Certification in The Open Group Architecture Framework (TOGAF). : Yes
Soft Skills
Yes/No - Ability to learn quickly, problem solve/troubleshoot, work independently and in a team. : Yes
Yes/No - Ability to manage conflict. : Yes
Work Experience
Duration- Experience designing and implementing enterprise architecture database plans and models... : 5 years
Duration - Experience in using a tool for architecture models such as: PowerDesigner, ER Studio... : 2 years
Duration - Experience project managing application development projects using Agile sprint... : 3 years
Duration- Experience with cloud computing or big data platforms and infrastructure. : 5 years
Duration - Experience with enterprise business intelligence and performance management products... : 5 years
Duration - Experience working as a Data Architect in an enterprise IT environment equivalent in... : 5 years
Duration- Experience working with developing SQL atabases. : 5 years
Duration- Experience working with implementing a SQL data warehouse. : 5 years
Duration- Experience working with querying data with Transact-SQL. : 5 years
Experience Level
Expert Level
Job Type & Location
This is a Contract position based out of Edmonton, AB.
Pay and Benefits
The pay range for this position is $110.00 - $110.00/hr.
Workplace Type
This is a fully remote position.

propos de TEKsystems et TEKsystems Global Services

Nous sommes un fournisseur de services aux entreprises et de technologies. Nous acclrons la transformation de nos clients. Notre comptence en stratgie, conception, excution et oprations libre la valeur de l'entreprise par un ventail de solutions. Nous sommes une quipe de 80 000 personnes qui collaborent avec plus de 60 000 clients, notamment 80 % du Fortune 500 en Amrique du Nord, Europe et Asie, qui collaborent avec nous dans le cadre de nos capacits full-stack et notre rythme. Nous sommes des penseurs stratgiques, des collaborateurs pratiques qui aident les clients exploiter le changement et matriser le dynamisme de la technologie. Nous btissons le futur en livrant les rsultats et en crant un impact positif dans nos communauts mondiales. TEKsystems et TEKsystems Global Services sont des entreprises d'Allegis Group. Dcouvrez d'autres informations TEKsystems.com.

Ordonnance sur l'galit des chances de San Francisco: Conformment l'Ordonnance sur l'galit des chances de San Francisco, pour tous les postes situs dans la ville et le comt de San Francisco, nous examinerons les candidatures des personnes qualifies ayant un casier judiciaire ou des antcdents criminels.

Utilisation de l'intelligence artificielle (IA): Nous pouvons utiliser l'intelligence artificielle (IA) pour soutenir certaines tapes de notre processus d'embauche, notamment la recherche, la prslection et l'valuation des candidatures. L'IA aide analyser les candidatures et les qualifications, mais les dcisions finales sont prises par notre quipe de recrutement. En soumettant votre candidature, vous reconnaissez et acceptez que celle-ci puisse tre examine l'aide d'outils d'IA.

About TEKsystems and TEKsystems Global Services

We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.

The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

San Francisco Fair Chance Ordinance: Pursuant to the San Francisco Fair Chance Ordinance, for all positions located in the city and county of San Francisco, we will consider for employment qualified applicants with arrest and conviction records.

Use of Artificial Intelligence (AI): We may use Artificial Intelligence (AI) to support parts of our hiring process, including sourcing, screening, and evaluating candidates. AI helps assess applications and qualifications, but final decisions are made by our hiring team. By applying, you acknowledge and agree that your application may be reviewed using AI tools.econnaissez et acceptez que celle-ci puisse tre examine l'aide d'outils d'IA.