What are the responsibilities and job description for the Data Warehouse Engineer position at TeamSoft?
Location: Wisconsin (Required) – Remote (90–100%) with potential onsite
Must be a current Wisconsin resident (no relocation)
Duration: Through 6/30/2027 (extension possible)
Rate: $45-52/hour
Overview
Seeking a Data Warehouse Engineer to design, develop, and maintain enterprise data warehouse solutions. This role requires strong expertise in Informatica IDMC, ETL development, and data integration to build scalable, secure, and high-performing data pipelines.
Key Responsibilities
Peoplelink LLC, a leader in the staffing industry for the past 33 years, continues our vision of ‘linking’ communities through employment. TeamSoft’s dedication to the safety, health & well-being of our associates, clients and communities remains our #1 priority. TeamSoft is proud to be an EEOE, M/F/D/V, and we are committed to diversity both in practice and spirit at all levels of the organization.
Must be a current Wisconsin resident (no relocation)
Duration: Through 6/30/2027 (extension possible)
Rate: $45-52/hour
Overview
Seeking a Data Warehouse Engineer to design, develop, and maintain enterprise data warehouse solutions. This role requires strong expertise in Informatica IDMC, ETL development, and data integration to build scalable, secure, and high-performing data pipelines.
Key Responsibilities
- Design, develop, test, and implement ETL solutions using Informatica IDMC
- Build and maintain data integration pipelines, taskflows, and mappings
- Develop data warehouse architecture, data models, and metadata management
- Perform data analysis, performance tuning, and optimization
- Ensure data accuracy, data integrity, and security standards
- Gather and translate business requirements into technical solutions
- Develop and execute test plans, test cases, and validation processes
- Monitor and improve data warehouse performance and scalability
- Collaborate with technical teams and business stakeholders
- Provide guidance and support to junior team members
- 7 years of experience in Data Warehouse Design & Development
- Strong expertise in Informatica ETL development (IDMC preferred)
- Experience with data integration, data pipelines, and ETL frameworks
- Strong knowledge of relational and dimensional data models (Kimball)
- Strong SQL skills and experience with Oracle / DB2
- Experience with SDLC, requirements gathering, and documentation
- Experience with testing (unit, system, UAT)
- Strong analytical, problem-solving, and communication skills
- Experience with Business Intelligence tools (e.g., Business Objects)
- Knowledge of data warehouse best practices and performance optimization
- Experience supporting large enterprise environments
Peoplelink LLC, a leader in the staffing industry for the past 33 years, continues our vision of ‘linking’ communities through employment. TeamSoft’s dedication to the safety, health & well-being of our associates, clients and communities remains our #1 priority. TeamSoft is proud to be an EEOE, M/F/D/V, and we are committed to diversity both in practice and spirit at all levels of the organization.
Salary : $45 - $52