What are the responsibilities and job description for the Data Modeler position at Photon?
For the past 20 years, Photon has powered many Digital Experiences for the Fortune 500. Since 1999, we have grown from a few people to more than 4000 team members across the globe that are engaged in various Digital Modernization.
We are hiring a Data Modeler to join our Digital Engineering team.
Title: Data Modeler
Location: Las Vegas, NV
Job Type: Full time/Permanent or Contract
What are we looking for?
- 7 years of experience in Data Modeling & Data Analyst and should have excellent communication and leadership skills. Financial Domain knowledge is plus.
- Should have strong understanding of cloud Datawarehouse like SnowFlake and Data modelling skill using Data Vault 2.0 .
- Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data data sources / tools such as Hive , S3 , Trino , HUE , etc
- Should have done complex (100 entities/tables) Data Modeling programs in both on-prem and cloud environments .
- Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc)
- Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2
- Should have experience in working with product managers, project managers, business users, applications development team members, DBA teams and DataGovernance team on a daily basis to analyze requirements, design, development and deployment technical solutions.
- Should have implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
- Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, DataDictionary, Data Mapping, Data Policy, and Data Governance.
