Advocate Aurora Health

Senior SQL Developer


PayCompetitive
LocationRemote
Employment typeFull-Time

This job is now closed

  • Job Description

      Req#: R114037

      Department:

      12250 AHP Administration - Site Information Systems

      Status:

      Full time

      Benefits Eligible:

      Yes

      Hou rs 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 development of the front-end application.
      • Ability to develop and support reports used by Claims Operations. This should include an understanding of the business workflows/requirements and developing report solutions to meet those needs.


      This job description indicates the general nature and level of work expected of the incumbent. It is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities required of the incumbent. Incumbent may be required to perform other related duties.

      About Advocate Health

      Advocate Health is the third-largest nonprofit, integrated health system in the United States, created from the combination of Advocate Aurora Health and Atrium Health. Providing care under the names Advocate Health Care in Illinois; Atrium Health in the Carolinas, Georgia and Alabama; and Aurora Health Care in Wisconsin, Advocate Health is a national leader in clinical innovation, health outcomes, consumer experience and value-based care. Headquartered in Charlotte, North Carolina, Advocate Health services nearly 6 million patients and is engaged in hundreds of clinical trials and research studies, with Wake Forest University School of Medicine serving as the academic core of the enterprise. It is nationally recognized for its expertise in cardiology, neurosciences, oncology, pediatrics and rehabilitation, as well as organ transplants, burn treatments and specialized musculoskeletal programs. Advocate Health employs 155,000 teammates across 69 hospitals and over 1,000 care locations, and offers one of the nation’s largest graduate medical education programs with over 2,000 residents and fellows across more than 200 programs. Committed to providing equitable care for all, Advocate Health provides more than $6 billion in annual community benefits.

  • About the company

      Advocate Aurora Health is a non-profit health care system with dual headquarters located in Milwaukee, Wisconsin

Notice

Talentify 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 protected veteran status.

Talentify provides reasonable accommodations to qualified applicants with disabilities, including disabled veterans. Request assistance at accessibility@talentify.io or 407-000-0000.

Federal law requires every new hire to complete Form I-9 and present proof of identity and U.S. work eligibility.

An Automated Employment Decision Tool (AEDT) will score your job-related skills and responses. Bias-audit & data-use details: www.talentify.io/bias-audit-report. NYC applicants may request an alternative process or accommodation at aedt@talentify.io or 407-000-0000.