Note: The job is a remote job and is open to candidates in USA. Dice is a recruiter offering contract technology opportunities. The company is seeking a Senior Data Engineer to build a modern data warehouse using Snowflake and DBT, with a strong focus on Sigma Computing. The role involves developing analytics-ready data products, partnering with business users, optimizing warehouse performance, and mentoring team members on Sigma and modern analytics practices.
Responsibilities
- Design and develop scalable data warehouse solutions using **Snowflake**
- Build and maintain data transformation pipelines using **DBT**
- Develop reusable DBT models, including staging, intermediate, and mart layers
- Implement incremental models, data quality testing, source freshness checks, and documentation
- Develop **Sigma datasets, workbooks, dashboards, and self-service analytics solutions** backed by Snowflake
- Partner with business and analytics teams to translate reporting requirements into governed data products
- Help establish best practices for Sigma development, reusable datasets, calculations, filters, and self-service analytics
- Provide knowledge sharing, mentoring, and guidance to team members on Sigma and modern analytics practices
- Integrate data from external and internal sources into the data warehouse
- Design dimensional data models to support reporting and analytics
- Optimize Snowflake queries, warehouse sizing, clustering, and overall data warehouse performance
- Implement data quality, governance, security, and reliability practices
- Collaborate with a small cross-functional data team to deliver the new data warehouse initiative
Skills
- * Strong hands-on experience with **Snowflake**
- * Strong hands-on experience with **DBT**
- * Strong hands-on experience with **Sigma Computing**
- * Experience developing **Sigma dashboards, workbooks, and datasets**
- * Strong SQL development skills
- * Experience with modern data warehouse architecture and dimensional modeling
- * Experience building ETL/ELT pipelines and integrating multiple data sources
- * Ability to work directly with business and analytics stakeholders
- * Strong communication and collaboration skills
- * Ability to mentor or guide other team members on Sigma and analytics best practices
- The ideal candidate is not simply a Snowflake or DBT developer who has Sigma listed on their resume. We are looking for someone with **demonstrable, hands-on Sigma experience** who can build solutions independently and help **teach, mentor, and enable other team members and business users**
- * Sigma dashboards and workbooks they have built
- * Sigma datasets connected to Snowflake
- * DBT models and transformations they have developed
- * Snowflake warehouse/data-modeling projects they have delivered
- * Working with business users on self-service analytics
- * Training or mentoring others on Sigma or analytics solutions
- **This is a fully remote contract opportunity, but candidates must be able to work EST or CST hours.**
- * Experience building a **new or modernized data warehouse**
- * Experience integrating external/third-party data sources
- * Financial Services, Banking, Insurance, Wealth Management, or related industry experience
- * Experience with data governance and data quality frameworks
- * Experience with cloud data platforms and modern analytics engineering practices
- * Experience working in a small, collaborative engineering team
Benefits
- This is a fully remote contract opportunity
Company Overview
Company H1B Sponsorship