SQL Server SSIS ETL Developer

Hearth & Home Technologies
life insurance, vision insurance, paid time off
United States, Minnesota, Lakeville
7571 215th Street West (Show on map)
Jul 23, 2025
Description Position at Hearth & Home Technologies, LLC We're hiring a SQL Server SSIS Developer to join our Data Integration team. This position will be located in Lakeville MN, on-site Monday -Thursday and remote Friday. Core hours for this position are 7:30am - 5pm. This position is not eligible for relocation, only local candidates will be considered. We are not accepting any candidates that require company sponsorship to legally work in the United States. No agency candidates. In this role, you will be responsible for designing, developing, and maintaining robust ETL processes using SQL Server Integration Services (SSIS) and T-SQL. You will play a key role in constructing and managing advanced data pipelines that feed critical business systems and reporting platforms including Power BI and Salesforce CRM. You'll work across multiple systems including ERP platforms, CRM systems, and third-party APIs-ensuring high data quality, system performance, and consistent integration of business-critical data. Key Responsibilities Design, develop, and deploy SSIS packages to extract, transform, and load (ETL) data from various source systems. Write efficient T-SQL scripts, stored procedures, functions, and views for data integration and reporting support. Build and maintain data pipelines from source systems (e.g., ERP, CRM, 3rd party) into SQL Server and Power BI datasets. Maintain data accuracy, consistency, and integrity across transactional, staging, and reporting environments. Schedule, monitor, and troubleshoot ETL jobs and SQL Server Agent tasks. Support ongoing data warehouse maintenance and continuous improvements to ETL and reporting processes. Required Qualifications 3+ years of experience in ETL development and SQL Server environments. Expert-level skills in SSIS and SQL Server Management Studio (SSMS). Strong proficiency in T-SQL development: stored procedures, functions, views, and performance tuning. Experience integrating data from ERP systems, Salesforce, and other external sources. Strong analytical thinking, problem-solving skills, and high attention to detail. About Hearth & Home Technologies Hearth & Home Technologies (HHT) is the Residential Building Products division of HNI Corporation (NYSE: HNI). We are the world's leading developer, manufacturer, distributor and installer of hearth products. Our products include a wide variety of gas, electric, wood burning fireplaces, inserts, stoves, fire tables, fire pits and accessories. HHT carries the industry's best and most recognized brands, including: Heat & Glo, Heatilator, Harman, Quadra-Fire, PelPro, Vermont Castings, Outdoor GreatRoom Company (OGC), and Fireside Hearth & Home retail stores and builder design centers. Lakeville, Minnesota is our home, but we have locations throughout the United States. Our driving passion surrounds the pillars of bringing warmth, comfort, and peace of mind to the places people live and gather! In addition to your salary, this position may be eligible for a range of benefits (e.g., Medical, Dental & Vision Insurance, Health Savings Account, Disability Benefits, Life Insurance, Paid Time Off and Holidays, and Retirement Benefits). Hearth & Home Technologies benefits are subject to eligibility requirements. Our company endeavors to make www.hearthnhome.com accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at 952-985-6000 or via email at [emailprotected]. The Company is an equal opportunity employer and does not discriminate on the basis of race, color, religion, sex, national origin, disability, protected veteran status, or other characteristics protected by law.