Remote Data Warehouse & ETL 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

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