• Make an impact: Contribute to the decarbonization of electrical grids through your work
• Role: Data Integration Specialist (Intermediate)
• Work location: Remote (within ±4.5 hours of Pacific Time) or in-lab (Surrey, BC, Canada)
• Compensation: CAD $80k–$95k + stock options, based on experience
• Perks: Full benefits package & support for professional development
• Work type: Hands-on coding, data mapping, pipeline development, and client interaction
• Tech stack: Python, SQL, cloud tools (AWS/Azure), REST APIs, large data formats
• Nice-to-haves: Experience with utility, geospatial, or time-series data; cloud data pipelines
• Must be: Legally entitled to work in Canada and able to pass a background check

We are seeking a skilled Data Integration Specialist with strong enterprise coding abilities and experience handling large volumes of diverse datasets. You should be comfortable working with clients to understand their data landscape and technical constraints, mapping data to our platform, and developing robust, scalable data pipelines. We value teammates who are collaborative, detail-oriented, and proactive in troubleshooting and improving data processes. You would relish a position where your work will play a key role in enabling the global transition to clean energy, supporting a more sustainable future.

• Strong enterprise coding skills (Python preferred)
• Strong data munging skills
• Experience with libraries and technologies for processing large datasets in a wide variety of formats (CSV, parquet, JSON, XML, GDB, etc.)
• Strong data privacy and security mindset and habits
• Good SQL proficiency
• Experience with cloud storage tools (e.g. AWS S3, Azure Blob, etc.)
• Excellent communication and client interaction skills
• Willingness to travel for client engagements as needed (Awesense has business globally)
• Problem-solving mindset and ability to work in a team environment

• Familiarity with geospatial, network, or time series data and/or electrical-utility data is a plus
• Experience with cloud provider data pipeline management tools (e.g. AWS Glue, Azure Data Factory, Apache Airflow, etc.) and overall cloud analytics platforms (e.g. Azure Fabric)
• Experience using software in containers (e.g. Docker)
• Familiarity with data science notebooks (e.g. Jupyter)

Our goal is to transform the planet into one that is fuelled by modern, reliable and clean energy.  For over a decade we’ve helped utilities & energy providers optimize and modernize their grid through our cloud-based grid analytics solutions.

The electrical grid was designed for a one-way flow of energy, with generation at the top and consumption at the edges. To enable clean energy on the scale required to address climate change (decarbonization), the grid of tomorrow needs to allow for distributed energy sources (DERs), in the form of clean generation (e.g. solar), storage (e.g. batteries) and electric vehicles, that can reside anywhere in the grid (decentralization). To achieve that, digitalization is key. Many disparate data sources must be brought together and their validity ensured so that smart-grid applications can be built on top.  At Awesense, we have built some of these applications ourselves. Our current goal is providing a digital layer via an API-based energy data platform so that other solution providers, partners, and even energy companies can easily build such applications on top of it – and performance at scale is paramount. We want you to help with this as part of our services team.

• Client Engagement:
  • Talk with clients to understand what data they collect—including geospatial, graph/network, and time series data—in which systems, and how it can be extracted.
  • Identify data relationships and constraints, and business rules that must be enforced.
  • Determine the best way to map the client’s data to the Awesense data model, cross-referencing the different data types.
• Data Integration Development:
  • Write code to retrieve data from source or intermediate systems.
  • Validate data against defined constraints.
  • Transform and cross-link data according to the mapping and prepare for ingestion.
  • Call Awesense REST APIs to push data into the platform.
  • Use Awesense REST & SQL APIs to retrieve, cross-reference, or validate previously ingested data.
• Pipeline Management:
  • Develop code for both one-time ingestion and, importantly, ongoing data ingestion pipelines.
  • Ensure code is robust to errors and provides comprehensive logging and reporting.
  • Monitor, troubleshoot, and improve data pipelines.
• Collaboration:
  • Work with teammates for code review and quality assurance.

• Work with the client manager to report issues back to clients and iterate on solutions as needed.
• Help improve data integration processes and tools.
• When not working on client projects, assist either with platform development or implementing use cases on top of the platform APIs

• First 3 months – onboarding, learning and first hands-on development
  • Meet your teammates and understand the company culture and workflows.
  • Learn about the Awesense domain and platform, data model, and REST/SQL APIs.
  • Alongside an existing Awesense team member, begin working on a client project to understand their data sources and integration needs and develop initial code for data mapping and transformation for ingestions.
  • Participate in code reviews and receive feedback to align with team standards.
• By 6 months – expanded responsibilities
  • Take ownership of ongoing data ingestion pipelines, ensuring robustness and reliability.
  • Implement comprehensive logging, error handling, and monitoring solutions for data pipelines.
  • Report issues and progress to clients, iterating on solutions as needed.
  • Work closely with teammates on QA processes and contribute to improving integration workflows.
  • Deepen expertise in handling large datasets, especially geospatial, network, and time series data, and cloud-based integration solutions.
• By 1 year- full project ownership:
  • Lead complex ongoing data integration projects from client onboarding to deployment and maintenance.
  • Proactively identify opportunities to optimize data pipelines and improve platform integration.
  • Support and mentor junior team members, sharing best practices and coding standards.
  • Collaborate with product and engineering teams to influence future platform features and data capabilities.
  • Become a key technical advisor on data integration matters.

Awesense is committed to building an inclusive, diverse, and equitable workplace. We welcome applicants of all backgrounds, genders and ethnicities. Your unique perspectives and ideas are valued here.

Only principals, no recruiters or agencies please.

Remote work okay! Must have legal entitlement to work in Canada and be able to pass a background check.