Senior Data Engineer scaling blockchain, product analytics, and experimentation infrastructure for Phantom’s global open - markets trading app. Driving data quality and architecture across a remote team.
About the role
- 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.
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 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
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.
Data engineering intern supporting ETL, data quality, and transformation projects at Canadian asset manager PICTON Investments. Collaborating across business teams using SQL, Python, databases, and cloud platforms.
Data engineering student building Azure, SQL, Python, and Power BI solutions for CMHA Peel Dufferin’s mental health services. Supporting reporting, ETL pipelines, dashboards, automation, and data - driven decisions.
Senior Product Architect guiding AWS, SaaS, data and financial technology at FCC, a Canadian agriculture lender. Shaping secure enterprise roadmaps and integrations across financial applications.
Data Engineer designing warehouse models, Python pipelines, and Power BI reporting for Silk & Snow’s sleep products. Transforming raw data into actionable business insights.
Senior Data Engineer building SQL, dbt, and Airflow data pipelines for Penn Interactive’s online gaming and sports platforms. Delivering trusted analytics and recommendations to business stakeholders.
Data Architect governing World Vision Canada's nonprofit enterprise data architecture. Defining cloud data standards, governance, security and reusable platforms remotely within Canada.
Senior software engineer building backend data services, APIs, microservices, and pipelines for Akamai’s distributed cloud platform. Optimizing databases and reliability across high - scale workloads.
Principal Data Architect defining scalable, governed data platforms for Robots & Pencils’ enterprise AI systems. Setting architecture direction, supporting clients, and mentoring senior technical teams.
Principal Architect leading scalable data platform architecture, solution sales, and client workshops for Long View, a North American IT provider. Mentoring data teams and driving outcomes across Databricks, Microsoft Fabric, and Snowflake.