Power BI Architect

Key ResponsibilitiesThe following are the key responsibilities of the 
position. It is expected that most, if not all of these, are met by the 
candidate:
Develop, maintain, and optimize SQL-based datasets across Oracle and SQL 
Server environments
Work with large and complex datasets from multiple operational systems 
(ServiceNow, device telemetry, transaction data, ODS/EDW).
Develop and maintain reports, dashboards, and data models in Power BI, 
including DAX, scheduled refresh, and governance-aligned practices.
Support and enhance CTS’s KPI Engine and performance measurement 
frameworks, ensuring compliance with contractual KPIs and SLAs across 
global programs.
Apply data science and ML concepts
Required Skills and QualificationsBachelor’s/master’s degree in Comp 
Science, Data Analytics, Engineering, Mathematics, or related field.
5+ years of experience in data analysis, analytics engineering, or data 
science roles.
Expert-level SQL skills in both Oracle and SQL Server (complex joins, 
window functions, CTEs, performance tuning).
Strong experience with Python
Proven ability to work with very large datasets, multi-source systems, and 
complex business logic.
Deep understanding of data transformation, modelling, pipelines, and 
ETL/ELT processes.
Experience working with KPI/SLA-driven environments, producing measurement 
logic and detailed performance analysis.
Working knowledge of Power BI (modeling, DAX, optimisation, power query 
etc.)
Ability to translate ambiguous or complex requirements into structured 
analytical solutions.
Preferred SkillsHands-on experience with Azure (ADF, SQL, Databricks, Data 
Lake) or other cloud data platforms.
Experience working in a transportation, operations, SaaS, or managed 
services environment.
Exposure to predictive maintenance, device health analytics, or operational 
reliability analytics.
Familiarity with version control (Git), DevOps, CI/CD data workflows.
Experience with data visualization best practices and storytelling 
techniques.
Knowledge of ServiceNow data models (incidents, requests, tasks, changes) 
is an advantage.
Soft SkillsStrong analytical mindset with exceptional problem-solving 
abilities.