This job listing has expired and the position may no longer be open for hire.

Sr Software Engineer at Horizontal Talent

Posted in Other 30+ days ago.

Location: Minnetonka, Minnesota





Job Description:

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.



More jobs in Minnetonka, Minnesota


Volunteers of America - National Services

Volunteers of America - National Services

Volunteers of America - National Services
More jobs in Other


Eurofins

Eurofins

Eurofins