Senior SSIS Developer-Gainwell Technologies

Job Description

Job Title: Senior SSIS Developer

Company: Gainwell Technologies

Location: Ohio

Pay: $100000 – 120000 per year

AI Pay Analysis: The hourly rate of $100,000 – $120,000 per year for a “Senior SSIS Developer” in Ohio translates to approximately $48 – $58 per hour, which is generally competitive within the industry standards for similar roles in the region. According to industry reports and salary surveys, senior developers with expertise in SQL Server Integration Services (SSIS) and related technologies typically earn between $45 and $70 per hour, depending on factors such as experience, specific skill sets, and the complexity of projects. Therefore, the offered rate aligns well with market expectations, making it an attractive opportunity for seasoned professionals in this field.

Job description:
Be a vital part of a team that harnesses cutting-edge technologies to enhance the health and well-being of the most vulnerable individuals in our country and communities. At Gainwell, you will discover numerous rewards, including significant opportunities for career growth within a company that prioritizes work flexibility, continuous learning, and professional development. You will enhance your technical credentials and certifications while enjoying a generous and flexible vacation policy, alongside educational assistance. Additionally, our comprehensive leadership and technical development academies are designed to hone your skills and capabilities.

As a Senior SQL Server BI Developer (SSIS) at Gainwell, contribute your expertise as we leverage technology to assist our clients in improving the health and well-being of their communities’ most vulnerable members. Connect your passion with purpose by collaborating with colleagues who are dedicated to developing innovative solutions for some of healthcare’s most pressing challenges.

– In this role, you will design, create, maintain, deploy, and manage SSIS and SQL applications for internal business teams and our clients under general supervision.
– Collaborating closely with IT staff and business stakeholders, you will create, maintain, and support ETL packages in a compliant and regulated environment.
– You will take ownership of concerns by escalating them to project management or Team Lead, while actively contributing to the identification and implementation of best practices.

In your mission with us:

– Engage in Joint Application Design (JAD), Rapid Application Development (RAD), and Design Specifications Document (DSD) sessions to identify and articulate business requirements, crafting detailed systems design documentation for reports, data interface files, data conversion, and other data exchange methods.
– Develop, test, manage, and implement SSIS Packages from the development server to the production server using package configuration.
– Oversee the maintenance and administration of SSIS, including the creation of jobs, alerts, and SQL Mail Agent setup, as well as scheduling DTS/SSIS Packages.
– Provide guidance to other developers on complex interfaces while demonstrating strong debugging skills.
– Automate SSIS package execution using SQL Server Agent Jobs.
– Proactively engage in continuous improvement initiatives.
– Diagnose and resolve incident tickets and errors effectively.
– Produce ETL specifications, data mapping, and other documentation required for ETL development.
– Utilize SQL, data models, data element dictionaries, and schemas to conduct data and business analyses.
– Ensure data quality by understanding business data and performing thorough quality assurance testing.
– Establish and maintain positive, effective working relationships with colleagues, clients, members, providers, and customers.
– Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.

We seek candidates who possess:

– A minimum of 9 years of experience in applications design and development, specifically with SQL Server/MS-SQL scripting and SSIS.
– Proficiency in crafting complex queries and reports using Microsoft SQL.
– Strong analytical and data analysis skills utilizing Microsoft SQL.
– Prior experience in team leadership, including mentoring and overseeing team performance.
– Preferred experience in one or more of the following areas:
– Healthcare plan data focusing on medical claims and financial processing.
– Member eligibility processing.
– Provider networks.
– MCO contract details, auditing, and reporting in compliance with Federal and State requirements.

Expectations for this role include:

– A fully remote opportunity with the flexibility to work from anywhere within the United States.
– Potential travel opportunities (0-10%).
– The ability to maintain a flexible schedule to accommodate business needs and travel requirements.
– Participation in a rotating on-call team.
– Mandatory video camera usage during all interviews and the initial week of orientation.

The application deadline for this position is February 28, 2025. The salary range for this role is $100,000 – $120,000 per year, with the base salary offered varying based on geographic location, internal equity, job-related knowledge, skills, and experience among other factors.

Join Gainwell and turn your passion into a career. Experience professional growth in an environment that values flexibility, learning, and development. Enjoy our generous vacation policy, educational assistance, and access to various leadership and technical development academies designed to enhance your skills.

At Gainwell Technologies, we believe in the power of collaboration, innovation, and inclusion to drive success in healthcare. We are committed to a diverse, equitable, and inclusive workplace and take pride in being an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other legally protected characteristics. We celebrate diversity and are dedicated to fostering an inclusive environment for all employees.

Job Posting Date: Wed, 05 Feb 2025 03:56:54 GMT

Apply now!