SSIS Developer

Job Description

SSIS Developer

Lead I - Software Engineering

Who We Are

UST HealthProof is a dynamic company with a mission to lower the cost of care and deliver the future of healthcare. Our consumer-centric approach gives our health plan customers a modern infrastructure and reduced administrative costs, helping to drive better business results for our customers — and better outcomes for our communities.

We achieve this mission together through teamwork, communication, collaboration, and focus. Our employees are our greatest assets, and we invite you to apply to be a part of our journey toward making a difference in healthcare in the United States. **

You Are**

UST is looking for an SSIS Developer to build end to end business solutions and to work with one of the leading healthcare providers in US. The ideal candidate must possess excellent background in Service now technologies. The candidate must possess excellent written and verbal communication skills with the ability and collaborate effectively with domain and technical experts in the team. **

The Opportunity**

• Interpret the application/feature/component design to develop the same in accordance with specifications.
• Code, debug, test, document and communicate product/component/feature development stages.
• Validate results with user representatives; integrates and commissions the overall solution.
• Select appropriate technical options for development such as reusing, improving or reconfiguration of existing components or creating own solutions.
• Optimizes efficiency, cost and quality.
• Influence and improve customer satisfaction.

This position description identifies the responsibilities and tasks typically associated with the performance of the position. Other relevant essential functions may be required. **

What You Need**

• Experience in SSIS package scheduling using SQL server agent.
• ServiceNow experience administering the platform, monitoring performance, deploying applications, building out catalog items/workflows, and configuring integrations.
• Experience writing and debugging JavaScript – Client/Server sides
• Experience writing and debugging Angular, HTML, AJAX, CSS and third-party controls
• Experience with REST/SOAP API development – Integration with third-party platforms – OOP, JSON, Payload/XML
• Experience with upgrades and clones
• ServiceNow Developer Certification
• Working knowledge how configuration management factors into the ITIL framework
• Previous working experience with ServiceNow CMDB
• Previous working experience on ACLs
• Knowledge of relational database concepts – SQL
• Knowledge of .NET, C# and a programming proficiency in C#, ASP.NET is a plus
• Good written and verbal communication skills
• Good analytical skills
• Good project management and time-management skills
• Good problem-solving skills
• Good teamwork – team player
• Exposure to Cloud integration technologies.
• Experience with C# and the .NET Framework
• Experience or knowledge of Microsoft Power BI
• Experience in technical implementations of business intelligence applications that deliver business decision making capabilities.
• Experience with Web-based applications, including knowledge of various operating systems and application servers.
• Experience in the healthcare domain
• Hands-on experience developing ETL processed in MS SQL environment using SSIS, SQL & stored procedures.
• Experience in utilizing MS SQL Server for DDL/DML/DCL, specifically as it relates to database design, implementation, efficiency, and performance.
• Hands-on SQL Programming experience required.
• Ability to test scripts and review and document results.
• Experience developing data models for database schemas, stored procedures, functions, views, triggers in OLTP and OLAP-based environments.
• Experience with fundamental administrative performance and design capabilities including indexing, partitioning of data, creating and restoring backups, jobs, etc.
• Fundamental understanding and exposure to data management capabilities

Compensation can differ depending on factors including but not limited to the specific office location, role, skill set, education, and level of experience. As required by applicable law, UST provides a reasonable range of compensation for roles that may be hired in various U.S. markets as set forth below. **

Role Location: Remote**

Compensation Range: $73,000-$109,000

Our full-time, regular associates are eligible for 401K matching, and vacation accrual and are covered from day 1 for paid sick time, healthcare, dental, vision, life, and disability insurance benefits. **

What We Believe**

We’re proud to embrace the same values that have shaped UST HealthProof since the beginning. Since day one, we’ve been building enduring relationships and a culture of integrity. And today, it's those same values that are inspiring us to encourage innovation from everyone, to champion diversity and inclusion, and to place people at the center of everything we do. **

Humility**

We will listen, learn, be empathetic and help selflessly in our interactions with everyone. **

Humanity**

Through business, we will better the lives of those less fortunate than ourselves. **

Integrity**

We honor our commitments and act with responsibility in all our relationships. **

Equal Employment Opportunity Statement**

UST HealthProof is an Equal Opportunity Employer.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

UST HealthProof reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance.

#USTHealthproof

#CB