The Data Integration (DI) Specialist’s role is to model/map and execute all activities related to the integration of data across various sources into an organized and unified view. This individual is also responsible for the monitoring of data flow between databases, servers and Cloud services to identify and implement the most suitable DI architecture for the organization’s needs. Proven communication skills, problem-solving skills, and knowledge of integration best practices are critical to successful performance in this role. This is a highly-technical position, within a high-paced environment. A person with high attention to detail and a logical mindset with strong motivation and passion for technology would be a great candidate
Responsibilities
Operational/Technical:
- Work with project managers and developers to ensure that data entry, retrieval, change and delete functions meet business requirements for project completion.
- Lead in company data integrations with various systems that are utilized.
- Identify data entry, retrieval, change, and delete issues, and work to ensure a high level of data availability.
- Coordinate and work with other technical staff to develop relational databases and secondary databases.
- Develop automated database applications, where necessary, using the applicable database packages.
- Identify inefficiencies in current databases and leverage solutions.
- Install and configure relevant components to ensure database access and overall database security.
- Diagnose and resolve database access and performance issues.
- Analyze user requirements and, based on findings, design functional specifications for client/server databases and database applications.
- Evaluate and select database components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions.
PERCENTAGES OF JOB RESPONSIBILTIES
% OF JOB
DESCRIPTION
75%
Integrations between various data sources, mainly MS SQL 2008/2012. This includes writing queries, triggers, stored procedures, data quality, data validity, and ensuring database integrity. Highly technical. Highly logical.
20%
Working with the Development team (Cold Fusion) in order to ensure that the coding is in line with the database structure and database attributes.
5%
Determining data quality issues, troubleshooting data issues
Knowledge, Skills & Experience:
- Years of direct experience in enterprise-level data integrations
- Proven experience in overseeing the linking of cross-functional databases between disparate business units and systems.
- Strong experience writing SQL queries, stored procedures and triggers
- Strong experience with database platforms, including Microsoft SQL 2008/2012
- Experience with database design applications, including Microsoft SQL 2008/2012.
- Maintain high standards of data quality through the introduction and enforcement of information handling processes and organization of the data integration processes.
- Hands on experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping.
- Working technical knowledge of current database software, protocols, and standards.
- Strong understanding of database structures, theories, principles, and practices.
- Working technical experience with designing, building, installing, configuring and supporting database servers, including Microsoft SQL 2008/2012.
- Strong knowledge of system and software quality assurance best practices methodology.
- Hands-on database tuning and troubleshooting experience.
- Experience with data processing flowcharting techniques.
- Technical Project management experience.
- Working technical experience with developing, installing, configuring and supporting database environments.
- Knowledge of applicable data privacy practices and laws.
Personal Attributes:
- Highly self-motivated and directed.
- Highly Logical.
- Keen attention to detail.
- Proven analytical and problem-solving abilities.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Good written and oral communication skills.
- Strong technical documentation skills.
- Good interpersonal skills.
- Ability to conduct research into database issues, standards, and products as required.
- Ability to present ideas in user-friendly language.
- Strong customer service orientation.
- Experience working in a team-oriented, collaborative environment.
Formal Education & Certification:
- College diploma or university degree in the field of computer science and 5+ years equivalent work experience.
