Allied Consultants
Data Warehouse Consultant
Allied Consultants, Austin, TX
Overview
Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Warehouse Consultant to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.
Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check
Allied Consultants is an equal opportunities employer.
Responsibilities
M204 database experience desired but not required.
Qualifications
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years
Required/Preferred
Experience
7
Required
Extensive experience in using database access tools for application delivery, such as Informatica, or Oracle OCI
5
Required
Strong knowledge of database management systems, as well as data warehouse management and decision support tools
5
Required
Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
5
Required
Experience in business objects and in building the data dictionary
5
Required
Strong familiarity with analysis, planning and management reporting functions
5
Required
Well-developed oral and written communications skills
5
Required
Strong teamwork and interpersonal skills
5
Required
Extremely high level of analytical ability where problems are very unusual and extremely difficult
5
Required
Understanding of benchmarking processes and techniques
5
Required
Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output
5
Required
Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
5
Required
GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
5
Required
Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.
5
Required
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5
Required
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
5
Required
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5
Required
Excellent analytical; problem-solving; team playing; and oral and written communication skills.
5
Required
Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
7
Preferred
Informatica database tools
5
Preferred
Oracle Database experience
5
Preferred
SSRS report creation
Allied Consultants, Inc. is an Austin-based firm which has for 32 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Data Warehouse Consultant to be a key resource on a technical services team.
Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.
Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law. Offers of Employment are contingent on a successful background check
Allied Consultants is an equal opportunities employer.
Responsibilities
M204 database experience desired but not required.
Qualifications
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
Years
Required/Preferred
Experience
7
Required
Extensive experience in using database access tools for application delivery, such as Informatica, or Oracle OCI
5
Required
Strong knowledge of database management systems, as well as data warehouse management and decision support tools
5
Required
Extensive experience in the development, implementation and maintenance of data warehouses and data marts is desired
5
Required
Experience in business objects and in building the data dictionary
5
Required
Strong familiarity with analysis, planning and management reporting functions
5
Required
Well-developed oral and written communications skills
5
Required
Strong teamwork and interpersonal skills
5
Required
Extremely high level of analytical ability where problems are very unusual and extremely difficult
5
Required
Understanding of benchmarking processes and techniques
5
Required
Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output
5
Required
Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models
5
Required
GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools.
5
Required
Implementation experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies.
5
Required
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5
Required
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
5
Required
Implementation experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools.
5
Required
Excellent analytical; problem-solving; team playing; and oral and written communication skills.
5
Required
Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
7
Preferred
Informatica database tools
5
Preferred
Oracle Database experience
5
Preferred
SSRS report creation