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
Aerospace • Hardware • Information Technology • Security • Software • Cybersecurity • Defense
Design, develop, and maintain Tableau and Power BI dashboards and data solutions for Supply Chain. Implement AI/ML models with Enterprise AI team, build ETL pipelines, perform ad-hoc analysis and automation, own KPIs, ensure data governance, provide training/support, and participate in QA and UAT to deliver actionable insights for operations.
Top Skills:
AlteryxDataikuETLGoogle Ai StudioKnimeMicrosoft Azure AiPower BIPythonSQLStack AiTableau
Cloud • Information Technology • Security • Software • Cybersecurity
Serve as a quota-carrying technical trusted advisor owning discovery, architecture, demos, PoCs, onboarding, and adoption. Drive commercial outcomes, expansion, and executive-level technical reviews. Leverage AI-augmented workflows to automate routine tasks and focus on high-value architecture, integration troubleshooting, and customer telemetry to ensure time-to-value.
Top Skills:
Ai GatewayApi ConnectorsCloud InfrastructureCloudflare Developer PlatformCloudflare Workers AiDdos MitigationDnsEdge ComputingJavaScriptLlmPythonRagRoutingVectorize
Consumer Web • Healthtech • Professional Services • Social Impact • Software
Own architecture and technical direction for Headway's Journey communications platform: design the decision engine, experimentation layer, channel orchestration, unified message ledger, and productionize LLM-powered personalization across multi-vendor delivery systems to improve patient and provider engagement.
Top Skills:
SparkAws EcsAws FargateDatadogFastapiGitIterableKafkaKnockLaceworkLlmMailgunNext.JsPagerdutyPostgresPython 3ReactRedisRemixS3SemgrepSentrySnykSqlalchemyTwilioTypescript
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center



