Who are we?
For the past 20 years, we have 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. For a brief 1 minute video about us, you can check https://youtu.be/uJWBWQZEA6o.
What will you do? What are we looking for?
Job Description :
• 5 + 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.
• Need to have at least 2 hours overlap with Pacific Timings to interact with Onsite team and to attend daily standup meetings .
Compensation, Benefits and Duration
Minimum Compensation: USD 38,000
Maximum Compensation: USD 133,000
Compensation is based on actual experience and qualifications of the candidate. The above is a reasonable and a good faith estimate for the role.
Medical, vision, and dental benefits, 401k retirement plan, variable pay/incentives, paid time off, and paid holidays are available for full time employees.
This position is also available for independent contractors
No applications will be considered if received more than 120 days after the date of this post
Skills Required
- 5+ years of experience in Data Modeling and Data Analysis with strong communication and leadership skills
- Financial domain knowledge
- Strong understanding of cloud data warehouses such as Snowflake and data modeling using Data Vault 2.0
- In-depth understanding or execution experience with Data Lakehouse architectures and Big Data sources/tools (Hive, S3, Trino, HUE)
- Experience executing complex (100+ entities/tables) data modeling programs in both on-prem and cloud environments
- Experience designing normalized, denormalized, relational, dimensional, star and snowflake schemas using tools like Erwin, ER/Studio, Toad Data Modeler
- Extensive data modeling experience in big data and cloud databases such as Hive, Redshift, Snowflake and on-prem databases such as Oracle, SQL Server, DB2
- Experience working with product managers, project managers, business users, application development, DBAs and Data Governance teams to analyze requirements and deliver solutions
- Implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses
- Strong understanding of Data Warehousing, Data Analysis, Data Profiling, Master Data Management, Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance
- Must have at least 2 hours overlap with Pacific Time for daily standup meetings
What We Do
Photon.com has emerged as one of the world’s largest and fastest-growing Digital Agencies. We work with 40% of the Fortune 100 on their Digital initiatives and are known for our ability to integrate Strategy Consulting, Creative Design, and Technology at scale. Please visit www.photon.com to learn more about us, how we work, and our customer case studies. Digital Transformation Starts Here.
