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.
**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
Photon Chicago, Illinois, USA Office
11 East Adams Street Suite 1100, Chicago, IL, United States, 60603
Similar Jobs
Fintech
Senior Solutions Architect responsible for designing and implementing enterprise Azure hybrid cloud architectures (AKS, IaaC, networking, security, observability). Provide technical leadership, prototype cross-platform solutions, partner with product and engineering teams, ensure scalable, resilient, and secure deployments using Infrastructure-as-Code, CI/CD, and cloud best practices.
Top Skills:
App Service Environment (Ase)Application Security Group (Asg)Arm TemplatesAzure AdAzure Ad B2CAzure Api ManagementAzure App ServiceAzure Application InsightsAzure CliAzure Container Registry (Acr)Azure Container Service (Acs)Azure DevopsAzure Key VaultAzure Kubernetes Service (Aks)Azure Log AnalyticsAzure MonitorAzure Public CloudAzure Security CenterAzure SentinelAzure SqlAzure Virtual NetworkCi/CdCosmos DbDatadogDockerDomain Driven Design (Ddd)Event HubsExpressrouteHstsKubernetesMicroservicesAzureMicrosoft Cloud Adoption FrameworkNetwork Security Group (Nsg)Nginx Ingress ControllerOpenid ConnectPowershellService BusService MeshSite-To-Site VpnSsl/TlsSysdigTerraformTwistlockUser Defined Routes (Udr)
Blockchain • Fintech • Payments • Financial Services • Cryptocurrency • Web3
Lead full-cycle recruiting for Finance and core business roles, partner with hiring leaders and cross-functional teams, maintain TA systems, and build/test agentic AI bots and Skills using Claude Code/OpenAI Codex to automate recruiting workflows and improve process quality, governance, and candidate experience.
Top Skills:
Claude CodeGemGoogle WorkspaceLinkedin RecruitermacOSModernloopOpenai CodexSlackWorkday
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
Lead SnackFutures Ventures investments in early and growth-stage companies, manage deal sourcing, screening, negotiation, and portfolio oversight, coordinate cross-functional teams, contribute to investment strategy, and support exits or handovers to Corporate Development.
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory



