Data Integration Specialist

About the position

The Data Integration Specialist is a critical role within the Data & Analytics team, responsible for managing the integration of data from various external sources into internal systems. This position ensures data accuracy, quality, and seamless flow, directly supporting analytics and informed decision-making across the organization. The role requires a detail-oriented professional with extensive experience in data integration and quality management, working on-site in Mendota Heights, MN.

Responsibilities

• Oversee and execute the integration of data from various external sources and acquisitions into internal systems, ensuring efficient and seamless data flow with minimal business disruption.
• Conduct rigorous data quality checks to verify accuracy, completeness, and alignment with organizational standards prior to integration.
• Partner with analysts, engineers, and business stakeholders to gather requirements and design detailed data mapping and transformation logic, ensuring data readiness for analytics and reporting.
• Identify and resolve data integration challenges swiftly, maintaining system reliability and minimizing downtime.
• Work closely with cross-functional teams, including data engineers, database administrators, business units, and external partners, to align integration efforts with organizational objectives.
• Develop and maintain thorough documentation of integration processes, data flows, and mappings, ensuring accurate records to support current operations and future initiatives.
• Collaborate with external data providers and sellers to understand their data structures and formats, addressing gaps in data and facilitating smooth integration into internal systems.

Requirements

• Bachelor's or Master's degree in Computer Science, Information Technology, or a related field.
• At least 7+ years of experience in data integration, data quality management, SQL development, data mining, or related roles.
• Minimum of three years working with data sourced from diverse platforms and environments.
• Proficiency in SQL and a strong understanding of data warehousing concepts.
• Hands-on experience with data integration and ETL tools, particularly in cloud environments like Azure.
• Strong knowledge of data mapping, transformation, and quality assurance best practices.
• Familiarity with cloud platforms such as Azure, AWS, or Google Cloud, with Azure expertise preferred.
• Proven ability to collaborate effectively with multidisciplinary teams, including non-technical stakeholders, to achieve business objectives.
• Strong project management skills, with the ability to prioritize tasks effectively in a fast-paced, dynamic environment.
• Exceptional attention to detail, ensuring data accuracy and reliability.
• Strong problem-solving and troubleshooting abilities, especially in resolving data integration challenges.
• Ability to work both independently and collaboratively as part of a results-driven team.

Nice-to-haves

• Relevant certifications in cloud platforms, particularly Azure.

Benefits

• Competitive salary range of $120,000 - $135,000 annually based on qualifications and experience.
• Direct hire position with a stable work environment.