Senior Data Warehouse Engineer
About The Position
As a Senior Data Warehouse Engineer, you will play a pivotal role in designing, building, and maintaining our enterprise data warehouse to enable strategic insights and business growth. Working primarily with Snowflake, Azure, SQL Server, and PostgreSQL, you will develop robust ELT pipelines, evolve data models, and ensure high-quality, scalable data solutions. This collaborative role involves partnering with technical teams, business analysts, and stakeholders in an Agile environment. You will manage multiple priorities, support mission-critical systems, troubleshoot issues, and contribute to improving our overall data culture and architecture.
Requirements
- Bachelor’s degree in Computer Science, Information Technology, or a related technical field
- 7+ years of experience in data warehouse design, development, data structures, and ELT/ETL processes
- 5+ years managing large-scale ELT systems (design, implementation, strategy, and maintenance)
- 5+ years building clean, maintainable, and well-tested code
- 2+ years working with data visualization tools (e.g., Tableau, Sigma) and integrating with data engineering assets
- Proficiency in T-SQL; experience with Alteryx or similar ETL tools
- Strong communication skills for collaborating with stakeholders at all levels
- Team-oriented mindset with experience in Agile environments
Nice To Haves
- Hands-on experience with Azure, Snowflake, and Salesforce
- Expertise in architecting, implementing, and supporting OLTP, OLAP, or data warehouse systems
- Knowledge of data quality principles, assurance practices, and their application in ELT architecture
- Background in data science, analytics, or data governance
- Familiarity with modern tools like Coalesce, dbt for transformations, Honeydew, Fivetran/Census, or other cloud automation tools
Responsibilities
- Design, develop, and maintain enterprise data warehousing systems, data marts, and ELT/ETL pipelines
- Evolve data models and schemas to meet evolving business and engineering needs
- Collaborate with business analysts and subject matter experts to gather requirements and deliver data sources, reporting, and analytics solutions
- Ensure code integrity, data quality, and adherence to architecture, development, and deployment standards
- Lead data quality initiatives, including cleanup, documentation, and issue resolution
- Troubleshoot production issues, perform root cause analysis, and resolve within established SLAs
- Extract, transform, and load data from diverse sources into our platform
- Conduct technical analysis for partner integrations and drive automation (e.g., RPA, master data management)
- Break down complex requirements into actionable components and features
- Communicate technical concepts to non-technical stakeholders and vice versa
- Mentor and lead daily tasks for data development team members
- Contribute to large-scale projects and perform additional duties as needed
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
