- Breaking down existing Python-based business logic for implementation in SQL (Snowflake).
- Maintenance of some existing Python-based codebases.
- Working with IT and the business to specify IT requirements for features and stories.
- Liasing with business and IT teams to keep stakeholders informed and keep project on track.
- Working with team update legacy data pipelines.
- Ensuring new code adheres to best practices and team standards.
Deep Python experience is absolutely critical for this role. A successful applicant should be able to code in Python “fluently.”
- In general, a successful candidate should not need to refer to reference materials when coding in Python.
- A successful candidate be strongly conversant with:
- Python data structures
- Pandas data structures
- Object Oriented Python Development
- Data cleaning and munging using Python and Pandas
- Data analysis using Python and Pandas
Deep SQL experience is also very important. A successful candidate should be conversant with:
- Window Functions
- Common Table Elements
- Recursive queries
- Pivots
- The successful candidate is comfortable with source code management tools like Gitlab and Github.
- Data modeling is useful because the team will be interfacing with a data modeling team, but this is not a data modeling role.