urgent requirement for Sr Data Architect with our Direct Client In Charles Town, WV

Following is an urgent requirement for Sr Data Architect with our Direct Client  in Charles Town, WV . if you  have any resource available please send resume and contact details to Easwar@xperttech.com

 

 

---Sr Data Architect

---Mid Level Data Architect

Two roles, same job description. 3 month contracts.

Job Location

Charles Town, WV US (Approximately 45 minutes from DC\Balitmore\Northern Virginia)

 

 

looking for a Senior Data Architect. The Data Architect is responsible for analyzing data requirements and developing data models and designs for Client's Enterprise Data Warehouse. The individual in this role will translate business data requirements into logical and physical data models, will understand and apply the concepts of proper data modeling and database design, and gain a strong understanding of source data to ensure the design approach results in a logical and efficient data model to support the University's business Intelligence capabilities.

 

Essential Functions:

• Analyzes data requirements and develops dimensional data models to support data warehouse initiatives.
• Participates in database design discussions, collaborating with developers to ensure the database designs are accurate and that they support efficient reporting.
• Assists in the identification and resolution of inefficiencies in database designs and determines and implements solutions for database design problems.
• Validates database designs for accuracy and performance, identifying opportunities for indexing, partitioning, etc.
• Analyzes the impact of source system data design changes as they relate to the logical and physical data models and makes appropriate changes to existing data models.
• Performs analysis to prevent data redundancy across systems and employs data integration best practices.
• Develops and maintains data architecture and administration standards including standardization of table names, column names, data types, etc.  Enforces semantic consistency across the enterprise.
• Performs data profiling, understands source data, and models data to accommodate any nuances that may exist.
• Works with implementation team to ensure smooth deployment of data models and ensures resolution of outstanding issues.
• Employs an enterprise-wide approach to data architecture.
• Leads review and design walkthroughs.
• Mentors junior associates on the team.
• Performs other duties as assigned.

Work Environment and Physical Demands: 

• Standard office environment in Charles Town, WV.

 

Qualifications:

Required Skills

• Effective verbal and written communication skills.
• Excellent facilitation skills.
• Ability to work as part of a team and interact effectively with others.
• Problem solving and decision making ability.
• Ability to be flexible and think strategically in a rapidly changing environment.
• Ability to quickly digest information and understand the business.
• Displays willingness to accept responsibility, displays initiative, good judgment and positive attitude.
• Demonstrates competence, experience, knowledge, and understanding of data architecture and administration concepts, including dimensional modeling, star and snowflake schema design, and ETL concepts.

Required Experience

• Bachelor's degree in Information Science (or related field) or equivalent proven experience.
• Minimum of five years' experience in a professional development environment having participated in all facets of the software development life cycle. 
• Minimum of five years' information technology development and SQL experience.
• Minimum of five years' experience with ERwin, ER/Studio or similar data modeling tools.
• Experience with SQL Server or similar Relational Database Management System (RDBMS).
• Experience with SQL Server Integration Services (SSIS) or similar ETL tools.
• Experience developing/analyzing stored procedures and relational database programming.   
• Experience with education based ERP or similar products. 
• Experience modeling conforming dimensions and Type 2 (slowly changing dimension) data.
• Experience with MicroStrategy or similar Business Intelligence (BI) tools preferred.
• Experience in Higher Education preferred.

 

Warm Regards

Easwar Rao

Team Lead

400 W Cummings Park

Suite#2850

Woburn, MA-01801

Email:  Easwar@xperttech.com

Phone: 781-497-0039

Fax: 781-207-0709

--
You received this message because you are subscribed to the Google Groups "US_Jobs&Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to us_jobsnconsultants+unsubscribe@googlegroups.com.
To post to this group, send email to us_jobsnconsultants@googlegroups.com.
Visit this group at http://groups.google.com/group/us_jobsnconsultants?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.