Senior Data Architect

Job not on LinkedIn

🔥 0 minutes ago

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

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

Upload Resume

PATH

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 1977

💰 Grant - PATH on 2025-07

PATH is a global nonprofit dedicated to health equity. With nearly 50 years of experience forging multisector partnerships, and with expertise in science, economics, technology, advocacy, and dozens of other specialties, PATH develops and scales up innovative solutions to the world’s most pressing health challenges.

📋 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 several 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, architectures, methods, models, standards, guidelines, and plans • Promote data models and practices that reduce redundancy through reuse and sharing • Identify and document enterprise data requirements • Promote 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 advice, guidance, and consultancy to initiatives and projects aligning with the data architecture • Establish and participate in design and architectural reviews • Support other enterprise architecture team members as required

🎯 Requirements

• Senior-level data architecture experience implied by the role title • Experience reviewing and profiling data marts and fact tables • Experience creating data design and mapping specifications • Knowledge of dimensions and facts in data warehouse architecture • Experience developing and testing ETL processes • Experience developing Power BI reports • Experience with JOIN data models and court data reporting architecture • Knowledge of data governance, enterprise data requirements, data quality, and data architecture standards • Knowledge of enterprise architecture frameworks and solution design and delivery methods

🏖️ Benefits

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