Responsibilities:
- Develop and modify SSIS packages and related stored procedures on MSSQL Server.
- Analyze data flow across multiple systems.
- The assignment will be approximately 50% evaluating SSIS packages and tracing data, with approximately 50% modifying/creating new SSIS packages, and modifying stored procedures
Requirements:
- Ability to work across multiple remote teams
- Intermediate to advanced T-SQL skills: Experience with large amount of code with complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs
- Use of GitHub for deployments
- Intermediate to advanced SSIS development with numerous source and destination types, to include connecting with Teradata
- Familiarity with ESP is a plus
- Solving server issues such as permissions, blocks, locks, long running jobs, indexing is a plus
- Experience with Medicare, Medicaid, and Risk Adjustment nice to have, but not necessary
- AWS experience is a plus
- Bachelor’s in Computer Science or equivalent work experience
Hourly Pay Rate Range (dependent on location, experience, expectation)
- The pay range that Magnit reasonably expects to pay for this position is: $53.00/hour-$71.00/hour
- Benefits: Medical, Dental, Vision, 401K (provided minimum eligibility hours are met)