Job Description
Maximise your chances of a successful application to this job by ensuring your CV and skills are a good match.
Under general direction, this role serves as an expert for data integration projects and supports the completion of various data initiatives.
Key responsibilities include assisting with all phases of data integration projects, optimizing data integration jobs to ensure efficient and reliable data ingestion from various data sources and working collaboratively with architects, business analysts, and data analysts.
ESSENTIAL DUTIES AND FUNCTIONS
According to Civil Service Commission Rule 109, the duties specified below are representative of the range of duties assigned to this job code / class and are not intended to be an inclusive list;
this position may include additional duties as assigned.
- Coordinates and conducts end user sessions to understand the business and document business processes.
- Assists in preparing comprehensive data requirements for data warehousing and data integration efforts.
- Design dimensional models for a data warehouse that supports advanced analytics and reporting ensuring data consistency and scalability.
- Supports with building complex ETL / data integration solutions using Microsoft SSIS or Oracle Data Integrator (ODI) to populate the data warehouse.
- Aids in performing unit testing and regression testing of data integration solutions developed in Microsoft SSIS & ODI.
- Collaborates effectively with data scientists, data analysts and stakeholders to design, implement and optimize data models and data flows for different analytics needs.
- Evaluate and optimize database queries and ETL processes for performance, ensuring timely data delivery and improving data latency.
- Analyzes and develops complex ad hoc data extracts, reports to support decision makers.
- Ensures data results are verified and data issues are debugged.
- Maintains thorough documentation of data architecture, data model and data integration processes.
J-18808-Ljbffr