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.08 – $57.69 per hour, which is competitive and aligns well with industry standards for this role in the region. SSIS (SQL Server Integration Services) developers are in demand due to the growing need for data integration and ETL (Extract, Transform, Load) processes in various sectors, including finance and healthcare. The compensation can be considered attractive, particularly when compared to the average salaries for similar roles in Ohio, which tend to range from $80,000 to $110,000 annually. Overall, this pay scale positions the role favorably within the market, especially factoring in cost of living differences in Ohio.

Job description:
Be part of a team that harnesses cutting-edge technologies to enhance the health and well-being of our country’s most vulnerable populations. At Gainwell, you will have the exceptional opportunity to advance your career within a company that prioritizes work flexibility, professional development, and continuous learning. You will expand your technical credentials and certifications while enjoying a comprehensive vacation policy and educational assistance. Our organization also offers extensive leadership and technical development academies designed to enhance your skills and capabilities.

As a Senior SQL Server BI Developer (SSIS) at Gainwell, you will leverage your expertise to empower our clients in their mission to improve the health and well-being of the communities they serve. You will collaborate with a team of dedicated individuals who are passionate about delivering innovative solutions to some of healthcare’s most pressing challenges.

Key Responsibilities:

– Under general direction, design, create, maintain, deploy, and manage SSIS and SQL applications tailored for internal business teams and external customers.
– Collaborate with IT personnel and business stakeholders to develop and support ETL packages within a compliant, regulated environment.
– Escalate concerns to project management or Team Lead, assist in defining best practices, and recommend improvements to existing processes.

Your Role in Our Mission:

– Engage in Joint Application Design (JAD), Rapid Application Development (RAD), and Design Specifications Document (DSD) sessions to understand business requirements and produce detailed systems design documentation for reports, data interface files, data conversion, and other data exchange methods.
– Develop, test, manage, and implement SSIS Packages from development to production servers, utilizing package configuration.
– Oversee maintenance and administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and scheduling DTS/SSIS Packages.
– Provide guidance to other developers on complex interfaces, showcasing strong debugging skills.
– Automate the execution of SSIS packages using SQL Server Agent Jobs.
– Contribute proactively to continuous improvement initiatives.
– Diagnose and resolve incident tickets and errors.
– Formulate ETL specifications, data mappings, and other necessary documentation for ETL development.
– Utilize SQL, data models, and schema to conduct data and business analyses.
– Ensure data quality through thorough testing processes.
– Foster positive working relationships with coworkers, clients, members, providers, and stakeholders.
– Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.

Qualifications:

– A minimum of 9 years of experience in application design and development with SQL Server/MS-SQL scripting and SSIS.
– Proficient in building complex queries and reports using Microsoft SQL.
– Strong analytical skills and data analysis capabilities using Microsoft SQL.
– Previous leadership experience, including mentoring and monitoring team performance.
– Preferred experience in the following areas:
– Healthcare plan data with a focus on medical claims and financial processing.
– Member eligibility processing.
– Provider networks.
– MCO contract details, auditing, and reporting in compliance with Federal and State regulations.

What You Can Expect:

– A fully remote opportunity with the flexibility to work from anywhere in the United States.
– Potential travel opportunities (0-10%).
– Willingness to work a flexible schedule to meet business needs and travel requirements.
– Participation in a rotating on-call team.
– Video conferencing is required for all interviews and during the initial week of orientation.

The deadline for submission of applications for this position is February 28, 2025. The salary range for this role is between $100,000 and $120,000 per year. Please note that the base salary offered may vary based on geographic region, internal equity, job-related skills, knowledge, and experience.

Put your passion to work at Gainwell and take advantage of the opportunity to grow your career within a company that champions work flexibility, learning, and professional development. We offer a generous vacation policy and educational assistance, along with diverse leadership and technical development academies designed to strengthen your skills.

Gainwell Technologies is deeply committed to fostering a diverse, equitable, and inclusive workplace. We take pride in being an Equal Opportunity Employer, ensuring all qualified applicants receive equal consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other characteristics protected by law. We celebrate diversity and are committed to cultivating an inclusive environment for all employees.

Job Posting Date: Tue, 04 Feb 2025 23:52:26 GMT

Apply now!