Datawarehouse Architect/ Solutions Lead

About the Role

The role of the solution lead is to oversee the technical design and implementation of very complex analytical systems. The individual is an expert at data warehouse and operational data store design practices. He or she is not a project manager, but more a hands-on expert who contributes to the project as a senior data resource functioning either as a data architect and/or as an data engineering lead. The person must be focused on delivering value while presenting synergy. This person will define the overall technical architecture of solution, outline the execution project, and support the Scrum master in managing the implementation.

Responsibilities

• Recommend targeted solution design and execution strategy for different types of data management initiatives including -Operational Data Repositories, Analytics Data Stores, Data Lakes and Machine learning/AI

• Define data model of the target solution

• Develop the ETL patterns to be supported and advise on the ETL pipeline architecture

• Develop reusable Data Engineering components (if necessary)

• Define solution architecture, take ownership of projects and manage the delivery team

• Define and integrate specific data management best practices and train and mentor client resources as appropriate

Requirements

• Must have experience building DWs and Data Lakes

• Must understand the different analytical data architectures (3NF, Star schema)

• Must have programming experience with Python/PySpark

• Experience building solutions on appliances a plus (Netezza, DB2, Oracle Exadata etc)

• Experience building streaming solutions using Kafka, Apache Spark is a nice to have

• Must have strong experience with atleast one Business Intelligence Technology (Business Objects, Tableau)

• Bachelor's or foreign equivalent in Computer Science, Mathematics, Engineering, or related field, plus 5 years of post-baccalaureate progressively responsible experience in software development.