Data Modeler

Job Description

Data Modeler : 7 – 10 Years

Position : 1

Location: Bangalore

7 + years of IT experience Job Title –Data Modeler – RDBMS/DATA WAREHOUSING/OLAP/SNOWFLAKE/CLOUD The Purpose of This Role As a Data Modeler, You will collaborate with business, technology and architecture teams across the company to design and develop our next generation data platforms using traditional/cutting edge/Cloud technologies, open source frameworks and cloud services. you will be responsible for contributing to the overall effort around defining the domain and data capabilities by analyzing business requirements, and developing solutions for the projects delivered by the PI Technology Engineering team. The candidate will work directly with Architects, Tech Leads and senior development resources across our team, as well as other technical and business stakeholders across the organization in a fast paced agile environment The Value You Deliver • Strong execution skills in a fast-paced environment using agile methodologies • Ability to collaborate and partner with business domain leads, data scientists, product owners, enterprise architects and other functional leads to deliver world class data solutions. • Define the overall data model for the Applications in the business unit, a data warehouse approach, and how data is structured, designed, and/or accessed • Data modelling, Architecting, designing and helping engineering teams to build and support mission critical platforms in data areas. (Databases, data marts, Datawarehouse, Cloud data warehouses) • Contributes to standard practices for problem-solving approaches, tools, and processes. • You will Analyze and manage technology cost drivers to ensure efficient scale and support of OLTP/OLAP capabilities including public cloud migration. • Exploring new technology trends and leveraging them to simplify our data ecosystem. • Driving Innovation and guiding the teams to implement solutions with future thinking. • Collaborating with internal and external teams to deliver technology solutions for the business needs • Acting as a technical mentor to the engineering teams and bringing them up to speed on latest data technologies and promoting continuous learning. • You will need to constantly update professional knowledge by researching new internet technologies and software products, participating in educational/training opportunities, reading professional publications, maintaining professional networks. The Skills that are Key to this role Technical / Behavioral • Demonstrated technology and personal leadership experience in architecting, designing and building highly scalable data platforms. • Mastery of relational database, Cloud, ETL/ELT and data service technologies. • Extensive hands-on data modelling ( Dimensional Modeling) , architecture and development experience on data integration patterns, relational and NoSQL databases, Event driven architecture and microservices. • Hands on experience on Dimensional Modelling, Snowflake Modelling, Data vault Modelling • Enterprise scale expertise in data analysis, modelling, data security, data warehousing, metadata management and data quality. • Hands on experience in building data solutions using external cloud (e.g. AWS) data applications and capabilities. Ability to evaluate, prototype and recommend open source and vendor technologies and platforms. • Experience with DevOps, Continuous Integration and Continuous Delivery technologies. • This role requires 6+ years of data architecture, data modelling, design and development delivery experience. • Ability to effectively articulate and present ideas / technical design to appropriate audience. • Good knowledge in Big Data Ecosystem technologies with hands on experience implementing scalable data ingestion, storage, processing and publication solutions. • Innovation Mindset and Creativity • Possess knowledge and understanding of specific firm-wide IT languages, Databases: RDMBS, Oracle , Snowflake, Python, AWS, Airflow, How Your Work Impacts the Organization Personal Investing (PI) is the retail investing arm of Fidelity that serves the financial needs of millions of individual investors with a comprehensive range of investment products and services. The primary objective of the team in India is to enable the PI businesses, working with our IT business partners in the US. Over the years, we have developed technical expertise on various functions of personal and strategic investment products and data. Across our business we take great pride in building strong and lasting relationships with our customers, providing sound investment guidance, and delivering a best-in-class customer experience. 

The Expertise We’re Looking For Graduate - Bachelor’s or Master’s Degree in Engineering Field Certifications if any