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
Similar Jobs
Digital Media • Information Technology • News + Entertainment
Field-based enterprise seller responsible for developing territory strategy, prospecting and closing mid-market and enterprise multi-location accounts. Delivers face-to-face presentations, builds partner relationships, positions Comcast Business solutions, ensures customer retention, and meets/exceeds financial targets while coordinating with internal teams.
Top Skills:
23)Business ContinuityCustomer Premise Equipment (Cpe)CybersecurityDisaster RecoveryEthernetLanMan (Metropolitan Area Network)Network SecurityNetworking Protocols (Layers 1Sd-WanVoipVpnWanWdm
Digital Media • Information Technology • News + Entertainment
Design, develop, and deploy microservices and ETL applications for a SaaS cybersecurity platform. Collaborate with product, UX, DevOps, and architects to implement features, support production deployments, triage customer issues, and build reusable components while applying DevSecOps practices and production incident mitigation tools.
Top Skills:
Apache IcebergContent Management SystemsData LakeDevsecopsDockerETLGitGoJIRAMicroservicesPythonSaaSUnit Test Frameworks
Digital Media • Information Technology • News + Entertainment
Lead and scale a national Inside Enterprise Account Management organization to drive expansion, retention, and multi-product adoption for enterprise customers under $3,500 monthly telco spend. Set strategy, coverage models, quotas, and operating rhythms; coach managers and account teams; partner cross-functionally to remove barriers; and own performance versus revenue, retention, and customer experience goals.
Top Skills:
Advanced VoiceBroadbandCybersecurityManaged ServicesMetro EthernetSecurity
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute

