dnata is one of the world’s largest air and travel services providers; offering ground handling, cargo, travel and catering & retail services at over 130 airports in more than 34 countries across six continents. At dnata, we are by your side for the entire travel experience. 

As a Senior BI Developer, you will be a fully participating member of a cross-functional team working autonomously on technology development and problem resolution in the analytics space. The role involves the design, development, testing, implementation, support and maintenance of technical data and analytics solutions and products.


In this role, you will:

• Develop, maintain, and manage advanced reporting, analytics, dashboards and other BI solutions. Translate functional and non-functional data and analytics requirements into fit for purpose technical design. Ensure solution performance, business edge cases and security related issues are addressed while developing software.


• Review the business requirements and analyse the effort estimation for design and development perspective.


• Debug issues of complexity, resolve blockers and follow design documents with minimal or no supervision.


• Complete data engineering coding tasks on problems of moderate to high scope and complexity. Demonstrate good coding principles. Conduct code review for peers. Ensure solutions adhere to published data privacy and cybersecurity principles.


• Operate with a data-driven mindset. Help translate data and analytics requirements into data solutions based on the approved technical designs. Assist with data analysis activities such as source system analysis, data modelling, data dictionary collection, data profiling and source-to-target mapping to ensure solutions deliver on business needs.


• Work on problems of diverse scope where analysis of data requires evaluation of identifiable factors. Demonstrate good judgment in selecting methods and techniques for obtaining solutions.


• Collaborate closely with internal data engineering, architectural and data science colleagues to build out data frameworks to support reporting needs.


• Update data inventories and registries as required to keep metadata and data lineage up-to-date, following agreed Data Governance standards, guidelines and principles.


• Carry out unit testing independently. Troubleshoot issues, and fix defects that are of moderate to high complexity.

To be considered for the role, you must meet the below requirements:

• Degree or Honours (12+3 or equivalent) and experience in Airport Operations. Other.


• Degree in a relevant field such as Computer Science, Computational Mathematics, Computer Engineering or Software Engineering. Specialization or electives in a Data & Analytics field (e.g. Data Warehousing, Data Science, Business Intelligence).


• 4+ years of development, testing and support experience in the Business Intelligence applications along with knowledge of administration/architecture, using the Microstrategy or similar tools like Business Objects, PowerBI, OBIEE, Tableau, Qlikview.


• 4+ years of data engineering and ETL development background with using Snowflake or Redshift, Azure Data Factory, Postgresql, Oracle or similar database management systems.

Knowledge/Skills: 

• Understanding of data architecture concepts, data modelling, enterprise data warehousing, cloud data warehousing, data vault and dimensional modelling.


• Advanced knowledge on integration with source systems, Operational Data Stores, Data Warehouse solutions and Data Warehouse lifecycle.


• Strong SQL querying skills.


• Python coding experience a nice-to-have. 


• Strong Microstrategy development, management and administration skills.


• Awareness about modern data stack and Data Analytics/Machine Learning solutions.


• Strong ability to conduct data analysis (e.g. source system identification, data dictionary / metadata collection, data profiling, source-to-target mapping).


• Ability to conduct unit testing.


• Demonstrated problem-solver, able to design and document solutions independently.


• Team player, able to collaborate with others to remove blockers, solve complex design problems and debug/resolve issues.


• Is accountable and displays positive attitude.


• Self-starter and has passion for exploring and learning new technologies, especially those in the Enterprise Data & Analytics.


• Airline industry experience a nice-to-have.

Safety Sensitive Role: No

Leadership Role: No