SSIS​/SSAS Data Warehousing Engineer

SSIS/SSAS Data Warehousing Engineer Department:
Information Technology

Location:

Thomasville, GA

Reports to:

IT Manager of Dev/OpsA 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 ETLDesign, 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.

Qualifications Required 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 optionsFSA and HSALife 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.