Job Description
Is data warehousing, data quality, timeliness and integrity your forte? We are looking for a BI Operations Engineer to work alongside the BI team. Our BI team brings crucial analytics to Melita in gaining a competitive advantage in the market.
Responsibilities:
- Monitor critical data pipelines and DWH processing
- Maintain data pipeline statistics and record identified issues
- Perform root cause analysis and resolve or escalate to the second level as necessary
- Monitor existing data quality rules, recommend and implement additional data quality rules
- Monitor DWH platforms and conduct preventative maintenance
- Closely coordinate with data source owners and platform teams to maintain operational stability
- Automate and coordinate operational tasks
Requirements:
- Strong analytical skills applied at root cause analysis and issue resolution
- Good communication skills
- A continuous improvement mind-set
- Preferably a good understanding of data models and associated best practices
- Experience with data warehouses processing large volumes of data and ingesting diverse data sources
- Experience with SSIS, SSRS, SSAS, PowerBI, Excel
- Basic Microsoft SQL Server administration
- Very good SQL knowledge
- Preferably knowledge of Google BigQuery, Google Cloud Dataflow
- Issue tracking software experience – for incident and problem management (such as JIRA)
