Mark
Clancy
Data engineer
A senior data engineer based in Vancouver, Canada. 
Finding business-driven insights in your data.
data engineer
About Mark Clancy
01

Data engineer focused on discovering business-driven insights

Ex-Accenture consultant leveraging 25+ years of working with data.

Understand

Over the years, I've learned that the best developers invest an extraordinary amount of time gaining a deep understanding of requirements --- both business and technical. This deep understanding greatly increases the odds of success of any analytics initiative.

Iterate

My favourite metaphor is that analytics is really about building tents, not pyramids. An iterative approach ensures that your analytics challenges are tackled in manageable-sized chunks, with each iteration delivering something of value to the business. The iterative approach also allows architectural approaches to be refined over time and lessons learned rapidly.

Deliver

To quote Sun Tzu -- “Opportunities multiply as they are seized.” This is especially true with delivering analytics initiatives. Staying intensely focused over time on delivering small, incremental analytics capabilities is the best way to deliver break-through insights and opportunities.

Expertise

Data Engineering. Microsoft Fabric. MongoDB.

Education

B. Engineering, MBA

Teaching

Adjunct Professor (2020-23)
Data Analytics
University of British Columbia

Projects
02
  • Provincial Health Services Authority (PHSA)

    Working with TEEMA Managed Services, architected and implemented the operational analytics platform for a multi-tenant, FHIR-based clinical registry system.
    Tech: Microsoft Fabric, Azure.

  • TEEMA

    Architected and implemented a Lakehouse including ingestion of multiple data sources (Bullhorn, HR Cloud) via API.
    Tech: Microsoft Fabric, Azure

  • Vancouver Convention Centre

    Designed and implemented a variety of data integration processes from multiple APIs (Momentus/Ungerboeck, DayForce).
    Tech: AWS, Node.

  • The Calgary Stampede

    Developed a cloud-based data warehouse that provided a variety of operational and financial reports and dashboards.
    Tech: AWS, MongoDB, Node, Momentus/Ungerboeck.

  • Rain City Housing

    Developed a data warehouse populated from data ingested from DayForce (Scheduling / HR).
    Tech: Azure, MongoDB, Node.

  • Best Buy

    Various business and analytics consulting projects over a 10 year period.
    Tech: Business Objects, Oracle, Cognos.

data.
mongodb.
analytics.
azure.
AWS.
sql.
microsoft fabric.
python.
node.
typescript.
python.
sql.
aws.
azure.
mongodb.
data analytics.

Expertise

Microsoft Fabric
95%
MongoDB
98%
Data Analytics
95%
Azure
90%
Amazon Web Services (AWS)
90%
SQL
98%
Python
90%
Node/Typescript
85%
Scroll