ETL Developer – SQL, Python, SAS

<br /> <span><span><span><b>Job Title:</b> <strong>ETL Developer –SQL, Python, SAS</strong><br /> <b>Duration:</b> 8 Months<br /> <b>Location:</b> Salem, OR – <strong>Remote</strong></span></span></span><br /> <br /> <span><span><span><b>Key Skills:</b> <strong>Legacy SAS,</strong> <strong>SQL Programming, ETL, Python, Advanced Data Analysis, DevOps, GIT, Microsoft Office</strong></span></span></span><br /> <br /> <span><span><span>We are seeking a ETL Developer to modernize ETL processes for a Medicaid analytical and reporting data mart. The work includes converting existing ETL processes, developing new SQL/Python-based solutions, and preparing for future cloud migrations (AWS → Azure).</span></span></span><br /> <span><span><span>The data mart supports Medicaid analytics and reporting, integrating claims and enrollment data from the state’s Medicaid management and information system. Analysts also access data through a Medicaid data warehouse and decision support environment, which stores raw transactional data. The data mart enhances this information with analytical groupings for easier reporting and analysis.</span></span></span><br /> <br /> <span><span><span><b>Primary Responsibilities:</b></span></span></span> <ul> <li><span><span><span><span>Analyze existing data mart systems, including data models, schemas, ETLs, and reporting environment.</span></span></span></span></li> <li><span><span><span><span>Collaborate with project teams, management, and end users to gather business/technical requirements.</span></span></span></span></li> <li><span><span><span><span>Document system, data, and integration requirements for improvements.</span></span></span></span></li> <li><span><span><span><span>Design, develop, and implement new ETL code/packages.</span></span></span></span></li> <li><span><span><span><span>Migrate ETL processes from SAS to SQL/Python stored procedures, ensuring modular design.</span></span></span></span></li> <li><span><span><span><span>Review, update, and test new SQL-based ETL processes in development and production environments.</span></span></span></span></li> </ul> <br /> <span><span><span><b>Required Skills &amp; Experience:</b></span></span></span> <ol> <li><span><span><span><strong>Advanced SQL Development</strong> – 7–10+ years in SQL programming and Microsoft SQL Server, including stored procedures and complex ETL logic.</span></span></span></li> <li><span><span><span><strong>ETL Process Modernization</strong> – Migration from legacy SAS to SQL/Python, modular code design, and performance optimization.</span></span></span></li> <li><span><span><span><strong>Python Programming</strong> – 7–10+ years of experience for data processing, automation, and integration.</span></span></span></li> <li><span><span><span><strong>Healthcare/Medicaid Data Expertise</strong> – Understanding of claims, enrollment, eligibility, and national coding standards.</span></span></span></li> <li><span><span><span><strong>Data Warehousing</strong> – Experience designing and maintaining analytical data environments and reporting data marts.</span></span></span></li> <li><span><span><span><strong>Version Control &amp; DevOps Tools </strong>– Proficiency with Microsoft DevOps, GIT, or similar tools for code management.</span></span></span></li> <li><span><span><span><strong>Collaboration &amp; Communication</strong> – Ability to work with business teams, data owners, and technical staff in a government/public health setting.</span></span></span></li> </ol> <br />  Email your resume to<u>: </u><a href="mailto:usjobs@mavensoft.com">usjobs@mavensoft.com</a><br /> To learn more about Mavensoft visit us online at <a href="http://www.mavensoft.com/">http://www.mavensoft.com/</a><br /> <br />