EDW Data Architect/Data Architect Job in Stamford, Connecticut US
Company Overview:
ICONMA is a consulting firm, that provides professional staffing services and project based solutions for a broad range of Fortune 1000 companies. Our areas of expertise include Information Technology, Accounting/Finance, Engineering, and Professional. ICONMA has a nationwide presence that helps us support our national clients.
ICONMA has received numerous awards for delivering outstanding services and providing the highest standards of quality. We recently received the Bridge Award and the Silver Supplier Award from two of our major clients. We provide long and short term opportunities as well as contract to hire and direct hire opportunities. ICONMA offers Paid Vacation, Holidays, Personal Days, Medical and Dental, Life Insurance and 401K. We also have an AFLAC insurance program that allows our consultants to further personalize their coverage with a choice of selections that include long and short term disability, additional term life insurance.
We are currently looking to hire for one of our clients.
Description:
- EDW Data Architect will lead the design, enhancement and implementation of Enterprise Data Warehouse model (dimensional) catering to reporting and interface data requirements.
- This individual will work in partnership with key business stakeholders and peer teams to translate requirements into a flexible and scalable dimensional data model/repository.
- This individual will also architect and design the aggregate layers of the EDW repository.
- Translate business requirements into a flexible and scalable dimensional data model (Kimball Methodology)
- Design/enhance 3NF operational data stores
- Develop and/or improve a common data dictionary for business
- Manage data model using Erwin/Model Manager, use of naming file, domains, etc.
- Ensure compliance to documented IT standards
- Write SQL to explore source data, data quality issues, etc.
- Demonstrate working knowledge of Oracle performance tuning (e.g. indexing, partitioning)
- Demonstrate working knowledge of BI tools (e.g. Cognos)
- Engage early in the requirements gathering process by establishing rigor with Requirement and business teams
- Identify opportunities to reuse existing data structures to accommodate new business requirements
- Develop data mappings specifications capturing business rules and logic
- Coach data architects, BI architects, QA analysts on right usage of data and the dimensional model
- Manage and mentor junior staff
Required Skills:
- 8+ years experience as a dimensional Data Modeler, Data Architect in finance/banking/treasury-related business
- 7+ years experience with enterprise level data analysis and integration work and/or providing data focused systems integration solutions
- Must have multiple full lifecycle project experience in developing DW solutions as an architect and a leader
- Expert skills in identifying and capturing business rules and business requirements
- Ability to present highly technical concepts to a non-technical audience
- Ability to produce quality technical analysis covering data, data mapping and process mapping
- Working knowledge and experience with ETL (preferably Informatica) and BI tools (Cognos, etc.)
- Proficient in data modeling tools: ERWIN and Model Manager
- Strong understanding of relational dbs (Oracle, SQL Server etc.) and Oracle/db performance tuning concepts.
- Must have solid SQL skills and be able to perform data analysis
- Excellent interpersonal, written/verbal communication, and leadership skills with the ability to quickly build credibility, influence and make recommendations to all levels
- Strong organizational skills – ability to effectively manage multiple tasks simultaneously
- Ability to work in a dynamic, fast paced environment
- Must be a team player
Education:
- Four year college degree in computer science, information systems or finance, or equivalent work experience.
Satyen Sanghavi
Sr. Recruiter
ICONMA
Ph: (815) 355-8212
Fax: (800) 489-8046 or (248) 583-1929
Email: satyen@iconma.com
Website: www.iconma.com
