Database Administrator 2

Bestica Inc.; Austin (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Bestica Inc. is seeking a data warehousing specialist to design, implement, and maintain enterprise data warehouse solutions.

The role involves working with large databases, data marts, and ETL processes to support decision-making and reporting across the organization. The ideal candidate has deep experience with ETL tools (Informatica, DataStage), relational databases (Teradata, Oracle, SQL Server), and BI platforms (Business Objects, Cognos, Hyperion, MicroStrategy).

Qualifications

• Experience building and maintaining data warehouses and data marts.
• Strong SQL and data modeling skills.
• Familiarity with benchmarking processes.
• Excellent communication and teamwork abilities.

Responsibilities

• Lead data warehouse implementation from requirements through deployment.
• Collaborate with technical and non-technical teams to deliver reporting solutions.

Skills

Database management

Data warehousing

Decision support

Data analysis

Communication skills

Teamwork

Tools

Informatica

IBM WebSphere DataStage

Teradata

Oracle

SQL Server

Business Objects

Cognos

Hyperion

MicroStrategy

Job description

• Strong knowledge of database management systems, as well as data warehouse management and decision support tools
• Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
• Experience in business objects and in building the data dictionary
• Ability to use data base access tools for application delivery
• Strong familiarity with analysis, planning and management reporting functions
• Well-developed oral and written communications skills
• Strong teamwork and interpersonal skills
• Extremely high level of analytical ability where problems are very unusual and extremely difficult
• Understanding of benchmarking processes and techniques
• Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output
• Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
• GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
• Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.
• Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
• Experience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL pe
• Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
• Excellent analytical; problem-solving; team playing; and oral and written communication skills.
• Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.