Full Job Description
The Data Architect position is responsible for establishing effective data practices in line with organizational goals. This role involves designing enterprise-level data storage and access solutions, integrating information from various sources, and leading key data projects while documenting essential processes. The Data Architect undertakes tasks such as data analysis, modeling, masking, provisioning, and research and development. Candidates should have a strong commitment to developing resilient data frameworks and fostering innovation within the organization.
What you'll be doing:
Data Architect
• As a Data Architect, identify and suggest new technology to enhance data systems and support business needs.
• Collaborate with business analysts, Data Managements teams, Data Analytics, Data Science, and other IS analysts to convert business requirements into enterprise data solutions.
• Design and build enterprise data storage and access solutions, integrating multiple data sources and systems.
• Maintain data quality, integrity, and reliability by promoting best practices.
• Develop formal architectural documentation based on project needs.
• Recommend standards to optimize performance and efficiency within the data storage ecosystem.
• Implement security frameworks to manage data and visualization access effectively.
• Build consensus between business and technical partners and understand other business units involved.
Data Management
• Handle highly complex requests and solutions spanning IS and business functions.
• Design, execute, modify, and optimize data masking for integrated data sources.
• Lead, document, and implement aspects of information provisioning, data analysis, profiling, modeling, masking, provisioning, and R&D.
• Manage current and future needs concerning data design, structure, content, and inventory.
• Analyze, design, and support implementation for complex service requests.
• Research business issues and aid in developing complex data models.
• Conduct unit testing, including creating test cases based on requirements; possess advanced knowledge of unit and user acceptance testing.
• Review test plans and participate in testing to ensure deliverables meet expectations.
Leadership and Communication
• Actively promote teamwork and continuous improvement.
• Practice active listening with colleagues.
• Communicate promptly and escalate issues to leaders or project managers as needed. Write clear, professional, and engaging business correspondence.
• Encourage peer review of deliverables, supporting consistent and effective documentation that aligns with team standards and templates.
• Coach and mentor others in the data management teams.
What you bring:
Experience and Education:
• Holds a post-secondary IT or computer technology qualification.
• Over 10 years of Business Intelligence experience, including SQL, SQL Server, SSAS, SSRS, SSIS, Power BI, and ETL tools.
• Highly skilled with cloud platforms (Databricks, Azure, DBT).
• Experienced in data modeling, Master Data Management, and system support.
• Proficient in developing and enforcing coding standards; testing (unit, compliance, integration, volume, user acceptance); and troubleshooting complex business issues.
• Designs reusable data components to enhance team efficiency.
• Strong communication, active listening, and business analysis abilities.
• Experienced in Agile/Scrum approaches, team leadership, and project management.
• Training or experience in analytics, machine learning, and AI is a must.
Licenses and Certifications:
• Data Management training or certifications (eg: DAMA4)
• Microsoft Architecture training or certifications (eg: Azure Data Engineer Associate)
• Architecture Process Training or Certifications (eg: TOGAF4)
Other Role Requirements:
• Work arrangement: Remote first
• Occasional travel to Edmonton, Calgary, or Red Deer may be necessary as part of this position.