- Build, maintain, and optimize data pipelines that ingest information from multiple source systems into Snowflake.
- Develop and maintain scalable data models using dbt, following bronze, silver, gold, and platinum modeling practices.
- Create reliable data solutions that support reporting, business intelligence, analytics, and downstream applications.
- Use SQL and Python to transform data, automate processes, build ingestion logic, and support integrations such as APIs and web scraping.
- Partner with business teams across Marketing, Operations, Finance, and other departments to understand data needs and translate business questions into practical data solutions.
- Establish and maintain data quality checks, testing, documentation, naming conventions, and data definitions.
- Monitor pipelines, troubleshoot failures, and document root causes and solutions.
- Build semantic models to support natural-language querying.
- Collaborate with the Data & Analytics Lead and Data Scientist to develop datasets that support predictive analytics and machine learning initiatives.
- Participate in project planning, requirements gathering, sprint development, and code reviews.
PythonSQLGit+5 more