Find Jobs Find Talent
Sr Software Engineer
Minnetonka, Minnesota  |  Remote, Hybrid, Onsite
Contract to Hire Position
It appears that you have already applied to this job.
Applied on September 29, 2022
Job Id #57350 Posted June 28, 2022


Projects the candidate will be working on:

  • This position is for a Medi-Cal Data Warehouse project for State of California in Sacramento.
  • The Data Feeds Specialist will be responsible to develop and maintain the data feed process from various data sources and transmit data in preparation for loading into the MIS/DSS data warehouse

Experience:

  • Experience with paid and denied claims (diagnosis codes, procedure codes, etc.) and data standards (Protected Health Information, privacy standards, HIPAA data elements, and code sets.)
  • Intermediate skill level with Microsoft Office Suite of tools and VISIO in facilitating written communication such as developing status reports, creating/updating technical and procedure documentation, and communication with team members, end users and stakeholders.
  • Experience in oral communication in a variety of situations such as interacting with the user community (e.g. State staff, vendors, and Data Center staff), making presentations, facilitating meetings and walkthroughs, and user training.
  • Experience transitioning program changes into production.
  • Experience with Medicaid, Social Security Administration (SSA), or other welfare programs specific to state and federal policies and procedures.

Top Requirements:

  • Five (5) years’ experience with front-end data warehouse or similar processing which includes extracting data for large files from various sources, cleansing data, and preparing the data for loading into a data warehouse.
  • Five (5) years’ experience as an analyst-programmer performing various system development life cycle functions including; project planning, requirements analysis, program specifications, coding, testing, and implementation.
  • Five (5) years’ experience working with statistical reporting data tools such as SAS and Informatica for large volume databases developing and maintaining production reports.

Team and Team size:

  • 6 Data Feeds Specialists and 1 Data Feeds Specialist Lead. They all report to the client directly.

Top Responsibilities:

  • Develop and maintain the data feed process from various data sources and transmit data in preparation for loading into the MIS/DSS data warehouse
  • Analyze DHCS warehouse requirements and research existing claim, eligible and provider processes to maintain the data feed production cycle.
  • Utilize SAS EG statistical tool to create reports and trends from the MIS/DSS, support user requests and provide support for existing data feed outgoing data feeds to the plans, audit and other external areas.
  • Experience using Informatica to help support TMSIS and PERM reporting.
  • Experience using API’s and GLUE to access and store data to the warehouse
  • Respond to help desk and system changes and updates or changes to the existing data extract and data feed process

Skills/attributes Required

  • Five (5) years’ experience with front-end data warehouse or similar processing which includes extracting data for large files from various sources, cleansing data, and preparing the data for loading into a data warehouse.
  • Five (5) years’ experience as an analyst-programmer performing various system development life cycle functions including; project planning, requirements analysis, program specifications, coding, testing, and implementation.
  • Five (5) years’ experience working with statistical reporting data tools such as SAS for large volume databases developing and maintaining production reports.
  • Two (2) years’ experience working with Informatica to extract data required for TMSIS/PERM reporting as well as other data extractions required.
  • Two (2) years’ experience working with Informatica, API, and GLUE to support the electronic exchange of data.
  • Five (5) years-experience working in a mainframe environment (with working knowledge of COBOL, VSAM file structures, JCL and TSO) Intermediate level experience with developing program specifications, pseudo code, or logic diagrams.

Skills/attributes Preferred

  • Experience with paid and denied claims (diagnosis codes, procedure codes, etc.) and data standards (Protected Health Information, privacy standards, HIPAA data elements, and code sets.)
  • Intermediate skill level with Microsoft Office Suite of tools and VISIO in facilitating written communication such as developing status reports, creating/updating technical and procedure documentation, and communication with team members, end users and stakeholders.
  • Experience in oral communication in a variety of situations such as interacting with the user community (e.g. State staff, vendors, and Data Center staff), making presentations, facilitating meetings and walkthroughs, and user training.
  • Experience transitioning program changes into production.
  • Experience with Medicaid, Social Security Administration (SSA), or other welfare programs specific to state and federal policies and procedures.

Horizontal is proud to be an Equal Opportunity and Affirmative Action Employer. We seek to provide employment opportunities to talented, qualified candidates regardless of race, color, sex/gender including gender identity and/or expression, national origin, religion, sexual orientation, disability, marital status, citizen status, veteran status, or any other protected classification under federal, state or local law.

In addition, Horizontal will provide reasonable accommodations for qualified individuals with disabilities. If you need to request a reasonable accommodation in order to complete the application or interview process, please contact hr@horizontal.com.

All applicants applying must be legally authorized to work in the country of employment.

EQUAL OPPORTUNITY EMPLOYMENT SURVEY

What is your gender?

What is your ethnicity?

What is your Veteran / U.S. Military Status?

Do you identify with one or more of the classifications of protected veterans below?

If yes, please indicate by checking the appropriate box below

Do you have a disability?

You are considered to have a disability if you have a physical or mental impairment or medical condition that substantially limits a major life activity, or if you have a history or record of such an impairment or medical condition.

Horizontal is proud to be an Equal Employment Opportunity/Affirmative Action Employer providing a drug-free workplace.

Success!

You have saved your first job! To see all your Saved Jobs, click here. Or continue scrolling through jobs and bookmark openings that catch your eye and apply for those jobs later.

Return to Job Search
Close

We’re sorry!

There are currently no open positions in your location or accepting applications from out of the country

Return to Home
Close
X
Cookies help us improve your website experience.
By using our website, you agree to our use of cookies.
Confirm