Database​/ETL Administrator

Location & Work Authorization (Please Read First)
This role serves Texas counties and requires current residency in Texas.

This position is a hybrid role that requires working onsite in our downtown Austin office at least three days each week.

We’re a Texas nonprofit and not able to offer visa sponsorship (e.g., H‑1B, F‑1 OPT) now or in the future.

Applicants must be authorized to work in the U.S. without current or future sponsorship.

Position Overview Position works, with limited supervision, within TAC’s Data & Reporting team to support TAC’s business intelligence (BI) efforts of converting data to information and ultimately knowledge for internal and external stakeholders. Responsible for developing solutions to respond to reporting requirements including modeling of target data structures, extraction, transformation and loading of data, creating business metadata, and presentation of data to develop static and interactive reporting, dashboards, pixel-perfect and subscription-based reports as needed.

Serves to establish and support a central repository in reporting and data administration within TAC.Essential Job Functions Design data infrastructure to extract and organize data for authorized individuals to access. Identify TAC’s internal and external data sources, collaborating with department SMEs to determine their data storage and organizational needs and using the information to create and maintain data infrastructure for internal users.

SQL Server Database Administrator which involves database maintenance, tuning, upgrades and problem solving.

Contribute to the creation, maintenance and expansion of the conceptual and logical enterprise data models using modern techniques and methods for data warehousing data mart OLAP systems. Integrating new data source as required by business needs.

Develop database solutions to store and retrieve TAC’s data. Support the whole data pipeline creation and successful executions: starting from row data, through structuring data and pushing it to Data Warehouse, Operational Data Store (ODS) and Dashboards. Migrate data from legacy systems to new solutions. Responsible for the entire lifecycle of extract, transform and load (ETL) pipelines creation and maintenance from the concept to PROD release including data analysis and requirement elicitation, implementing data pipelines, testing, gathering and migrating code.

Convert business needs into data and system requirements, algin business processes with IT systems and manage the flow of data and information within TAC. Understand the logic behind the queries, with relation to the business cases. Working with key stakeholders to understand what data element is valuable for business to represented on the dashboard. Develop presentation layer objects that present data in a manner that is easily understandable to business users for report creation, with the intention of BI self-service within the current analytics package or via a connector.

Maintains TAC databases, through administration and support including, but not limited to, upgrades, patching, etc.

Analyzes business needs and develops requirements (alone or in collaboration with a Business Systems/Intelligence Analyst) and prepares technical specifications based on those gathered requirements. As a partner and subject matter expert to the business, establish a mindset that data functions are an integral part of existing business processes, process modifications or process implementations.

Perform additional job duties as assigned.

Experience / Education Requirements Bachelor’s degree in computer science, management information systems, mathematics, computer and information management or related area required.

A minimum of five years’ technical experience accessing enterprise data sources and developing enterprise reporting required.

Experience and proficiency in insurance, government or financial industries preferred.

Other Skills & Abilities Must demonstrate understanding of data warehouse concepts, software quality assurance testing, and the software development life cycle process.

Strong technical knowledge of the following tools/software applications: SQL…