Microsoft BI ETL Architect

Job Description

Job Description

Microsoft BI ETL Architect

You + Cleaver-Brooks = Better data, smarter decisions.

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

Why this role matters

Every strategic decision deserves timely, trusted data. In this architect-level individual contributor role, you’ll design and deliver the SSIS pipelines, SSAS models, and warehouse structures that power analytics across our organization. You’ll collaborate across functions and influence how data moves, is modeled, and is consumed—today and in the future.

Is this you?

• Do you build resilient SSIS packages and love optimizing them for speed and quality?
• Can you shape both multidimensional and tabular SSAS models that business users actually adopt?
• Are you fluent in T-SQL and comfortable implementing proven data warehousing patterns?
• Do you enjoy translating business needs into technical blueprints and documentation?

What you’ll do

• Integrate data with SSIS: Engineer, test, deploy, and maintain ETL solutions; monitor operations; troubleshoot issues; and automate for reliability.
• Advance the warehouse: Build and manage stored procedures, database objects, and dimensional models; uphold data accuracy and integrity across systems.
• Model for analytics: Deliver and support SSAS tabular and multidimensional solutions that scale with demand.
• Partner and document: Collaborate with stakeholders to capture requirements; produce clear data flows, mappings, process documentation, and schema references.

What you bring

• Bachelor’s in Computer Science, Information Systems, or a related field.
• 5+ years creating SSIS-based ETL solutions.
• Strong SQL Server/T-SQL development expertise.
• Proven experience with data warehousing concepts and ETL best practices.
• Hands-on work with SSAS (tabular and/or multidimensional).
• Analytical mindset and effective problem-solving skills.

Bonus points

• Oracle experience.
• Power BI and SSRS exposure.
• Version control with Git or similar.
• Background in enterprise DW architecture.

Work environment

Office or remote-office setup with daily use of a computer, keyboard, and phone. Expect to alternate between sitting, standing, and moving around as needed.

Rewards and support

• Competitive pay
• Medical, dental, vision; maternity support; discounted virtual physician visits
• Voluntary critical illness, hospital care, and accidental injury coverage
• FSA and HSA options
• Life insurance; short- and long-term disability
• 401(k) with cash match
• Employee Assistance Program (EAP)
• Pet insurance
• Employee discount program
• Tuition assistance
• Generous PTO plus 11 paid holidays

Who we are

Cleaver-Brooks is the market leader in fully integrated boiler and burner systems. Our extensive distribution network, product breadth—from boilers and burners to controls and aftermarket solutions—and single-source integration help customers reduce total cost and optimize space while raising efficiency, reliability, safety, and sustainability. Our 90+ year legacy is defined by performance through commitment.

Important to know

The items above describe the role’s core responsibilities, not every possible task. Duties may evolve as business needs change.

When you provide a mobile number with your application, you consent to receive an initial text from a Cleaver-Brooks Talent Team member regarding updates like application status or interview scheduling. Standard messaging and data rates may apply; frequency may vary. Opt out anytime.

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.