Python and Database Developer

• Participate in design and development of data pipelines for ingestion, transformation, and loading of data
• 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 on cloud platforms
• Occasionally work non-standard shifts including nights and/or weekends
• Provide technical support and troubleshooting for production systems
• Stay up-to-date with latest trends and technologies in Python development, database systems, and data engineering
• Evaluate and recommend new tools and technologies
• Contribute to 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+)
• Experience with 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
• 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
• 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 vacation, sick leave, and paid holidays
• Discretionary and formulaic incentive and retention awards