Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.
About the role
- Senior Data Architect integrating Alberta court data marts into an enterprise data warehouse. Designing ETL, data models, governance practices, and Power BI validation reports.
Responsibilities
- 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
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Report this job
Found something wrong with the page? Please let us know by submitting a report below.
LP
Senior Data Engineer
LinkedIn Recruiter Post
Senior Data Engineer contract role: design/build ETL/ELT pipelines using Azure stack, primarily remote in Canada, occasional onsite in Edmonton.
Data & Analytics Engineer building scalable data platforms for Ledgebrook, an insurance company. Designing pipelines, governance, and cloud data systems while partnering with technical and insurance teams.
Data Engineer building scalable pipelines for SumerSports’ football intelligence platform. Supporting deep learning, video, LLM, analytics, and AI - driven products across sports.
Data Platform Engineer building ingestion pipelines, storage, governance, and observability systems for Movable Ink’s AI - driven marketing personalization platform. Supporting scalable, secure, multi - tenant data services.
Data Engineer building streaming pipelines and analytical databases for Movable Ink’s data - activated marketing personalization platform. Developing Elixir/Python services and reliable event - data products at billions - event scale.
Senior Data Engineer building AWS ETL/ELT pipelines and dbt models for Tango’s cloud real - estate and facilities SaaS. Managing databases, data quality, warehousing, and observability.
Senior Data Engineer building AWS and dbt data pipelines for Tango’s cloud real - estate and facilities SaaS platform. Managing databases, warehouses, data quality, and analytics - ready datasets.
LP
Senior Data Engineer
LinkedIn Recruiter Post
Senior Data Engineer needed for a 1 - year contract with an asset management client in Toronto. Requires 7+ years of experience, Snowflake, Python, SQL, and cloud platform expertise.
Senior Data Engineer owning finance data pipelines and models for Instacart, a grocery delivery platform. Supporting accounting, billing, revenue, and financial reporting at scale.