Database Administrator: Data Warehouse & BI Specialist

Allied Consultants, Inc.; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Benefits offered by this job

Medical insurance

Life insurance

401(K) plan with company match

Flexible spending account

Job summary

Allied Consultants, Inc in Austin is seeking an experienced Database Administrator to lead production database management within a high-impact technical services team. The role requires deep knowledge of data warehousing, relational databases, SQL, and ETL tooling, with strong analytical and communication skills.

You will ensure data integrity, security, and disaster recovery for state agencies in Texas. Local clients include Texas State Agencies; Allied offers competitive pay and comprehensive

Qualifications

• Extensive experience building data warehouses and data marts.
• Strong knowledge of database management systems and data dictionaries.
• Experience with benchmarking and performance tuning.
• Ability to translate business requirements into data models.
• Excellent written and oral communication.

Responsibilities

• Develop and maintain databases for production systems.
• Direct programmers to modify DBMS and optimize performance.
• Ensure data integrity and security; implement disaster recovery.
• Collaborate with stakeholders to gather data element requirements.
• Benchmark, test, and document database standards.

Skills

Database management

Data warehousing

Data modeling

SQL

ETL tools

Business intelligence

Communication skills

Analytical ability

Tools

Informatica

IBM WebSphere DataStage

Teradata

Oracle

SQL Server

PowerBI

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

Allied Consultants, Inc in Austin is seeking an experienced Database Administrator to lead production database management within a high-impact technical services team. The role requires deep knowledge of data warehousing, relational databases, SQL, and ETL tooling, with strong analytical and communication skills.

You will ensure data integrity, security, and disaster recovery for state agencies in Texas. Local clients include Texas State Agencies; Allied offers competitive pay and comprehensive