SQL Programmer (Remote Job)

Job Detail

• Job Code 11124 25
• Tax Term W2 Hourly1099
• Career Level Mid Level
• Experience 6 Years
• US Work Status US Citizen
• Job Duration 10 Months
• Qualifications Bachelor's Degree

Job Description

Excelraise, LLC is a leading provider of full-service IT solutions and a talent management company headquartered in Denver, CO. At Excelraise, we specialize in IT staffing solutions tailored for government and federal clients across the USA.

Excelraise, LLC values your referrals! Refer qualified candidates for our open Job Postings and earn a generous REFERRAL BONUS for successful placements. Submit referrals here: Excelraise Referral Program.

Excelraise, LLC is seeking an SQL Programmer (Remote Job) for our client in Salem, OR.

***This is 100% Remote Job***

***Remote work/Telecommuting will be contingent upon the key person providing their own adequate office equipment and connectivity***

OIS/OHA are seeking a SQL programmer to help modernize our ETL process for a reporting data mart names HAL (Health Analytics Library). This work anticipates development of an ETL that will have continuity as we move data marts into the Azure cloud-based servers from on-prem VM servers. Contractor’s Key Person under this WOC will closely with internal data management staff to identify scope of programming to update and update progress. The programmer will work with internal program staff to facilitate introductions with data owners and work team meetings.

• Perform analysis of HAL data system as needed, which may include reviewing documentation and analyzing current HAL system/ environment, including data models, schemas and tables, data dictionaries, ETL’s, system and database management processes, data quality, security, queries, reporting environment.
• Work with OHA project team members (PM, BAs, DBAs, data analysts, architects), HAL management and HAL users to identify/ determine business/technical requirements.
• Gather and document detailed system, data and integration requirements for HAL system improvements (e.g. changes to ETL code, business rules, HAL tables, new or updated OHG Medicaid claim code grouping categories, etc.)
• Design, develop and implement new ETL code/ packages.
• Migrate existing ETL process built in legacy SAS coding to Microsoft Structured Query Language (“SQL”) stack language/ stored procedures, by:
  • Woking with various program areas and business teams to make code as modular as possible.
  • Reviewing and analyzing existing ETL SAS programming code to update to new SQL language/ procedures
  • Developing new SQL stack / stored procedures programming code to create new ETL processes.
  • Test, troubleshoot and implement the new ETL code in the HAL test and production environments.

Required skills and experience:

• SQL programming
• Advanced Data Analysis skills.
• Data Warehousing
• Microsoft SQL Server
• Microsoft Office
• Experience using Microsoft DevOps or other code management tools.
• Experience with SAS data management.
• Good communication skills

Required skills