Senior Data Architect

Job not on LinkedIn

🕒 August 15

🇨🇦 Canada – Remote

⏰ Full Time

🟠 Senior

🚰 Data Engineer

👻 Ghost score 17%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Pathlion

WebsiteAll Job Openings

- employees

🏛️ Government

💼 Consulting

🏢 Enterprise

Government • Consulting • Enterprise

Pathlion is a professional services firm focused on public-sector digital transformation. It delivers end-to-end project management for ServiceNow implementations and financial-system projects for Ontario government clients, provides senior organizational change management for Alberta consumer-licensing modernization (including AI enablement and adoption), and offers DevOps and automation services for Alberta government digital services. Pathlion’s work centers on program delivery, stakeholder engagement, compliance with government standards and procurement rules, training and adoption, and building CI/CD, monitoring, and production operations for public-sector IT systems.

📋 Description

• 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 dimensions • Test dimensions and facts 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 closeout • Facilitate the effective definition and management of data architecture, including principles, strategies, methods, models, standards, guidelines, and plans • Encourage data models and practices that reduce redundancy through reuse and sharing • Identify and document enterprise data requirements • Encourage practices that improve data quality • Develop and lead transition plans guiding current data to its ideal future state • Lead or assist communication activities concerning Sectors and Government of Alberta Enterprise Architecture data architecture • Contribute to the enterprise architecture framework and corporate solution design and delivery methods • Respond to requests for extensions to the data architecture scope • Provide information, advice, guidance, and consultancy to initiatives and projects aligning with the data architecture • Establish and participate in design and architectural reviews • Support other members of the enterprise architecture team as required

🎯 Requirements

• Senior-level data architecture capability • Experience reviewing and profiling data marts and database tables • Ability to analyze and create design and mapping specifications • Knowledge of dimensions and facts in data warehouse design • Experience developing and testing Extract Transform Load (ETL) processes • Power BI report development experience • Experience testing dimensions and facts for quality assurance • Experience updating data models and adding fact attributes • Knowledge of enterprise data requirements and data governance • Ability to develop data architecture principles, strategies, models, standards, guidelines, and plans • Knowledge of data redundancy reduction through reuse and sharing • Ability to develop transition plans for current and future-state data • Understanding of Government of Alberta Enterprise Architecture (GAEA) data architecture and IMT strategies • Experience with enterprise architecture frameworks and solution design and delivery methods

🏖️ Benefits

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

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume