9063 BI Data Architect

Location: Washington, DC, United States
Date Posted: 08-01-2017
BI Data Architect 
Term - Full time permanent position (No VISA sponsorship or Transfer)

• Advanced understanding of data integration, data virtualization, data federation, and database design techniques
• Advanced knowledge of dimensional modeling, modeling for reporting applications, normalization techniques, forward-engineering, and reverse-engineering techniques
• In-depth understanding and practical expertise with regards to structured system development methodologies
• Advanced knowledge of designing multidimensional databases
• Knowledge of various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)
• ETL experience with Informatica
 
Programming Languages: PL/SQL
Database: Oracle 10g/11g, Microsoft SQL Server 2008 and above
Operating Systems: Unix, Linux
Design Language: UML, Visio, Erwin 7.3x and above
Tools: Informatica 9.0.x – Power Center, IDQ, MDM, Composite Software 6x
Essential Job Functions:
• Consult, facilitate understanding and translate data requirements into logical, physical and semantic layer models across the analytical data environment.
• Ensure data structures are designed for flexibility to support future business needs.
• Profile and analyze source system data to determine data relationships, design constructs, consistency and quality.
• Ensure that data designs follow architectural best practices and appropriate business rules
• Facilitate data integration, conformity, data quality, integrity and consolidation
• Be an advocate for best practices while balancing business value and reasonable practicality
• Create and Maintain critical data documentation and metadata that allows data to be understood and leveraged as a shared asset.
• Set the strategy and repeatable process for maintaining the Enterprise Data model using automated tools.
• Analyze and evaluate data definition and modeling environment providing key recommendations for improvement. Assist in defining data modeling standards, and foundational best practices.
 
 
Educational Qualifications and Experience:
• Education: Bachelor’s degree in Computer Science or Engineering
• Role Specific Experience: 6+ years of years of hands-on data modeling expertise for relational databases – both for logical and physical data models
• Experience with building and maintaining physical and logical database models in Erwin
• 5+ years of experience in ERWIN (7.x and above) and Oracle 10.x/11.x. PL/SQL programming
• Extensive experience in various development methodology like Agile/Scrum development methodology
• Experience in Data/Web Services Technology , ETL tools preferably Informatica
 
 
Required Skills/Abilities:
• Advanced understanding of data integration, data virtualization, data federation, and database design techniques
• Advanced knowledge of dimensional modeling, modeling for reporting applications, normalization techniques, forward-engineering, and reverse-engineering techniques
• In-depth understanding and practical expertise with regards to structured system development methodologies
• Advanced knowledge of designing multidimensional databases
• Knowledge of various process modeling techniques (activity hierarchy diagrams, data flow diagrams, sequence diagrams, workflow diagrams, system interface diagrams)
• High level of creativity and lateral thinking
• Excellent communication, writing/documentation and facilitation skills
• Ability to juggle multiple tasks in a fast-paced environment
• Strong diplomatic, interpersonal, and teamwork skills
• Proficiency in the following technologies:
 
Programming Languages: PL/SQL
Database: Oracle 10g/11g, Microsoft SQL Server 2008 and above
Operating Systems: Unix, Linux
Design Language: UML, Visio, Erwin 7.3x and above
Tools: Informatica 9.0.x – Power Center, IDQ, MDM, Composite Software 6x
 
Desired Skills/Abilities (not required but a plus):
• Global development experience
• ETL experience with Informatica
 
If you are interested for this job, share your profile on priya@reqroute.com
For more job details reach me 408-300-9063 (PST)

Priya Shinde
408-300-9063 (PST)
priya@reqroute.com
 
Companies across U.S. have engaged ReqRoute, Inc to deliver skilled, dedicated IT professionals. Recruiting is our passion and we support Fortune 1000 companies with their hiring needs. We always seek to deliver competitive and sought-after career opportunities to our potential consultants and employees. We invite you to review the position requirements and apply today if your skills match our needs.  
 
ReqRoute, Inc is an Equal Opportunity Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, disability, military status, national origin or any other characteristic protected under federal, state, or applicable local law. (www.reqroute.com)
or
this job portal is powered by CATS