Job Description
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
Data Modeler
Dallas, TX (Onsite)
Hiring Type : Full Time
**Job Description: **
Responsibilities:
- 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.
Qualifications:
- 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.
Job Tags
Full time,