Senior Applications Developer for SQL Server and ETL

 
Position: Senior Applications Developer for SQL Server and ETL

Job ID: 144017

Location: US-TX-Houston

Department: TCHP IS SUPPORT

Talent Area: Information Services

Full/Part Time: Full-Time

Regular/Temporary: Regular

Shift: Days

About Texas Children's Hospital

Founded in 1996, Texas Children’s Health Plan is the nation's first health maintenance organization (HMO) created just for children. We provide STAR/Medicaid and Children's Health Insurance Program (CHIP) to pregnant women, teens, children and adults in Houston and surrounding areas. Currently, the Health Plan has more than 375,000 members who receive care from our network of more than 1,100 primary care physicians, 3,200 specialists, and 70 hospitals. Texas Children's Health Plan is also the largest combined STAR/CHIP Managed Care Organization in the Harris County service area.   To join our community of 13,000 dedicated team members, visit texaschildrenspeople.org for career opportunities. You can also learn more about our amazing culture at infinitepassion.org.

Summary:

We are searching for a Senior SQL/ETL Developer - someone who works well in a fast-paced primary/managed care setting. You will perform custom application development, data and application integration for the Health Plan's information systems, and to devise and design technical requirements and estimate effort. You will be responsible for documentation of well-defined methods, procedures, programs and configurations in the delivery of application services. You will also be responsible for making recommendations regarding how to solve the challenges associated with the job’s purpose and essential responsibilities.

 

You MUST have a good working knowledge of SQL Server and ETL.  SSIS should be on your resume already. This role will be a backend developer that integrates data across several applications.  These will be custom and vendor managed applications with a mix of 80% vendor and 20% custom applications.  You must be able to pull data from the vendor application and then get it successfully into the target application with a high measure of data integrity.  This is a true back end developer role!  T-SQL and SSIS are crucial tools in your toolbox

 

You should be able to take requirements and identify and overcome ambiguity or gaps in those requirements.

 

Think you’ve got what it takes?

 



Responsibilities :

  • Implements design principles to be used in each development assignment
  • Ensure adherence to best practices and standards
  • Works with Enterprise and Solution Architects in the design and review of technical solutions for projects
  • Defines, documents and designs technical requirements for custom applications, integrations, and processes
  • Prepares design specifications, implements any required data mapping, including documenting and revising user test plans
  • Estimates time to complete team level assignments breaking down user stories/requirements into actionable tasks
  • Accurately communicates status on individual assignments and prioritize to complete on schedule
  • Contributes details to the overall plan within your scope of experience and skills
  • Develops, documents, and tests application and process following best practices and standards
  • Develops deployment and roll back scripts for releasing changes into production
  • Creates or updates application and process documentation in compliance with standards Analyzes, reviews, and alters application and data integrations to increase operating efficiency or adapt to new requirements


Qualifications:

  • ETL (SSIS, Informatica etc.)
  • SQL Server Database Development(T-SQL)
  • JSON/XML

 

  • SSRS
  • High School Diploma or GED
  • Eight (8) years of experience as a software developer or software engineer including two (2) years of database design and programming and three (3) plus years of  experience with Microsoft tool set
  • Experience with Microsoft Visual Studio 2013/2015/2017

Nice to have:

  • PowerBI
  • .NET Frameworks
  • Web Services (WCF, WEB API)
  • C#
  • Object Relational Mapping (Entity Framework preferred)
  • Web Development (HTML5, ASP.NET, JavaScript, CSS)

 



Apply Now

Current Texas Children’s employees – Please click here to login.

Create Profile or Log In Search Careers