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.