Find Jobs
ETL/SQL Developer & Data Analyst
Eden Prairie, Minnesota
Contract to Hire Position
It appears that you have already applied to this job.
Applied on June 24, 2021
Job Id #46514 Posted March 26, 2021


Description

  • The individual will be accountable for successful design, development and delivery of SQL solutions within a SQL Server environment.
  • An ideal candidate will analyze, develop, validate and maintain processes for a Medicaid encounter batch processing system using data warehouse techniques.
  • Extract data from claims platforms and transform data Medicaid encounter processing using SSIS, SQL and stored procedures in a MS SQL Server environment.
  • Data will be loaded to an operational data store (ODS) integrated into a multi-dimensional model.

Job Description

  • Strong experience using SSIS as the ETL tool in a data warehouse environment.
  • Interact with end users and business analysts to understand requirements.
  • SQL Server development, including but not limited to stored procedures and views.
  • Designs and implements technology best practices, guidelines, and repeatable processes.
  • Creates data validation rules on source data to confirm the data has correct and/or expected values.
  • Performs data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, understanding of natural keys.

Minimum Qualifications

  • 5 years experience with health care provider, enrollment/eligibility and claims data
  • 2-5 years writing complex SQL queries
  • 2-5 years ETL - preferably SSIS
  • Proficient with star and snowflake schemas
  • Bachelor’s degree in computer science, MIS, accounting, finance or equivalent
  • Excellent analytical and problem-solving skills.
  • Experience with behavioral health Medicaid data in multiple claims platforms is a plus
  • Experience with ANSI X12 837, 835 and 277 is a plus
  • Experience of Visual Studio .Net is a plus
  • Experience with Tableau, SSRS or other BI reporting tools is a plus.
  • Ability to adapt to different projects and assignments quickly.
  • Team player with strong communication skills

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.

Upload Your Resume

We accept .DOC, .DOCX, .PDF up to 10 MB.

We do not accept scanned documents, images, or resumes containing images and/or icons.

Password must contain:
  • minimum 10 characters

  • 1 uppercase letter

  • 1 lowercase letter

  • 1 numeric character

  • 1 special character (such as !, %, @, #)

  • Passwords match

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