Role Description The Senior Data Engineer will play a pivotal role in building, modernizing, and scaling our enterprise data platform. While our legacy footprint includes SQL Server on GCP, our future is centered on a modern stack powered by Snowflake and Python. - Pipeline Engineering: Design, develop, and maintain resilient, scalable, and efficient end-to-end data pipelines. - Stakeholder Collaboration: Partner directly with product owners, data analysts, and Analytics stakeholders to gather requirements, communicate technical roadmaps, and deliver data solutions aligned with business goals. - Architecture & Design: Play a key role in data modeling and architecture discussions to support high-volume, low-latency, and high-availability systems. - Technical Leadership: Act as a subject matter expert for the data layer; mentor junior engineers, advocate for code quality, and delegate project tasks effectively. - DevOps Culture: Champion a modern DevOps mindset by implementing CI/CD practices, automated testing, and robust monitoring/observability for data workflows. - SDLC Execution: Deliver clean, well-tested, and secure code within an Agile/Scrum framework (Jira), participating fully from discovery through to deployment. - Continuous Innovation: Evaluate emerging data technologies and framework optimizations to continuously improve platform performance and cost-efficiency. - Responsible for end-to-end project ownership. - Follow established processes and be a champion for best practices and continuous improvement. - Deliver timely, well-written, well-designed, testable, efficient code. - Ensure designs and code are in compliance with specifications. - Perform other duties as assigned. Qualifications - 5+ years of professional experience designing and implementing commercial data warehouses and data marts. - 4+ years of hands-on production experience with Snowflake (including performance tuning, Snowpipe, or secure data sharing). - 3+ years of strong development experience in Python for data manipulation and pipeline orchestration. - 3+ years of strong experience with DBT or similar transformation tool. - Expert-level proficiency in advanced SQL (including complex joins, window functions, and query optimization). - Experience integrating with external data sources via APIs and handling semi-structured data (JSON, Parquet). - Solid understanding of relational databases (MSSQL/MySQL). - Proven track record of shipping high-quality software backed by a strong belief in automated testing (unit, integration, and data quality testing). - Experience working within an Agile SDLC environment. - Must comply with HIPAA rules and regulations. - Must be willing and able to communicate with the team via webcam, webconf, and phone. - Must have access to private, quiet work space with high-speed internet to effectively work remotely. Requirements - Minimum of 5 MBPS for Download Speed and 3 MBPS for Upload Speed for remote work. - Employees who regularly work from home offices are eligible for expense reimbursement to offset internet costs. Benefits - Salary range: $105,000.00 to $120,000.00 in base pay, exclusive of any bonuses or benefits. - Eligible for an annual bonus targeted at 15%. - Includes medical, dental, vision, life, and pet insurance, 401K, paid time off, and other wellness programs.