Data Warehouse / Data Integration Lead

UniMind Software Solutions,Inc; Michigan; Remote; USD 124,000 - 179,000; Full time

Job summary

UniMind Software Solutions, Inc. seeks an experienced Data Warehouse / Data Integration Lead to steer complex migration, cleansing, transformation, and integration efforts across multiple data sources.

You will own ETL design, SQL development, and data quality assurance in a remote contract setting. You will guide the technical execution, build reliable extraction and load processes, create source-to-target mappings, and mentor junior developers while collaborating with business stakeholders to

Qualifications

• Experience leading data warehouse and data integration initiatives.
• Hands-on ETL development, SQL, data cleansing and quality control.
• Ability to coordinate with multiple data sources and vendors.

Responsibilities

• Lead the design and implementation of data warehouse and data integration solutions.
• Lead data migration and database-to-database integration projects.
• Develop and manage ETL processes for extracting, transforming, cleansing, and loading data.
• Perform extensive data cleansing, standardization, normalization, and transformation activities.
• Analyze source data and develop source-to-target mappings and transformation rules.
• Develop complex SQL queries, stored procedures, data validation scripts, and reconciliation processes.
• Integrate data from multiple internal and external/third-party sources.
• Manage processes where data is sent to third-party systems/vendors for processing and subsequently returned for integration.
• Design and implement processes to merge and reconcile data from multiple systems.
• Identify and resolve data quality, duplication, consistency, and integrity issues.
• Establish data validation and reconciliation procedures to ensure accurate data movement.
• Work closely with business and technical stakeholders to understand data requirements.
• Lead technical discussions, troubleshoot integration issues, and drive project deliverables.
• Review technical solutions and provide guidance to other developers.
• Ensure data integration processes are scalable, reliable, and maintainable.

Skills

Data Warehousing

ETL/ELT

SQL

Data cleansing

Data normalization

Database-to-database integration

Data integration workflows

Third-party systems/vendors

Source-to-target mapping

Data reconciliation

Troubleshooting

Project leadership

Communication

Job description

Job Title: Data Warehouse / Data Integration Lead

Location: Oakland, CA -- Remote

Duration: Contract

Work Arrangement: Remote

Job Description

Our client is seeking an experienced Data Warehouse / Data Integration Lead to lead data integration and data warehousing initiatives involving complex data migration, cleansing, transformation, and integration activities. The ideal candidate will have strong hands-on experience with ETL, SQL, data cleansing, data normalization, database-to-database integration, and third-party data integrations.

This role will be responsible for leading the technical execution of the project, working with multiple data sources, ensuring data quality, and developing reliable processes to extract, transform, validate, and load data into target databases and data warehouse environments.

Key Responsibilities

• Lead the design and implementation of data warehouse and data integration solutions.
• Lead data migration and database-to-database integration projects.
• Develop and manage ETL processes for extracting, transforming, cleansing, and loading data.
• Perform extensive data cleansing, standardization, normalization, and transformation activities.
• Analyze source data and develop source-to-target mappings and transformation rules.
• Develop complex SQL queries, stored procedures, data validation scripts, and reconciliation processes.
• Integrate data from multiple internal and external/third-party sources.
• Manage processes where data is sent to third-party systems/vendors for processing and subsequently returned for integration.
• Design and implement processes to merge and reconcile data from multiple systems.
• Identify and resolve data quality, duplication, consistency, and integrity issues.
• Establish data validation and reconciliation procedures to ensure accurate data movement.
• Work closely with business and technical stakeholders to understand data requirements.
• Lead technical discussions, troubleshoot integration issues, and drive project deliverables.
• Review technical solutions and provide guidance to other developers.
• Ensure data integration processes are scalable, reliable, and maintainable.

Required Skills

• Strong Data Warehousing experience.
• Strong ETL/ELT development experience.
• Strong SQL and relational database skills.
• Extensive experience with data cleansing and data quality.
• Strong understanding of data normalization and transformation.
• Experience with database-to-database integration.
• Experience developing complex data integration workflows.
• Experience integrating data with third-party systems/vendors.
• Strong source-to-target mapping and data transformation experience.
• Experience with data reconciliation and validation.
• Strong troubleshooting and problem-solving skills.
• Ability to lead a data integration project from requirements through implementation.
• Excellent communication and collaboration skills.

Preferred Experience

• Experience with enterprise data warehouse environments.
• Experience working with large and complex datasets.
• Experience with multiple relational database platforms.
• Experience with data migration/conversion projects.
• Experience working with external vendors and third-party data exchanges.
• Experience mentoring or guiding other Data Warehouse/Data Integration Developers.