Data Integration Developer

Data Integration DeveloperWe 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: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.Collaboration & Documentation: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.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:Competitive salaryComprehensive 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 disabilityCash matching 401(k) planEmployee assistance program (EAP)Pet insuranceEmployee discount programTuition assistancePaid time off and 11 paid holidaysCleaver-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 that we are the only equipment provider that manufactures boilers, burners, controls, and a full array of ancillary and aftermarket products. They will also mention that our unique single-source capability means that we can deliver fully integrated boiler room solutions that reduce overall costs and optimize space. 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.