SQL/ETL Developer

Responsibilities

• Manage ETL process, translate complex business requirements into scalable and efficient data solutions.
• Investigate and troubleshoot data and user-related system errors to ensure data integrity.
• Implement ETL processes to extract, transform, and load data from multiple sources into a data warehouse.
• AI Data Preparation / Insights (20% of role)
• Cleaning, transform, and prepare large and complex datasets.
• Handling missing values, outliers, inconsistencies, and data quality issues.
• Data scaling, normalization, encoding, and feature engineering techniques.
• AI Data Planning to achieve FT’s AI Strategy.
• Applying ML models to our prepared Data to gain insight.
• Augmenting Models with our data to enable achievement of AI strategies.
• Designing, training, evaluating, and deploying ML models, integrating AI solutions into applications, and working with large datasets.

Requirements

• Programming Languages and Skills
• Python: Strong proficiency is required. Familiarity with libraries like Pandas, NumPy, Scikit-learn, TensorFlow, Keras, PyTorch, and potentially others, depending on the domain (e.g., OpenCV for image processing, NLTK/SpaCy for NLP).
• SQL: Excellent skills in writing and optimizing complex SQL queries for data extraction, manipulation, and analysis from relational databases.
• R: experience of R would be a plus, though not a requirement.
• Hands-on experience of the various AWS Database & ETL services, particularly: S3, Python code, Lambda, CloudFormation, and other AWS serverless resources.
• Active participation in Agile teams, collaborating with team members to review user stories, estimate effort, and contribute to sprint reviews.
• Solid understanding of various ML algorithms (supervised, unsupervised, reinforcement learning).
• Experience in training, evaluating, and deploying ML models would be a plus.
• Knowledge of model selection, hyperparameter tuning, and cross-validation techniques.
• Familiarity with ML frameworks and libraries mentioned above.
• 2+ years of experience in a similar ETL role is essential.
• Exposure to AI ML models and AI data solutions delivery a major plus.

Personal Profile

• We are seeking long-term team members who align with our values and can thrive in our distributed Continuous Development Agile Scrum team.
• Ideal candidates will be: Self-directed and self-motivated with a proven ability to deliver results.
• Strong communicators, capable of summarizing key deliverables and meeting daily deadlines.
• Experienced in a fast-paced Agile/Scrum development environment.
• Comfortable working in a distributed development environment with remote colleagues.
• Proven team players.

Pay

Competitive salary based on experience and qualifications.

Schedule

Full-time remote position.