Data Engineer (Strong SQL & SSIS Capabilities) at Praesignis

Job Description

• We are looking for an experienced intermediate Data Engineer. Candidate must have strong SQL & SSIS capabilities, good production support experience for being on call on a 7-day rotation cycle. AWS cloud skills would be a massive benefit as well.

Skills & Experience Required:

 Technical Stack:

• Strong proficiency in SSIS (SQL Server Integration Services) – candidates should demonstrate extensive experience in developing, optimising, and maintaining SSIS packages in a production environment.
• Proven ability to perform 24/7 on-call support and handle production support issues effectively and independently.
• Ability to balance operational responsibilities with new development – we’re looking for someone who is not only strong in maintaining and supporting existing systems but also has the capability to drive and implement new projects independently.
• Self-starter with the confidence to take ownership of deliverables, proactively identify issues, and provide solutions without needing constant direction. 
• Strong SQL and data modelling skills (dimensional and normalized)
• Proficient in Python or Scala
• Strong SSIS knowledge
• Experience with Spark (PySpark preferred)
• Experience with cloud platforms, ideally AWS (e.g., S3, Glue, Athena, EMR)
• Knowledge of data warehouse and data lake architectures
• Exposure to CI/CD pipelines and containerization (e.g., Docker, GitLab CI)

Production Support Requirements:

This role includes participation in a rotational production support schedule. The successful candidate must be willing and able to:

• Be on call every third week as part of a structured support roster.
• Respond to after-hours callouts, including late-night or early-morning alerts.
• Support and troubleshoot issues in the nightly batch process to ensure successful completion.
• Work collaboratively with operations and infrastructure teams to resolve time-sensitive issues under pressure.
• Maintain logs, escalate critical incidents, and ensure accurate handovers.
• This support responsibility is critical to ensure the availability and continuity of data services required by business users and systems across the enterprise.