Senior Data Warehouse Developer/DBA
Client: State of Texas
Location: Austin, Texas
Experience: 12+ Years Required
Work Arrangement: Hybrid – 2 Days Remote / 3 Days Onsite
Onsite Days: Wednesday, Thursday & Friday
Candidate Location: Texas Candidates Only
Client Type: State of Texas
Position Overview
The State of Texas is seeking an experienced Senior Data Warehouse Developer/DBA with strong hands-on expertise in Enterprise Data Warehousing, Data Marts, Data Modeling, ETL, Snowflake, Oracle, SQL, Business Objects, and Power BI.
The ideal candidate will have extensive experience designing, developing, implementing, maintaining, and supporting enterprise-class data warehouse environments and business intelligence solutions.
Key Responsibilities
- Design, develop, implement, and maintain Enterprise Data Warehouse (EDW) solutions.
- Design, develop, and maintain Data Marts to support business reporting and analytical requirements.
- Develop and maintain data warehouse population and data integration processes.
- Analyze business and technical requirements and translate them into effective data warehouse solutions.
- Develop logical and physical data models based on business and technical requirements.
- Design and implement Star Schema, Snowflake Schema, and highly normalized data models.
- Develop and maintain ETL processes for extracting, transforming, and loading data from multiple source systems.
- Utilize Informatica, IBM WebSphere DataStage, or similar ETL tools for enterprise data integration.
- Perform data extraction, transformation, validation, cleansing, and loading activities.
- Work with Snowflake and enterprise database environments to support data warehouse and analytical solutions.
- Develop and optimize complex Oracle SQL queries, procedures, and database objects.
- Support enterprise-class databases such as Oracle, Snowflake, SQL Server, Teradata, or similar technologies.
- Develop and maintain reporting and analytical solutions using Business Objects and Power BI.
- Support BI platforms such as Cognos, Hyperion, MicroStrategy, or similar reporting technologies.
- Build and maintain data dictionaries, metadata, business definitions, and technical documentation.
- Analyze data warehouse performance, data quality, and integration issues and coordinate appropriate resolutions.
- Participate in the complete data warehouse implementation lifecycle, including requirements analysis, logical modeling, physical database design, data sourcing, transformation, loading, SQL development, and reporting.
- Collaborate with technical and non-technical stakeholders to understand business requirements and deliver effective data solutions.
- Perform data analysis and validation to ensure accuracy, consistency, completeness, and reliability of enterprise data.
- Support troubleshooting, root-cause analysis, performance optimization, and production issue resolution.
- Manage multiple priorities while working effectively with cross-functional teams.
- Communicate technical concepts and analytical findings clearly to both technical and business audiences.
Minimum Required Technical Skills
Data Warehousing & Data Marts
- Enterprise Data Warehouse development, implementation, and maintenance
- Data Mart design and management
- Data warehouse population
- Data integration
Data Modeling
- Star Schema
- Snowflake Schema
- Highly Normalized Data Models
- Logical Data Modeling
- Physical Data Modeling
ETL / Data Integration
- Informatica
- IBM WebSphere DataStage or similar ETL tools
- Data extraction
- Data transformation
- Data loading
- ETL workflow development and support
Database Technologies
- Snowflake
- Oracle Database
- SQL
- Enterprise-class database environments
- Database design and implementation
BI & Reporting
- Business Objects
- Power BI
- Cognos
- Hyperion
- MicroStrategy
- Similar enterprise reporting and analytical tools
Additional Qualifications
- Strong analytical and problem-solving skills.
- Excellent written and verbal communication skills.
- Strong teamwork and interpersonal skills.
- Ability to work effectively with technical and non-technical stakeholders.
- Ability to manage multiple responsibilities and priorities.
- Strong understanding of data warehouse implementation methodologies.
- Experience with database and SQL performance analysis.
- Ability to document technical solutions, data structures, and business requirements.
Ideal Candidate Profile
The ideal candidate should have 12+ years of experience and strong hands-on expertise across the following technology stack:
Snowflake + Data Warehousing + Data Modeling + ETL + Informatica/DataStage + Oracle + SQL + Business Objects + Power BI
Candidates should also demonstrate strong experience with enterprise data warehouse implementations, data marts, database technologies, BI/reporting platforms, data integration, and analytical solutions.
Work Location & Schedule
📍 Austin, Texas
Hybrid Schedule:
🏠 Monday: Remote
🏠 Tuesday: Remote
🏢 Wednesday: Onsite – Austin, TX
🏢 Thursday: Onsite – Austin, TX
🏢 Friday: Onsite – Austin, TX
⚠️ TEXAS CANDIDATES ONLY
Candidates must currently reside in Texas and must be able to work onsite in Austin, TX every Wednesday, Thursday, and Friday.
Please submit candidates who can meet the required hybrid schedule and possess the required data warehouse, ETL, database, and BI experience.
Never miss an opportunity! Create an alert based on the job you applied for.