Senior IT Data Warehouse Developer - San Antonio, TX - Full-time / Part-time

At Optum, we are driven to transform health care not just for our own good, but for the greater good. And, with your data reporting and analysis expertise, you can join us on our mission to help make the health care system work better for everyone. As a Data Analyst, you will thrive as you design and architect data warehouse solutions. You will be a primary contributor in developing, testing and deploying key data warehouses or data marts, and you will be working with cutting edge technology.

This role will prepare you for significant career growth as you shift to a gear you didn't know you had in you. So the contributions you'll make as a Data Analyst at Optum, the pride you will feel, the smile that will keep you company on your way home are all ways that you'll know what you do here really matters. It will be important. No, it will not be just important, it will be historic. That's why someday, you will look back at the things you achieved here and realize that you did your life's best work(sm)

The Sr. Data Warehouse Developer works closely with key business data and designs solutions by which information is loaded into and extracted from key IT and business systems.  This position will leverage key development, database, reporting, analytic, and business intelligence skills across a diverse and multi-faceted application landscape. 

Primary Responsibilities:

• Reviews and analyzes on-going customer requests (for new data elements to be brought into the existing model, for customizations or cross-walking of existing data elements, for computation of new fields based on customer-provided business logic, combinations of existing data elements, etc.)


• Functions as a primary contributor in designing, coding, testing, debugging, documenting and supporting all types of applications consistent with established specifications and business requirements to deliver business value. Participates in multiple concurrent projects


• Solves unique and complex problems with broad impact on the business


• Translates highly complex concepts in ways that can be understood by a variety of audiences


• Develops complete descriptions of all specifications and solutions required


• Develops common operations, which can be reused


• Devises data verification and quality methods and standard systems procedures that will be used to support Enterprise Data Warehouse and Business Intelligence platforms


• Participates in certain aspects of user consulting, systems analysis, general systems design, vendor contracts and detail systems design


• Learns user functions, organization and role in the enterprise to the extent required


• Performs all other related duties as assigned

Required Qualifications:

• Bachelor's degree in computer science, business administration or related field required. (4 additional years of comparable work experience beyond the required years of experience may be substituted in lieu of a bachelor's degree)


• Three or more years of strong Informatics/ETL experience, SQL Server experience (Version 2005 or higher), Visual Studio (Version 2005 or higher), SQL SSIS experience, and SQL & Querying Tuning


• Broad knowledge of .NET (Version 3.0 or higher) framework, designing and developing additional components using .NET


• Excellent communication skills both written and verbal


• Sound knowledge of ETL concepts and at least two years experience building SSIS packages including logging, exception handling, etc.

Preferred Qualifications:

• 
  
  Background in the Healthcare industry


• 
  
  Experience with SQL Server Reporting Services


• 
  
  Experience developing reporting tables, OLAP cubes, datamarts


• 
  
  HEDIS experience


• 
  
  HIPAA/CMS knowledge


• 
  
  Experience gathering business requirements


• 
  
  SQL 2012 experience

WellMed is a healthcare delivery system serving more than 90,000 patients, primarily Medicare eligible seniors, in Texas and Florida through primary care clinics, multi-specialty clinics, and contracted medical management services. Headquartered in San Antonio, Texas, WellMed is an industry leader in medical risk management, highly effective disease management and chronic care programs, healthcare delivery services and more.

Our focus and mission is to help the sick become well and to help patients understand and control their health in a lifelong effort at wellness. We are innovators in preventative healthcare, striving to change the face of healthcare delivery for seniors. Our providers and support staff are selected for their dedication to the senior population and focus on preventative, proactive patient care.

Careers with Optum. Here's the idea. We built an entire organization around one giant objective; make the health system work better for everyone. So when it comes to how we use the world's large accumulation of health-related information, or guide health and lifestyle choices or manage pharmacy benefits for millions, our first goal is to leap beyond the status quo and uncover new ways to serve. Optum, part of the UnitedHealth Group family of businesses, brings together some of the greatest minds and most advanced ideas on where health care has to go in order to reach its fullest potential. For you, that means working on high performance teams against sophisticated challenges that matter. Optum, incredible ideas in one incredible company and a singular opportunity to do your life's best work(sm)

Diversity creates a healthier atmosphere: All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran status, or disability status.




UnitedHealth Group is a drug-free workplace. Candidates are required to pass a drug test before beginning employment. In addition, employees in certain positions are subject to random drug testing.

Job keywords: Data Warehouse Developer, ETL, SQL, SQL SSIS, Visual Studio, .NET, SAP, OLAP cubes, HIPAA, HL7, WEDI-SNIP, BizTalk, San Antonio, TX