Senior Data Modeler BI in Washington, DC

[vaibhav yadav]

*CareFirst in Washington, DC*

 Skype hire...

I need candidates before COB today and I need the RTR for them as well.



[image: https://ssl.gstatic.com/ui/v1/icons/mail/images/cleardot.gif]



*Requisition732– Senior Data Modeler BI*



*Background:*

The focus of these positions is to define and promote *Access Layer
(semantic) design*by making the Integration and Access Layers usable for
the business, hence aiming for a simple structures that supports
self-service BI initiatives and future BI developments.





*Responsibilities:*

1. 1.  Rapidly *developing dimensional models* or analytical data
sets based on specific business requirements. Experience in ER -
dimensional model design and *implementation of STAR and SNOWFLAKE schemas* is
a must.

2. 3.  Transform Logical Data Models into Physical Data Design for
theIBM DB2 database, for the both the Integration and Access Layers in the
three tier architecture.

3. 4.  Engage with Data Architects, Directors and Business Users to
understand *data access paths*and business use.

4. 5.  Apply *appropriate Denormalization* and *Audit Balance* and
Control columns.

5. 6.  Perform data profiling, and *business rules investigations* on
source data, to ensure correct design of the Integration and Access layers.

6. 7.  Map and *document data transformations* of data from a
business terms perspective.

7. 8.  Support project delivery teams in *assessing their resource
needs* to deliver the Integration and Access layers.

2. Work with the Architecture and Governance team to *set strategy
*for *conformed
dimensions*, and*enterprise hierarchy*etc.

*Required Skills*

·  *Dimensional Modeling*

oo   At least 5 year hands on experience designing and implementing
Star Schemas

oo   At least 5 year experience implementing Data Warehouse
presentation layer - including design and definition of logical tables,
physical sources, dimensions, columns, aggregation rules

oo   At least 5 year experience in writing advanced SQL queries, views,
and optimization of SQL queries

oo   Comprehensive Knowledge of Ralph Kimball’s Data Modeling Concepts
including Transaction dimensions, conformed dimensions and facts, slowly
changing dimension, multi-Star/ Snowflake Schema Modeling, different types
of Fact tables

oo   Implementing a virtual semantic layer (virtual star schema) using
views on a multi-tiered normalized Integrated Operational Data Store is a
huge plus



·  *3NF (Relational) Logical and Physical Modeling*

oo   This position is not focused on 3NF data modeling but experience
with 3NF models is required

oo   At least 2 year hands on experience with 3NF Data Modeling and
NORMALIZED schema

oo   Comprehensive Knowledge of Bill Inmon’s Data Modeling Concepts
(Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction,
Associative entities / tables

oo   Experience with IBM DB2 Physical Modeling and Performance Tuning

o*Business Intelligence*

§  o   This position is not focused on BI platform but rather on the data
platforms, but experience with BI platforms is required

§  o   Hands-on experience with BI application architecture and development

§  o   Hands-on experience in designing technical architecture,
installation and configuration of BI Stack components

§  o   Extensive knowledge in Presentation layer such as MOLAP, ROLAP,
HOLAP, Ad-hoc reports.

§  o   Experience creating mockup reports, demo, & storyline a plus

§  Proven ability to work in a team environment

§  Thrives in an environment of changing priorities

§  Excellent problem solving and critical thinking skills.



*Software & Tools:*

*MS Word, PowerPoint, Outlook Excel, Visio, HP ALM, Adobe Acrobat, ERWIN*







*Thanks & Regards Vaibhav Kumar*



* Sourceinfotech Inc. **3840, Park Avenue, Suite C-205, Edison, NJ-08820*

*EMAIL: **vaib...@sourceinfotech.com* <vaib...@sourceinfotech.com>
* Phone: **609-917-3451*
*| Fax: 732-909-2282 | Gtalk: vvyadu23 Certified Minority Business
Enterprise - MBE*

*Disclaimer:*  If you are not interested in receiving our e-mails then
please reply with a "REMOVE" in the subject line at
rem...@sourceinfotech.com for automatic removal. And mention all the e-mail
addresses to be removed with any e-mail addresses, which might be diverting
the e-mails to you. We are sorry for the inconvenience.

-- 
You received this message because you are subscribed to the Google Groups 
"Companies Looking for IT Out Staffing & Recruitment" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to arunsinh+unsubscr...@googlegroups.com.
To post to this group, send email to arunsinh@googlegroups.com.
Visit this group at https://groups.google.com/group/arunsinh.
For more options, visit https://groups.google.com/d/optout.

Senior Data Modeler

[amit bhatt]

Data Modeler

Franklin, TN



*Rate MAX $43/HR*



*Mandatory Skills*



· 8 years of experience as a SSIS/BI and focused on data modelling

· Able to effectively engage business users to define analytics and
reporting needs

· Strong experience in building and evolving models following
Kimball or Inmon approaches

· Detailed data analysis and translation of business needs into
logical and physical data models

· Advanced SQL and performance tuning experience

· Design and build efficient ETL/ELT processes

· Ability to work effectively in development team



*Desired Skills*



1.  Experience with Healthcare data modelling

2.   Experience with large data sets (excess of 1 billion row tables)

3.   Experience with OLAP technologies such as cubes

4.   Experience with MPP technologies

5.   Experience with data modelling tools

6.   Experience with Agile development methodology



*JOB RESPONSIBILITIES*



· Responsible for working with business users to understand the
business and effectively translate to efficient data warehouse model.

· Responsible for building, maintaining, and integrating
dimensional models and guiding development teams to effectively load and
maintain high levels of data quality, load and query performance.

· Responsible for insuring data dictionaries and other meta data
elements are properly maintained

· Responsible to educate technical teams on defined models

Responsible for proactively identifying issues, solving problems, and
driving process efficiencies



*Thanks & Regards…*

*RK*

*Business Development Manager*

*Email : r...@systematix-software.com *

*Phone: 616-433-1771*

-- 
You received this message because you are subscribed to the Google Groups 
"Companies Looking for IT Out Staffing & Recruitment" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to arunsinh+unsubscr...@googlegroups.com.
To post to this group, send email to arunsinh@googlegroups.com.
Visit this group at https://groups.google.com/group/arunsinh.
For more options, visit https://groups.google.com/d/optout.

SENIOR DATA MODELER||Stamford, CT||WWE HQ ||F2F

[Meenu Yadav]

*SENIOR DATA MODELER*

*T + F*

*Client:: **WWE HQ*

   - *Location: *Stamford, CT
   - *Duration: *6 months with opportunity to extend
   - *MUST HAVE SKILLS: *
  -




*Need a person with experience doing: 1) Enterprise data warehouse
  dimensional modeling 2) Enterprise data warehouse relational modeling 3)
  Stakeholder requirements gathering and excellent communications 4) Using
  big data such as Google Analytics Big Query or Twitter as a data
source 5)
  Decent Big Data knowledge*



The Sr. Data Modeler will work closely with project teams to understand
business requirements and provide data modeling subject matter expertise.
Strong quantitative and analytic skills are required

This position is for Data Engineering and Analytics Solutions organization.
Our primary partner for whom we have to model the data is our Data
Analytics team. We deal with structured, unstructured and streaming data.

*Our Environment:*

*All our work is done on Cloud (AWS)*

*BI Platform:*

   - Database – RedShift
   - ETL – Informatica
   - BI – Cognos
   - Data Visualization – Tableau
   - Data Modeling – Erwin

*Big Data Platform:*

   - Data Stores - S3, HDFS
   - Database - RedShift, NoSQL (not decided yet)
   - ETL - Pig, Hive
   - BI, Data Viz - Cognos, Tablea

*Mandatory Skills and Experience*

   - Develop logical and physical data models
   - Experience working closely with business users in understanding the
   data, business requirements and converting them into logical models.
   - *5+ years of data modeling and metadata management experience.*
   - Experience with both relational and dimensional data modelling
   - Experience having designed and involved in building large data
   warehouses or data marts
   - Experience with data management standards and data model practices
   - Experience in one or more the data modeling tools - *ERWin or
   ER/Studio*
   - Experience in one or more relational database systems - *Oracle or
   DB2. Preferred RedShift*
   - Have good conceptual understanding of how to model data in various
   databases including relational and *NoSQL*

*Preferred Skills & Experience*

   - Exposure or knowledge in data modeling in NoSQL databases like
   Key-Value databases, Document databases, etc.
   - Hive or Pig or any of the query languages in Hadoop environment.
   - Preferred if has understanding of database concepts, Normalization
   rules, relational algebra






*Regards, Meenu Yadav*



*IT-Technical Recruiter Source Infotech Inc. **3840 Park Avenue, Suite
C-205, Edison, NJ-08820*

*Phone#: 609-608-0466|| Fax: 732-909-2282 || Email: *
*mya...@sourceinfotech.com* <mya...@sourceinfotech.com>

*--*

*Disclaimer: *Under Bill s.1618 Title III passed by the 105th U.S. Congress
this mail cannot be considered Spam as long as we include contact
information and a remove link for removal from our mailing list. To be
removed from our mailing list, reply with remove in the subject heading and
your email address in the body. Include complete address and domain to be
removed. Pursuant to Federal law, if you do not wish to receive future
email messages from us, please reply with "remove" to the same id.

-- 
You received this message because you are subscribed to the Google Groups 
"Companies Looking for IT Out Staffing & Recruitment" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to arunsinh+unsubscr...@googlegroups.com.
To post to this group, send email to arunsinh@googlegroups.com.
Visit this group at https://groups.google.com/group/arunsinh.
For more options, visit https://groups.google.com/d/optout.

Urgent Rek : Senior Data Modeler at Richmond, VA - Local to VA - F2F needed

[Shailesh Recruiter]

*Senior Data Modeler at Richmond, VA*

PLEASE SEND MATCHING RESUMES TO shail...@swarkysolutions.com OR
shailesh.recrui...@gmail.com

Stongly prefer people located near Richmond, VA and can interview in
person!!!***

Senior Data Modeler
Richmond, VA

Proposed individual is expected to:

Understand and translate business needs into data models supporting
long-term solutions
Organize work sessions with business and IT teams to understand sources of
data
Plan for collection, data cleansing, and normalization of enterprise data
to support decision making and reporting
Develop modeling policies and procedures to support ongoing and new systems
to ensure integrity of the data
Coordinate data models, dictionaries, and other data documentation across
multiple applications
Work with data transformation teams to ensure that the model design and
development is properly communicated

Required Skills:

8+ years of experience in database technologies and data design
5+ years of experience in relational and dimensional structures for large
operational, analytical, warehouse and BI systems
Skilled in data profiling
Excellent communicator and be able to produce clear and concise
documentation at the detail and summary level
Skilled in Embarcadero ERStudio or similar data modeling tool
Strong SQL experience in SQL Server or similar database environment
Must be an independent worker and be able to prioritize own work activities
with minimal guidance and coaching in a fast paced dynamic environment
Must meet deadlines

Additional Preferred Skills:

Experience with large, complex, cross-functional applications
An aptitude for fast learning, and the ability to work well in a team
environment
Retirement, Pension or Accounting industry experience

Thanks & Regards
Shailesh
Swarky Solutions, MN
shail...@swarkysolutions.com

-- 
You received this message because you are subscribed to the Google Groups 
"Companies Looking for IT Out Staffing & Recruitment" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to arunsinh+unsubscr...@googlegroups.com.
To post to this group, send email to arunsinh@googlegroups.com.
Visit this group at https://groups.google.com/group/arunsinh.
For more options, visit https://groups.google.com/d/optout.

10157-1 : Direct Client Requirement : Senior Data Modeler : NJ : 6 Months

[Sanju Malhotra]

*Hi Business Partners,
*

Please find the *requirements below* and respond with updated resume and
contact details of your consultant to *san...@essit.com*. Thanks a lot

*Resumes with the following information will be given preference.

Full Name:* *
Current Location:
Relocation:
Availability:
Work Authorization in US:
Contact Number:
Email:
Rate on C2C:
(Please Mention Employer details with contact person, contact no E-mail ID)

Please ensure all candidates have all skills listed under Required Skills
on their resume.*



*Req No: 10157-1*

*Job Tittle: **Senior Data Modeler *

*Location : Somerset, NJ
*

*Duration : 6 Months
*

*Job Summary: *

Analyzes complex business requirements, translate them to data requirements
and develop conceptual, logical and physical data models. Identify and
promote best practices and reuse patterns across all Line of Businesses.

Manages planning, organizing and implementing multiple and complex data and
information design projects.

*Functional Responsibilities: *

Devises standards and processes for the group. Creates architectural blue
prints to enable understanding of high level business requirements.
Understands and incorporates industry standards into enterprise
architectural guidelines.

Manages and resolves multiple design priorities with various customers
efficiently. Tool evaluation and work with vendor for new functionality
based on enterprise requirements.

Project planning activities in support of AD efforts. Partners with AD to
ensure best design solutions for most efficient use of data. Develops and
implements data modeling standards and best practices, including re-use
across the application portfolios.

Prepares status reports on project work and workplan progress. Ensures that
relational designs and dimensional databases performs effectively and
efficiently, conceptually, logically and physically.

Provides expert knowledge in working with* CA ERWIN CASE tool. *Effectively
maintains all artifacts associated with supported applications.

*Financial knowledge and atleast 5 yrs experience* : Buy side asset classes
_ Derivatives, equities and Mortgages.

Data Modeling expertise : *Erwin 8*

At least *2 years experience with data warehousing.*

Bachelors degree preferred. In lieu of a degree, equivalent years of
relevant experience will be considered.

Experience working with an on-shore/off-shore model.
*
Supervisory Responsibilities: *

Lead and motivates project team members that are not direct reports, as well
as providing work direction to lower-level staff members

Strong communication skills, both, in written  verbal formats.


MUST HAVE AT LEAST 5 YEARS. DATA MODELER EXPERIENCE
MUST HAVE PRIOR FINANCIAL/WALL STREET INDUSTRY BACKGROUND




Thanks  Regards,
*Sanjay Aryan Malhotra,*
IT Recruiter.
*_*
*
* *Enterprise Software Solutions ,INC.,*
*(732) 839-1549* office,
*(732) 572-7404* fax.
Official Email ID : san...@essit.com
Gmail ID : sanjay.es...@gmail.com
Yahoo ID : sanjay_es...@yahoo.com
Please visit us at http://www.essit.com
Consultant's Linkedin Contact :
http://in.linkedin.com/pub/sanju-aryan-malhotra/3a/a05/91b (for
Consultant's)
Employee Linkedin Contact :
http://in.linkedin.com/pub/sanjay-aryan-malhotra/30/217/39a (for my
vendor's)
(G)

-- 
You received this message because you are subscribed to the Google Groups 
Companies Looking for IT Out Staffing  Recruitment group.
To post to this group, send email to arunsinh@googlegroups.com.
To unsubscribe from this group, send email to 
arunsinh+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/arunsinh?hl=en.