Data Architect (ETL - Erwin Data Modeler)
5 - 7 years experience • Engineering Services
Job Title: Data Architect (ETL - Erwin Data Modeler)
Job Location: Bridgeport, CT
Job Type: Full Time / Direct Hire / Permanent Hire
This position is responsible for medium to high complexity data modeling, mining and warehouse initiatives for a whole domain(s).
In addition, this position utilizes business and domain knowledge to obtain business requirements from end users, design solutions and document and communicate the solution for both business and technical audiences.
• Acts as data tech lead on data centric projects.
• Works on multiple concurrent projects guiding a team of architects.
• Works in a consultative manner with end users to gather Data Modeling Requirements, Define Modeling needs, design Solutions, recommend proper analytical methodologies, and execute projects.
• Develops Statistical Models, Data-Driven Analyses, and Relational, Informational and Operational Models from start to finish with the help of Erwin.
• Utilizes Complex Data Mining Techniques and queries to gather business intelligence in regard to data acquisitions and conversions to support the organization’s business and growth initiatives.
• Writes ETL Development Specifications and Prototype SQL to prove Data Transformation.
• Coordinates Data Models across Marts and Warehouses; manages dictionaries and other documentation across multiple Data Marts and Data Warehouses.
• Creates and documents Data Management Best Practices, Strategy and Standards.
• Produces detailed work while keeping the Data Warehouse big picture and direction under consideration.
• Helps mentor junior level team members on best data architecture practices.
• Adheres to compliance procedures and internal/operational risk controls in accordance with any and all applicable regulatory standards, requirements, and policies.
• College degree or equivalent work experience.
• 5-7 years of relevant experience.
• 7 years IT experience.
• 3-5 years Data Modeling/Warehouse and Data Transmigration experience.
• 2+ Years of Experience with Statistical Models, Data-Driven Analyses, and Relational, Informational and Operational Models from start to finish with the help of Erwin.