Sr. SQL Developer

Rapinno Tech; Oregon (WI); Hybrid; USD 80,000 - 100,000; Full time

Job summary

A technology company is seeking a candidate for a critical role involving SQL Server and SSIS for data integration projects. The ideal applicant will have at least 5 years of experience in SQL Server databases and T-SQL, with an ability to work independently. Responsibilities include collaborating with Business Analysts to define requirements, managing enhancements, and ensuring quality in data integrations. This role is suited for someone who can work positively with vendors and internal teams. The start date is November 1.

Qualifications

• Minimum of 5 years of experience in working with SQL Server databases, SSIS, and T-SQL.
• Experience using KingswaySoft in SSIS to link to Salesforce or Dynamics 365 is a plus.
• Ability to build and maintain positive relationships with vendors and internal stakeholders.

Responsibilities

• Collaborate with Business Analysts to understand data integration and report requirements.
• Manage enhancements to ensure successful completion and realization of value.
• Work with vendors and support teams to define technical requirements for data integration.

Skills

SQL Server databases

SSIS

T-SQL

Education

Bachelor of Science in Computer Science, Informatics, Information Technology or equivalent work experience

Tools

KingswaySoft

Job description

• This is only being released to Partner Connect Sponsors for an 11/1 start
• The project is taking existing framework and modernizing, as well as building an in-house system where they are able to dictate their own requirements
• This person must be able to work independently; be able to interpret requirements and run with them
• They will be working with 4-5 other individuals on the team
• Interviews to be held Oct. 5-7
• This manager prefers the candidate NOT be on Pacific Time; they will be on 8:30am Eastern standups

QUALIFICATIONS, SKILLS, AND EXPERIENCE:

• Bachelor of Science in Computer Science, Informatics, Information Technology or equivalent work experience.
• Requires minimum of 5 years of experience in working with SQL Server databases, SSIS, and T-SQL.
• Experience using KingswaySoft in SSIS to link to Salesforce or Dynamics 365 is a plus.
• Must be able to build and maintain a positive relationship with vendors and internal suppliers and customers.
• Must be able to manage and coordinate multiple projects simultaneously.

RESPONSIBILITIES:

• Working with Business Analysts and customers to understand data integration and report requirements.
• Managing enhancements and ensuring their successful completion and the realization of value.
• Working with systems vendors and internal technical support teams to gain access to business data, defining the technical requirements for data integration, and ensuring successful set up and testing of integrations.
• Designing, developing, and testing SSIS procedures using T-SQL and KingswaySoft for loading data into a SQL Server data warehouse and for extracting data from that data warehouse for downstream integrations.
• Quality assurance testing of new or changed integrations.