Job Description
We are seeking an experienced Business Analyst with extensive banking knowledge and a strong background in data analysis and modelling. A proactive self-starter who can effectively manage multiple initiatives while maintaining strong organisational skills.
Key Responsibilities:
* Collaborate with business areas to understand their data needs and requirements.
* Define requirements for data products, including table schemas, in collaboration with business stakeholders.
* Design data models that meet business requirements and support efficient data retrieval and analysis.
* Assist in the creation of data workloads such as reports, queries, spreadsheets, and dashboards in the new data lakehouse platform.
* Develop and execute test plans to ensure accuracy and completeness.
* Write and optimise SQL queries to support the creation and validation of the data workloads.
* Document processes, data models, and any changes to business workflows.
* Stay current with industry trends and best practices in data management.
Requirements:
* Proven experience in data projects, preferably within financial services, commercial banking or a similar industry.
* Deep understanding of business areas such as Middle Office, Risk, or Finance, with the ability to translate business requirements into technical specifications.
* Proficiency in SQL, with the ability to write and optimise complex queries.
* Strong experience in data modelling, including the design of table schemas and data structures.
* Familiarity with data platforms and modern data architecture principles.
* Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
Preferred Qualifications:
* Experience with specific data lakehouse technologies/platforms (e.g., Iceberg, Cloudera CDS, Databricks, Snowflake).
* Knowledge of ETL processes and tools (e.g., Spark, dbt).
* Knowledge of Object-Oriented Languages (e.g., Java).
* Knowledge of bash scripting (Linux Shell).
* Experience with data visualization tools (e.g., Tableau, Power BI).
Job Details:
Job Title: Business And Data Analyst
Location: Basel, Switzerland
Job Type: Contract