Data Analytics Engineer (Oracle, SSAS, BI, Over $38K)

• 5 Days Work

• Stable working environment

• Medical Coverage

Job Description:

• Partner with architecture, security, domain administration, database administration, platform teams, developers and business users to translate analytics and reporting requirements into solution designs across Oracle, PostgreSQL, SSAS and PBIRS, ensuring successful delivery.

• Design and deliver enterprise analytical solutions for change requests and platform enhancements, including solving tough technical constraints such as PBIRS file size limits (e.g. 2 GB) and related environment restrictions.

• Build, maintain and optimize complex Oracle, PostgreSQL and SSAS analytical models and semantic layers that support enterprise reporting, analytics and reusable data services.

• Serve as the central point of contact across stakeholders, aligning infrastructure setup, security requirements, authentication mechanisms, deployment activities and operational readiness of BI solutions.

• Assess machine-level configuration, security compliance controls, network protocols, authentication setup and environment dependencies to confirm solutions are robust, compliant and production-ready.

• Set up CI/CD pipelines, automated controls, release governance, version controland deployment procedures for Oracle, PostgreSQL, SSAS and PBIRS across test and production environments.

• Define and maintain lifecycle management processes, monitoring controls, operational standards and runbooks that support maintainability, auditability, supportability and compliant deployments.

• Proactively surface and mitigate architectural and operational risks to avoid late-stage rework, clear delivery blockers and sustain long-term operational resilience.

• Support SSAS models and PBIRS reports in production, covering incident troubleshooting, root cause analysis, performance tuning and problem resolution.

• Continuously improve SSAS model design, query performance, report rendering, deployment efficiency and platform stability to keep the analytics platform scalable for current and future change requests.

• Document technical specifications covering functional and non-functional requirements, operational controls, deployment standards and support procedures for BI platform components.
  

Requirements:

• Degree in Information Technology or its equivalent

• At least 5+ years of IT experience with 2-years in data migration, business intelligence and/or data warehouse pipelines projects. At least 3-year experience with Oracle or SQL Server SQL development.

• Strong technical understanding of data quality metrics, data modelling, design and architecture principles and techniques across master data, transaction data and data warehouse.

• Expert with Stored Procedure (e.g. PostgreSQL, Oracle PL/SQL) and SQL DDL/DML.

• Experience in Oracle data and objects migration to PostgreSQL. Especially for Stored Procedure with Dynamic SQL

• Python, Java Spring boot, docker or OCP skill are advantages.

• Experience in Power BI tool with usage of data objects, report objects, and service objects in different scenarios

• Experience in Star Scheme and Snowflake design and dimensional modelling

• Knowledge with Power BI and/or SSAS Row level security

• Experience to use JSON API data service for rendering Power BI report

• Knowledge with Power Query M script is an advantage

• Strong Power BI skill with SSAS multi-dimensional model as data source

• Migration of Power BI data model to SSAS data model is best practice.

• SSAS model change version control and deployment across different testing environments and production.

• Performance monitoring and management of Power BI servers and SSAS servers.

If interested for the above position, please send detailed resume with current and expected salary as well as date of availability through Apply now.

For more job opportunity, please visit our website: www.clts.com 

The personal information collected is strictly for recruitment purpose only