We are looking for a strong Data Architect who has worked on DWH Modernization projects. Well experienced in being the Technical Lead in large ETL + Datawarehousing projects with hands on experience in Datastage. Thought out leader, architectural experience, mindset to avoid repetitive development, have worked on Enterprise wide projects including cross functional IT and Business partners, leads the meetings and integrations architectural tech discussions with IT SME’s. Experienced in and understands our technology stack which includes IBM PDA (Netezza), Datastage, Cloudera Big Data (experience at non-expert level is ok in Big data space), experienced in OpenSource programming technologies, not required but a plus if the candidate has any experience in Cloud Data Platforms.

Some of the key technologies being used/ considered for the role are;

1. Azure Hyperscaler
2. DataBricks Raw Store
3. Snowflake Curated Data Store 
4. Tableau 
5. Configure your Data Science Environment to operate across Raw and Curated Data Stores

What Will You Be Doing?
• Design, develop and implement complex data engineering solutions 
• Collaborate with other IT leads and developers to identify opportunities for improvement and innovation
• Discover, evaluate, and implement new technologies to maximize development efficiency
• Develop team members by providing coaching, code review, and process guidance
• Support critical production systems to ensure stability and uptime
• Assist business partners in applying data to evaluate and tackle business problems
• Create and uphold technology standards, processes, and audit methodologies
• Continuously improve IT platforms based on retail and data management technology trends in support of business strategies

Requirements:
• 5+ years’ experience with Data Warehousing/BI technologies including one or more of the following or similar: Enterprise Datawarehouse (ie.Netezza, Terradata), Hadoop Data Lake (i.e. HBASE, Hive, MapReduce, Spark, etc.)
• Experience with Snowflake and Azure Data Factory, DataLakes.
• 5+ years’ experience developing and supporting complex SQL and database views in a large data warehouse environment
• 4+ years’ experience in near real time and batch data integrations development and support using technologies such as Datastage, Informatica 
• Strong Tableau experience is highly preferred 
• Experience supporting data requests, and data issues stemmed from consumers of Enterprise BI Solutions viz. OBIEE, BOBJ, etc. and Modern Analytics Tools such as Tableau, Qlik, etc.
• 2+ years’ experience developing Python or Scala code is a plus
• Experience in 24x7 production support
• Personal attributes: confident, self-starter, strong work ethic, highly motivated, sense of humor, a winning ‘can-do’ attitude, team-oriented
• A 4 year degree in an IT related field