Full Time: Need SQL Server Developer based at Columbia, SC, United States

Integrated Resources Inc.; Columbia (SC); On-site; USD 75,000 - 105,000; Full time

Job summary

A staffing firm is looking for a SQL Server Developer to manage a real-time data warehouse environment. The role involves designing ETL processes, supporting database objects, and producing documentation. Candidates should have 4-6 years of experience and a Bachelor’s degree in Computer Science. Excellent communication skills and the ability to work both independently and collaboratively are essential.

Qualifications

• 4-6 years supporting MSBI initiatives.
• Strong decision-making and collaboration skills.
• Ability to work independently and in teams.

Responsibilities

• Develop and maintain real-time data warehouse environment.
• Design and implement ETL processes.
• Create SSIS integration jobs and support SSRS reports.

Skills

Task Management

Organizational Skills

Problem-Solving

Communication

Collaboration

Education

Bachelor’s degree in Computer Science or related field

Job description

Full Time: Need SQL Server Developer based at Columbia, SC, United States

• Full-time

A Few Words About Us

Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy, and Nursing.

We have a full-time position available with one of our direct clients.

Job Description:

Title: SQL Server Developer

Duration: Full Time

Location: Columbia, SC, United States

Responsibilities:

• Develop and maintain a real-time data warehouse environment and create real-time feeds to all subscriber applications from the Data warehouse.
• Design and implement Type 2 Dimension Data modeling and Historical ETL processes.
• Develop and support SQL Server database objects and code for Business As Usual (BAU) support.
• Create and support SSIS integration jobs to manage data integration between application databases and the data warehouse, including XML/CSV/Excel integration.
• Develop and support SSAS Cubes and related processing tasks.
• Develop and support SSRS reports, deployed on SharePoint.
• Document all developed objects and processes.
• Use TFS to track changes and artifacts.
• Follow strict change control processes throughout the development lifecycle.
• Develop and execute test scripts to ensure code quality and data integrity.
• Perform testing against acceptance criteria.
• Adhere to data and integration design patterns and architecture as prescribed.
• Comply with company policies, procedures, controls, and processes for development and testing.

Qualifications:

• Four to six years of experience supporting MSBI initiatives within a database team.
• Good task management and organizational skills.
• Willingness to take responsibility and ownership of tasks and issues.
• Ability to analyze, communicate, and resolve issues effectively.
• Ability to produce high-quality documentation under deadlines.
• Strong decision-making and collaboration skills for data architecture issues.
• Ability to work independently and collaboratively with various teams.
• Excellent communication and documentation skills.

Education:

Bachelor’s degree in Computer Science or a related field.

Kind Regards,

Om Puri

Technical Recruiter

Integrated Resources, Inc.