Access Control, Analysis Skills, Benchmarking, Communication Skills, Computer Security, Data Management, Data Mart, Data Migration, Data Modeling, Data Warehousing, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Management Software/Systems (DBMS), Database Programming, Database Technology, Decision Support, Documentation, Graphical User Interface (GUI), Hyperion, IBM Cognos, IBM WebSphere DataStage, Informatica, Information/Data Security (InfoSec), Interpersonal Skills, Management Reporting, MicroStrategy, Microsoft SQL Server, NCR Teradata, Oracle Database, Performance Analysis, Presentation/Verbal Skills, Problem Solving Skills, Procedure Implementation, Relational Databases (RDBMS), SAP BusinessObjects, SQL (Structured Query Language), SQL Server Reporting Services (SSRS), Snowflake Schema, Software Installation, Software Migration, Software Testing, Staff Motivation, Standards Development, Star Schema, Team Player, Writing Skills
Job Title: Data Warehouse Architect
Location: Austin, TX (Hybrid)
Duration: 6-12 Months
Job Description:
Supports the installation of database software and migrations to new data management system software levels, and tests the migrations to ensure data reliability and functionality.
Analyzes, designs, modifies, and maintains database structures.
Designs and implements procedures necessary to save, retrieve, and recover databases from hardware and software failures.
Establishes and implements database security controls and user access levels.
Evaluates and recommends database software packages for potential acquisition.
Prepares and develops database documentation, procedures, and definitions for data dictionaries.
Performs logical and physical data modeling, designs relational database models, and creates physical data models from logical data models.
Performs database performance monitoring and implements efficiency improvements.
Assists in modifying existing databases and database management systems.
Assists in developing standards, guidelines, policies, and procedures designed to ensure the integrity of the database environment.
Required Skills:
5 years of strong knowledge of database management systems, as well as data warehouse management and decision support tools
5 years of extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
5 years of experience in business objects and in building the data dictionary
5 years of experience ability to use data base access tools for application delivery
5 years of experience with strong familiarity with analysis, planning and management reporting functions
5 years experience with well-developed oral and written communications skills
5 years of strong teamwork and interpersonal skills
5 years of extremely high level of analytical ability where problems are very unusual and extremely difficult
5 years of understanding of benchmarking processes and techniques
5 years of very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output
5 years of Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
5 years of GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
5 years of implementation experience with enterprise-class databases, e.g., Teradata, Oracle, SQL Server, etc., or similar technologies. Teradata, Oracle, SQL Server, etc. or similar technologies.
5 years of Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5 years of experience with the 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.
5 years of Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5 years with excellent analytical, problem-solving, team-playing, and oral and written communication skills.
5 years of proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
Preferred Skills:
5 years of Oracle Database experience.
5 years with SSRS report creation.
1 year with M204 database experience.
Regards,
Himanshu Rawat
himanshu@carmansg.com