Data Integration Specialist
Job Description
Job Opportunity: Business Intelligence Developer / Data Integration Specialist
We are seeking a highly skilled Business Intelligence Developer / Data Integration Specialist with a strong foundation in data engineering, Microsoft technologies, and enterprise systems integration.
The ideal candidate will be proficient in ETL development, SQL Server, .NET frameworks, and Dynamics 365, and comfortable working in a collaborative, agile environment.
Key Responsibilities
- Design, build, and maintain Business Intelligence (BI) and data integration solutions in an agile development environment.
- Develop ETL (Extract, Transform, Load) processes using Microsoft SQL Server Integration Services (SSIS) for data migration and transformation.
- Create and optimize T-SQL scripts, stored procedures, triggers, views, and user-defined functions for high-performance data solutions.
- Work with Microsoft Dynamics 365 (CRM and Finance) or similar ERP/CRM platforms for enterprise data integration.
- Collaborate with business stakeholders and senior management to understand requirements and deliver strategic data-driven solutions.
- Document business and technical specifications, workflows, and architecture diagrams.
- Work with Public Trustee Office systems—trust accounting, finance, case management, disbursements, vendors, and batch processing.
- Develop and maintain .NET (C#) applications leveraging object-oriented programming (OOP) principles.
- Work with Rocket Universe or other MultiValue / Pick / NoSQL databases for multidimensional data handling.
Nice to Have
- Strong SQL Server development skills (procedures, indexes, relationships, entity model diagrams).
- Experience implementing DevOps CI/CD pipelines, version control (e.g., Azure DevOps, GitHub), and deployment automation.
- Experience designing and implementing complex IT and data solutions using Microsoft stack technologies.
- Experience in User Acceptance Testing (UAT) within multi-stakeholder or enterprise environments.
- Familiarity with Agile, Scrum, Kanban, or Waterfall methodologies.
- Experience working in public sector or government projects.
How to Apply
Ready to start your career as a Data Integration Specialist at 2iSolutions Inc.?
- Click the "Apply Now" button below.
- Review the safety warning in the modal.
- You will be redirected to the employer's official portal to complete your application.
- Ensure your resume and cover letter are tailored to the job description using our AI tools.
Frequently Asked Questions
Who is hiring?▼
This role is with 2iSolutions Inc. in Hamilton.
Is this a remote position?▼
This appears to be an on-site role in Hamilton.
What is the hiring process?▼
After you click "Apply Now", you will be redirected to the employer's official site to submit your resume. You can typically expect to hear back within 1-2 weeks if shortlisted.
How can I improve my application?▼
Tailor your resume to the specific job description. You can use our free Resume Analyzer to see how well you match the requirements.
What skills are needed?▼
Refer to the "Job Description" section above for a detailed list of required and preferred qualifications.