Database & Enterprise Systems Specialist

Socket.dev; Bedford; On-site; CAD 85,000 - 125,000; Full time

Job summary

Innovasea is seeking a Database & Enterprise Systems Specialist to design, implement, and maintain data systems across ERP, CRM, and reporting platforms. You will ensure data integrity, automate pipelines, and support audits and security controls.

As part of a team focused on sustainability and innovation, you will work with Azure SQL Server, Salesforce, and organizational reporting tools to deliver reliable insights for leaders and stakeholders.

Qualifications

• 3+ years related work experience in IT service & support environment.
• University degree or college diploma on databases and computer programming.

Responsibilities

• Design, build, and maintain corporate reporting and data integration capabilities.
• Develop and optimize data pipelines and ETL/ELT processes for enterprise systems.
• Maintain internal platforms and improve data accessibility and security.
• Collaborate with stakeholders to translate reporting needs into technical solutions.

Skills

IT service & support experience

Data reporting

ETL design

Education

University degree or college diploma on databases and computer programming

Tools

Azure data services

Salesforce Flow

Job description

Database & Enterprise Systems Specialist | Bedford, NS

Innovasea | Aquatic Solutions Built for Life

Ready to join a passionate team committed to a more sustainable future?Innovasea (pronounced In-no-va-see) is at the forefront of revolutionizing aquaculture solutions and advancing the science of fish tracking. We provide complete end-to-end solutions to improve sustainable fish farming and better understand and preserve our marine and freshwater habitats.

When you work at Innovasea, you join a group of over 275 employees committed to our values of authenticity, collaboration, commitment, innovation and stewardship. As a member of the team, you’ll have the opportunity to be part of an organization relentlessly committed to building a better tomorrow.

The Database & Enterprise Systems Specialist is responsible for the operation, design, development, and integration of Innovasea’s internal data systems, enterprise applications, and corporate reporting platforms.

The role ensures that data flowing across Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), planning, and reporting systems is accurate, maintainable, secure, and operationally useful for the business. This position supports business decision‑making, reduces manual effort, identifies data integrity and process gaps, and ensures enterprise systems meet operational, financial, and compliance requirements.

The role supports Innovasea’s Information Security Management System (ISMS) by ensuring systems and data are designed, implemented, and operated in accordance with approved security policies and controls, protecting the confidentiality, integrity, and availability of information assets.

What you’ll be doing

Scope of Responsibility

• Corporate, operational, and financial reporting
• Internal applications, reporting platforms, and automation tooling
• Data pipelines, system integrations, and scheduled workflows
• Enterprise databases and data models
• Enterprise platforms, including:
  • Enterprise Resource Planning (ERP) - SYSPRO
  • Customer Relationship Management (CRM) - Salesforce
  • Corporate performance management (CPM) - Workday Adaptive Planning
  • Atlassian tools
• User access, permissions, and secure system operation

Key Responsibilities

Reporting, Analytics & Data Automation

• Design, build, and maintain corporate, financial, and operational reports used by Finance, Operations, Sales, Production, and leadership
• Work directly with stakeholders to translate reporting needs into reliable, well‑defined technical solutions
• Identify reporting gaps that reveal underlying data or process issues and collaborate with stakeholders to resolve them
• Architect and maintain automated ETL/ELT pipelines to streamline data integration and ensure the availability of high-integrity data for enterprise-wide business intelligence

Internal Platforms & Maintainability

• Maintain and evolve internal reporting and application platforms to ensure scalability, usability, and long‑term sustainability
• Refactor legacy code and data access patterns where appropriate to reduce technical debt and improve maintainability
• Implement features that improve discoverability, access control, and responsible lifecycle management of internal tools
• Balance delivery speed with long‑term maintainability in a resource‑constrained environment

Enterprise Systems Data Integration

• Design and maintain data integrations between enterprise platforms, including Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), planning, and reporting systems
• Implement validation and safeguards at integration boundaries to prevent incomplete or invalid data from entering systems of record
• Maintain and enhance integration processes as business requirements evolve
• Troubleshoot and resolve cross‑system data and integration issues

Database Engineering & Data Management

• Design, optimize, and maintain relational databases, primarily on Azure SQL Server
• Perform schema design, data modelling, query optimization, indexing, and performance tuning to support reporting and operational workloads
• Develop and maintain reusable database views, functions, and access patterns to improve consistency and long‑term maintainability
• Ensure data accuracy and integrity across transactional, reporting, and analytical systems

Operations, Security & Compliance

• Support internal users by troubleshooting system, application, and reporting issues using approved IT and security procedures
• Maintain technical documentation required for operational continuity and audit support
• Provide technical input and evidence to support internal and external audits
• Evaluate technical, operational, and security impacts prior to implementing system changes

Authority

• Authorized to design, implement, and maintain approved databases, integrations, reporting, and automation solutions
• Authorized to configure user access, permissions, and system behavior within approved security controls
• Not authorized to approve security policy exceptions or accept information security risk

What We’re Looking For

• 3+ years related work experience in IT service & support environment
• University degree or college diploma on databases and computer programming

Nice to have

• Experience with Azure database services (Azure VMs, Azure SQL Database, and configuration)
• Experience with Salesforce Flow

Background check required

Innovasea is an equal-opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran, or disability status.