Demo
Salary Resume Critique Job Openings

SQL Developer - ETL

Mavensoft Technologies, LLC.
Salem, OR Full Time
POSTED ON 2/17/2025
AVAILABLE BEFORE 5/14/2025

Job Title :  SQL Developer - ETL

Duration :  10 months (Contract W2)

Location :   Salem, OR (Hybrid)

Key Skills : SQL Programming Expertise, Advanced Data Analysis Skills, Experience with ETL Processes, Collaboration & Communication Skills.

Job Description

Seeking an experienced SQL Programmer to assist in modernizing the ETL (Extract, Transform, Load) process for the Health Analytics Library (HAL), a critical Medicaid analytics and reporting database solution. This role will focus on reprogramming existing SAS ETL code into SQL, helping to prepare HAL for migration to the Azure cloud environment. This contractor will collaborate closely with internal data management teams to ensure the continued development of HAL's capabilities and improve its overall functionality.

Key Responsibilities :

  • ETL Analysis & Development : Analyze the current HAL system, including data models, schemas, tables, and ETL processes. Design, develop, and implement new SQL-based ETL processes to replace the legacy SAS code.
  • Collaborative Requirements Gathering : Work closely with OHA’s Medicaid Analytics and Data Integration (MADI) Unit, internal project teams (PM, BAs, DBAs, data analysts, architects), and HAL users to determine business and technical requirements for system improvements.
  • Code Migration : Migrate legacy SAS-based ETL code to SQL language, ensuring smooth transition and optimization. Develop SQL stack / stored procedure code to create new ETL processes and improve the system’s overall functionality.
  • System & Data Integration Requirements : Gather and document detailed system, data, and integration requirements for improvements to the HAL data logic, including updates to Medicaid claim code grouping categories and other analytical improvements.
  • Testing & Troubleshooting : Test, troubleshoot, and implement newly developed ETL code in both test and production environments.
  • Documentation : Document all technical processes, including new ETL programming, system integration steps, and improvements made to the HAL data environment.

Required Skills & Experience :

  • SQL Programming : Extensive experience with SQL programming, including the development of stored procedures and ETL processes.
  • Advanced Data Analysis : Strong skills in data analysis, with the ability to identify trends, issues, and areas for improvement in large datasets.
  • Code Management Tools : Familiarity with Microsoft DevOps or other code management tools.
  • Communication : Strong verbal and written communication skills, with the ability to interact effectively with both technical and non-technical stakeholders.

    • Preferred Qualifications :

  • Experience with SAS Data Management : Knowledge of or experience with SAS programming, especially related to ETL processes and data analysis.
  • Medicaid Data Knowledge : Familiarity with Medicaid administrative data, including medical claims and enrollment data, is a plus.
  • Problem-Solving : Ability to think critically and creatively to develop solutions that enhance system capabilities and meet business needs.

    • Education & Certifications :

  • Required : Full-time professional work experience in Information Technology.
  • Substitutions : Accredited college training may substitute for up to four (4) years of required experience (15 semester hours in Information Technology or related areas). Graduate training may substitute for up to two (2) years.
  • Certification : Successful completion of an Information Technology certification program may substitute for up to two (2) years of work experience.

    • Email your resume to :   usjobs@mavensoft.com

    To learn more about Mavensoft visit us online at  http : / / www.mavensoft.com /

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a SQL Developer - ETL?

    Sign up to receive alerts about other jobs on the SQL Developer - ETL career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $151,182 - $194,086
    Income Estimation: 
    $190,942 - $250,988
    Income Estimation: 
    $91,609 - $116,575
    Income Estimation: 
    $115,838 - $142,817
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $114,981 - $143,201
    Income Estimation: 
    $129,640 - $165,363
    Income Estimation: 
    $68,745 - $88,154
    Income Estimation: 
    $87,428 - $116,878
    Income Estimation: 
    $91,609 - $116,575
    Employees: Get a Salary Increase
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Mavensoft Technologies, LLC.

    Project Portfolio Manager - Monday.com (Part Time)
    Mavensoft Technologies, LLC.
    Hired Organization Address Golden, CO Part Time
    Job Title : Project Portfolio Manager - Monday.com (Part Time) Duration: 3-6 months (contract likely to extend) Location...
    Sr. AWS Solutions Architect
    Mavensoft Technologies, LLC.
    Hired Organization Address Portland, OR Full Time
    Role: Sr. AWS Solutions Architect Duration: 6 Months (Contract) W2 Location: Portland, OR (Hybrid) We are seeking a skil...
    IT Finance Specialist
    Mavensoft Technologies, LLC.
    Hired Organization Address Atlanta, GA Full Time
    Role: IT Finance Specialist Duration: 5 Months (Contract) W2 Location: Atlanta, GA (Onsite) Description The IT Finance S...
    Business Process Analyst - Water and Gas Operations
    Mavensoft Technologies, LLC.
    Hired Organization Address Richmond, VA Full Time
    Job Title : Business Process Analyst - Water and Gas Operations Duration: 16-18 months (contract-only) Location: Richmon...
    View More Jobs at Mavensoft Technologies, LLC.

    Not the job you're looking for? Here are some other SQL Developer - ETL jobs in the Salem, OR area that may be a better fit.

    Microsoft SQL Server ETL Developer

    Vector Consulting, Inc, Salem, OR

    ETL Developer

    Ruri Software Technologies LLC, Salem, OR

    View More Jobs

    AI Assistant is available now!

    Feel free to start your new journey!