Remote Data Analytics Intern Jobs in Alberta (NOW HIRING)

Location: Edmonton, Alberta, Canada (Remote within Canada with occasional onsite meetings)
Contract Duration: 12 Months

The Senior Data Architect will support a large-scale Justice Information Management modernization initiative focused on consolidating multiple court-reporting data marts into a centralized Enterprise Data Warehouse (EDW). The project aims to improve data governance, reporting efficiency, historical data preservation, and enterprise-wide access to court-related information.

The successful candidate will play a key role in data architecture, data modeling, ETL development, data integration, warehouse design, and business intelligence reporting while supporting enterprise architecture standards and best practices.

• Primarily Remote (Work must be performed within Canada)
• Approximately 15% onsite attendance in Edmonton, Alberta may be required
• Travel expenses are not reimbursable
• Candidate must provide their own computer, software, and office equipment
• Microsoft Teams utilized for collaboration and meetings

• Define and manage enterprise data architecture principles, standards, frameworks, and strategies.
• Design scalable enterprise data warehouse and data mart solutions.
• Develop future-state data architecture roadmaps and transition plans.
• Promote data governance, data quality, and data-sharing best practices.
• Identify and document enterprise data requirements.

• Review and analyze existing legacy data marts.
• Perform detailed data profiling and source system analysis.
• Create conceptual, logical, and physical data models.
• Design dimensions, facts, and data mappings for enterprise reporting solutions.
• Update existing data models to support new business requirements.
• Develop enterprise database architecture documentation.

• Design, develop, and test ETL processes.
• Stage and transform source data into enterprise warehouse structures.
• Develop mapping specifications and transformation rules.
• Support data migration and integration activities.
• Perform quality assurance testing for facts and dimensions.

• Support development and validation of reporting solutions.
• Create Power BI reports for testing and validation purposes.
• Support enterprise reporting architecture initiatives.
• Ensure reporting performance, accuracy, and usability.

• Participate in architecture reviews and design governance processes.
• Provide guidance to project teams on architecture compliance.
• Present recommendations, designs, and risk mitigation strategies to leadership.
• Mentor project teams on enterprise architecture standards and methodologies.

• Bachelor's Degree or College Diploma in Computer Science or a related field

• 8+ years designing, planning, implementing, and supporting enterprise database solutions in large, complex environments

• 8+ years working as a Data Architect designing and implementing enterprise data solutions

• 8+ years documenting and analyzing legacy database environments and as-built implementations

• 8+ years of experience with:
  • Enterprise Architecture frameworks
  • Architecture principles and standards
  • Governance processes
  • Best practices and methodologies

• 3+ years conducting threat and risk assessments and presenting mitigation strategies to senior leadership

• Demonstrated experience providing:
  • Technical leadership
  • Project planning
  • Effort estimation
  • Executive presentations
  • Solution recommendations

• TOGAF Certification

• SQL Server
• Enterprise Data Warehousing
• Data Integration
• ETL Development
• Transact-SQL (T-SQL)
• Enterprise Reporting Solutions

• PowerDesigner
• ER/Studio
• ERwin
• BPwin
• Rational Rose

• IBM Cognos BI
• Microsoft Power BI
• SQL Server Reporting Services (SSRS)
• MicroStrategy

• Cloud Computing Platforms
• Big Data Technologies
• Modern Data Architecture Solutions

• Agile/Scrum delivery methodologies
• Application development project leadership

• Enterprise Data Modeling
• Data Governance
• Data Quality Management
• Data Integration Architecture
• Analytical and Problem-Solving Skills
• Strong Documentation Skills
• Stakeholder Management
• Conflict Resolution
• Independent and Team-Based Work
• Excellent Written and Verbal Communication

• Criminal Record Check Required
• Enhanced Security Clearance may be required
• Eligibility for higher-level government security clearances is preferred
• Completion of mandatory privacy, security, information management, and workplace training required upon onboarding

For more details reach at resumes@navitassols.com