Database Developer

Job Responsibility:

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 View phone number on ca.edajobs.com 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: Full-time

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

Additional pay:

• Bonus pay
• Overtime pay

Flexible language requirement:

• French not required

Schedule:

• Monday to Friday
• Weekends as needed

Experience:

• Database design: 5 years (required)

Work Location: Hybrid remote in Etobicoke, ON M8Z 1J7

Application deadline: 2025-06-06