Senior BI and DATA WAREHOUSE DEVELOPER

Duties & Responsibilities

Ensure that the data being brought into the data warehouse is managed, secure, accurate, clean, easily available, and complete. Assist the business in ensuring that data warehouse processes are running at an optimum capacity at all times.
Maintain the business’s physical and logical data models, reflective of the current business environment. Provide technical assistance in the identification, evaluation and development of data warehousing systems and procedures. Define and promote the data warehouse design principles and best practice about architecture and techniques.
Design and support the table schemas and database for new and existing data sources for the business’s data warehouse. Create and support the ETL processes to facilitate the integration of data into the data warehouse using SSIS and other technologies. Lead data-related technical projects for the business across platforms; participate in project planning and the analysis of the business’s data requirements and solutions.

Desired Experience & Qualification

• Bachelor’s Degree (Master’s preferred) in Computer Science, Data Science, Information Technology, Statistics, Information Systems, or any other related field
• 3 – 4 years solid experience in a data warehousing environment and ETL development framework
• Exposure to big data
• Experience in report writing and user interaction
• Experience in managing/creating DataMart’s, dimension modelling and facts
• Expertise in the Microsoft BI solution offerings including SQL Server 2017 Stack (SSRS, SSAS, SSIS).  Knowledge of Power View, PowerPivot, SharePoint and Excel are an advantage
• Understanding of BI solutions: operational and analytical, strong knowledge of relational and multi-dimensional database architectures
• In-depth understanding of the Ralph Kimball data warehouse methodology
• Experience in report writing
• Knowledge in the technical aspects of BI, including data modelling, ETL, metadata/data management and OLAP tools
• 5+ years working experience in the field of data warehousing and BI
• A good feel and understanding of business in general
• Advanced Excel, OLAP and presentation skills
• Familiar with a semantic layer and designing frameworks for reporting and analysis
• Cube development using SSAS
• ETL knowledge (SSIS)
• Data warehousing conceptual and practical knowledge
• Exposure to MS PowerQuery and PowerBI is an advantage
• Knowledge of MDX query
• Agile Development principals.

Other BI tools (Cognos Analytics) Advantages.