The Data Warehouse Architect will help develop data-centric solutions to meet the company's business's needs - specifically, integrating existing siloed data and architecting data solutions that reflect the integrated landscape. Working closely with the business and application teams including BI, the Data Warehouse Architect will analyze the business needs, and develop appropriate data deliverables, such as, data models, data flow diagrams, data dictionary and glossaries to meet them.

Desirable Skills & Combinations: (Any Track from below with Enterprise Architect is

1st Track: ( "IBM Pure Data Appliance" OR "Cognos" OR "Datastage OR "Netezza")

2nd Track: ("SAS BI" OR "SAS VA" OR "SAS DI")

3rd Track: ("IRMS" OR "ALM" OR "DFAST" OR "ERM" OR "EWS" OR "Credit Risk" OR "Market Risk" )

The Data Warehouse Architect will also assist in issue resolution, in operationalizing Data Governance, in assessing, measuring and tracking data quality, and in creating and socializing data management artifacts, such as, SOP- s, standards and guidelines, control processes etc.

This position will also assist in extending the scope of the enterprise data warehouse and analytics program.

Essential Job Responsibilities:

- The Data Warehouse Architect will provide leadership and expertise in modernizing and maintaining data warehouse solutions. The candidate's core responsibilities will include, but are not limited to:

- Responsible for overall direction, oversight, and successful delivery of data warehouse design and implementation

- Leverage experience in architecting data warehouse solutions, including a strong background in Data Architecture, Data Modeling, Data Governance

- Research, analyze, design, and implement database solutions and changes

- Transform complex customer business requirements into effective, efficient, and maintainable enterprise-level solutions

- Serve as an escalation point of contact for all issues related to the data warehouse environment

- Develop and execute functional and technical specifications and testing for advanced system configuration, interfaces, installation and modifications

- Provide input to project planning, requirements gathering, process recommendations, etc.

- Execute project plan tasks and other duties as assigned

Job Requirements

Experience:

- 9+ years professional experience with and knowledge of relational databases and enterprise data warehouses, including work with MySQL, SQL Server, Oracle, or other common RDBMS

- Deep experience with building data warehouses in Redshift, Snowflake, SQL Server et al

- Experience with big data technology (Hadoop, Apache Spark, MapReduce, etc.)

- Knowledge of best practices and principles for data modeling and data mining

- Strong project management skills; ability to prioritize and manage client expectations across multiple projects

Skills:

- A love of data modeling. The backbone of a good data warehouse is the model

- Confidence communicating & translating data driven insights and technical concepts into simple terminology for business clients of various levels

- A passion for customer service.

- The following skills are important to the success of a skilled Confie technical leader:

- Listening skills - the ability to understand what people say

- Analytical skills- the ability to critically evaluate the information from multiple sources and breakdown high-level information into details

- Critical thinking and problem-solving skills

- Observation skills - the ability to validate data obtained via other techniques and expose new areas for elicitation

- Organizational skills - the ability to work with the vast array of information gathered during analysis and to cope with rapidly changing information

- Interpersonal skills - the ability to help set priorities

- Oral and written skills - excellent written and verbal communication with little or no supervision

- Self-motivated and able to motivate others in the performance of assigned duties

- Ability to work and communicate effectively with any levels of the user community from C-level to associate level

- Ability to conduct meetings with business members, partners and peers

- Ability to be flexible to the rapidly changing needs of the department and company

- Must be willing and able to work off hours support as needed; some travel may be required

Education:

Bachelor's degree (BA or BS) and or equivalent work experience

MBA or MS are a plus

This job opening was posted long time back. It may not be active. Nor was it removed by the recruiter. Please use your discretion.