Robert Half is in need of a Data Architect/ Data Modeler! We are seeking an individual with strong hands-on expertise in data modeling and data warehousing. The candidate will be responsible for data related aspects in projects, such as working with business partners to understand business information usage and future roadmaps and strategy, designing and developing data models, partnering with ETL and report developers to create and test solutions, and implementing data transformation and integration.
Analyze and document business data requirements and create functional/technical design documents and related documentation. Design and develop conceptual, logical, and physical level data models (both relational and dimensional). Ability to drive proper level of abstraction once explicit business entities are understood. Take iterative approach to modeling and determine what points of the model need flex (abstraction) versus what needs explicit fixed modeling. Additional responsibilities include source system analysis (understanding schemas, joins), data profiling of complex, under-documented systems, and source to target mapping (Physical to Logical, Logical to Physical). Data transformation and integration of relational/dimensional data models.
Business Intelligence and Data Warehousing (BI DW), Microsoft SQL Server, Oracle, Data Integration, ETL - Extract Transform Load
Bachelors Degree from a Four (4) year College or University; or six (6) to eight (8) years related experience and/or training; or equivalent combination of education and experience
8+ years of data modeling, data warehousing, business intelligence, schema & DB experience.
Extensive experience in Oracle, Microsoft SQL and other popular database systems
Experience in working on conceptual, logical, and physical data models using various Data Modeling tools. Erwin preferred.
Strong understanding in the principles of data warehousing using Fact Tables, Dimension Tables, star schema modeling and snowflake schema modeling, slowly changing dimensions, foreign key concepts, referential integrity
If this position looks like a good fit for your background, send your resume toASAP!
Robert Half Technology matches IT professionals with some of the best companies on a temporary, project or full-time basis. From roles in software and applications to IT infrastructure and operations, we provide you unparalleled access to exciting career opportunities. Our personalized approach, innovative matching technology and global network with local market expertise help you find the technology jobs that match your skills and priorities - fast. By working with us, you have access to challenging opportunities, competitive compensation and benefits, and training to enhance your skill sets.
From philanthropy to environmental stewardship to employee programs, Robert Half is proud to have an active role in the communities in which we live and work. Our company has appeared on FORTUNEs Most Admired Companies list every year since 1998.
Download our mobile app to take your job search on the go!
Contact your local Robert Half Technology office ator visit www.roberthalf.com/jobs/technology to apply for this job now or find out more about other job opportunities.
All applicants applying for U.S. job openings must be authorized to work in the United States. All applicants applying for Canadian job openings must be authorized to work in Canada.
2020 Robert Half Technology. An Equal Opportunity Employer M/F/Disability/Veterans.