Software & Data Engineer

In proud partnership, SCC is excited to deliver jobs at Rio Tinto Mongolia and its Mongolia Business Services & Support Centre.

Role purpose

The Software & Data Engineer - Operational Data Platform is part of the Governed Reporting Team and has the responsibility for the design and development of the ODP platform as well as its support throughout the business. The Operational Data Platform team provides the blueprint with which to build data platforms in the group, in addition to technical enablers that streamline the deployment of these Operational Data Warehouses and associated tools.

The role is essential to the ongoing development, improvements and support of the ODP and its delivery in the business.

The role will part of a team responsible for the ongoing development and support of the platform data. The ideal candidates will have experience with software development practices, data analysis, enterprise databases, business intelligence and reporting, metadata management and ETL, with experience with both Cloud and on-premise implementations. 

Location: Ulaanbaatar, Mongolia
Employment type: 6 months

Duties and Responsibilities

• Participate in Agile ceremonies such as sprint planning, retrospective, backlog refinement, sprint review, and daily stand-ups.
• Development / Maintenance of ETL framework templates (SSIS and Databricks), and Code generation templates to standardize ETL development (SSIS and Databricks)
• Development / Maintenance of Automated Testing Tools for unit and ETL testing (SSIS and Databricks), and DevOps automation for deployment and testing of ODP ODW and ODS
• Development / Maintenance of Support tools to monitor and report on the health of ODPs and Operational Data Warehouse, and supplementary tools for the ODP such as Manual Data Entry, Targets, Reference Data, and Data Governance.
• Mentoring of ODP Delivery teams in the use of the framework
• Support of ODP Delivery teams in the implementation of new features/upgrades.
• Troubleshooting of framework issues in ODP deployments.
• Identification of framework improvements and bugs from customer feedback/experiences to be prioritized for development.
• Training in the use of the ODP Framework.

Education & Qualifications

• Bachelor's Degree in Computer Science, Math, Software Engineering, Computer Engineering, or related field
• 2+ years of experience in business analytics, data science, software development, data modeling, or data engineering work (cloud or on-premise)
• 2+ years of experience building distributed systems leveraging technologies like REST APIs, queues, and databases.
• Microsoft SQL Server 2019, Azure SQL or later including SSIS.
• Strong T-SQL and database project development experience with Visual Studio
• Experience with Extract, Transform,   and Load (ETL) concepts and data design patterns
• Source control management tools (Git).
• Process or task automation scripts such as PowerShell, Bash, YMAL, etc.
• Web development frameworks such as ASP.NET, Angular and understanding of REST API
• JavaScript frameworks such as React, Redux, Vue, or Spring

• Experience working with modern coding practices such as continuous integration and deployment, automated testing, etc.
• Experience with Microsoft Power Platform desirable, including Power BI Reporting and DAX
• Experience with Data Bricks, Delta Lake, and Python desirable
• Microsoft Cloud Business Intelligence Technology stack examples including ADF, Azure SQL, Data Lake, Data Bricks, Synapse (or AWS/GCP equivalents)
• Test-driven development practices desirable

For further information: temuujin@scc.mn, 9973-3633.
- Cover Letter, Resume / CV