Senior Data Platform Engineer

The candidate will have responsibilities across the following functions:

DatabASe Platforms:

• Maintains databASe security, integrity, and availability.
• Manages databASe performance and capacity.
• Works with team members to establish routine maintenance, monitoring, alerting, and metrics collection/logging to proactively identify database-related issues, ensuring the databASe is highly responsive at all times.
• Reviews performance stats and recommends changes for SQL query tuning/optimization.
• Participates in off-hours 24/7 on-call support on a rotational bASis.

Business Intelligence and Data Integration Platforms:

• Manages the platform on an ongoing bASis while performing monitoring, patching and support functions.
• Leads and conducts code reviews, design reviews, testing, and debugging activities at the application level.
• Remediates platform issues and bottlenecks impacting software development activities.
• Implements service and application monitoring across all platforms to ensure continuous availability and operational continuity of critical systems.
• Participates in DevOps, Agile, and continuous integration frameworks, including, but not limited to GitHub Actions and Azure DevOps CI/CD Pipelines.
• Evaluates, understands, and implements patches and environment upgrades.
• Demonstrates strong technical aptitude in cloud architecture, services, and design concepts.
• Works in an Agile environment; collaborates with Operations, Development, and QA functions to develop solutions and systems that are predisposed to scalability, security, and simplified maintenance, utilising automation whenever possible.
• Follows security management practices, including the ongoing promotion of awareness on current threats, auditing of server logs, and other security management processes.
• Manages/Coordinates virtual and physical servers including server provisioning, upgrading, installing, monitoring, maintaining, and performance optimisation.
• Identifies and resolves problems, often anticipating issues before they occur or before they grow; develops and evaluates options, implements solutions, communicates results to ensure corrective and timely action is taken, and manages incident resolution to ensure all components work together.
• Participate in off-hours 24/7 on-call support on a rotational bASis.

The core requirements for the job include the following:

Database Platforms:

• 5+ years of Data Warehousing experience with at leASt 2 years being on multiple platforms.
• 5+ years of hands-on experience with Google BigQuery and/or Azure Synapse.
• Effective use of AI and/or LLMs to increase efficiency in deliverables.
• Strong understanding of Dimensional Modelling.
• Understanding of CI/CD pipelines, Azure DevOps, and GitHub Actions.
• Understanding of networking principles.
• Knowledge of Terraform and/or Infrastructure as Code (IaC) methodology.
• Participate in off-hours 24/7 on-call support on a rotational bASis.

Business Intelligence and Data Integration Platforms:

• 5+ years' experience managing production BI & Data Integration environments.
• 5+ years' experience scripting using PowerShell, Bash, JavaScript, Python, or other scripting languages.
• 5+ years' experience with Power BI platform security setup and capacity management.
• 5+ years' experience with DBT platform security setup and capacity management.
• 5+ years' experience in automation using Release pipelines.
• 5+ years' experience with version control (GHE preferred) and automation tools such AS ADO, Terraform, Ansible, Puppet, etc.
• Effective use of AI and/or LLMs to increase efficiency in deliverables.
• Working knowledge of Linux/Unix/AIX Operating Systems, shell scripting, package management systems, and other utilities.
• Experience with SaAS, PaaS, and Cloud solutions.