Sr. Data Modeler Job in Littleton 80129, Colorado US

Sr. Data Modeler

 

Location : Littleton, CO

 

Duration : 6-month contract-to-perm

 

This person needs to be a Sr. Level Data Modeler with experience Data Warehouse experience.  STRONG leadership and communication skills are a must for this position...not a heads down person. 

 

This individual will be a lead level contributor on the Business Intelligence/Data Warehousing (BI/DW) Modeling team. This individual will work in a team environment that is challenging and evolving and they will have input into the team’s BI/DW processes and standards.  This position requires that the individual lead efforts to gather and perform data modeling, data analysis and profiling,  participate in designing solutions, and supporting development as required.  

 

Required Qualifications:

•           5+ years of data modeling.

•           5+ years SQL and data analysis/profiling.     

•           5+ years experience implementing a BI/DW Infrastructure on a large scale: ETL, Data Warehouse, Data Marts, and Analytics.

•           Expert level understanding of modeling methodologies (3rd normal form - Bill Inmon, dimensional modeling – Ralph Kimball, ODS, etc.) and proper usage of modeling techniques.

•           Understands data normalization process (i.e., 1st – 3rd normal form) and the benefits of performing normalization. 

•           Expert level of dimensional modeling components (SCDs, degenerative dimensions, snow flakes, late arriving dimensional data, aggregates, etc.).

•           Expert level understanding of MDM and its role in a data warehousing environment.

•           Define the differences between OLTP and OLAP.  They should be able to have a clear understanding of data warehousing, reporting, OLAP (operational and general analytical reporting).

•           Expert knowledge of meta data components and the benefit meta data provides in a warehousing effort.

•           Knowledge in conceptual, logical and physical models.

•           Familiarity with ETL for data warehousing, data models to support ETL processes such as job controls, data quality efforts and auditing functions.

•           (Manager said this isn't technical a requirement, but they will naturally have some experience if they are the right type of candidate) Familiarity with reporting tools such as Business Objects, MicroStrategy, etc.

•           Provide input into data modeling best practices, templates and standards.

•           Knowledge in business requirements gathering.

•           Ability to map business requirements to data model.

•           Knowledge with modeling tools – ERwin preferred, as well as Oracle database.

•           Ability to perform some DB functions such as DDL generation as well as understanding reporting performance turning concepts and how they relate to building data models.

•           (this is actually a plus, not required) Some experience with IBM Telco DM

•           Ability to work multiple projects simultaneously requiring little direction.

•           Strong communication and leadership skills.

•           Ability to provide estimates.    

 

Other Qualifications:

•           Bachelor's degree in Computer Science, a related field or equivalent experience.

 

Qualified candidates must be authorized to work in the U.S. without sponsorship or transfer.

email-id : balaji@elenan.com / Contact no : 703-574-4951