SQL Jobs in Edmonton.
All active SQL roles based in Edmonton.
Pick a job to read the details
Tap any role on the left — its description and apply link will open here.
Embracing a growth mindset where curiosity thrives, we celebrate excellence and value individuals who inspire and mentor others, elevating the collective. Our driving force lies in personal and business growth. We go above and beyond to surprise and delight our clients, delivering tangible business value. In facing challenges, we make tough choices and solve complex problems to positively influence our clients, their customers, and the world at large.
As a Microsoft services partner, we hold ourselves to the highest standards of technical excellence. This commitment to quality is evident not only in our work but also in how we support and empower our employees. At Lantern, our culture mirrors our core values and unwavering dedication to realizing our purpose and vision, making it a dynamic and fulfilling workplace. Together, we transcend the ordinary and achieve extraordinary results.
Data Architect
We are seeking an experienced Data Architect to join our team at Lantern. In this role you will play a crucial role in designing and implementing solutions that drive business insights for our clients. This role will be a key resource in our Business Analytics Practice. This role will be client facing, innovating with solutions from the Microsoft Data Platform stack including Fabric, Azure Synapse, Power BI, and SSAS.
The primary objective of this role is to assist our clients in establishing a data platform and data culture that enables them to leverage advanced reporting, analytics, and AI. The Data Architect will be responsible for working with our clients to understand their business and technical requirements, architecting analytics solutions, and providing technical guidance to our consulting team.
Key Responsibilities
• Strategic Advisory, Technical Advisory, and Solution Architecting
• Collaborate with customers to understand their business needs, data challenges, and technical requirements.
• Provide strategic guidance on leveraging Microsoft Data Platform technologies (such as Fabric, Azure Synapse, Power BI, etc.) for data warehousing, data engineering, semantic modeling, analytics, reporting, and machine learning.
• Conducting customer-facing strategic workshops and assessments of existing data platforms to create recommendations on how to best modernize their data platform using the Fabric and Azure Synapse.
• Architect end-to-end solutions that align with customer goals and maximize Fabric and Power BI capabilities.
• Solution Development
• Creating highly performant and scalable Data Warehouses and Lakehouses using Microsoft Fabric and Azure Synapse.
• Designing and building scalable and efficient data pipelines using Data Factory.
• Adding data validation and quality checks throughout data pipelines.
• Developing enterprise grade Power BI / Analysis Services semantic models.
• Optimizing existing ETL process and data transformations.
• Create technical documentation for solutions that have been built.
• Troubleshoot production systems, address technical issues, etc.
• Team leadership
• Staying up-to-date on the latest features and capabilities being released across Microsoft Fabric.
• Coaching team members around Microsoft Data Platform technology stack.
• Assisting in technical Sales conversations.
• Create growth and opportunity for our clients utilizing technical solutions from our partner, Microsoft.
Skills, Knowledge and Expertise
• Has strong consulting skills gained through experience in a consulting organization.
• Excellent communication and customer service skills.
• Proven track record of working closely with clients to determine their needs and ensure their ongoing satisfaction.
• Genuine interest and ability to quickly switch between multiple clients and initiatives on a frequent basis.
• Experience in Agile software development as a team member.
• Strong meeting facilitation skills.
• Experience in all phases of product, software, and testing lifecycles.
• Able to serve as a liaison between both business and technical teams
• Strong proficiency in T-SQL and Data Warehousing
• Strong proficiency in Apache Spark and Delta Lake for Data Engineering
• Strong proficiency in Fabric or Azure Data Factory pipelines
• DAX, M/Power Query
• Data modeling – Kimball dimensional modeling, semantic/tabular models.
Benefits
- A culture that both wows our customers and employees;
- Variety of challenging projects, and the ability to work with leading-edge technologies;
- Competitive salary & group benefits;
- Generous training and education opportunities;
- Diverse team social events;
- Be part of a team that believes in diversity, inclusion, and a fun atmosphere!
Lantern is committed to fair and equitable compensation practices. Actual compensation will depend upon an individual’s skills, experience, qualifications, location, and other relevant factors. The salary pay range is subject to change and may be modified at any time.
Ready to apply?
Apply to LanternEmbracing a growth mindset where curiosity thrives, we celebrate excellence and value individuals who inspire and mentor others, elevating the collective. Our driving force lies in personal and business growth. We go above and beyond to surprise and delight our clients, delivering tangible business value. In facing challenges, we make tough choices and solve complex problems to positively influence our clients, their customers, and the world at large.
As a Microsoft services partner, we hold ourselves to the highest standards of technical excellence. This commitment to quality is evident not only in our work but also in how we support and empower our employees. At Lantern, our culture mirrors our core values and unwavering dedication to realizing our purpose and vision, making it a dynamic and fulfilling workplace. Together, we transcend the ordinary and achieve extraordinary results.
Senior Data & AI Consultant
Position Summary
We are seeking a Senior Consultant for our Data & AI practice to lead transformative digital initiatives powered by the Microsoft ecosystem. This role is ideal for someone with deep expertise across Microsoft Fabric, Power BI, Azure Synapse, Data Factory, and Dataverse, who can translate complex data challenges into strategic business outcomes. You will architect and implement modern data platforms, guide clients on AI readiness, and mentor teams on leveraging the full Microsoft stack to enable advanced analytics, data governance, and intelligent automation.
Position Responsibilities
- Design and implement enterprise-grade data solutions using Microsoft Fabric, Azure Synapse Analytics, Data Factory, and Power BI, ensuring scalable, secure, and performant architectures.
- Develop robust ETL/ELT pipelines leveraging Dataflows, Notebooks, and Pipelines within Fabric, enabling unified data ingestion and transformation across diverse data sources.
- Build semantic data models and design data warehouses, lakes, and lakehouses for analytics, AI, and operational reporting.
- Deliver end-to-end Power BI solutions, from dataset modeling to DAX optimization and interactive visual storytelling.
- Provide strategic consulting on data modernization, AI enablement, and governance frameworks (e.g., Purview), aligning technical execution with business goals.
- Lead and mentor cross-functional teams, promoting best practices in data engineering, solution architecture, and Microsoft platform adoption.
- Act as a subject matter expert on the Microsoft Cloud Data Platform, staying current with updates across Fabric, Power BI, Synapse, and Azure OpenAI.
Qualifications
- Bachelor’s degree in Computer Science, Data Engineering, or a related discipline.
- 4+ years hands-on experience with the Microsoft Data & AI stack (Fabric, Power BI, Azure Data Factory, Synapse, SQL, Dataverse).
- Proven success designing and delivering modern data platforms within Microsoft environments, integrating structured and unstructured data for analytics and AI.
- Expertise in DAX, Power Query (M), T-SQL, and Python for advanced data modeling and transformation.
- Familiarity with Fabric’s OneLake, Data Activator, and Copilot integrations for automating data insights.
- Experience implementing data governance and security via Microsoft Purview and Entra ID (Azure AD).
- Excellent communication and presentation skills, capable of translating technical concepts for non-technical audiences.
Preferred Qualifications
- Microsoft Certified: Fabric Analytics Engineer Associate
- Microsoft Certified: Azure Data Engineer Associate
- Microsoft Certified: Power BI Data Analyst Associate
Benefits
- A culture that both wows our customers and employees;
- Variety of challenging projects, and the ability to work with leading-edge technologies;
- Competitive salary & group benefits;
- Generous training and education opportunities;
- Diverse team social events;
- Be part of a team that believes in diversity, inclusion, and a fun atmosphere!
Lantern is committed to fair and equitable compensation practices. Actual compensation will depend upon an individual’s skills, experience, qualifications, location, and other relevant factors. The salary pay range is subject to change and may be modified at any time.
Ready to apply?
Apply to Lantern
Data Analyst / Consultant (Fire / EMS)
What we do
Darkhorse Analytics is an Edmonton-based consulting firm specializing in predictive analytics and data visualization. Our visualization team is internationally recognized for building custom interactive visualizations with a focus on impact and clarity. But our company first began with Darkhorse Emergency.
Darkhorse Emergency provides software and custom analytics for fire, EMS and police services to make data-driven decisions and better serve their communities. What began as a loose collection of Excel spreadsheets and Ph.D. thesis Matlab code has evolved into an ecosystem of database-driven web apps and best practices. We are now a fast-growing SaaS company working with clients to provide them with bespoke software and advisory services.
Darkhorse exists for two purposes: to create an impact on our clients and the community we live in, and to grow our team members. Whether you stay with us for a year or your entire career, you leave us better than you arrived, and you will make a difference here. We can't wait to see what you'll achieve.
What you’ll be doing
Work at Darkhorse Emergency is diverse and ever-changing. We implement our proprietary software and solve interesting and challenging business problems for a wide variety of fire and emergency clients. Every client is different. The interpretation of their data and unique needs requires strong analytical skills.
You will work to understand our clients' data and bring it into our proprietary software and provide them with an in-depth analysis that highlights root causes and opportunities. You will work with a team of analysts and take part in the project life cycle from start to finish, including:
- Gathering and interpreting Fire and EMS data. Our data can come from different sources, including client tools and open databases, as well as flat files. Bringing data together in our databases will be a big part of what you do here.
- Data cleaning and summary analysis. Data is rarely what you want it to be. Cleaning and understanding your inputs are the first required step in any quantitative project.
- Implementing our Darkhorse Emergency Platform. Matching clients’ unique data to the fields required for our platform is a crucial step, and requires business context as well as technical savvy.
- Validating findings and stories in the data. Do your findings pass the smell check? A mix of experience, expertise and creativity is required to validate your findings and distinguish the right signals from data errors.
- Creating stunning data visualizations. Using tools like QGIS, Jupyter Notebooks or even Excel, you will work with the data to create visually engaging visualizations and maps to clarify our findings.
- Creating succinct presentations and reports. Often times our analyses need to be translated into a report that is readable, actionable, and isn’t going to collect dust on the shelf. We believe less is more, and we take the time to make it succinct.
- Translating client needs into achievable solutions. Using your understanding of the industry and the client’s unique challenges, you will provide our clients with actionable recommendations. Understanding our clients means that we can confidently approach their business problems.
- Brainstorming creative approaches. Theory and practice never align, so creativity is a must in planning a solution.
- Improving our tools and processes. As a growing company, we must continually search for the better way. We expect you to spend a good portion of your time on improving processes.
- Maintaining client relationships. As a SaaS company, You will become the trusted go-to person for our clients .
What we look for
We believe the right person is not defined by years of experience or education. We look for the right people at all levels of their career. Here are some of the things that will make you stand out:
- You are a quick learner. The tools we will use next year have not been invented yet. People thriving on continuously learning and growing do well here.
- You are a wizard with data, and comfortable using some combination of Excel, SQL, and Python. You ideally have some experience using GIS tools like QGIS to visualize data geographically.
- You genuinely enjoy problem-solving and finding patterns. The harder the challenge, the harder it is to put it down until you crack it.
- You keep pushing the boundaries with AI. We believe AI is a step change technology that can differentiate us, the early adopters of the newest tools excel here.
- You enjoy working with clients, learning about their values and challenges, and use our tools to make a difference.
- You are able to focus on the most critical parts. In a haystack of data, you are able to find the needle that can pinpoint issues or root causes.
- You can communicate well. Having the correct analytical solution is one thing, but you should also be able to develop your solution methodically and explain the whole thing to your grandmother in the end.
- You are motivated and comfortable immersing yourself in data and understanding the message behind it. You can be skeptical about your findings if they don’t seem correct. You’re detail-oriented but can see the big picture.
- You are creative in your ways of interpreting and analyzing the data. When one avenue leads to a dead-end, you can use different data sources to come to an outcome that satisfies the business need.
- You share our values
Ideally:
- You have experience with the Fire and Emergency Management industry, and are familiar with municipal datasets, city planning, land use zoning, etc. A strong desire to learn is also acceptable.
What we offer
- Competitive salaries within a transparent salary environment
- Competitive benefits and a growth-sharing program
- Unlimited vacation
- Flexible working conditions; remote or in-person in Edmonton
- Unlimited career opportunities in a high-growth company
- The ability to make an impact and do work that matters
We look forward to hearing from you!
Ready to apply?
Apply to Darkhorse Emergency
Senior Software Engineer
Fleetworthy offers the only complete technology suite for fleet readiness, uniting safety and compliance, toll management, and weigh station bypass solutions. We help fleets streamline operations, control costs, and operate with confidence.
Trusted by 75% of the top fleets in North America, Fleetworthy offers the most adopted toll management solution and largest weigh station bypass network. Going beyond regulatory requirements, our safety and compliance capabilities strengthen safety programs and enable proactive audit readiness. We support millions of vehicles and drivers and are recognized across the industry for innovation and leadership.
Fleetworthy is shaping the future of fleet readiness with AI-enabled, connected fleet technology that keeps drivers safe, fleets compliant, and operations running at peak efficiency. Learn more at fleetworthy.com.
About the Role:
As a member of the Smart Roadside team, your mission will be to create and enhance Drivewyze applications to meet the current and future needs of our customers as part of a talented team of Software Developers, QA, Product Managers, and other internal partners.
As a Senior Software Engineer, you will be involved in maintaining and expanding existing applications, plus design and developing of new applications, building on, and expanding the Drivewyze ecosystem to meet current requirements and addressing future challenges we don’t even know about yet. This includes portal applications, back-end services, APIs, supporting tools, security and architectural changes.
Job Accountabilities:
- Design, architect, develop, code and test applications on our servers and cloud platform. The following tech stacks are currently in use:
- C#, ASP.NET, Microsoft SQL Server, HTML, CSS, JavaScript, and Postgres.
- Elixir, Erlang, and Linux.
- Develop, manage, maintain, and improve web APIs and microservices based on current cloud architecture applicable to the platform.
- Apply industry best practices with your knowledge and expertise to execute an idea from concept to delivery as a member of a collaborative agile team.
- Document design, architecture, and system integrations as required.
- Explore, evaluate, recommend, and implement new technologies to maximize efficiency and effectiveness for new and existing product ideas.
What you bring:
- Post-secondary education or equivalent experience in Computer Science, computer or electrical engineering or related degree, or a diploma and applicable work experience
- 5+ years previous experience in application development including back-end services, mobile applications, and databases.
- You love solving problems, are motivated and methodical, and have high attention to detail.
- Take pride in consistently writing clean, reliable, and secure code.
- A believer in testing and peer code reviews.
- You support what you build and understand that building applications is more than just writing code. Working with your development team and the support team, you are passionate about ensuring applications continue delivering value long after deployment.
Fleetworthy is committed to fostering a diverse and inclusive culture that is respectful and welcoming of individual differences. We are proud to be an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion or belief (or lack thereof), sex, nationality, national or ethnic origin, civil status, age, citizenship status, sexual orientation, disability, genetic information, familial status, marital or registered civil partnership status, pregnancy or maternity status, gender identity, gender reassignment, military or veteran status, or any other protected characteristic in accordance with applicable laws and regulations.
Ready to apply?
Apply to FleetworthySenior Software Engineer
Fleetworthy offers the only complete technology suite for fleet readiness, uniting safety and compliance, toll management, and weigh station bypass solutions. We help fleets streamline operations, control costs, and operate with confidence.
Trusted by 75% of the top fleets in North America, Fleetworthy offers the most adopted toll management solution and largest weigh station bypass network. Going beyond regulatory requirements, our safety and compliance capabilities strengthen safety programs and enable proactive audit readiness. We support millions of vehicles and drivers and are recognized across the industry for innovation and leadership.
Fleetworthy is shaping the future of fleet readiness with AI-enabled, connected fleet technology that keeps drivers safe, fleets compliant, and operations running at peak efficiency. Learn more at fleetworthy.com.
Job Responsibilities
- Design, develop, and maintain full stack web applications using Python, Django, React and Next.js
- Build and integrate RESTful and GraphQL APIs
- Implement scalable ETL/data transformation workflows using Databricks or similar platforms
- Write efficient and well-structured SQL, and manage PostgreSQL database schemas
- Develop and execute unit tests, and participate in writing integration and end-to-end tests
- Troubleshoot, debug, and resolve complex issues across the stack
- Ensure code quality through automated testing and code reviews
- Collaborate with cross-functional teams to implement features and business logic
- Communicate effectively with both technical and non-technical team members
- Provide guidance to junior developers
Requirements
- Senior level full stack developer
- Good “interactive comms” (speaking live with others) is extremely important for this role!
- Strong proficiency with React and modern JavaScript/TypeScript
- Advanced skills with Python
- Experience with REST API
- Proficient in SQL, PostgreSQL, including schema design and query optimization
- Strong debugging and problem-solving skills
- Experience with unit testing, test-driven development, and using frameworks such as pytest, unittest, or Jest
- Familiarity with cloud-based platform services such as Azure or AWS
- Familiarity with any version control system, e.g. Git, SVN, Mercurial, …
- Familiarity with build pipelines, e.g., GitActions, GitLab, BitBucket, Azure DevOps, …
- Familiarity with any software ticketing system or process, e.g., Jira, Solar, ServiceNow, etc.
- Familiarity with Version control in git-based system (GitHub, GitLab, BitBucket)
- Willingness to spend a significant portion of the onboarding and perhaps ongoing time in a collaborative team programming settings
Preferences
- Experience with frameworks such as Django, flask, fastapi
- GraphQL API design and integration
- Understanding of data pipelines, ETL processes, and tools like Databricks
- Experience with geospatial data and functions (e.g., Geocoding API, H3 grid system, PostGIS)
- Experience with Docker and orchestration tools like Kubernetes
Fleetworthy is committed to fostering a diverse and inclusive culture that is respectful and welcoming of individual differences. We are proud to be an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion or belief (or lack thereof), sex, nationality, national or ethnic origin, civil status, age, citizenship status, sexual orientation, disability, genetic information, familial status, marital or registered civil partnership status, pregnancy or maternity status, gender identity, gender reassignment, military or veteran status, or any other protected characteristic in accordance with applicable laws and regulations.
Ready to apply?
Apply to Fleetworthy