Data Warehouse Lead - Oaks, PA

As a Data Architect, you will liaise with clients to:

• Collate technical and functional requirements through workshops with senior stakeholders in various business teams
• Translate business requirements to technical solutions leveraging strong business acumen
• Build modern Data Warehouses to support the Analytics and AI/Client needs
• Develop solution proposals that provide details of project scope, approach, deliverables and project timeline
• Provide architectural expertise to project and other analytics teams.
• Identify risks, assumptions, and develop pricing estimates for the Data & Analytics solutions
• Provide solution oversight to delivery architects and teams

Mandatory Skills and attributes for success

• 10 years of experience in data warehouse, data analytics projects, and/or any Information Management related projects
• Prior experience building large scale enterprise data architectures using commercial and/or open source Data Analytics technologies is preferred
• Ability to estimate complexity, effort and cost
• Ability to produce client ready solution architecture, business understandable presentations and good communication skills to lead and run workshops
• Strong knowledge of data manipulation languages such as SQL, with Snowflake, DBT, Power BI, Oracle, Informatica and necessary to build and maintain complex queries, streaming and real-time data pipelines
• Data modelling and architecting skills including strong foundation in data warehousing concepts, data normalization, and dimensional data modelling such as OLAP, or data vault
• Good knowledge in DevOps engineering using Continuous Integration/ Delivery tools
• An in depth understanding of Cloud solutions (AWS, Azure and/or Google Cloud Platform) and experienced in integrating into traditional hosting/delivery models
• Bachelor's Degree in Computer Science or equivalent
• Ideally, you'll also have:
• Experience in engaging with both technical and non-technical stakeholders
• Strong consulting experience and background, including engaging directly with client