Senior BI Data Analyst | Austin, TX (Hybrid) | Locals only

The candidate should have strong experience with enterprise databases, data warehouse/data mart development, ETL tools, SQL, and BI/reporting platforms.

## Key Responsibilities

* Design, develop, implement, and maintain data warehouses and data marts.

* Perform data modeling using Star Schema, Snowflake Schema, and normalized models.

* Develop and maintain database structures, data dictionaries, and data models.

* Build and maintain ETL/data integration processes.

* Work with Informatica, IBM DataStage, or similar ETL tools.

* Develop and optimize SQL queries and database processes.

* Work with enterprise databases such as Oracle, Teradata, or SQL Server.

* Support Business Objects, Cognos, Hyperion, MicroStrategy, Power BI, or similar reporting tools.

* Analyze business requirements and translate them into technical/data warehouse solutions.

* Support data sourcing, transformation, loading, reporting, and end-user requirements.

* Monitor database performance and recommend improvements.

* Perform data quality, integrity, security, backup, and recovery activities.

* Create test database environments and support application testing.

* Work with both technical and non-technical teams.

* Ensure database interfaces and reporting capabilities meet applicable accessibility standards.

## Required Skills

* 5+ years of experience in Data Warehousing / Database Management.

* Strong experience with Data Warehouse and Data Mart development.

* Strong Data Modeling experience.

* Experience with Star Schema, Snowflake Schema, and normalized data models.

* Strong SQL skills.

* Experience with ETL tools such as Informatica or IBM DataStage.

* Experience with enterprise databases such as Oracle, Teradata, or SQL Server.

* Experience with Business Objects, Cognos, Hyperion, MicroStrategy, or similar BI tools.

* Experience with data warehouse implementation from requirements through design, ETL, loading, and reporting.

* Strong analytical, problem-solving, communication, and teamwork skills.

## Preferred Skills

* Oracle Database

* Power BI Report Development

* Data Dictionary

* Database Performance Tuning

* Database Security and Recovery

* Accessibility / EIR Accessibility Standards

## Key Skills

Data Warehousing | Data Marts | Data Modeling | SQL | ETL | Informatica | DataStage | Oracle | Teradata | SQL Server | Business Objects | Cognos | Hyperion | MicroStrategy | Power BI | Database Management | Data Dictionary | Performance Tuning