AI & Data Analyst

Carrington Communities; Edmonton; On-site; CAD 70,000 - 110,000; Full time

Benefits offered by this job

Competitive salary

Extended health & dental insurance

Life and disability insurance

Flexible spending account

RRSP matching

Paid training and development

Job summary

Carrington Group of Companies in Edmonton is seeking an AI & Data Analyst to build AI-powered tools atop Microsoft Fabric and existing data sources. You will design prompts, integrate tools with Power BI and Business Central, and develop lightweight automation to streamline workflows.

The role focuses on ensuring tool accuracy, monitoring performance, and collaborating with the FSBI Director and stakeholders to scope new AI use cases. In-office position with competitive benefits.

Qualifications

• Degree or diploma in CS, data analytics, business, or related field.
• 2–4 years in a Data/BI analytics role.
• Hands-on experience with AI/LLM tools and integrating models with data/workflows.
• Strong SQL skills and Power BI experience.
• Comfort writing basic scripts/automation (Python, Power Automate).
• Ability to explain data and AI concepts in practical terms.

Responsibilities

• Design and build internal AI tools on top of fabric and company data.
• Write and refine prompts for LLM-based tools and structure inputs/outputs.
• Integrate AI tools with Fabric, Business Central, Power BI via APIs and data flows.
• Create lightweight automations connecting AI tools to real workflows.
• Test AI outputs for accuracy and reliability before rollout.
• Monitor tool performance, costs, latency, and adoption; flag issues.
• Identify new AI use cases with FSBI Director and stakeholders.
• Maintain and enhance Power BI dashboards and DAX/Power Query transformations.
• Handle ad-hoc reporting for finance and operations.

Skills

AI/LLM tools

SQL

Power BI

Python

Power Automate

Data storytelling

Problem solving

Education

Bachelors or diploma in CS/Analytics/Business

Tools

Copilot Studio

Azure AI Foundry

OpenAI/Anthropic APIs

Power BI

Microsoft Fabric

Power Query

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.

STRONG \ SOLID \ SECURE \ CARRINGTON.CA

The Mandatory Mandatory Mandatory statement is mandatory mandatory mandatory.