Job Title: Data Warehouse Architect
Job Location: Dayton, OH
Duration: 3+Months
Mode of Interview: Phone Then Skype
VISA:USC AND GC ONLY
Nature of Work:
· Help define, communicate, and govern the architecture for and implementation of the new SQL server EDW.
Top Required Skillsets:
· Deep SQL Server experience
· Data Warehousing Architecture
· Communication skills
Role and Responsibility:
· Define enterprise data architecture to meet overall needs of business, across analytic systems and services
· Maintain business information model and data flow architecture
· Define and refine data standards / reference architectures for use by specific project teams in developing technical designs
· Assess industry standards including HIPAA and ARRA for information models, and incorporate them into the company information architecture standards where appropriate
· Provide input into the Meta-Data strategy to describe and administer data, and provide data lineage tracking ability
· Develop and maintain data interoperability between source and target systems
· Participate in the translation of business requirements and models into feasible and acceptable data warehouse and semantic layer designs
· Design internal and external data interfaces to ensure that database development needs are according to CareSource standards, HIPAA ARRA
Education / Experience:
· Bachelor of Science degree in information technology, business intelligence or related field or equivalent years of relevant work experience is required
· Minimum of five (5) years actively engaged in data architecture and Business Intelligence architecture required
· Three (3) years of healthcare data and information management experience preferred
· Minimum of three (3) years of experience in a lead or supervisory role required
· Experience on large multi terabytes data warehouses required
Required Competencies / Knowledge / Skills:
· Expert level work experience in a TeraData environment and traditional relational databases
· Expert level working experience using TeraData Utilities (BTEQ, Fast Load, and TPump)
· Expert level SQL skills
· Completed several Business Intelligence project life-cycles
· Ability to deal with and resolve ambiguity
· Ability to anticipate problems and take decisive action
· Strong Experience with leading a team of people to deliver results
· Excellent communication, presentation and written skills
· Must be able to work effectively with both business and technical stakeholders
· Proven ability to design scalable solutions using traditional and agile method
· Strong knowledge of leading concepts in Data Quality, Master Data Management, Data Governance and Data Stewardship
· Knowledge of Systems Architecture principles and processes
· Knowledge of Business Intelligence tools and methodologies
· In depth knowledge of new techniques, models, processes, methodologies, and plans within architecture disciplines.
· Excellent understanding of industry standards and technology trends
Thanks & Regards,
Sarthak Bhatia | Team Lead Recruitment
Trail Blazer Consulting LLC | Tel: 914-274-6400* 106
Mail: 3541 9th Street, Apartment -1R, Astoria, NY 11106
sar...@trailblazerit.com | www.trailblazerit.com |
Gmail:sarthak.ramy|Skype:sarthak.bhatia75
Disclaimer: We respect your Online Privacy. This e-mail message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. If you are not interested in receiving our e-mails then please reply with a "REMOVE" in the subject line at rem...@trailblazerit.com and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the emails to you. We are sorry for the inconvenience.