Senior SQL Developer

Department:

12250 AHP Administration - Site Information Systems

Status:

Full time

Benefits Eligible:

Yes

Hours Per Week:

40

Schedule Details/Additional Information:

Fully Remote Role from these states: AL, AK, AR, AZ, DE, FL, GA, IA, ID, IL, IN, LA, KS, KY, ME, MI, MO, MS, MT, NC, ND, NE, NH, NM, NV, OH, OK, PA, SC, SD, TN, TX, UT, VA, WI, WV, WY.

Due to complex requirements, remote work is NOT permitted for short or long periods in: CA, CO, CT, HI, MA, MD, MN, NJ, NY, OR, RI, VT, WA and working Internationally (this includes working while on vacation).

No Sponsorship for this position.

Major Responsibilities:

• Designs and develops business solutions primarily using Microsoft.NET and T-SQL.
• Complies with coding standards and development processes to ensure quality.
• Analyzes system requirements and existing business processes and information systems. Participates in business process reviews.
• Develops and coordinates systems planning, scheduling and implementation. Initiates corrective action to stay on schedule.
• Provides technical guidance on complex issues and provides recommendations for application, system improvement and architecture.
• Designs and develops components for all application tiers, including but not limited to UX, business logic, database access and web services.
• Develops automation techniques to enable end-user content publishing and communicating with existing content management systems.
• Assists with the training of new staff and developing existing staff. Develops and presents internal and external training programs.
• Maintains links to external sites and accuracy on internal links while ensuring up-to-date information. Researches, evaluates and recommends new Internet tools and applications for use in assigned responsibilities.
• Contributes to presentation and business-logic tier of self-service, customer-service and enterprise systems.

Licensure, Registration, and/or Certification Required:

• None Required.

Education Required:

• Bachelor's Degree (or equivalent knowledge) in Computer Science or related field.

Experience Required:

• Typically requires 5 years of experience in software development including ETL processing.

Knowledge, Skills & Abilities Required:

• Highly technical programming skills and knowledge of various IDE tools to code, test, debug, document and implement software applications.
• Object-oriented analysis, design and development skills.
• Experience in web and other technologies such as JavaScript, HTML, .NET, C#, and SharePoint.
• Extensive experience in T-SQL development and ETL processing.
• Familiarity with one or more application servers and experience with web services.
• Attention to software quality, using tools such as source control, unit testing and continuous integration.
• Ability to interact and work through technical requirements with clients to formulate project design and implementation requirements.
• Demonstrated negotiation and facilitation skills and ability to explain communicate web enabling design techniques
• to users.
• Demonstrated written and verbal communications skills when consulting with internal and external partners.
• Strong organizational and analytical skills. Ability to gather and organize data.
• Strong problem and issue resolution skills.
• Ability to handle multiple tasks, set appropriate priorities and accomplish assignments in a thorough and timely
• manner.

Physical Requirements and Working Conditions:

• Must have functional vision and ability to use a computer the majority of the day.
• Position requires some travel. May be exposed to road and weather hazards.
• Generally exposed to a normal office environment.
• Operates all equipment necessary to perform the job.

Additional Skills Required:

• Strong understanding of Claims Operations business workflows.
• Ability to work with various business units and external users such as payers to understand their requirements. Then develop technical solutions that meet the requirements.
• Demonstrated ability to support Claims Operations eligibility data flows. This includes ability to ingest payer specific data (flat files, EDI 834, etc.), apply business rules and ingest into downstream systems such as Epic Tapestry.
• Demonstrated ability to support Claims Operations workflows such as 278 encounter submissions.
• Demonstrated ability to support a home-grown provider network database application. Abilities include supporting the back-end data interfaces as well as managing the devel