Business System Analyst

Mandate key skills : combination of core BSA skills such as Requirement gathering, Data Mapping/STTM/Backlog and Data skills such as Azure, Databricks, Pyspark/Python, SQL, Power BI, Tableau, Azure Data Factory

Job Description :

- Skills required: Data warehousing, data analysis, ETL, SQL, spark SQL, data mapping, Azure, Databricks Pyspark and data bricks

- Experience in AML/ Banking/ Capital Market

- Experience with Agile methodology - Plan, develop, test and deploy

- Experience with SQL server management tools and writing queries, with large SQL data marts, relational database experience.

- Profile data and prepare source to target mappings, map source data to the target tables for the multi hop architecture.

- Closely working with data modelers, data engineers and architect and product owners to identify any discrepancies and get it resolved.

- Strong knowledge of data extraction, design, load, and reporting solutions, strong ability to read SQL server SSIS packages, SQL stored procedures/functions and back trace views

- Work in the team of data designer/ developer to translate user and/or systems requirements into functional technical specifications.

- Work with business stakeholders and other SMEs to assess current capabilities, understand high-level business requirements and apply technical background/understanding in the development of System Requirements Specification (SRS) documents.

- Collaborate closely with Application Owners, Application Managers, and Solution Designers as the business/functional counterpart in solution identification and maintenance.

- Support testing teams in translating requirements and use cases into test conditions and expected results for product, performance, user acceptance, and operational acceptance testing; participate in the testing of developed systems/solutions.

- Act as a technical resource for business partners to ensure deliverables meet business and end-user requirements.

- Identifying the source data/source tables as per project specific use case and get that ingested into source raw zone.

- Raise Data access control requests and make source data available in analytical zone for data profiling and data analysis.

- Understanding the existing codes and data bricks workflows and leverage that for our use case.