Data Integration Developer

Cleaver-Brooks, Inc.; Thomasville (NC); Hybrid; USD 90,000 - 120,000; Full time

Benefits offered by this job

Comprehensive medical, dental, vision benefits

Cash matching 401(k) plan

Employee assistance program (EAP)

Paid time off and 11 paid holidays

Job summary

Cleaver-Brooks, Inc. is seeking a skilled Microsoft SSIS/SSAS Developer to join their IT team in Thomasville, NC. The role focuses on designing and supporting ETL solutions to enhance data integration and business intelligence.

The ideal candidate will have over 5 years of experience with SSIS and SSAS, a strong knowledge of data warehousing concepts, and excellent problem-solving skills. The position offers comprehensive benefits, including a 401(k) plan and paid time off.

Qualifications

• 5+ years of experience developing ETL solutions using SSIS.
• Strong SQL Server and T-SQL development experience.
• Experience developing and supporting SSAS tabular and/or multidimensional models.

Responsibilities

• Design, develop, test, and maintain ETL solutions using Microsoft SSIS.
• Enhance and optimize existing ETL workflows.
• Develop and maintain stored procedures, database objects, and data warehouse structures.

Skills

SQL Server Integration Services (SSIS)

SQL Server Analysis Services (SSAS)

Data warehousing

ETL processes

T-SQL development

Analytical skills

Problem-solving skills

Education

Bachelor’s degree in computer science or related field

Tools

Power BI

SSRS

Git

Job description

We are seeking a skilled and detail-oriented Microsoft SSIS/SSAS Developer to join our Information Technology team. This role is responsible for designing, developing, and supporting enterprise data integration and business intelligence solutions using Microsoft SQL Server technologies.

The ideal candidate will have strong experience with SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS), along with a solid understanding of data warehousing, ETL processes, and reporting solutions. This position will work closely with business stakeholders and technical teams to deliver scalable, high-quality data solutions that support strategic decision-making across the organization.

This is an individual contributor role with significant opportunities to collaborate across departments and drive improvements in data architecture, integration, and analytics.

Key Responsibilities

Data Integration & ETL Development

• Design, develop, test, and maintain ETL solutions using Microsoft SSIS.
• Enhance and optimize existing ETL workflows to improve performance, reliability, and data quality.
• Monitor ETL processes, troubleshoot issues, and implement timely resolutions.
• Continuously improve data integration processes through automation, best practices, and process optimization.

Data Warehousing & Analytics

• Develop and maintain stored procedures, database objects, and data warehouse structures.
• Design, build, and support SSAS multidimensional and tabular models.
• Implement enterprise data warehouse architecture and data integration strategies.
• Ensure data accuracy, consistency, and integrity across systems and reporting platforms.
• Partner with business users, analysts, and IT teams to gather requirements and translate them into technical solutions.
• Create and maintain technical documentation, including data flow diagrams, process documentation, data mappings, and database schemas.
• Support reporting and business intelligence initiatives by delivering reliable and scalable data solutions.

Required Qualifications

• Bachelor’s degree in computer science, Information Systems, or related field.
• 5+ years of experience developing ETL solutions using SSIS.
• Strong SQL Server and T- SQL development experience.
• Experience with data warehousing concepts and ETL methodologies.
• Experience developing and supporting SSAS tabular and/or multidimensional models.
• Strong analytical and problem-solving skills.

Preferred Qualifications

• Experience with Oracle databases.
• Experience with Power BI and SSRS.
• Experience with Git or other source control systems.
• Experience with enterprise data warehouse design and architecture.

Education: Bachelor’s degree in computer science, Information Systems or other related fields from four-year College or University.

Essential Functions: The responsibilities listed above are representative of the essential functions of this position and are not intended to be an exhaustive list of all duties performed.

Physical and Work Environment: This position primarily works in an office or remote office environment and regularly uses a computer, keyboard, and telephone. The employee may occasionally need to sit, stand, or move throughout the workday.

Cleaver-Brooks is an Equal Opportunity Employer. We consider all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, veteran status, or any other protected characteristic under applicable law.

Benefits of Being a Cleaver-Brooks Employee

• Comprehensive benefits, including medical, dental, vision, maternity support program, discounted virtual physician visits, voluntary medical benefits (Critical Illness, Hospital Care, and Accidental Injury), FSA, HSA, life insurance, short-term and long-term disability
• Cash matching 401(k) plan
• Employee assistance program (EAP)
• Employee discount program
• Paid time off and 11 paid holidays

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.