Data Integration Specialist

Futurewave Systems; Pittsburgh (Allegheny County); On-site; USD 80,000 - 100,000; Full time

Job summary

A professional staffing and services firm in Pittsburgh is looking for a Data Integration Specialist to oversee the integration of data across various sources. The role demands high technical expertise in Microsoft SQL and experience with enterprise-level data integrations. Candidates must demonstrate strong problem-solving skills, a logical mindset, and the ability to implement data quality processes to ensure seamless data flow and architecture. Attention to detail and communication skills are critical for success in this high-paced environment.

Qualifications

• 5+ years of work experience in enterprise-level data integrations is required.
• Experience writing SQL queries, stored procedures, and database tuning.
• Ability to oversee linking cross-functional databases between different units.

Responsibilities

• Integrate various data sources ensuring data integrity and quality.
• Work with development teams to align coding with database structure.
• Troubleshoot data quality and performance issues effectively.

Skills

Data integration experience

SQL querying skills

Technical project management

Analytical and problem-solving abilities

Database design knowledge

Education

College diploma or university degree in computer science

Tools

Microsoft SQL 2008/2012

ETL software

Database management systems

Job description

Founded in 2006, Futurewave Systems is a minority owned boutique,STAFFING & PROFESSIONAL SERVICES PROVIDERheadquartered in Atlanta, GA. We are aGLOBAL NETWORKof proven industry professionals demonstrating the fastest fulfillment rate of high tech professionals for Fortune 500 Companies.

Job Description

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

Qualifications

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.
• 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.