Analyst

Job posting number: #7296033 (Ref:tsc-342899)

Posted: December 13, 2024

Senior/Lead Business Systems Analyst – ETL

Key Responsibilities:

• Work with business/data scientists to translate given business problem into analytical solution with defined outcomes.

• Analyze the data in depth, using SQLs and other exploratory tools against various platforms such as Bigdata, Oracle, SQL Server and others.

• Convert business requirements to functional requirements, with detailed transformation rules for ETL team. This is a very technical hands-on role.

• Work closely with the ETL and data science teams to review the requirements and data integrations.

• Understand the requirements from Business and Data Science. Understand the business and business impact on use cases.

• Write validation scripts to validate the data loaded by ETL team.

• Work with IT and business customers to develop and design requirements to formulate technical design.

• Skills to understand the right functional domain knowledge of the business to be able to gather right requirements for the design.

• Capture meta data, data lineage, reference data management and data quality rules as part of data governance.

• Work with team spread across the globe in driving the delivery of projects.

Required Skills/Knowledge:

• 5+ years of solutions development experience, including 1-2 years in data management/engineering organization.

• Proficient understanding of distributed computing principles.

• Extensive experience in data analysis and data modeling (table design).

• Proficiency in SQLs and data exploratory tools.

• Extensive experience writing functional requirements and high-level design documents.

• Experience in writing validation scripts to validate the data, data integrations and ETL transformations.

• Analytical skills to analyze situations and come to optimal and efficient solution based on requirements.

• Strong data analysis and profiling skills.

• Data warehouse concepts.

• Strong analytical skills related to working with unstructured datasets.

• SQL knowledge and data analysis skills for data anomaly detection and data quality assurance.

• Excellent communication skills, both written and verbal

Preferred:

• Experience working on DataLake using BigData Ecosystems.

• Strong background or working experience in Insurance Industry.

• Ability to interact with senior leadership teams in IT and business.

• Should have strong SQL knowledge.

• Should be good in Agile methodologies and SDLC process.

Salary Range- $70,000-$80,000 a year

#LI-CO1

Apply Now