Data Modeler - Dallas, TX

Posted 23 Days Ago
Be an Early Applicant
Hiring Remotely in United States
Remote
35K-123K Annually
Senior level
Agency • Information Technology
The Role
Design and develop scalable Snowflake data models (conceptual, logical, physical) to support reporting. Collaborate with analysts, engineers, and report developers, optimize models for Power BI, ensure data lineage/governance, participate in testing, and support report developers.
Summary Generated by Built In

**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.

 

Compensation, Benefits and Duration

Minimum Compensation: USD 35,000
Maximum Compensation: USD 123,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 not available for independent contractors
No applications will be considered if received more than 120 days after the date of this post

Skills Required

  • Bachelor's degree in Computer Science, Information Technology, Data Science, or related field
  • 7+ years experience in data modeling for data warehousing and BI projects
  • Expertise in conceptual, logical, and physical data modeling (dimensional, relational, star schema, snowflake schema)
  • Hands-on experience working with Snowflake
  • 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 attention to detail
  • Excellent communication and collaboration skills with technical and business stakeholders
  • Experience working in an Agile development environment
  • Prior experience with Power BI or other data visualization tools
  • Knowledge of financial services or investment management data
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
5,017 Employees
Year Founded: 2007

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.

Similar Jobs

PNC Bank Logo PNC Bank

Product Manager

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
134K-250K Annually

PNC Bank Logo PNC Bank

Software Engineering Manager

Machine Learning • Payments • Security • Software • Financial Services
Remote or Hybrid
USA
55000 Employees
100K-223K Annually

Federal Reserve Bank of Boston Logo Federal Reserve Bank of Boston

Security Engineer

Fintech • Information Technology • Payments • Sharing Economy • Financial Services • Cryptocurrency
Remote
USA
1200 Employees
150K-224K Annually

Liberty Mutual Insurance Logo Liberty Mutual Insurance

Inside Sales Representative

Artificial Intelligence • Fintech • Insurance • Marketing Tech • Software • Analytics
Remote or Hybrid
10 Locations
40000 Employees
55K-75K Annually

Similar Companies Hiring

Scrunch  Thumbnail
Artificial Intelligence • Information Technology • Marketing Tech • Software • SEO
Salt Lake City, Utah
Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account