17 Etl Developer jobs in Austin

ETL Developer
Hybrid 2 days a week onsite in Austin, TX (Candidates are required to already live here so not willing to relocate)
Interview - there are 2, first is video, 2nd is in person REQUIRED
Rate $70hr ctc
Visas - h4 ead, USC, GC/GC EAD
multi year

Job Description

Duties and Responsibilities
Essential Functions:
• Performs advanced ETL development work on data primarily residing in SQL Server
• Translates rules provided by PeopleSoft developers (Oracle based) into efficient T-SQL scripts to load data into the target database on SQL Server
• Troubleshoots, supports and maintains the ETL processes developed by the team
• Designs, deploys, and manages standardized, centralized data sources
• Helps to establish best practices for development, testing, migration and error handling of the ETL activities
• Performs other duties as assigned

Other Duties and Responsibilities:
• May interact with outside vendors

Essential Work Behaviors:
• Impeccable written and oral communication
• Communicates respectfully and works harmoniously with all co-workers, customers, and vendors.
• Provides exceptional customer service.
• Is flexible; able to work under pressure and; able to adapt to change; and able to work on multiple problems and tasks.
• Takes initiative to prevent and solve problems.

Qualification Requirements
Education/Special Requirements:
• Bachelor's degree in computer science, engineering, or related business field.

Experience and Training
• Three (3) years of hands on experience in T-SQL and SSIS/SSMS development
• Three (3) years of hands on experience in ETL development
• Three (3) years of hands on experience moving and manipulating large data sets

Preferred Qualifications
• Experience in health/life insurance, accounting and financials, or investment data related activities
• Experience with data tools (i.e. Visual Studio, SSIS, MSSQL )
• Experience with Azure and agile iterations
• Experience with ERP applications (i.e. PeopleSoft, etc.)

Knowledge, Skills and Abilities
• Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.
• Experience with PeopleSoft HRMS or Finance packages preferred
• Experience with ERD Modeling & Maintenance
• Knowledge of RDBMS architecture and troubleshooting is desirable.
• Knowledge of data mining methods

Requires in-office work. Please submit resumes only for candidates who are currently based in Austin.

JOB DESCRIPTION

Job Summary

The Azure ETL Developer is tasked with designing and developing Azure Data Factory solutions, covering projects of moderate to high complexity. This position also necessitates proficiency in Microsoft SSIS ETL solutions to support the architecture, development, and migration of legacy solutions to Azure Data Factory. Candidates should possess three to five years of experience with the Microsoft ETL stack, including experience in SSIS, SSRS, T-SQL, and Azure Data Factory. Furthermore, the role requires a comprehensive understanding of emerging technologies and the capability to design, research, and implement innovative solutions.

Knowledge/Skills/Abilities

• Proven ability to architect and develop solutions which perform data transformations using Azure Data Factory

• Strong knowledge of SQL Server, SSIS and t-SQL, preferably on Azure and/or SQL 2016+ Design and develop SQL Server stored procedures, functions, views and triggers

• Design, implement and maintain SQL database objects (tables, views, indexes) and database security

• Debug and tune existing SSIS/ETL processes to ensure accurate and efficient movement of processed data

• Collaborate with Product Owners to elicit and document business requirements for ETL and report design.

• Ability to translate business requirements into sound technical specifications

• Research issues and sets up proof of concept tests

• Support quality acceptance testing which includes the development and/or refinement of test plans

• Lead design review session with scrum team to validate requirements

• Troubleshoot data quality issues and defects to determine root cause

• 5+ years ETL development experience with 1-3 years utilizing Azure Data Factory

• Experience working with Azure SQL Database, DevOps, GIT and Continual Integration (CI)

• Knowledge and/or experience of the Agile framework and working in a scrum team

• Familiarity with healthcare data and concepts

• Familiarity with QNXT

• Excellent analytical and problem-solving abilities

• Strong written and oral communication skills

Required Education

Bachelor's Degree or equivalent combination of education and experience

To all current Molina employees: If you are interested in applying for this position, please apply through the intranet job listing.

Molina Healthcare offers a competitive benefits and compensation package. Molina Healthcare is an Equal Opportunity Employer (EOE) M/F/D/V.

Pay Range: $77,969 - $155,508 / ANNUAL

*Actual compensation may vary from posting based on geographic location, work experience, education and/or skill level.

Overview

We are seeking a detail-oriented and experienced ETL Developer to design, build, and maintain robust data pipelines that power our data infrastructure. This role is critical in ensuring data integrity, optimizing data flow, and supporting the business with actionable, reliable data insights. You will have hands-on experience with SQL Server, including performance tuning and database design. You will collaborate with cross-functional teams to solve complex data challenges and implement innovative solutions that align with our enterprise data governance and compliance standards, including HIPAA.

This position will be a fully remote position located in the United States.

Responsibilities

This role is responsible for developing and maintaining efficient, scalable ETL pipelines to support the integration and transformation of data from diverse sources into target systems. It includes designing and optimizing SQL Server databases, writing complex T-SQL queries and stored procedures, and ensuring high performance, data accuracy, and maintainability.

• Support ongoing ETL operations and ensure secure, compliant administration of data systems in alignment with enterprise data governance.

• Collaborate with internal teams to translate business needs into technical solutions and ETL requirements.

• Adhere to organizational procedures, including source control, release/deployment, and change management protocols.

• Conduct QA testing, troubleshooting, and validation to ensure pipeline accuracy and data integrity.

• Identify, design, and implement process improvements, including automation and optimization for scalability and performance.

• Assist IT teams in developing tracking tools for data usage, user activity, and SQL performance to inform product and process enhancements.

• Perform root cause analysis for data issues and suggest actionable improvements.

• Create and maintain thorough data documentation such as data dictionaries, ERDs, and data maps.

• Ensure compliance with all applicable regulatory requirements, including HIPAA.

• Work closely with Executive and Product teams to support their data needs and resolve technical issues.

• Partner with data analytics professionals to enhance functionality, governance, and user experience in our data systems.

• Handle sensitive data, including Electronic Protected Health Information (PHI), with appropriate care and confidentiality.

• Develop and maintain scalable and efficient ETL pipelines for extracting, transforming, and loading data from various sources into target systems.

• Build and maintain SQL Server databases, including schema design, indexing strategies, and stored procedure development to support data processing and reporting needs.

• Write and optimize complex T-SQL queries, stored procedures, and functions to ensure high performance, accuracy, and maintainability of database operations.

Qualifications

Required Skills and Experience

• Bachelor's degree in Computer Science, Information Systems, or related field, with 5 - 8 years of experience. (or commensurate experience)

• 5+ years of hands-on experience in relational databases and SQL querying.

• 3+ years working in an Agile environment.

• 3+ years of experience working in an Enterprise Data Warehouse environment.

• Proficient with enterprise data integration tools (Azure Data Factory preferred).

• Strong understanding of data warehouse architecture and cloud-based infrastructure.

• Experience in performance tuning of SQL queries and ETL pipelines.

• Experience with Azure DevOps and/or GitHub for version control, CI/CD pipeline automation, and release management

• Solid understanding of ETL best practices.

• Must be highly organized with strong attention to detail.

• Able to thrive in both team and independent environments with minimal supervision.

Clearance Required: Ability to obtain and maintain a Suitability/Public Trust clearance.

Preferred Skills and Experience

• Experience with healthcare data and familiarity with HIPAA compliance.

• Familiarity with data governance frameworks and best practices.

• VA Data Analytic experience preferred.

Company Overview

GovCIO is a team of transformers--people who are passionate about transforming government IT. Every day, we make a positive impact by delivering innovative IT services and solutions that improve how government agencies operate and serve our citizens.

But we can't do it alone. We need great people to help us do great things - for our customers, our culture, and our ability to attract other great people. We are changing the face of government IT and building a workforce that fuels this mission. Are you ready to be a transformer?

What You Can Expect

Interview & Hiring Process

If you are selected to move forward through the process, here's what you canexpect:

• During the Interview Process

• Virtual video interview conducted via video with the hiring manager and/or team

• Camera must be on

• A valid photo ID must be presented during each interview

• During the Hiring Process

• Enhanced Biometrics ID verification screening

• Background check, to include:

• Criminal history (past 7 years)

• Verification of your highest level of education

• Verification of your employment history (past 7 years), based on information provided in your application

Employee Perks

At GovCIO, we consistently hear that meaningful work and a collaborative team environment are two of the top reasons our employees enjoy working here. In addition, our employees have access to a range of perks and benefits to support their personal and professional well-being, beyond the standard company offered health benefits, including:

• Employee Assistance Program (EAP)

• Corporate Discounts

• Learning & Development platform, to include certification preparation content

• Training, Education and Certification Assistance*

• Referral Bonus Program

• Internal Mobility Program

• Pet Insurance

• Flexible Work Environment

*Available to full-time employees

Our employees' unique talents and contributions are the driving force behind our success in supporting our customers, which ultimately fuels the success of our company. Join us and be a part of a culture that invests in its people and prioritizes continuous enhancement of the employee experience.

We are an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender, gender identity or expression, sexual orientation, national origin, disability, or status as a protected veteran. EOE, including disability/vets.

Posted Pay Range

The posted pay range, if referenced, reflects the range expected for this position at the commencement of employment, however, base pay offered may vary depending on multiple individualized factors, including market location, job-related knowledge, skills, education, experience, and internal equity. The total compensation package for this position may also include other compensation elements, to be discussed during the hiring process. If hired, employee will be in an "at-will position" and the GovCIO reserves the right to modify base salary (as well as any other discretionary payment or compensation program) at any time, including for reasons related to individual performance, GovCIO or individual department/team performance, and market factors.

Posted Salary Range

USD $118,000.00 - USD $122,000.00 /Yr.

Submit a referral to this job (

Location US-Remote

ID 2025-6180

Category Information Technology

Position Type Full-Time

Job Title: Graph (Neo4j) and ETL Developer Job ID: 2023-12156 Job Location: Austin, TX; Morris Plains, NJ Job Travel Location(s): 0% # Positions: 1 Employment Type: W2 Candidate Constraints: Duration:Long Term # of Layers:0 Work Eligibility:All Work Authorizations are Permitted Key Technology: Graph database (Neo4j) experience and its query language (Cypher) Job Responsibilities: Work with ETL, data warehousing and graph database software to store and organize Graph data Secure and timely delivery of Graph data / use case results to consuming applications and user communities Ensure that databases meet user requirements. Develop archiving procedures for old and expired transactions / data Participate in sprint planning sessions and help TPOs Skills and Experience Required: 10+ years of strong Graph database (Neo4j) experience and its query language (Cypher) Should be able to demonstrate graph data loads pipelines from Hadoop Proven skills on Python, PyArrow and Spark/Scala Hands on experience on SQL/In-memory databases and automation of ETL Strong knowledge on Hadoop, Neo4j and PyArrow technologies Strong development experience on Hadoop file formats and organizing warehouse data Strong exposure to Graph nodes/edges and relations Strong experience on DevOps pipeline implementation Healthcare domain knowledge is plus Good Understanding of spark/Hadoop eco system including YARN responsibilities Should have great debugging skills on Hadoop spark/graph Excellent thinker with exceptional problem solving skills Should have strong communication and interpersonal skills Good exposure to Agile development process Excellent query optimization skills and provide inputs of required keys for better performance improvement. #J-18808-Ljbffr

LeanDNA is helping solve the $150B problem that global manufacturers face-excess inventory tying up critical working capital and keeping manufacturing companies from being as efficient as they need to be. Without an effective way to optimize inventory, manufacturers are buying too much, too little, or placing inventory in the wrong place at the wrong time. Companies are stuck fighting operational fires related to critical inventory shortages, creating delays in delivering their product to customers on time.

LeanDNA's factory inventory optimization and shortage management solution quickly empowers supply chain professionals to dramatically reduce excess inventory, deliver on time, and establish operational command of their organization's inventory operations. LeanDNA optimizes the inventory management process by adding the much-needed (and much-appreciated) artificial intelligence into the forgotten area of the business: The factory. It's not just about smart inventory planning-true optimization occurs when procurement leaders have command over the operation, and the supply chain teams tasked with bringing those plans to life have total visibility, AI-driven recommendations, and a clear game plan for hitting their inventory goals every time.

The SeniorData Integration team at LeanDNA is responsible for integrating customer data with the LeanDNA cloud solution. Senior Data Integration Engineers ensure we are getting high quality and current data from the source systems, and that this data is reliably uploaded to the cloud in a uniform format that can be consumed by the LeanDNA analytics and reporting engines. This role is essential in helping LeanDNA customers quickly and successfully utilize our cloud-based Supply Chain Analytics solution to drive results for their businesses.

The ideal candidate would possess several skill sets including proficiency with data technologies and SQL, passion for data analytics, and excellent communication skills. You will be working alongside (and at times, onsite) with customer IT staff and business analysts to retrieve customer data and understand the customer's data structures and semantics. You will use your data analytics and SQL capabilities to transform the data and upload it to the LeanDNA cloud solution. You will be working with the LeanDNA Customer Success team to ensure that the data is of the highest possible quality, and with the LeanDNA Engineering team to integrate into the LeanDNA data pipeline. This is a fantastic role for a data geek with awesome skills for someone that wants to jump into an extremely fast-cycle deployment world. Your energy and enthusiasm to work and grow alongside our high-trajectory team are essential!

Responsibilities:

• Perform initial data integration with new customers, and maintain the data extraction and transformation processes
• Build and maintain processes to extract data from various sources, transform it into a usable format, and load it into databases / data lakes
• Automate workflows and improve existing processes for better performance and efficiency
• Integrate data from systems such as APIs, databases, ERPs web services, third-party platforms, and more
• Manage data quality by identifying and resolving data issues, ensuring consistency, completeness, and accuracy
• Act as the primary technical point of contact for a group of customers
• Analyze customer data to ensure accuracy and to help the customer achieve their goals (inventory reduction, shortage prevention)

• Proficiency in languages like Python, Java or SQL
• Experience with relational and NoSQL databases
• Experience with cloud data infrastructure on AWS or Azure
• Collaborate effectively with cross-functional teams, including software engineers, customer success and product managers
• Continuously monitor and improve the data pipeline to ensure efficiency and reusability

• Bachelor's or Master's degree in Computer Science, Engineering, Data Science, or a related field
• Previous experience in a data engineering role or a related position involving data management, extraction and analysis
• Ability to learn systems and business processes quickly
• Experience with ERP systems and other business systems
• Advanced SQL skills
• Proficiency with data pipeline engineering
• Strong understanding of data design principles
• Ability to explain technical concepts to non-technical stakeholders

• Strong knowledge of supply chain processes
• Familiarity with DevOps practices, including CI/CD pipelines