Data Analytics Specialist

Dautom; Riyad Al Khabra; On-site; SAR 120,000 - 180,000; Full time

Job summary

Join a forward-thinking company as a Data Analytics Specialist where you will leverage your extensive experience in ETL processes and database technologies. This role offers the chance to work closely with a global leader in diversified portfolios, driving innovation and quality in data integration solutions. You will be responsible for designing and developing ETL processes, ensuring optimal performance of data systems, and collaborating with various departments to meet data needs. If you are passionate about data analytics and thrive in a dynamic environment, this opportunity is perfect for you.

Qualifications

• 10+ years experience in database and ETL technologies required.
• Strong expertise in ETL methodologies and data integration.

Responsibilities

• Analyze and revise data initiatives including ETL processes.
• Develop ETL processes based on requirements and provide support.

Skills

Data Integration

ETL methodologies

Informatica

Microsoft SSIS

Database Design

Oracle

SQL Server

Microsoft Office

Communication Skills

Organizational Skills

Education

Bachelor's Degree in Computer Science

Tools

Informatica PowerCenter

Microsoft SSIS

Job description

In this role, you will have the opportunity to work closely with one of our esteemed clients. This client is a global leader in the Diversified Portfolio, known for its commitment to quality and innovation. They have chosen Dautom as their trusted partner for their upcoming projects.

Job Title: Data Analytics Specialist

Job Description:

1. Analyses and revises information and data initiatives including database structure, ETL processes, and external data interfaces.
2. Design and Development of ETL processes based on the requirements.
3. Excellent experience in using Informatica, PowerCenter and Microsoft SSIS ETL tools.
4. Develop Program Units (such as Stored Procedures, Packages) required for the ETL process.
5. Exceptional knowledge of using Microsoft Office products especially Word, Excel, Outlook, Access, PowerPoint.
6. Interact with the other departments to understand and identify data needs and requirements and work with other members of the IT organization to deliver ETL solution to address those needs.
7. Provide third-level support for production Data Integration environment.
8. Monitor performance of all Data Integration systems; provide ongoing performance tuning, review logs, clean temp files and all other administrative issues required to ensure applications and databases are performing efficiently.
9. Must possess excellent organizational skills, be detail oriented with an ability to meet critical deadlines.
10. Excellent communication (oral/written) skills with respect to team members, peers, and staff at all levels of the organization.
11. Has ability to work both independently and as part of a team.

Qualifications:

Bachelor's Degree required in Computer Science or equivalent (a combination of education and experience will be considered). High level interpersonal skills and communication skills both written and oral.

Experience:

1. A minimum of 10 years hands-on experience working with database and ETL technologies and architectures; including both logical and physical designs, data mart creation, ETL tools, loaders and development and reporting tools is preferable. This experience should include influencing global data architecture directions and defining major data architecture related technology standards.
2. A minimum of 10 years experience with implementation of ETL processes using Informatica PowerCenter and Microsoft SSIS tools.
3. A minimum of 7 years experience writing Oracle & SQL Server stored procedures and packages.
4. A minimum of 7 years hands-on experience in various data definition and modelling projects and demonstrated capabilities in carrying best practices and common objects/components to other projects is required.

Skills:

1. Strong expertise in Data Integration and ETL methodologies and concepts.
2. Strong expertise in Informatica and Microsoft SSIS ETL tools.
3. Strong expertise in database design and database development.
4. Experience in real time/near real time data integration.
5. Experience with development processes and production release management; application and database tuning and interdependencies on operating system configuration is highly desired.
6. Must possess excellent organizational skills, be detail oriented with an ability to meet critical deadlines.
7. Exceptional knowledge of using Microsoft Office products especially Word, Excel, Outlook, Access, PowerPoint.

Dautom is a prominent name across the globe in IT consulting services. With a relentless commitment to innovation and excellence, we empower businesses to bolster their IT teams with top-tier talent. Our greatest asset is our talented team of IT professionals. Our journey towards becoming an employer of choice has been built on a foundation of trust, respect, and unwavering support for our employees' growth and well-being. We take pride in being a great place to work, and we invite you to explore what sets us apart in the world of technology and corporate culture.

Required Skills:

Informatica, Objects, Database Design, PowerPoint, Stored Procedures, Interfaces, Consulting, Data Analytics, Components, Architecture, Interpersonal Skills, Analytics, Writing, Integration, Databases, Oracle, Computer Science, Education, SQL, Microsoft Office, Design, Communication, Science, Management.