Demo

Senior SSIS Developer

Gainwell Technologies
Ohio, OH Full Time
POSTED ON 2/8/2025
AVAILABLE BEFORE 5/8/2025

Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You'll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You'll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.

Summary

As a Senior SQL Server BI Developer (SSIS) at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve - a community's most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare's biggest challenges.

  • Under general direction, responsible for designing and / or creating, maintaining, deploying, and managing SSIS and SQL applications for internal business teams and our customers.
  • Will work collaboratively with IT staff, and business stakeholders to create, maintain, and support ETL packages in a compliant, regulated environment.
  • Escalate concerns to project management or Team Lead, assist in determining best practices and provide suggestions on how to improve current practices.

Your role in our mission

Play a critical part in ensuring Gainwell is meeting our clients' objectives in important areas.

  • Participate in JAD (Joint Application Design), RAD (Rapid Application Development) and DSD (Design Specifications Document) sessions to define and understand the business requirements and present detailed systems design documentation for reports, data interface files, data conversion and any other method of data exchange.
  • Develop, test, manage and implement SSIS Packages from development server to production server using package configuration.
  • Work on maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS / SSIS Packages.
  • Design and guide other developers on complicated interfaces and should have strong debugging skills.
  • Ability to automate the execution of SSIS packages using SQL Server Agent Jobs.
  • Proactively engage on continuous improvement efforts.
  • Diagnose and resolve incident tickets and errors.
  • Develop ETL specifications, data mapping and other documentation required for ETL development.
  • Use SQL, data models, data element dictionary and schema to perform data and business analysis.
  • Understand business data and perform quality assurance testing to ensure the data presented is correct.
  • Ability to establish and maintain positive and effective work relationships with coworkers, clients, members, providers and customers.
  • Support Unit Testing, System Integration Testing, End-to-End System Testing, and User Acceptance Testing.
  • What we're looking for

  • 9 years of applications design and development experience with SQL Server / MS-SQL scripting and SSIS
  • Ability to build complex queries and reports using Microsoft SQL.
  • Analytical and data analysis skills using Microsoft SQL
  • Previous team leadership experience to include analyzing, mentoring and monitoring.
  • Preferred experience in any of the following :
  • healthcare plan data focusing on medical claim and financial processing

  • member eligibility processing
  • provider networks
  • MCO contract details, auditing and reporting in compliance with Federal and State requirements.
  • What you should expect in this role

  • Fully remote opportunity with the option to work anywhere within the United States
  • Opportunities to travel through your work (0-10%)
  • Willingness to work a flexible schedule to accommodate business needs and travel as required
  • This position is part of a rotating on-call team
  • Video cameras must be used during all interviews, as well as during the initial week of orientation
  • LI-SH1

    LI-REMOTE

    The deadline to submit applications for this posting is February 28, 2025

    The pay range for this position is $100,000 - $120,000 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You'll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits, and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.

    We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You'll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.

    Gainwell Technologies is committed to a diverse, equitable, and inclusive workplace. We are proud to be an Equal Opportunity Employer, where 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 applicable legally protected characteristics. We celebrate diversity and are dedicated to creating an inclusive environment for all employees.

    Salary : $100,000 - $120,000

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Senior SSIS Developer?

    Sign up to receive alerts about other jobs on the Senior SSIS Developer career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $141,014 - $186,880
    Income Estimation: 
    $180,084 - $244,913
    Income Estimation: 
    $81,298 - $105,685
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $101,449 - $132,468
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $124,087 - $161,899
    Income Estimation: 
    $152,365 - $200,973
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Gainwell Technologies

    Gainwell Technologies
    Hired Organization Address Arkansas, AR Full Time
    Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of tho...
    Gainwell Technologies
    Hired Organization Address Little Rock, AR Full Time
    Great companies need great teams to propel their operations. Join the group that solves business challenges and enhances...
    Gainwell Technologies
    Hired Organization Address Bridgeport, CT Full Time
    Job Details Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-...
    Gainwell Technologies
    Hired Organization Address Austin, TX Full Time
    Job Details Summary As a Senior Professional Programmer Analyst at Gainwell, you will be a part of an innovative healthc...

    Not the job you're looking for? Here are some other Senior SSIS Developer jobs in the Ohio, OH area that may be a better fit.

    Senior Business Developer

    IBERDROLA Renewables, Ohio, OH

    Senior Business Developer

    Iberdrola, Ohio, OH

    AI Assistant is available now!

    Feel free to start your new journey!