Onsite
Full Time Posted 11 days ago
I'm Interested

Job Type

Full Time

Job Details

Job Description What you get to do in this role:
  • Establish standards for modeling, structuring, naming etc. for various data structures consumed across the Data & Analytics org
  • Define and implement the star and snowflake schemas for enterprise reporting
  • Work with centralize architecture team to create artifacts for governance, standards, policies etc.
  • Collaborate with team across the Geos to understand business requirements and design appropriate data solutions to meet business need
  • Implement snapshot processes, data refresh schedules, exception handling procedures as necessary
  • Define required data integration requirements between various systems and work with extended team to get them created and persist the historical CDC snapshot of the data
  • Keep pace with latest technology advances in DB technologies for performance and scalability
  • Develop functional subject matter expertise within various areas of enterprise business processes
  • Cross train other team members and convey value delivered on key initiatives to broader organization
  • Communicate status regularly with management, stakeholders and executive sponsors
  • Develop database design and architecture documentation for the company
Qualifications  In order to be successful in this role we need someone who has: 
  • Bachelor’s degree or equivalent in Computer Science, Engineering, or Information Systems
  • 9+ years of documented experience as a data modeler for designing the large DW systems for enterprise level reporting
  • Strong hands-on knowledge of SQL and/or Python to perform data-analysis, writing adhoc queries
  • Strong understanding of enterprise scale data-vault modeling, dimensional modeling etc. design patterns for data self-serve
  • Good knowledge of DB modeling tools such as, Erwin etc. to create conceptual, logical and physical data models
  • Good understanding of ETL process and to translate the design into dimensions and facts, keeping the change data capture from source in mind
  • Understanding of data-modeling for data-science projects, especially for experience in working with large historical snapshot tables with multiple features
  • Fast paced learner and ability to explore various emerging technologies for newer design patterns for distributed and scalable data-architectures
  • Experience in Cloud Data warehouse technologies such as Snowflake etc. preferred
  • Excellent communication skills, ability to work individually and collaborate with broader geographically disperse teams across the time zones
Additional Information ServiceNow is an Equal Employment Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex, sexual orientation, national origin or nationality, ancestry, age, disability, gender identity or expression, marital status, veteran status or any other category protected by law. At ServiceNow, we lead with flexibility and trust in our distributed world of work. Click here to learn about our work personas: flexible, remote and required-in-office. If you require a reasonable accommodation to complete any part of the application process, or are limited in the ability or unable to access or use this online application process and need an alternative method for applying, you may contact us at talent.acquisition@servicenow.com for assistance. For positions requiring access to technical data subject to export control regulations, including Export Administration Regulations (EAR), ServiceNow may have to obtain export licensing approval from the U.S. Government for certain individuals. All employment is contingent upon ServiceNow obtaining any export license or other approval that may be required by the U.S. Government. Please Note: Fraudulent job postings/job scams are increasingly common. Click here to learn what to watch out for and how to protect yourself. All genuine ServiceNow job postings can be found through the ServiceNow Careers site.   From Fortune. © 2022 Fortune Media IP Limited All rights reserved. Used under license. Fortune and Fortune Media IP Limited are not affiliated with, and do not endorse products or services of, ServiceNow.
Mission
We're connecting diverse talent to big career moves. Meeting people who boost your career is hard - yet networking is key to growth and economic empowerment. We’re here to support you - within your current workplace or somewhere new. Upskill, join daily virtual events, apply to roles (it’s free!).
Are you hiring? Join our platform for diversifiying your team
Staff Data Modeler (Enterprise Data Platform)
I'm Interested