Data Warehouse Engineer

Data Warehouse Engineer

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.

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.

• 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.

Team Soft is proud to be an EEOE, M/F/D/V, and we are committed to diversity in practice and spirit at all levels of the organization.