HI,
Sr Data Architect
Mid Level Data Architect
3 month contracts.
Job Location
Charles Town, WV US (Approximately 45 minutes from DC\Baltimore\Northern Virginia) *
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.
Nagesh Gona
400 W Cummings Park
Suite#2850
Woburn, MA-01801
Email: nagesh@xperttech.com
Phone: 781-898-2018
Fax: 978-405-5040
You received this message because you are subscribed to the Google Groups "canada usa jobs" group.
To unsubscribe from this group and stop receiving emails from it, send an email to canada-usa-jobs+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
No comments:
Post a Comment