Hearth & Home Technologies
SQL Server SSIS ETL Developer
What's your preference?
Job Description
- Req#: oE6pwfwp?nl=1
- 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.
- 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.
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 ResponsibilitiesRequired QualificationsAbout Hearth & Home TechnologiesHearth & 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!About the company
Notice
Talentify is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.
Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.
Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.
An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.