4 Dimensional Modelling Jobs

Description: Technical i. Pyspark SparkSQL SQL and Glue. ii. AWS cloud experience iii. Good understanding of dimensional modelling iv. Good understanding DevOps CloudOps DataOps CI/CD & with a SRE mindset v. Understanding of Lakehouse and DW architecture vi. strong analysis and analytical skills vii. understanding of version control systems specifically Git viii. strong in software engineering APIs Microservices etc. Soft skills i. written and oral communication skills ii. ability to translate business needs to system Additional Details Global Grade : C Remote work possibility : No Global Role Family : 60236 (P) Software Engineering Local Role Name : 6362 Software Developer Local Skills : 6170 SQL Languages Required: : English

Education/Language: BTech MTech Master of Science degree in Computer Science and/or equivalent work experience Good verbal and written communication skills Professional Skills & Experience: Minimum of 3-5 years of experience in implementing end to end business intelligence using Qlik Sense. Thorough experience in Qlik Sense architecture, design, develop, test and deployment process. Thorough understanding of Qlik Sense best practices (re-usability, efficiency, optimization). Knowledge on Clinical Datasets and Standards is a plus. (eg: SDTM, CDISC (92,45,101), Q Format, Customized Data formats ..etc). Excellent understanding of relational database concepts, data modelling, and design. Excellent knowledge on writing SQL code and ETL procedures using MS-SQL Server. Strong Software Development Lifecycle experience (Agile methodology experience is a plus). Strong technical project management experience and team leadership skills including scope management, work planning and work delegation. Strong troubleshooting skills and use of defect/feature management systems. Proven ability to work independently and with technical team members (Startup environment experience is a plus). Good verbal and written communication skills. Strong analytical skills and strong decision-making capabilities. Technical Skills & Experience 3+ years of experience in Qlik Sense architecture and design 3+ years of experience in develop, test and deploy of Qlik Sense applications. 3+ years with SQL Server and ETL process. 3+ years with Data modelling (physical & logical). Experience with Performance tuning and best practices of Qlik Sense. Experience with Dimensional modelling, Star Schema and Snowflake Schema. Knowledge of clinical trial data and SDTM standards is a plus.

Department: Finance GBS Digital & Process Excellence Are you passionate about developing innovative solutions? Do you have a knack for creating impactful business intelligence visualizations? We are looking for an Associate Developer to join our Digital Excellence & Communications team within Finance GBS at Novo Nordisk. If you are ready to make a difference, read more and apply today for a life-changing career. Apply Now! The position As an Associate Developer in Power BI your key responsibilities will be: Provide business solutions for reporting and analysis using Power BI, SQL, and Dataverse. Enhance and optimize existing solutions with the aim of achieving 100% automation and superior user satisfaction. Co-develop new innovative solutions for the finance community using the latest technologies. Perform rigorous detailed analysis, resolve issues, and conduct data quality checks. Prepare test cases and execute them to ensure the quality of solutions provided to stakeholders. Assist in user acceptance testing, troubleshooting, and end-user support. Document technical specifications, user guidelines, and provide end-user training and drive innovative initiatives across projects and share best practices. Qualifications Should have 3 - 6 years of relevant work experience in PowerBI development. Solid experience in specification, design, development, or implementation of Business Intelligence (BI) solutions. Experience in SQL / Dataverse, relational databases, and dimensional modelling. Good Knowledge of REST API connection / Power Connectors. Experience with SAP BW and queries. Experience with finance operations data. Hands-on GUI development in Business Intelligence. Experience in agile development processes. Good knowledge of data security and section access models with strong users experience skills and ability to provide the right advice to the business. Proficient in working with complex data models and different schemas. Strong communication skills effective verbal and written communication skills in English. Quick learner and proactive in developing new skills and sparring with the team with sense of urgency, ability to manage and prioritize multiple work requirements to meet deadlines. Flexible and enthusiastic to go beyond given instructions to create business value. Power BI Certification (Preferred).

Minimum 10 years experience in design, architecture or development in Analytics and Data Warehousing Have experience in solution design, solution governance and implementing end-to-end Big Data solutions using Hadoop eco-systems (Hive, HDFS, Pig, HBase, Flume, Kafka, Sqoop, YARN, Impala) Possess ability to produce semantic, conceptual, logical and physical data models using data modelling techniques such as Data Vault, Dimensional Modelling, 3NF, etc. Has the ability to design data warehousing and enterprise analytics-based solutions using Teradata or relevant data platforms Can demonstrate expertise in design patterns (FSLDM, IBM IFW DW) and data modelling frameworks including dimensional, star and non-dimensional schemas Possess commendable experience in consistently driving cost effective and technologically feasible solutions, while steering solution decisions across the group, to meet both operational and strategic goals is essential. Are adept with abilities to positively influence the adoption of new products, solutions and processes, to align with the existing Information Architectural design would be desirable Have Analytics & Data/BI Architecture appreciation and broad experience across all technology disciplines, including project management, IT strategy development and business process, information, application and business process. Have extensive experience with Teradata data warehouses and Big Data platforms on both On-Prim and Cloud platform. Extensive experience in large enterprise environments handling large volume of datasets with High Service Level Agreement(s) across various business functions/ units. Have experience leading discussions and presentations. Experience in driving decisions across groups of stakeholders.