Previous Job
Data Architect
Ref No.: 17-03135
Location: Naperville, Illinois
Position Type:Full Time
Pay Rate : $ 90,000.00 - 100,000.00 /Year
The Data Architect is responsible for the design of the data warehouse, which maps to the data warehouse architecture and balances the need for access, security, and performance. This position focuses on data warehousing, data modeling, and database design. This role will establish and implement the overall data management direction, provide strategic enterprise data vision (3-5 years out), and directing immediate data architecture initiatives. Additionally, the position will ensure the overall quality of implementations across multiple data domains including management, integration, quality, reporting, and analytics while supporting multiple business units, managers, and their teams. Lastly the architect will lead the design and integration of key data storage and systems that require fundamental change to the overall corporate data strategy and direction. 

Essential Functions: 

Experience in software and systems design and development, with working knowledge of database platforms, architectures, and application designs or relevant experience in technology infrastructure management. Extensive knowledge of information technology principles and practices. Knowledge of financial business and technology. ETL Development Unit and integration testing Analysis including Workflow & Efficiency Analysis System implementation Back-ups/Recovery Data Warehouse integrity/security Data modeling and architecture Participate in project scope definition, data architecture development and project planning with other members of the Business Intelligence team. Create design pattern templates for deliverable objects. Define and implement ETL development standards and procedures and provide leadership and mentoring to data warehouse developers. Provide on-going support of existing warehouse as well as continually re-evaluate current processes and techniques for increased efficiency and maintainability. Ensure completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements. Understanding of data models for implementing data warehouse projects using ETL tools. Define and implement ETL tool configuration. Maintain an awareness of existing, new and emerging data warehousing technologies. Provide detailed estimates of time for software development efforts. Ensure ETL quality through reviews and knowledge sharing. Ensure effective ETL functional decomposition into deliverable objects. 

Minimum Requirements: 

Bachelor's degree in Computer Science A minimum of 10 years of experience in application development, systems engineering or IT management At least 5 years of enterprise data management experience. More than 5 years of experience in design and development of ETL jobs using ETL tools. 

Qualifications / Additional Skills / Aptitude: 

Data Modeling or Database Design Experience. Experience with IBM Netezza, IBM InfoSphere, SQL Server or similar solutions.