Description:
Responsibilities
- Various database-centric activities such as database maintenance and query tuning, stored procedure creation and review.
- Performing development tasks in AWS using Python, PowerShell, SQL and similar
- ETL and data acquisition development and maintenance in tools such as AWS DMS, Airflow, Lambda, AWS Glue
- Helping to design efficient data structures to store time series data, complex commodity market and industry data, trade transaction data etc.
- Maintaining, supporting, and developing the company's suite of data tools
- Ensuring Confidentiality, Integrity and Availability of data for our users
- Dashboarding in AWS Quicksight, Excel, Tableau, Excel etc as required
- Exploring new AWS technologies with a view to improving the IT offering to the business e.g., AWS Lambda, Redshift, DynamoDB
Required Skills and Experience
Inter-personal Skills
- Strong interpersonal and communication skills
- Ability to prioritise issues in a time sensitive environment
- Ability and willingness to take end to end ownership and responsibility for issues raised and project work
- Flexible and eager to apply best practice and fit for purpose software solutions to practical issues and problems facing our users
- Working closely with business teams to come up with solutions to recurring problems as well as delivering incremental system improvements
- Diligent with attention to detail, particularly in relation to documentation for processes and procedures (creating and maintaining Knowledge Base, wikis, run books, topology etc)
- Self-starter with a strong interest in, and aptitude for picking up, new and emerging technologies
Technical Skills
- Skilled in eliciting requirements from business users, and translating these into fit for purpose technical solutions
- Experience of Cloud computing environments (particularly AWS e.g., VPC, Security rules, use of S3, MySQL RDS, Apache Airflow/Redshift Spectrum/CLI Scripting/Lambda)
- Strong SQL skills (including Stored Procedures), especially in MySQL, including simple database administration tasks in a cloud-based environment e.g., query tuning, account maintenance, etc.
- Use of database development tools e.g., SQL Workbench/Toad or similar
- Good understanding of Data Warehousing, ETL Tooling (e.g., DMS, AWS Glue, Other), Scraping, Data cleansing
- Excellent understanding of the structure, operation, and maintenance of at least one enterprise database engine.
- Python programming experience, experience using Powershell or similar scripting languages or tools
- Experience with the use of standard source control systems e.g., Git, BitBucket
- Primary degree in a technical field e.g., computer science, computer applications and business, or other STEM field