Databricks Business Systems Analyst Consultant - Capital Markets

Are you a data-savvy Business Systems Analyst with expertise in Databricks?Working with one of our top financial clients, this role calls for a Databricks Business SystemsAnalyst Consultant - CapitalMarkets. This position involves supporting a major Capital Markets Client Reporting Optimization and Integration initiative. The successful candidate will act as a bridge between business stakeholders, source systems, and the technical data engineering team, focusing on modernizing reporting environments and integrating data across Capital Markets data architecture. The role requires a highly data-centric professional comfortable working directly with source data and collaborating with developers to translate business needs into structured data solutions.Responsibilities
Analyze business requirements and convert them into detailed data and reporting specificationsExamine source systems and datasets to understand data structures, relationships, and limitationsMap source system data to business reporting and analytics needs for Capital MarketsCollaborate with Databricks engineers on data integration, transformation, and modeling within the data environmentValidate data assumptions and identify issues through direct data analysis using SQL and other toolsUnderstand and navigate the Databricks environment, including Unity Catalog, schemas, and tablesDefine dimensions, measures, and relationships supporting analytical reporting while applying star schema, dimensional modeling, and Medallion architecture best practicesFacilitate requirement clarification and resolution of data-related questions across business and technical teamsProvide data mappings, definitions, and context to support development effortsBuild data prototypes or proofs of concept to validate solutions with stakeholders and speed up deliveryInvestigate discrepancies and data quality issues between source systems and reporting outputsHelp establish clear definitions for key business metrics such as revenue, client profitability, and risk measuresCollaborate with Power BI and Databricks teams to ensure the data architecture supports reporting needsEngage in solution discussions around data integration, modeling, and reporting designAct as a liaison between business users and technical developers to ensure alignment and clarity in data solutionsDesired Skill-Set
Extensive experience as a technically oriented Business Systems Analyst or Data Business AnalystPractical experience working with Databricks and modern data environmentsStrong SQL and data analysis skillsDeep understanding of data modeling and data structuresKnowledge of star schema, dimensional modeling, and Medallion architectureAbility to analyze source systems and perform detailed data mappingProficiency working directly with data rather than relying solely on business requirements documentationExcellent communication skills to liaise with both business stakeholders and technical teamsExperience translating business needs into technical data specificationsStrong analytical and problem-solving abilitiesDomain expertise in Corporate Banking, Commercial Banking, or Capital Markets, including familiarity with revenue generation, client profitability, risk, and financial reporting in highly regulated environmentsNice to Have
Support experience with Databricks migration or data integration projectsKnowledge of Azure Databricks and Azure Data ServicesExperience with Unity CatalogSupporting Capital Markets reporting or analytics applicationsFamiliarity with Power BI or other analytical reporting platformsExposure to PythonExperience building data prototypes or collaborating with development teamsWorking with complex financial datasetsBeachHead is an equal opportunity agency and employer. We advocate for our candidates and welcome applicants regardless of race, color, religion, national origin, sex, age, or physical or mental disability. BeachHead or our clients may use technology-enabled tools, including automation and artificial intelligence (AI), to support parts of the recruitment process such as resume screening, application management, and candidate matching. These tools assist our recruiters and our clients, and do not replace human decision-making. This job posting represents a current or anticipated vacancy. The position may be filled at any time, and the posting may be removed without notice once the role has been filled.Privacy Policy
#J-18808-Ljbffr