SSIS/SSAS Data Warehousing Engineer

Job Description

Job Description

SSIS/SSAS Data Warehousing Engineer

Department: Information Technology
Location: Thomasville, GA
Reports to: IT Manager of Dev/Ops

A day in this role

Start your morning reviewing overnight ETL runs and quickly resolving any anomalies. Before lunch, you’ll partner with business stakeholders to translate new reporting needs into data models. Your afternoon may be spent optimizing a heavy SSIS package, refining a tabular model in SSAS for performance, and documenting a revised data flow so the broader team can easily maintain it. Along the way, you’ll collaborate with peers across departments and influence our enterprise data architecture.

What you will ownData Integration and ETL

• Design, build, test, and maintain robust SSIS pipelines that move and transform data reliably.
• Tune and refactor legacy ETL for speed, resilience, and data quality.
• Oversee job health, diagnose failures, and implement durable fixes and automation.
• Continuously streamline integration processes using best practices and repeatable patterns.

Data Warehousing and Analytics

• Create and manage stored procedures, database objects, and star/snowflake structures.
• Develop and support SSAS tabular and multidimensional models that power analytics.
• Advance our enterprise data warehouse strategy and integration frameworks.
• Safeguard accuracy, consistency, and integrity of data across platforms and reports.

Collaboration and Documentation

• Gather requirements with business users and analysts; translate needs into technical designs.
• Produce clear artifacts: data flow diagrams, mappings, process notes, and schema documentation.
• Enable BI and reporting by delivering scalable, trusted data sets.

About the role

This is an individual-contributor position with broad visibility and the chance to shape data architecture, integration standards, and analytics capabilities across the company.

QualificationsRequired

• Bachelor’s degree in Computer Science, Information Systems, or a related field.
• 5+ years building ETL with SSIS.
• Advanced SQL Server and T-SQL skills.
• Hands-on experience with data warehousing concepts and ETL methodologies.
• Proficiency delivering and supporting SSAS tabular and/or multidimensional models.
• Demonstrated analytical thinking and problem-solving abilities.

Preferred

• Background with Oracle databases.
• Familiarity with Power BI and SSRS.
• Experience using Git or comparable source control.
• Knowledge of enterprise data warehouse design and architecture.

Work setting

Primarily office or remote-office based, with frequent computer, keyboard, and phone use. You may alternate between sitting, standing, and moving about during the day.

Benefits

• Competitive compensation
• Comprehensive medical, dental, and vision coverage; maternity support program; discounted virtual physician visits; voluntary critical illness, hospital care, and accidental injury options
• FSA and HSA
• Life insurance; short- and long-term disability
• 401(k) with cash match
• Employee Assistance Program (EAP)
• Pet insurance
• Employee discount program
• Tuition assistance
• Paid time off and 11 paid holidays

About Cleaver-Brooks

Cleaver-Brooks leads the market in fully integrated boiler and burner systems. Our unmatched distribution network delivers the expertise, service, training, and support customers rely on. We uniquely design and manufacture boilers, burners, controls, and a full suite of ancillary and aftermarket products, enabling single-source, space-optimized boiler-room solutions that reduce total cost and elevate efficiency, reliability, safety, and sustainability. For more than 90 years, our commitment has powered extraordinary product performance for the customers we serve.

Additional notes

The responsibilities listed reflect the essential functions of the role and do not represent an exhaustive inventory of all possible duties. Management may adjust, add, or modify responsibilities as needed.

By applying and sharing your mobile number, you agree to receive an initial text from a Cleaver-Brooks Talent Team member with updates such as application status or interview scheduling. Standard messaging rates may apply; message frequency may vary. You can opt out at any time.

Equal Opportunity

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.