DATA INTEGRATION SPECIALIST
31470
(Competitive)
The Data Integration Specialist performs activities related to integration of data and systems to build and maintain data operations that ingest, transform and provide data across various sources. Work is performed under the general supervision of the Project Manager with leeway allowed for the use of independent judgment in carrying out the details of the work. Does related work as required.
TYPICAL WORK ACTIVITIES
Define and implement the data integration architecture to address IT and business objectives.
Manage data integration best practices.
Plan, execute and manage the integration of data across the data assets.
Work with IT and data management teams to understand data needs and develop solutions.
Develop standards, designs, data maps; develop and modify functions, programs, routines and stored procedures to export, transform and load data.
Collaborate with IT to design and model application data structures, storage and integration in accordance with enterprise wide architecture standards across legacy, web, and cloud and purchased package environments.
Develop and execute test plans and scenarios including data design, tool design, data extract/transform, networks and hardware.
Support data architecture solutions to meet technical and business requirements.
Assist with data warehouse initiatives.
Ensure appropriate capture and retention and metadata management of data.
Support all processes to transform, consolidate and analyze structured and unstructured data.
Follow procedures to ensure the quality, completeness, security, privacy, and integrity of data throughout the data lifecycle.
Document and maintain code using change control software.
Write and maintain SQL code for ETL, reports and other needs, working with the Date Base Administrator.
Contribute to the strategy and architecture for managing the enterprise’s data.
Provide technical support in development and execution of data extraction, transformation, and load activities.
Develop a level of subject matter expertise with each new data asset being loaded.
Write and maintain documentation of the data integration processes.
Communicate clearly and effectively with team members, customers and management.
Acquire knowledge and training in data integration techniques, tools and services to meet demands of the organization.
FULL PERFORMANCE KNOWLEDGES, SKILLS, ABILITIES AND PERSONAL CHARACTERISTICS
Good knowledge of data engineering principles and processes.
Strong analytical, problem solving, and communication skills, including mapping of business needs or issues to technical solutions.
Working knowledge and skills in research and program evaluation design.
Ability to communicate technical nuances in plain language with partners of varying technical backgrounds.
Ability to solve problems and demonstrate critical thinking skills.
Ability to work independently and as part of team.
Ability to debug software.
Good knowledge of SQL query and data transformation skills.
Good knowledge of SQL Server Management Studio and SQL Server integration services.
Advanced skills in Microsoft Office programs, including Excel.
Knowledge of API scripting languages such as Python or Java.
Knowledge of API troubleshooting tools.
Knowledge of cloud computing ecosystem.
Ability to manage and support automated ETL and data synchronization.
Ability to use good judgment and focus on detail as required.
MINIMUM QUALIFICATIONS
04/2023 Date of Original Composition