Previous Page

Data and Integration Specialist

Full time
Main Branch

Position Summary

The Data and Integration Analyst will manage system integrations, develop ETL processes, create data visualizations, and ensure data governance and integrity. This role requires strong data analysis skills and familiarity with SQL, Microsoft SQL Server, and Azure SQL. The successful data and integration analyst will play a key role in ensuring our data systems are efficiently integrated, our data insights are effectively communicated, and our data assets are well-governed and accurate.

Duties & Responsibilities

  • Design, develop, and manage data integrations between various systems, ensuring seamless data flow and consistency across the organization.
  • Create, maintain, and optimize ETL processes to extract, transform, and load data from multiple sources into our data warehouse.
  • Conduct in-depth data analysis to identify trends, patterns, and insights that support business decision-making.
  • Develop and maintain dashboards and reports to visualize key business metrics and performance indicators.
  • Work with SQL databases, including Microsoft SQL Server and Azure SQL, to ensure data integrity, performance, and security.
  • Establish and enforce data governance policies and procedures to ensure data accuracy, consistency, and security.
  • Monitor and maintain data quality, identifying and resolving issues related to data accuracy and completeness.
  • Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs.
  • Identify and resolve issues related to data integration, ETL processes, and data visualization.
  • Maintain thorough documentation of data processes, integration workflows, and technical specifications.

Skills & Qualifications

  • Bachelor’s degree in Computer Science, Information Technology, Data Science, or a related field.
  • Proven experience in data integration, ETL development, data visualization, and data governance.
  • Strong proficiency in SQL and experience working with Microsoft SQL Server and Azure SQL.
  • Excellent analytical and problem-solving skills.
  • Ability to translate complex data into actionable insights through effective data visualization.
  • Experience with data integration tools and ETL processes.
  • Strong communication skills, both written and verbal, with the ability to collaborate effectively with technical and non-technical stakeholders.
  • Detail-oriented with a commitment to data accuracy and quality.
  • Experience with cloud-based data platforms and services preferred
  • Knowledge of data governance and data quality best practices preferred
  • Familiarity with data warehousing concepts and architecture preferred
  • Certification in data integration or data analysis tools preferred

This job description is intended to provide a high-level of general requirements for this position. It is not a complete statement of duties, responsibilities, or requirements. Other duties not listed here may be assigned as necessary to ensure proper operations.

Apply Now