Photon Logo

Photon

Data Modeler - Dallas, TX

Posted 3 Days Ago
Be an Early Applicant
Remote
Hiring Remotely in United States
35K-123K Annually
Senior level
Remote
Hiring Remotely in United States
35K-123K Annually
Senior level
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.
The summary above was generated by AI

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

Similar Jobs

58 Minutes Ago
Remote or Hybrid
106K-160K Annually
Senior level
106K-160K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Tax Manager will lead tax advisory services, manage client relationships in the healthcare sector, and supervise tax staff while ensuring compliance.
Top Skills: AdobeCasewareDepreciation Processing SoftwareExcelGo File RoomPowerPointTax Preparation Software (Axcess)Tax Research Software (Ria)Word
58 Minutes Ago
Remote or Hybrid
106K-160K Annually
Senior level
106K-160K Annually
Senior level
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Manage tax compliance engagements, serve as client contact, review tax work, supervise staff, and maintain technical tax expertise.
Top Skills: AccountingCpaFinancial ReportingTax ComplianceTax Research
58 Minutes Ago
Remote or Hybrid
United States
66K-89K Annually
Junior
66K-89K Annually
Junior
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
The Consultant II will implement solutions for clients, assist with business processes in a consulting capacity, and support project execution under senior supervision.
Top Skills: AICloud-Based TechnologySage Intacct

What you need to know about the Charlotte Tech Scene

Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.

Key Facts About Charlotte Tech

  • Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
  • Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
  • Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
  • Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
  • Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account