TRAFFIC Gauteng

Senior BI Developer

NTT Limited

Job Description

Responsibilities
  • Data Wrangling: Production experience building ETL / ELT / pipelines using SQL, SSIS, Azure Data Factory, Azure Synapse.
  • Minimum 10+ years production experience analysing and wrangling data, with preference for relational data sources (CSV, Excel, SQL, Oracle, PostgreSQL, MySQL).
  • Deep understanding of relational, dimensional, and non structured data and their modelling.
  • Transform and conform diverse data sources to business insights through collaborative business metrics and visible data lineage.
  • Dimensional Modelling: Build data warehouses and/or dimensional models using Kimball star schema methodology on Microsoft technologies.
  • Minimum 10+ years production experience building data warehouses and dimensional models from relational models; preference for at least 3 modern modelling tools (on premise or cloud) such as MS SQL, Analysis Services, Power BI, Azure Synapse Analytics.
  • Build star schema dimensional data warehouses on SQL Server on premise, Azure SQL variants, or Azure Synapse Analytics.
  • Build user friendly self service data models using visualisation tools (Power BI, Analysis Services).
  • Build developer friendly technical data models using SQL Views, Analysis Services, Azure Synapse Analytics, Power BI Desktop, Power BI Service, Power BI Apps.
  • Work with DAX modelling measures (Power BI, Analysis Services, DAX Studio, Tabular Editor or other external tools).
  • Build dashboards, especially for dev testing self service or technical dimensional models to engage peer and subordinate report writers and dashboard builders (Power BI Desktop, Excel).
  • Technical knowledge of data from mainstream source systems (SAP, Oracle EBS, Salesforce, SharePoint, Dynamics 365, Office 365, SQL based systems) and Master Data Management, Data Governance, Data Lineage.
  • Working knowledge of public data, non relational data, unstructured data, streaming data, and related technologies (IoT, Edge, Big Data, Data Lakes, Data Streaming, Advanced Analytics, Machine Learning, AI, Robotics).
  • Experience building CI/CD processes (DevOps, GitHub).
  • Knowledge of Microsoft Fabric, Snowflake, Databricks, AWS, Google platforms and related BI stacks.
  • Lead BI software development, deployment, and maintenance; coach and train team members.
  • Translate business requirements into technical specifications, scope, estimate, and document RFP processes and post project automation.
Qualifications
  • Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
  • Microsoft certification is a plus.
Personal Traits
  • Friendly and easy going.
  • Goal oriented.
  • Passionate about problem solving.
  • Team oriented.
  • Good communicator.
  • Self motivated.
  • Deadline orientated.

NTT DATA is an Equal Opportunity Employer. We do not discriminate based on age, race, colour, gender, sexual orientation, religion, nationality, disability, pregnancy, marital status, veteran status, or any other protected category.

About This Role

Career insights for Software Developers positions

Salary Benchmark
$132,270/year
Source: O*NET (USD)
Job Outlook
This career will grow rapidly in the next few years and will have large numbers of openings.
Common Technologies
Apache Kafka Apache Maven Jakarta EE Airtable Apache Hive Blackboard Learn Apache Spark jQuery