Senior Database Analyst

COGENT DATA SOLUTIONS LLC; Austin (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

COGENT DATA SOLUTIONS LLC in Austin, TX seeks a Senior Database & Data Warehouse Analyst to lead design, development, and governance of data warehouses and BI reporting.

You will work in a hybrid environment with stakeholders across IT and business, applying DW modeling (star/snowflake), ETL tools, and reporting platforms.

Candidates should have 5+ years of experience with DBMS, Data Warehousing, Business Objects, and data population, delivering reliable analytic solutions.

Qualifications

• 5+ years of experience with DBMS, data warehousing, and decision support tools.
• 5+ years building data warehouses and data marts.
• 5+ years using Business Objects and creating data dictionaries.
• 5+ years using database access tools for delivery.
• 5+ years in analysis, planning, and management reporting.
• 5+ years in data warehouse population and modeling (star/snowflake/normalized).
• 5+ years GUI-based ETL tools (Informatica, DataStage) experience.
• 5+ years implementing enterprise databases (Teradata, Oracle, SQL Server).
• 5+ years with analytic/reporting tools (Business Objects, Cognos, Hyperion, MicroStrategy).
• 5+ years across DW implementation lifecycle (requirements, modeling, transformation, loading, SQL, tools).
• 5+ years database performance, tuning, security, backup/recovery, DR.
• 5+ years of excellent analytical, problem-solving, communication, teamwork, interpersonal skills.
• 5+ years working with stakeholders while managing multiple responsibilities.
• 5+ years with database standards, data integrity, redundancy control, and security.
• Working knowledge of EIR Accessibility standards and assistive tech for DW interfaces.

Skills

DBMS

Data Warehousing

Decision Support

Data Marts

Business Objects

Data Dictionaries

Data Access Tools

Analysis & Reporting

Data Modeling

Star Schema

Snowflake Schema

ETL Tools

Informatica

DataStage

Teradata

Oracle

SQL Server

BI Reporting

Stakeholder Management

Tools

Informatica

IBM WebSphere DataStage

Teradata

Oracle Database

SQL Server

Power BI

Job description

Role: Senior Database & Data Warehouse Analyst

Location: Austin, TX – Hybrid

Required

• 5+ years of strong experience with Database Management Systems (DBMS), Data Warehousing, and Decision Support tools.
• 5+ years of experience developing, implementing, and maintaining Data Warehouses and Data Marts.
• 5+ years of experience with Business Objects and building/maintaining Data Dictionaries.
• 5+ years of experience using Database Access Tools for application delivery.
• 5+ years of experience with analysis, planning, and management reporting functions.
• 5+ years of experience in Data Warehouse data population and data modeling, including Star Schema, Snowflake Schema, and normalized data models.
• 5+ years of experience with GUI-based ETL tools, such as Informatica, IBM WebSphere DataStage, or similar.
• 5+ years of implementation experience with enterprise databases such as Teradata, Oracle, SQL Server, or similar technologies.
• 5+ years of experience with analytical and reporting tools, such as Business Objects, Cognos, Hyperion, MicroStrategy, or similar.
• 5+ years of experience across the Data Warehouse implementation lifecycle, including business requirements, logical/physical modeling, data sourcing, transformation, data loading, SQL, and end-user tools.
• 5+ years of experience with database performance monitoring, tuning, benchmarking, security, backup/recovery, and disaster recovery.
• 5+ years of excellent analytical, problem-solving, communication, teamwork, and interpersonal skills.
• 5+ years of experience working effectively with technical and non-technical stakeholders while managing multiple responsibilities.
• 5+ years of experience with database standards, data integrity, redundancy control, and database security.
• Working knowledge of EIR Accessibility standards and assistive technologies, including accessibility for database administration, data input, viewing, and reporting interfaces.

Preferred

• 5+ years of experience with Oracle Database.
• 5+ years of experience creating Power BI reports.