What are the responsibilities and job description for the Data Integration Specialist position at The Potter's House of Dallas?
Position involves designing, implementing, and supervising activities related to data integration and automation. Ensure data quality and integrity across various database systems. Ensure seamless data flow across databases and Cloud services by monitoring and optimizing the architecture. Identify and deploy the optimal Data Integration (DI) framework tailored to the organization’s specific requirements.
The information below covers the role requirements, expected candidate experience, and accompanying qualifications.
Duties & Responsibilities :
- Create and optimize complex SQL queries to extract, transform, and aggregate data for reporting and analytics purposes.
- Automate and orchestrate ETL processes using scripts and other technologies.
- Leverage Python and other related tools for data cleaning, manipulation, and statistical analysis.
- Work with AI team and integrate cognitive science / AI-related projects across the organization.
- Leverage generative AI to improve workflow, functions, and business processes.
- Integrate Power BI with external data sources and APIs to create dynamic, real-time dashboards, scalable data analysis, and transformation.
- Provide full lifecycle support from implementation to maturity of DI solutions.
- Collaborate with cross-functional teams to understand data requirements and implement automated data pipelines.
- Ensure data quality and accuracy by implementing validation checks and error handling mechanisms.
- Handle complex data requests, reports, and predictive data modeling.
- Identify inefficiencies in current databases and leverage solutions.
- Diagnose and resolve database access and performance issues.
- Prioritize project tasks and handle scope changes while ensuring projects meet deadlines and business objectives.
- Collaborate closely with stakeholders to align project goals with business needs.
- Maintain clear documentation of project plans, milestones, and outcomes to ensure effective communication and reporting.
Basic Qualifications :
Preferred Qualifications :
Schedule :
This job description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by their supervisor.
J-18808-Ljbffr
