
Open since May 2012
Data Modeler
AI Summary
Designs and implements enterprise data warehouse schemas, including star, snowflake, and constellation models, and manages data quality and metadata constructs.
About this role
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
Explore related jobs
More jobs at Atria Group LLC
Similar AIX Scripting jobs
- U
ETL Developer (Mid-level) --------------Need GC and USCUSM · Wilmington, DE - A
BO DeveloperAccionLabs · Singapore, Singapore - X
Power/AIX Automation Specialist (XIN001_HTYC )Xinnovit · Richmond, VA - S
IBM MQ (No H1B)Sonsoft Inc · Nashville, TN - U
AIX Administrator---Need localsUSM · Marlborough, MA - J
AIX AdministratorJobsbridge · Cupertino, CA
Jobs in Dallas
- S
Leasing Consultant - Stella ApartmentsSimpson Housing LLLP · Dallas, TX - F
Principal Mechanical / Piping EngineerFermi · Dallas, Texas - F
Principal Instrumentation & Controls EngineerFermi · Dallas, Texas - F
Principal Electrical EngineerFermi · Dallas, Texas - F
Principal Civil / Structural EngineerFermi · Dallas, Texas - E
Associate Territory ManagerElement Science · Dallas, Texas
Browse these categories
Market data for this role
All reports →- SeriesRole reportsOne role family at a time: how many openings, what changed this week, who is hiring, what it pays.
- SeriesSalary reportsWhat employers publish in job postings, by level and workplace. Not self-reported pay.
- Market overviewState of tech hiring, September 2026: up 4.8%Tech hiring rose 4.8% month over month in September 2026, with 411,122 new listings. Customer support and account executive roles led the growth.