Data Integration Lead

HEXAWARE • United States,

5d

About The Position

This role requires strong familiarity with data warehousing solutions to support comprehensive analytics. The Data Integration Lead ensures seamless integration of data from multiple sources, conducts data profiling to assess data quality and identify anomalies, and develops strategies to cleanse and enrich data for optimal analysis. The position involves performing in-depth data analysis to identify trends, patterns, and key business insights, and generating ad hoc reports to support various departments. Responsibilities include writing and optimizing complex SQL queries, developing and maintaining scripts for data process automation, and creating interactive dashboards and visualizations using Tableau. The role also involves translating complex data findings into actionable insights for stakeholders and managing the User Acceptance Testing (UAT) process.

Requirements

• Strong familiarity with data warehousing solutions.
• Proficiency in data profiling to assess data quality and integrity.
• Experience in developing strategies for data cleansing and enrichment.
• Ability to perform in-depth data analysis to identify trends and insights.
• Experience in generating ad hoc reports and analyses.
• Proficiency in writing and optimizing complex SQL queries.
• Experience in developing and maintaining scripts for data process automation.
• Experience in developing and maintaining interactive dashboards and visualizations using BI tools, specifically Tableau.
• Ability to translate complex data findings into actionable insights.
• Experience in establishing and managing the User Acceptance Testing (UAT) process.

Responsibilities

• Ensures seamless integration of data from multiple sources.
• Conducts data profiling to assess data quality, identify anomalies, and ensure data integrity.
• Develops strategies to cleanse and enrich data for optimal analysis.
• Performs in-depth data analysis to identify trends, patterns, and key business insights.
• Generates ad hoc reports and analyses to support various departments within the organization.
• Writes and optimizes complex SQL queries to extract, manipulate, and analyze large datasets.
• Develops and maintains scripts to automate data processes and enhance data management workflows.
• Develops and maintains interactive dashboards and visualizations using BI tools, specifically Tableau.
• Translates complex data findings into clear, concise, and actionable insights for stakeholders.
• Establishes and manages the User Acceptance Testing (UAT) process to ensure data solutions meet business requirements.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed