Job Description :
As a Data Warehouse Developer, you will lead and be hands on with design, development, and delivery of enterprise analytics solutions in support of Business Intelligence and corporate self-service initiatives. You will perform data modeling, query optimization, implement data marts, build SSAS tabular cubes with the end goal of empowering business users with reliable data and analytics. You will play a critical role in building the next generation data and analytics platform, to support the rapidly growing and dynamic business demand. You will also have an immediate influence on decision making of senior leaders, including Chief Information Officer (CIO) and Managing Directors.

Please review this role and if interested/know of someone who would be interested in this role then email your updated resume in a word document with your contact details, current location, availability and salary expectations to

Main Responsibilities

Design, model, develop, and deliver dimensionalized tables in the Data Warehouse / data marts.
Build ETL pipelines to support the Data Warehouse / data marts.
Build SSAS tabular models, both live query and in-memory, for business user empowerment and support of BI solutions.
Extracting and combining data from various data sources.
Project leadership skills with the ability to manage multiple assignments effectively.
Write and maintain functional and technical documentation.



Experience Required

Two years of demonstrated experience modeling logical and physical designs for both relational and multidimensional data models. Should understand when to use star schema, and snowflake design. Experience with modeling tools such as ERwin preferred.
Two years of demonstrated experience developing complex ETL pipelines for data warehousing, including capacity planning, and performance optimization. (e.g. SSIS, Informatica, ADF
Experience designing, implementing, and optimizing SSAS Tabular models and queries to support self-service analytics.
Expert knowledge of SQL Server, T-SQL, and query tuning as applied to data warehousing and analytics in a HA/DR environment.
Experience leading cross-functional technical projects, navigating obstacles, updating stakeholders regularly.
Excellent interpersonal and communications skills, while establishing and maintaining effective work relationships with team members
Knowledge of cloud Data Warehousing strategies using Azure preferred.