Data EngineerIT Officer- Large Multinational Bank

Responsibilities:

Perform data analysis and create reusable assets for our Data & Analytics Portal i.e. dashboard data visualization & reports including adhoc requests from clients.

Analyze large datasets to identify trends patterns and insights utilize tools and techniques to understand patterns.

Ability to quickly grasp business insights and navigate through the data structures to assess the issue.

Reverse engineering from reports dashboards and applications through medallion architecture understand the business logic and document them.

Work with crossfunctional teams to understand data needs and provide analytical support.

Develop solutions based on data analysis to address business challenges and Identify opportunities for process improvements through data insights.

Document data processes methodologies and findings for future reference and maintain clear records of data sources and analysis methods.

Identify and categorize source data (where the data originates) and establish a clear mapping between source and target fields.

Analyze how changes will affect existing processes or systems and identify stakeholders impacted by data migration or integration.

Develop validation checks to ensure data integrity postmigration and conduct testing to confirm that the target meets requirements.

Maintain comprehensive documentation of the analysis process and record decisions made issues encountered and resolutions.

Work closely with data engineers to understand the target structures and design the semantic layer conducive for analytics.

Work closely with Data governance team and business stakeholders to document the data elements metadata and report metadata.

Compare source and target data structures to identify discrepancies and assess data quality issues such as duplicates missing values or inconsistencies.

Develop test plans test scripts automation procedures to test data and report quality

Contribute develop and maintain Enterprise Data Model

Actively seeks knowledge needed to complete assignments and shares knowledge with others communicating and presenting information in a clear and organized manner.

Develop maintain support AI/ML models in support of various analytical and data science needs

Candidates Profile:

Masters degree with 5 years experience OR equivalent combination of education and experience in relevant discipline such as Computer Science.

Minimum 3 years of experience in each of the following areas: (i) SQL Python R or any programming language (ii) Reports and Dashboard (iii) Building analytics and troubleshooting issues (iv)Data Analysis.

Ability to understand business requirements decode it into data needs correlate it with business processes and develop reporting data requirements data models etc.

Excellent and proven skills in data modelling data integration and understanding different ways of designing data schema.

Hands on experience with cloud platforms covering Power BI platform & Tableau and covering onprem Business Objects.

Hands on experience in building semantic layer encompassing complex logic to accommodate reporting requirements.

Good understanding on SAP BW/SAP HANA structures and decoding of business rules to migrate to Modern Cloud platforms.

Knowledge of advance SQL programming skills to perform complex operations and data programming on large amount of data stored in data warehousing or lakes.

Strong understanding of row and columnlevel security in the semantic layer to facilitate smooth reporting.

Work with application team leads to refine and tighten the security framework and access control for internal and external data access points

Ability and flexibility to learn and adapt to a spectrum of data technologies running on multiple platforms primarily on the Semantic layer modelling Report building APIs and Dashboards.

Knowledge of building data warehouse applications in Hybrid environment both oncloud and onprem and ability to keep up to date with Cloud offerings and solutions in a global delivery environment.

Ability to participate and collaborate within and across teams in developing options roadmaps evaluations decision frameworks for complex enterprise solutions.

Experience in implementing and maintaining some of these tools Informatica Intelligent Cloud Services (IICS) Tableau Tibco Data Virtualization Collibra Informatica MDM Data Bricks NoSQL Databases PostgreSQL and Azure technologies is preferrable

Experience working on AI/ML data science models is preferred.

Experience in evaluating best of the breed tools in Data & Analytics and work closely with the leadership team to come up with pro and cons is preferred.

Proven experience of working and navigating in teams with offshore/onsite model and collaborate across teams to build/maintain complex IT landscapes and diverse client bases.

Experience in finance human resources resource management loans and travel is preferred.

Experience in writing unit/integration tests work in agile iterative approach towards building products and documents work.

Ability to deliver information effectively in support of team or workgroup. Excellent communication writing/documentation and facilitation skills.

Ability to juggle multiple tasks in a fastpaced environment and the maturity to participate in multiple complex programs at the same time in an agile environment.

BI,SAP BO,SQL,Data Warehouse,ETL