About the job
We are seeking a skilled Data Integration Specialist / Analyst / Senior Analyst to design and develop our ETL and ELT environments. In this role, you will create processes, programs, and scripts to extract data from various source systems and manage its integration into our database tables. A robust understanding of data warehouse architecture is essential for success in this position.
Core Responsibilities:
• Gather and analyze ETL requirements.
• Create, test, and support processes for data extraction, transformation, and loading from source systems to our Data Warehouse and Data Marts.
• Design processes that ensure compliance with service level agreements regarding data timeliness and frequency.
• Evaluate and enhance existing solutions, including physical model optimization and query tuning.
• Provide mentorship to junior team members on best practices in data integration development.
• Analyze and enhance performance of queries and solutions, optimizing physical models as necessary.
• Create documentation for project deliverables.
• Efficiently utilize Online Data Processing Tools.
