SSIS/SQL Developer

Altair Data Resources, Inc.; Nashville (TN); On-site; USD 80,000 - 100,000; Full time

Job summary

Altair Data Resources, Inc. is seeking a skilled SSIS/SQL Developer to enhance data integration processes. The role involves designing and maintaining SQL Server Integration Services (SSIS) packages and collaborating with teams to ensure data accuracy and efficiency.

Candidates should have a Bachelor's degree in Computer Science and a minimum of three years in SSIS solutions and SQL development. Strong communication skills are essential for success within our dynamic team.

Qualifications

• Minimum of 3 years of experience in SSIS solutions development.
• Minimum of 3 years of experience as a SQL Developer.
• Experience with large data sets and data-intensive environments.

Responsibilities

• Design, develop, and maintain SSIS packages for large data sets.
• Collaborate with teams to gather requirements for SSIS solutions.
• Create and optimize complex SQL queries, stored procedures, and functions.
• Perform data profiling and address data quality issues.
• Implement data cleansing and validation rules.
• Develop and maintain comprehensive documentation.
• Monitor and optimize SSIS performance.
• Troubleshoot data integration and performance issues.
• Stay updated on industry trends in data integration technologies.

Skills

SSIS

SQL programming

Data modeling

Data profiling

Problem-solving

Communication

Education

Bachelor's degree in Computer Science

Tools

Microsoft SQL Server Integration Services

Job description

Description

We are seeking a highly skilled SSIS/SQL Developer to join our dynamic and innovative team. As an SSIS/SQL Developer, you will be responsible for designing, developing, and maintaining efficient database load and update processes using Microsoft SQL Server Integration Services (SSIS) and other related technologies. Your expertise in SSIS and SQL programming, particularly with large data sets, will be crucial in developing our data integration packages, ensuring data accuracy, and supporting various data-driven initiatives within our organization.

SSIS/SQL Developer Responsibilities and Duties

• Design, develop, and maintain SQL Server Integration Services (SSIS) packages to efficiently load large, consolidated data sets.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications for data integration and SSIS solutions.
• Create and optimize complex SQL queries, stored procedures, and functions where necessary to support SSIS package operation/performance.
• Perform data profiling and analysis to identify data quality issues and propose appropriate solutions.
• Implement data cleansing, transformation, and validation rules to ensure the accuracy and consistency of data.
• Collaborate with database administrators and data architects to align processes with the company’s data processing frameworks and database standards.
• Develop and maintain documentation, including data flow diagrams, data dictionaries, and technical specifications.
• Monitor and optimize the performance of SSIS processes to ensure efficient data processing and system reliability.
• Troubleshoot and resolve data-related issues, including data integration failures, data quality problems, and performance bottlenecks.
• Stay up to date with industry trends and best practices in SSIS, SQL development, and data integration technologies.

Requirements

SSIS/SQL Developer Work Experience

• Minimum of 3 years of experience in designing and implementing SSIS solutions according to best practices, ideally with large data sets.
• Minimum of 3 years of experience working as a SQL Developer within a data intensive environment, demonstrating strong analytical and critical thinking skills, including a thorough understanding of how to interpret customer business requirements and translate them into database-oriented solutions.

SSIS/SQL Developer Qualifications and Skills

• Bachelor's degree in Computer Science, Information Systems, or a related field. Equivalent work experience may be considered.
• Proven experience as an SSIS/SQL Developer or a similar role, with a strong understanding of database concepts and SQL programming.
• In-depth knowledge of Microsoft SQL Server Integration Services (SSIS) and experience in designing and developing database load/update processes.
• Proficiency in SQL programming, including complex query optimization, stored procedures, and functions.
• Solid understanding of data modeling concepts.
• Familiarity with data profiling and quality assurance techniques.
• Strong problem-solving and analytical skills with the ability to identify data-related issues and propose effective solutions.
• Excellent communication and collaboration skills, with the ability to work effectively in a team environment. Ability and desire to share SSIS knowledge, approaches, and experience with less experienced team members.
• Ability to work on multiple projects simultaneously and meet deadlines.

SSIS/SQL Developer Additional Considerations

• Python/PHP experience a plus
• Familiarity with API integrations