Python and Database Developer

• Participate in design and development of data pipelines for ingestion, transformation, and loading of data from various sources into our data warehouse/lake
• Develop data models that support business requirements and analytical needs
• Optimize data models for query performance and data accessibility
• Write optimized and maintainable SQL queries and leverage SQLAlchemy for efficient database interaction
• Implement robust data quality checks and monitoring systems
• Contribute to the design and implementation of data governance policies and procedures
• Continuously research and implement new technologies and best practices
• Take ownership of the deployment and monitoring of data pipelines and related infrastructure on cloud platforms
• Ability to occasionally work a non-standard shift, including nights and/or weekends, and/or have on-call responsibilities
• Design, develop, and maintain database schemas and models
• Write and optimize SQL queries for data retrieval, manipulation, and reporting
• Communicate technical concepts and solutions effectively
• Provide technical support and troubleshooting for production systems
• Stay up-to-date with the latest trends and technologies
• Evaluate and recommend new tools and technologies
• Contribute to the continuous improvement of development processes and practices

• 6+ years of hands-on experience in a Data Engineering role
• Experience with data visualization tools and techniques
• Familiarity with agile development methodologies
• Strong proficiency in Python (version 3.6+), with experience in Python packaging and shared libraries like Pandas and NumPy
• Experience implementing REST APIs in Python using microframeworks like Flask
• Extensive experience working with relational databases, writing complex SQL, and optimizing queries for performance
• Proven expertise with SQLAlchemy or similar ORM libraries
• Experience with workflow management tools like Airflow
• Solid understanding of data warehousing concepts and experience working with large datasets, including data modeling and ETL processes
• Ability to guide and mentor junior developers
• Strong communication skills, both written and verbal
• Experience working in a Continuous Integration and Continuous Delivery environment and familiarity with tools like Jenkins, TeamCity, SonarQube, OpenShift, ECS, or Kubernetes
• Proficient in industry-standard best practices such as Design Patterns, Coding Standards, Coding modularity, and Prototyping
• Bachelor's degree in Computer Science, Software Engineering, or a related field

Experience with PySpark or PyFlink is a major plus

• medical, dental & vision coverage
• 401(k)
• life, accident, and disability insurance
• wellness programs
• paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays
• discretionary and formulaic incentive and retention awards