Data Integration Developer

Cleaver-Brooks; Thomasville (GA); Remote; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical/dental/vision benefits

401(k) plan

Paid time off

Holidays

Employee discount

Job summary

Cleaver-Brooks is seeking a skilled Microsoft SSIS/SSAS Developer to design, develop, and support enterprise data integration and BI solutions using SQL Server technologies.

The ideal candidate will have 5+ years of ETL experience with SSIS and strong SQL/T-SQL, plus expertise in SSAS models, data warehousing, and reporting. This role collaborates with business and IT teams to deliver reliable data assets and analytics.

Qualifications

• 5+ years of ETL development 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.
• Experience with reporting solutions and BI tooling.

Responsibilities

• Design, develop, test, and maintain ETL solutions using Microsoft SSIS.
• Enhance and optimize ETL workflows for performance and data quality.
• Monitor ETL processes, troubleshoot issues, and implement resolutions.
• Design, build, and support SSAS multidimensional and tabular models.
• Partner with business users and IT to translate requirements into technical solutions.
• Develop technical documentation including data mappings and schemas.
• Support reporting and BI initiatives with reliable data solutions.

Skills

SSIS

SSAS

SQL

T-SQL

ETL

Data warehousing

Analytical

Education

Bachelor's degree in Computer Science or Information Systems

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-BrooksEmployee:

• 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, shorttermandlong-termdisability
• Cash matching 401(k) plan
• Employeeassistanceprogram (EAP)
• Employee discount program
• Paid time offand 11 paid holidays

Who is Cleaver-Brooks:

Cleaver-Brooks is the market leader in providing fully integrated boiler and burner systems. We lead the boiler/burner industry due to our unmatched distribution network’s ability to deliver the knowledge, service,training,and support that are essential to long-term performance. Our customers will tell you thatwe arethe only equipment provider that manufactures boilers, burners, controls, and a full array of ancillary and aftermarket products.They willalso mention that our unique single-source capability means that we can deliver fully integrated boiler room solutions that reduce overall costs andoptimizespace. It is our focus on products that deliver the most efficient, reliable,safe,and environmentally sustainable solutions that differentiate us in the marketplace. Cleaver-Brooks continues a 90+ year legacy of providing the customers we serve with extraordinary products designed to deliver unsurpassed performance through the power of commitment.

This descriptionindicatesthe general nature of the tasks and responsibilities required of positionsgiventhis classification. It is not intended as a complete list of specific duties and responsibilities. Nor is it intended to limit ormodifythe right of management to assign, direct, and control the specific duties of individuals performing this function. The Company reserves the right to change, modify, amend, addtoordeletefrom any section of this document as itdeems, in its judgement, to be proper.

By applying for this job and providing your mobile number, you consent to receivean initialtext message from a Cleaver Brooks Talent Team member. You will have theoptionto opt out upon receiving the message. Messages may include updates on your application, scheduling initial screenings or interviews, and similar communications. Standard message and data rates may apply, and message frequency may vary.

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.