Senior Data Engineer

Overview: We are seeking a skilled Senior Data Engineer to support our data platform initiatives. The ideal candidate will have strong experience with Snowflake and in cloud-based data engineering (AWS), hands-on SQL and Python development Key Responsibilities: · Design, develop and maintain scalable data pipelines and ETL processes in the cloud. · Work with stakeholders to understand data requirements and deliver solutions. · Develop & optimize SQL queries for data extraction, transformation, and reporting. · Build and maintain scripts and automation using Python. · Integrate with and perform basic operations within Snowflake data warehouse. · Ensure data quality, performance, and reliability of systems. · Collaborate with functional teams including Data Scientists, Analysts & DevOps. · Design and implement scalable database structures and ensure data integrity across systems. · Analyze large and complex datasets, troubleshoot issues and support data-driven decision-making. · Participate in data architecture discussions and contribute to best practices in database design and data governance. · Monitor and optimize data pipeline performance, troubleshoot bottlenecks, and recommend tuning improvements. · Participate in structured peer code reviews and deployment processes to ensure production readiness and reduce risk. · Take part in initiatives to continuously improve version control practices and deployment workflows. · Participate in root cause analysis sessions to identify the impact of data issues and improve long-term system stability. Required Skills & Experience: · Strong SQL development skills and solid understanding of database design principles, indexing strategies, and normalization. · Expert-land optimization in SQL (e.g., T-SQL, PL/SQL) and query optimization techniques. · Strong experience with AWS cloud services (e.g., S3, Lambda, Glue, Redshift). · Proficiency in Python for data engineering and automation tasks. · Experience with Snowflake or similar modern cloud-based data platforms. · Familiarity with modern data architecture patterns and ETL best practices. · Experience with Git and CI/CD tools for version control and deployment automation. · Experience with orchestration tools such as Kubernetes and Airflow. · 8+ years of hands-on experience as a Data Engineer or in a similar data-focused role. · Experience with large, complex datasets and enterprise-scale data environments. · Experience participating in or managing data deployment processes, with understanding of production release and risk mitigation practices. · Detail-oriented mindset with a focus on quality, performance, and stability. · Ability to understand the broader system and business impact of technical solutions. · Strong analytical, problem-solving, and communication skills. Nice to Have: · Knowledge of the US healthcare system, including claims data or HIPAA compliance. · Experience with other cloud-based databases (e.g., AWS RDS, Azure SQL, Google Cloud SQL). · Familiarity with scripting languages (e.g., Bash) for automation. · Experience in Agile environments and cross-functional, remote collaboration. · Familiarity with documentation and collaboration tools (e.g., Confluence, Jira).