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 to ensure data integrity and accuracy
• Contribute to the design and implementation of data governance policies and procedures
• Continuously research and implement new technologies and best practices to improve the efficiency, scalability, and resilience of our data platform
• Take ownership of the deployment and monitoring of data pipelines and related infrastructure on cloud platforms such as OpenShift, ECS, or Kubernetes
• Ability to occasionally work a non-standard shift, including nights and/or weekends, and/or have on-call responsibilities to support critical data operations

• Bachelor's degree in Computer Science, Software Engineering, or a related field
• Proven Significant hands-on experience in a Data Engineering role
• Proven experience with database design, development, and administration
• 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
• Strong communication skills, both written and verbal
• Proficient in industry-standard best practices such as Design Patterns, Coding Standards, Coding modularity, and Prototyping

Experience with PySpark or PyFlink