Microsoft SQL Server ETL Developer
Our government client is looking for an experienced Microsoft SQL Server ETL Developer on a hybrid 12+ months renewable contract opportunity in Salem, OR.
Position: - Microsoft SQL Server ETL Developer
Job Description
The agency is 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.
The Agency Unit Wants To Launch a HAL Modernization Project To Analyze, Identify And Make Improvements To The HAL Analysis And Reporting Database Solution. This Project Has The Following Objectives
• Analyzing the existing HAL database solution and environment, identifying any refinements or rework to HAL architecture, dataflows, governance or management processes, and developing a roadmap for HAL future state.
• Reprogramming HAL ETL code, currently written in legacy SAS language, into SQL language, to prepare HAL for migrating to the agency cloud Azure environment (NOTE: The migration to the cloud, expected to occur in the next 1-2 years, is out of scope for this project and will require working with OIS and other agency teams)
• Gathering and documenting requirements, developing and testing other improvements to the HAL data logic, including:
• Updating claim data grouping categories used predominantly by the Office of Actuarial and Financial Analysis (OAFA) team for rate capitation analyses, to reflect updates Medicaid national coding standards
• Performing other coding improvements needed by OAFA team users and other HAL users to improve analytical value and capabilities of HAL data or reflect changes in Medicaid eligibility, program, beneficiary and claim administrative coding– these types of improvements have accumulated over time and have reached a point in which they require a focused project and dedicated resources.
Tasks
Contractor’s Key Person shall:
• 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 the agency 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:
o 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.
Skills
• SQL programming
• Advanced data analysis skills.
• Experience using Microsoft DevOps or other code management tools.
• Experience with SAS data management.
• Good communication skills
Covendis rate card description for an Application Systems Analysis/Programmer IV:
Full-time professional work experience in Information Technology.
Substitutions: Accredited college training may substitute for the required work experience with a maximum substitution of four (4) years. (Fifteen (15) semester hours in Information Technology or a related area is required.)
Accredited graduate training in the above area may substitute for the required work experience with a maximum substitution of two (2) years.
Successfully completion of an Information Technology Certification program, may substitute for the required work experience with a maximum substitution of two (2) years. (Proof of certification must accompany application.)
Two (2) years of work experience as an Application Systems Analysis/Programming-Specialist; Application Systems Analysis/Programming-Intermediate; Application Developer-Senior may substitute for all of the required experience.
Required/Desired Experience Skills Qualification Competency Skills Data Analysis Proficient (4-6 Years) Skills Data Warehousing Proficient (4-6 Years) Skills Microsoft SQL Server Advanced (7-9 Years) Skills SQL Advanced (7-9 Years) Skills Communication skills both verbal and written Proficient (4-6 Years) Skills MicrosoftOffice Proficient (4-6 Years)
About Vector
Vector Consulting, Inc., (Headquartered in Atlanta) is an IT Talent Acquisition Solutions firm committed to delivering results. Since our founding in 1990, we have been partnering with our customers, understanding their business, and developing solutions with a commitment to quality, reliability and value. Our continuing growth has been and continues to be built around successful relationships that are based on our organization's operating philosophy and commitment to
•
• People, Partnerships, Purpose and Performance - THE VECTOR WAY
“Celebrating 30 years of service.”
