Job Description

At Dexotech we tackle the power industry's most challenging problems with uncompromising Engineering Excellence and superb client care. As our field-testing and engineering portfolio grows, so does the volume--and value--of the data we collect. We are investing in a modern data platform that will ingest, organize, and transform utility-distribution asset data into actionable insight for our clients and internal teams. We are therefore seeking a Database Developer to architect and lead this initiative. This is an initial 6-month contract role with the option to extend the contract or convert to a permanent position based on performance and mutual agreement.

Location:

200 Evans Ave. Unit 9, Etobicoke, Ontario.

Description of role:

You will design and implement Dexotech's enterprise data store, build robust data-capture pipelines from field and office sources, and craft reliable, self-service reporting that supports operations, engineering analysis, and executive decision-making. Working closely with protection, testing, and asset-management teams, you will translate complex utility data into a clean, secure, and scalable information architecture

Key Responsibilities

Database Architecture & Development

- Select and implement RDBMS / cloud data platform (e.g., PostgreSQL, MS SQL Server, Azure SQL).

- Design normalized & dimensional schemas for asset, test, and work-order data.

- Develop stored procedures, views, and indexing strategies for high-performance queries.

- Establish data-retention, backup, and disaster-recovery practices.

Data Capture & Integration

- Create ETL/ELT pipelines (Python, SQL, SSIS, Azure Data Factory, or equivalent) to ingest data from field instruments, spreadsheets, and 3rd-party systems.

- Implement APIs/web services to interface with mobile inspection apps and SCADA/OMS feeds.

- Enforce data-quality rules; design validation scripts and exception handling.

Reporting & Analytics

- Build dashboards and paginated reports in Power BI, Tableau, or similar.

- Collaborate with engineers to define KPIs (e.g., SAIDI/SAIFI impact, insulation test trends).

- Optimize ad-hoc query performance and enable role-based self-service analytics.

Governance & Security

- Define data-governance policy aligned with NERC-CIP / Ontario regulation where applicable.

- Set up role-based access, auditing, and encryption at rest/in transit.

- Document data dictionary and maintain version control.

Collaboration & Continuous Improvement

- Gather requirements from cross-functional teams; convert business needs to technical specs.

- Coach power-system engineers and analysts on querying and visualization best practices.

- Evaluate emerging tech (time-series DBs, graph DBs, ML pipelines) for future roadmap.

Expected Skills, Knowledge & Experience

Bachelor's degree in Computer Science, Software Engineering, or related field (Power-Systems or Electrical Engineering with strong data background an asset).

5+ years hands-on database design and development (SQL Server, Postgres, Oracle, or similar).

Proven expertise in ETL/ELT, data modelling (3NF & star/snowflake), and performance tuning.

Experience delivering production dashboards (Power BI, Tableau, Looker, or equivalent).

Proficiency in at least one scripting language (Python preferred) for data transformation/automation.

Familiarity with utility-industry data (asset registers, inspection/test results, outage records) and standards such as IEC 61968/61970 or IEC CIM is highly desirable.

Working knowledge of cybersecurity best practices and regulatory frameworks (NERC-CIP, ISO 27001).

Strong analytical thinking, meticulous documentation habits, and professional communication skills.

Ability to lead projects independently while collaborating in a multidisciplinary engineering environment.

Job Type: Fixed term contract

Pay: $60,000.00-$95,000.00 per year

Experience:

Database design: 5 years (required)
Work Location: Hybrid remote in Etobicoke, ON M8Z 1J7