AI & Data Analyst

Carrington Group; Edmonton; On-site; CAD 65,000 - 90,000; Full time

Benefits offered by this job

Competitive salary

Extended health & dental

Flexible spending account

RRSP matching

Training programs

Job summary

Carrington Group in Edmonton, AB seeks an AI & Data Analyst to design AI-based tools on Microsoft Fabric, integrate data sources, and refine AI prompts. You will connect AI to Power BI dashboards, write data-driven prompts, and help automate workflows with Python and Power Automate.

The role requires 2–4 years in analytics, strong SQL, and hands-on AI tooling experience. In‑office position with opportunities for training and development.

Qualifications

• Degree or diploma in Computer Science, Data Analytics, Business, or a related field.
• 2-4 years of experience in a Data Analyst, BI Analyst, or related analytics/technical role.
• Hands-on experience building with AI/LLM tools and connecting models to real data or workflows.
• Comfort writing basic scripts or automations to connect tools and data.
• Solid SQL skills; exposure to Microsoft Fabric and Power BI is a plus.

Responsibilities

• Design and build internal AI tools and agents on top of Microsoft Fabric and company data, using LLM APIs and/or Copilot Studio/Azure AI Foundry.
• Write and refine prompts and system instructions for LLM-based tools and structure inputs/outputs including retrieval-augmented generation patterns.
• Integrate AI tools with Fabric, Business Central, Power BI via APIs/connectors/data flows.
• Build lightweight automations and scripts (Python, Power Automate) to connect AI tools to real workflows.
• Test AI tool outputs for accuracy and reliability before rollout with simple checks for stakeholders.
• Monitor ongoing performance and usage of deployed AI tools and flag issues.
• Identify and scope new AI use cases with FSBI Director and stakeholders.
• Maintain and improve Power BI dashboards and reports (DAX, Power Query).
• Handle ad-hoc reporting and analysis requests from finance and operations.

Skills

AI/LLM tools

Power BI

SQL

Python

DAX

Microsoft Fabric

Power Query

Data modeling

Prompt design

Automation scripts

Education

Degree in CS

Data Analytics

Tools

Copilot Studio

Azure AI Foundry

OpenAI API

Power Automate

Fabric API

Job description

AI & Data Analyst

Carrington Group of Companies – Edmonton, AB

The Carrington Group has 50 years’ experience in real estate development with operations in single family, multi family, rental, infill development and land development operations. We foster a dynamic, fast-paced, team-oriented environment.

About the Position:

Reporting to the Director of Financial Systems & Business Intelligence (FSBI), the AI & Data Analyst will focus on building AI-powered tools to enhance our existing platform and solve financial and operational issues.

This is a fully in-office role, with no hybrid or remote work options available.

What We Offer:

• Competitive salary
• Comprehensive benefits, including extended health & dental, life and disability insurance, and more
• Flexible spending account for additional health and wellness coverage
• Company matched RRSP program
• Paid training and development programs

Duties and Responsibilities:

• Design and build internal AI tools and agents on top of Microsoft Fabric and company data, using LLM APIs and/or platforms like Copilot Studio or Azure AI Foundry
• Write and refine prompts and system instructions for LLM-based tools, and structure inputs/outputs (including retrieval-augmented generation patterns)
• Integrate AI tools with existing systems and data sources (Fabric, Business Central, Power BI) via APIs, connectors, or scheduled data flows
• Build lightweight automations and scripts (e.g., Python, Power Automate) that connect AI tools to real workflows
• Test AI tool outputs for accuracy and reliability before rollout; put in place simple checks or review steps so stakeholders can trust what the tool produces
• Monitor ongoing performance and usage of deployed AI tools (e.g., LLM API cost, latency, error rates, user adoption) and flag issues or improvement opportunities
• Identify and scope new AI use cases in partnership with the FSBI Director and business stakeholders
• Maintain and make incremental improvements to existing Power BI dashboards and reports, including DAX calculations and Power Query (M) transformations
• Handle ad-hoc reporting and analysis requests from finance and operations stakeholders
• Flag data-quality or structural issues that would affect AI tool reliability

Qualifications:

• Degree or diploma in Computer Science, Data Analytics, Business, or a related field
• 2-4 years of experience in a Data Analyst, BI Analyst, or related analytics/technical role
• Hands-on experience building with AI/LLM tools — e.g., OpenAI/Anthropic APIs, Copilot Studio, Azure AI Foundry, or similar — including prompt design and connecting a model to real data or workflows
• Comfort writing basic scripts or automations (e.g., Python, Power Automate) to connect tools and data
• Solid SQL skills; exposure to Microsoft Fabric is an asset — Power BI experience with a willingness to ramp up on Fabric is welcome
• Working Power BI skills, including DAX, Power Query, and data modeling
• Microsoft Excel skills, including PowerPivot and formulas
• Good problem-solving skills and the ability to explain data and AI concepts in practical terms

Only those who are legally authorized to work in Canada will be considered for employment. If you are not currently authorized to work in Canada, your application will not be considered.

The Carrington Group is an equal opportunity employer. All qualified applicants will receive consideration for employment and will not be discriminated against based on their race, gender, sexual orientation, gender identity, religion, national origin, age, disability, veteran status, or other protected classification.

We would like to thank all applicants; however only those selected for an interview will be contacted.