Job Openings Senior Data Engineer

About the job Senior Data Engineer

We are hiring!

Senior Data Engineer Opportunity 


How to Apply:

Click Apply for position


Requirements 

SQL Proficiency:
A strong understanding of Structured Query Language (SQL) is crucial. Role requires work with databases, querying data and optimizing performance.

Data Modelling:
Familiarity with data modelling concepts helps with designing efficient and effective database structures. Understanding relationships, normalization and denormalization is essential.

ETL (Extract, Transform, Load):
Experience with ETL processes is vital. The role is responsible for extracting data from various sources, transforming it and loading it into data warehouses, etc.

Financial Data Knowledge:
Basic knowledge of financial concepts (such as general ledger, balance sheets and income statements) is beneficial. It will assist in understanding the context of financial data.

Problem-Solving Skills:
As a support engineer, the role will encounter data discrepancies, performance issues and user queries. Strong
problem-solving abilities are essential.

Attention To Detail:
Accuracy matters when dealing with financial data. Paying attention to details ensures data integrity.

Communication Skills:
Collaborating with different teams, including financial analysts and IT professionals. Clear communication is essential for
effective troubleshooting and documentation.

Security Awareness:
Understanding data security principles and compliance (such as GDPR) is crucial. This role handles corporate sensitive
financial information.
Technical Troubleshooting:

Ability to diagnose and resolve technical issues related to data integrity and data warehouse performance.

Documentation:
Maintaining comprehensive system documentation assists knowledge sharing and troubleshooting.

Technologies: 

The following technologies are used in the provision of the Orbit
Data warehouse environment:
Microsoft Azure technologies, including Synapse and DevOps.

  • Microsoft SQL Server technologies, including Master Data Services.
  • Microsoft Power BI.
  • Microsoft Office 365.

Responsibilities

Data Management:

  • Oversee data integrity, validation and transformation within the Orbit Data environment to ensure data accuracy.
  • Optimize data retrieval, query performance and storage efficiency.
  • Implement best practices for data governance and quality assurance.

Technical Support:

  • Provide advanced technical assistance to users and stakeholders.
  • Investigate complex data-related issues and resolve them promptly.
  • Collaborate with IT teams to address data warehouse performance issues.
  • Diagnose complex data, software and system engineering issues. 
  • Evaluate, recommend and execute the best resolution.

Data Security and Compliance:

  • Implement and enforce data access controls, ensuring compliance with Gallaghers information security policies.
  • Monitor data access controls, audit logs, assist with SOX & internal audit reviews and address any security/access issues.
  • Ensure compliance with data security regulations (e.g.,GDPR).
  • Advise and implement appropriate encryption and data masking where necessary.

Performance Optimization:

  • Improve, maintain and optimize source data ingestion and query performance.
  • Identify locks, blocks, bottlenecks and recommend
  • improvements to enhance performance/efficiency.

Documentation:

  • Maintain comprehensive documentation related to data warehouse processes, procedures, configurations and orchestration.
  • Create and maintain a Service Catalogue for all components of the Orbit Data warehouse environment (data access,

reports, etc.) and ensure everything is requestable through Company request management system (IDM).

  • Produce a monthly service report, including performance against SLAs, incidents, requests and changes.

Collaboration:

  • Work closely with financial analysts, business intelligence teams and data engineers.
  • Maintain positive working relationships with data engineering, testers, PMO and infrastructure teams, and contribute to

financial data architectures, required functionality and strategic vision.

  • Participate in cross-functional projects related to data integration and reporting.

Requirements Analysis:

  • Develops detailed technical application requirements and collaborates with project/development teams to ensure the delivery of quality products, features and user experience.

Development:

  • Write efficient, concise code that is stable, scalable, extensible and unit tested to Gallagher standards.
  • Write code that meets business requirements, design specifications and anticipates potential errors or issues.
  • Run code reviews to improve quality, attempt to identify bugs, ensure code follows best practices and standards and meets requirements.
  • Implement new requirements within the teams Agile delivery methodology, driving best practices, standards and aligning to architectural principles.

Technical Leadership:

  • Provides technical leadership to the Orbit Data support team and recommends direction on architecture, design, integrations, etc. to the Support Lead, Support Manager & Data Services Manager.
  • Coaching the Orbit Data support team. Sharing knowledge and expertise with staff and ensure project learnings are documented and shared among the team.

Testing:

  • Provides technical leadership in industry standard best practices for testing software applications and data warehousing solutions.

Release Management:

  • Ensure Gallaghers Service Transition and Release Management processes are understood and adhered to for each release/deployment.
  • Establish continuous integration, continuous delivery and continuous deployment pipelines and practices.

Architecture & Design:

  • Create detailed technical designs for enterprise solutions. 
  • Design and recommend high-availability data warehouse architectures.
  • Plan, document and implement backup, recovery and disaster recovery procedures.
  • Collaborate with data architects to enhance data models.

Automation & Scalability:

  • Develop and maintain automated data processing workflows.
  • Scale Orbit Data environments and infrastructure to accommodate growing data volumes.
  • Evaluate and recommend new technologies for continuous improvement.

Training:

  • Provide training to support technicians and users.
  • Foster knowledge sharing across the team and user-base.

Supervisory Responsibilities:

  • Assist the Support Lead in supervising the Orbit Data support team, including: planning, directing and coordinating activities for the team. Other such duties include: scheduling and assigning of work, training, quality control, hiring and decisions impacting the operations of the team.
  • Inclusivity: Every member of the team is expected to promote a collaborative, inclusive environment where each individual feels safe and able to contribute and be themselves at all times.
  • Every member is expected to follow Gallaghers shared values, in particular, putting clients at the heart of our business.

Ready to take your career to new heights? We're InTalent Asia, your go-to recruitment partner in Sri Lanka, and we've got an exciting opportunity for you! Our client lookout for a dynamic individual to fill the role of Senior Data Engineer.

At InTalent Asia, we're not just recruiters; we're here to architect your career success. Join us in the journey of matching your skills with unparalleled opportunities. Apply now and see how you can be the perfect fit for this exclusive position!


Or refer someone