Database Administrator/ETL & Data Integration Engineer

TX-HHSC-DSHS-DFPS•Austin, TX

7d•$7,015 - $11,500•Onsite

About The Position

This position is open to U.S. Citizens and permanent residents. This onsite role requires the selected candidate to work from an HHS office in Austin, Texas. The Database Administrator/ETL & Data Integration Engineer reports to the Regulatory Services, Long Term Care (LTC) Systems Architect/Supervisor. This position leads the data team and supports TULIP (Texas Unified Licensing Information Portal). This position performs day-to-day data-related operations and integration-related tasks to ensure the uninterrupted delivery of IT systems and services. The successful candidate should be able to work with minimal supervision.

Requirements

Knowledge of the principals, practices and techniques of database design and development, database structures and theories and current database technologies.
Knowledge of data analysis techniques.
Knowledge of relational databases (e.g., Oracle, SQL Server)
Knowledge of the principles, practices, and techniques of software development and the full software development life cycle (SDLC).
Knowledge of computer operations, systems, and procedures.
Skill in administering Oracle and/or MS SQL databases.
Skill in performing Extract, transform, and load (ETL).
Skill in SQL and scripting.
Skill in technical analysis and design, including database design and planning.
Skill in complex problem solving and critical thinking.
Ability to design and develop database systems based on customer requirements
Ability to coordinate the development and dissemination of technical content for a variety of users.
Ability to identify and analyze complex business problems and define user needs.
Ability to process information logically and perform detailed work accurately.
Ability to work independently and to meet deadlines.
Ability to manage and coordinate multiple activities in different projects.
8+ years of progressive experience in software application development, support and operations is required.

Nice To Haves

Salesforce and Azure Data Factory-related certifications are preferred.
5 plus years of ETL experience preferred.

Responsibilities

Designs, develops, and maintains enterprise-grade ETL/ELT pipelines using Azure Data Factory to move and transform data across databases, SFTP locations, APIs, and SaaS applications including Salesforce. Ensures data quality, reliability, and scalability of all pipeline workflows. Collaborates with data engineers, analysts, cloud architects, and business stakeholders to deliver robust data integration solutions that support organizational reporting and analytics needs.
Manages Salesforce data operations and Data Cloud configurations to ensure data integrity, platform performance, and alignment with business processes. Serves as the primary data resource for Salesforce-related data tasks including data quality, migrations, and integration with enterprise data systems. Designs and implements Salesforce Data Cloud interfaces for data ingestion, identity resolution, segmentation, and unified customer profiles.
Manages and maintains the enterprise data warehouse environment including Azure Synapse Analytics and Azure SQL databases. Ensures the warehouse is optimized for performance, availability, and scalability to support downstream analytics and reporting workloads. Coordinates with cloud architects and database administrators to enforce data standards and governance.
Develops, maintains, and publishes Tableau dashboards and integrates data visualizations with Salesforce and enterprise data sources to deliver actionable business intelligence to end users and leadership. Partners with business stakeholders to translate reporting requirements into scalable, interactive dashboards that drive data-informed decision making.
Leads the data team by providing technical direction, mentoring, and hands-on guidance to data engineers, DBAs, and analysts. Establishes team standards, promotes best practices, and fosters a culture of continuous learning. Serves as the subject matter expert and escalation point for the team across ADF pipelines, Salesforce data operations, warehouse management, and Tableau reporting.
Works with application teams, technical support staff, cloud architects, and contract staff to perform modifications and updates to existing data systems or to implement new data integration solutions. Identifies, investigates, and resolves production data issues and pipeline failures. May include analyzing problems, coding, testing, implementing solutions, and supporting technical staff and end users.