Long Description

Job Summary

Oversee and manage various aspects of data integration and data warehouse processes. This includes implementing data quality measures, designing and deploying integration solutions, collaborating with team members, troubleshooting production issues, refining best practices, educating end users, participating in code reviews, exploring, and adopting new technologies, leading prototype development, and ensuring adherence to industry standards. The role involves working within Agile teams, reporting on project status, and partnering with IT Solution Architects to optimize data integration designs. The goal is to contribute to efficient and effective data analytics integration solutions while staying informed about technological trends and mentoring team members.

Job Responsibilities

Operational Work – 75% of time 

• Implement Data Warehouse data quality processes. Provide solutions where issues are identified
• Design, develop, test, and deploy data integration solutions based on business requirements
• Collaborate with team members on data integration designs and alternatives
• Troubleshoot and resolve production issues
• Continually refine and document data integration best practices
• Educate end users (where applicable) in the use of metadata and understanding where data originates
• Participate in code reviews
• Identify, evaluate, and refine leading-edge data integration tools and methods
• Build prototypes and POCs
• Bring a passion to stay on top of tech trends, experiment with and learn new technologies, participate in internal & external technology communities, and mentor other members of the engineering community
• Own the development of cross-functional, multi-platform prototypes
• Work within and across Agile teams to design, develop, test, implement, and support data analytics integration solutions
• Document and support deployment activities
• Report on status of IT Data Operations products and projects on a regular and timely basis
• Ensure the timely resolution of issues
• Follow standards and guidelines according to industry best practices
• Escalate anticipated risks to management promptly and properly
• Partner with IT Solution Architects regarding data integration design options

Strategic Work – 25%

• Educate and inform yourself and team members about data integration technology solutions and emerging trends
• Continually participate in visioning exercises and contribute to the data strategy

Candidate Requirements

Required years of relevant experience:

• 4+ years of experience designing, developing, and maintaining data integration solutions

Desired Qualifications:

• Education – B.S. in Computer Science or related discipline.
• Advanced degree a plus

Specialized Skills:

Required:

• Data integration development experience with the following skill sets:
• Extract, Transformation, and Load (ETL) of disparate data sources to targets including databases, files, and API’s. Talend, Matillion, Glue Data Studio preferred
• Ability to detect, identify and resolve source to target performance / load issues
• Expert level proficiency in structured query language (SQL)

o    Data Warehousing
-Thorough understanding of relational data models including third normal form and fact / dimension designs
-Change data capture (CDC) design options and application
-Data marts
o    Oracle database platform features including indexing, partitioning and PL/SQL
o    AWS Data Migration System (DMS), Amazon Redshift, Aurora Postgres Expertise including but not limited to performance tuning
o    Linux O/S commands and scripting
o    Secure File Transfer Protocol (SFTP)
o    Desire to work in the data integration space (data warehouse, data lake, AWS, data API’s) while continuing to grow skill sets

Desired:

• Modern development practices – e.g. DevOps
• Experience with open source database platforms:

– PostgreSQL
– MySQL
-MariaDB

• Data Lake integration design and development (ETL & ELT Methodologies)
• Experience with data quality tools
• Experience with AWS platform:

o    DMS
o    Glue
o    Redshift
o    S3, etc

• AWS Certifications
• Experience in API development
• Master data management integration and concepts
• Experience with job scheduling solutions such as Airflow

Education

Job Summary

The Group Enterprise Architecture (EA) function within Alghanim Industries IT is responsible for providing architecture oversight and
guidance across the entire application and technology landscape, aligned to the tactical and strategic business initiatives.

Job Responsibilities

• Working with Head of Enterprise Architecture to define, mature and maintain the EA strategy and framework
• Drive adherence to EA technical standards and leading practices (e.g. TOGAF, Zachman)
• Provide architecture governance, guidance, policy, process, solutions and technology leadership business unit or technology domain
• Maintain and execute a sustainable and comprehensive roadmap for EA domains in alignment with business/ IT strategy
• Establish and run EA governance & stakeholder management mechanisms, integral to overall IT demand management
• Provide architecture guidance, governance and solutions to complex enterprise problems
• Create high level solution blueprints for business initiatives leading into sound investment decisions and/or exploitation of existing
IT assets
• Provide EA services and an “Architecture Centre of Excellence” capability to progammes and projects
• Deliver architecture governance and ensure projects’ adherence to EA by running domain specific Design Authorities
• Collaborate with and guide IT change delivery, IT services, PMO, 3rd party SIs, software vendors and technology services to ensure
architectural consistency, alignment and sustainability across the IT landscape
• Interface with senior executives, business stakeholders and IT business partners to influence and guide strategy and to secure
architectural ongoing principles
• Perform IT landscape analysis and audit to identify risks and deficiencies and recommend solutions
• Lead, develop, maintain and extend EA artifacts, presentations, system maps and reference documentation, including where
required managing internal and/or third-party resources to execute
• Provide domain specific business technology thought leadership, keep pace with change in new technologies, methods and products

Candidate Requirements

Bachelor or Master degree in IT, MIS, IT Management or comparable technology / engineering discipline
• 10+ years of industry experience having strong track record of delivering solution or technical architecture for large size
programs/projects in heterogeneous environments
• TOGAF or Zachman qualified, and exposure/ working familiarity with an EA tool(s) will be advantageous (e.g Orbus, Mega)
• Packaged software implementation experience of at least one of the leading application vendors is a must
• Retail, Automotive, Industrial, Engineering experience is desirable
• Client side lead consulting/advisory experience will be an advantage
• Specialism in given business units / domains, but good understanding of other domains from a big picture standpoint
• Knowledge of business re-engineering principles and processes
• Familiarity with graphical modelling approaches, tools and model repositories
• Experience and comfort in presenting and facilitating at senior management levels
Necessary Skills
• Customer focused having excellent communication (written and verbal), documentation and presentation skills
• Excellent understanding of business and technology process, skills, organizations, stakeholder management, change management
and critical success factors for large scale IT initiatives
• Proven abilities to think in terms of end-to-end landscape design, consistency, automation, planning, risks, constraints with a
passion to secure value from architecture
• Experience and knowledge of cloud enabled services / applications
• Good knowledge and awareness on technology and IT vendor trends, directions and roadmaps
• Ability to problem solve, influence with excellent networking skills
• Well structured, delivery focused and driven