Data Modeler

Greetings from Photon!!

Who are we?

Photon 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. For a brief 1 minute video about us, you can check

• Design and develop robust and scalable data models on the Snowflake platform to support the current and future reporting needs of Workplace Investing.
• Collaborate closely with business analysts, report developers, and data engineers to understand data requirements and translate them into efficient and effective data models.
• Develop conceptual, logical, and physical data models, ensuring alignment with best practices and data governance standards.
• Optimize data models for performance, scalability, and ease of use for Power BI reporting.
• Participate in data mapping and data lineage activities to ensure data integrity and traceability during the migration process.
• Contribute to the development and maintenance of data dictionaries and metadata repositories.
• Identify and resolve data modeling issues and provide recommendations for improvements.
• Stay abreast of the latest data modeling techniques and technologies relevant to Snowflake and cloud-based data warehousing.
• Participate in the testing and validation of data models.
• Provide support and guidance to report developers on data model usage and interpretation.

• Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
• Proven experience 7+Years in data modeling for data warehousing and business intelligence projects.
• Strong expertise in developing conceptual, logical, and physical data models (e.g., dimensional modeling, relational modeling, star schema, snowflake schema).
• Hands-on experience working with Snowflake as a data warehousing platform.
• Familiarity with data integration processes and tools.
• Understanding of data governance principles and practices.
• Excellent SQL skills for data querying and analysis.
• Strong analytical and problem-solving skills with a keen attention to detail.
• Excellent communication and collaboration skills, with the ability to effectively interact with both technical and business stakeholders.
• Experience working in an Agile development environment is a plus.
• Prior experience with Power BI or other data visualization tools is beneficial.
• Knowledge of financial services or investment management data is a plus.