Purpose:
Model, design and implement advanced Data Warehouse database schema designs, such as star and snowflake schemas, and constellations to support project requirements.
Job Function:
Review data architectures and designs of source application systems and the target Data Warehouse /Marts
Manage and maintain a data warehouse environment, including delta load processing and designing Metadata constructs.
Advocate data quality and the necessity of clean and accurate data to ensure Business Metric integrity.
Participate in the development and documentation of standards within the department, especially technical standards, and be able to clearly communicate those standards.
Assist in determining and identifying risks in existing and/or proposed reporting database and data warehouse/mart designs.
Actively work with customer representatives to determine analytical reporting needs, perform data analysis tasks and troubleshoot complex problems and propose optimal resolutions.
Responsible for recommending optimal data warehouse / mart schema designs.
Basic Qualification:
Experience with dimensional data modeling at an enterprise level.
Expert level experience in ERWin 4.x data modeling
Expert knowledge of Kimball and Inmon methodologies
Experience and/or working knowledge of SAP, Oracle, SQL Server, DB2 and UDB 9.x.
Familiarity with, DB2 Connect & UNIX AIX Scripting preferred
Familiarity with Informatica and cognos
Additional Information:
At least four (5) years experience in data warehouse data modeling on an enterprise scale is required. The candidate must be a self-starter with excellent decision-making, problem solving, and technical writing skills, and be able to work independently while maintaining good communication with co-workers for team oriented approaches.
Expert level experience in ERWin 4.x data modeling
Additional InformationLong term contract.
Skills Required
- Dimensional data modeling at an enterprise level
- Expert level experience in ERWin 4.x data modeling
- Expert knowledge of Kimball and Inmon methodologies
- Experience and/or working knowledge of SAP, Oracle, SQL Server, DB2 and UDB 9.x
- Familiarity with DB2 Connect & UNIX AIX scripting
- Familiarity with Informatica and Cognos
- At least 4-5 years experience in enterprise data warehouse data modeling
- Self-starter with excellent decision-making, problem solving, and technical writing skills
- Ability to work independently while maintaining good communication with co-workers
What We Do
Atria Group LLC, also operating as Atria IT, is a specialized IT staffing and consulting firm headquartered in Plano, Texas. The company provides comprehensive workforce solutions, including staffing, consulting, software development, and training services, specializing in enterprise solutions for small to medium-sized businesses. Their primary objective is to assist these enterprises in maximizing their IT resources to meet evolving technological challenges.
