Overview
The Business Data Analyst will play a crucial role in supporting a significant data transformation initiative within the financial services sector. This position involves collaborating closely with business Subject Matter Experts (SMEs), engineers, and architects to map data from various source systems into a Common Data Model (CDM) for reporting and regulatory purposes. The role requires a blend of strong analytical skills and technical expertise, particularly in SQL and data integration.
Responsibilities
- Collaborate with business SMEs to gather requirements and understand data needs.
- Map data from multiple source systems into a Common Data Model (CDM).
- Support reporting and regulatory domains through effective data transformation.
- Utilize SQL to perform data queries and analysis.
- Engage with engineers and architects to ensure effective data integration and ETL processes.
- Provide insights and reports utilizing data visualization tools like Power BI or Tableau.
- Assist in the data modeling process to enhance data usability and governance.
Requirements
- Proven experience as a Business/Data Analyst, particularly in financial services.
- Strong proficiency in SQL for data manipulation and analysis.
- Experience in data mapping, integration, and ETL processes.
- Familiarity with cloud data platforms, preferably GCP/BigQuery.
- Knowledge of data visualization tools such as Power BI or Tableau.
- Experience in data modeling and working with Common Data Models (CDM) is a plus.
- Understanding of lending, savings, regulatory reporting, finance, or risk is desirable.