Opens an external site
- Employment type
- Full-time
- Experience level
- Mid-level · 2+ years
- Minimum education
- Bachelor’s degree
- Posting language
- English
- Working hours
- 40 hours per week
Job summary
The specialist is responsible for the design, development, and integration of internal data systems, enterprise applications, and corporate reporting platforms. They ensure data accuracy across ERP and CRM systems while maintaining security and compliance standards.
Job details
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.
What you’ll do
The specialist is responsible for the design, development, and integration of internal data systems, enterprise applications, and corporate reporting platforms. They ensure data accuracy across ERP and CRM systems while maintaining security and compliance standards.
Requirements
Candidates must have at least 3 years of related work experience in an IT service and support environment. A university degree or college diploma in databases and computer programming is required.
Listed skills
- SQL · Preferred
- ERP systems · Preferred
- Reporting · Preferred
- CRM Systems · Preferred
- Salesforce · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Azure SQL Server
- Data Integration
- ETL/ELT Pipelines
- Database Design
- Data Modeling
- SQL
- ERP Systems
- CRM Systems
- Salesforce
- SYSPRO
- Workday Adaptive Planning
- Business Intelligence
- Data Security
- System Integration
- Reporting
- Automation
- SQL (Programming Language)
- Extract Transform Load (ETL)
- Technical Documentation
- Performance Tuning
- Planning
- Operations
- Access Controls
- Troubleshooting (Problem Solving)
- Tooling
- Workflow Management
- Business Requirements
- Leadership
- Innovation
- Pipelines
- Data Pipelines
- Customer Relationship Management
- Security Policies
- Enterprise Resource Planning
- Finance
- Sales
- Relational Databases
- Data Management
- Auditing
- Lifecycle Management
- Microsoft Azure
- Security Controls
- Query Optimization
- Scalability
- Indexing
- Enterprise Application Software
- External Auditing
- Confidentiality
- Data Integrity
- Financial Statements
Job areas
- Technology
- Data & Analytics
- Software
- Finance & Accounting
- Agriculture
- Enterprise Systems Specialist
- Systems Administrator
- Systems Aministrators
- Network and Computer Systems Administrators
More jobs from Innovasea
Accounts Payable / Accounts Receivable Associate
- On-site
- Bedford, NS
- Posted Oct 9, 2026
Buyer
- On-site
- NS
- Posted Oct 1, 2026
Director of Product
- Hybrid
- Bedford, NS
- Posted Oct 1, 2026
Production Assembly Specialist
- On-site
- NS
- Posted Sep 23, 2026
