James Fairclough

Experience

• 

  Bank of America Merrill Lynch

  Jun 2019 - Aug 2019

  Summer Intern

  Part of a global team within the Chief Technology Operations division for the duration of a ten-week internship. The function of the team was to automate recurring errors on infrastructure systems and report metrics of automated events.Role involved:• Adding features to an internal web page that was used to request automations and provideanalytics of automated events.• Creating automations in BMC Atrium Orchestrator that was used to streamline internalreporting.• Working within an agile software development team.• Taking part in daily Scrum calls.• Tracking tasks using JIRA.• Shadowing other teams in the business to gain a deeper understanding of the ties betweencapital markets and technology. This included the market data team and equities electronic trading team. Show less

• 

  First Derivatives

  Sept 2020 - Dec 2022

  Financial Engineer

  Part of a regulatory post-trade data team during a large, time-sensitive data migration project covering multiple asset classes. Responsibilities included:• Analysis using SQL for regulatory reporting.• Creating and using data quality dashboards with QlikView.• Automating report building and testing using Python scripts.• Understanding large database schemas and handling big data/data warehousing.• Performing data quality reconciliation for data migration validity using SQL.• Updating data models.• Compiling bespoke reports for regulatory reporting and front-office teams.• Performing root cause analysis for real-time data validity and completeness issues.• Creating data definitions and English-language rule descriptions for data dictionaries.• SME for RFQ (Request for Quotes) tables.• Decoding XML and FIX messages from upstream systems for root cause analysis. Show less

• 

  Schischule Hopl Hochwurzen-Planai Steiner

  Jan 2023 - Apr 2023

  Ski Instructor

  Ski instructor in Austria. Responsibilities included:• Providing expert advice on skiing equipment and conditions.• Coaching skiing to adults and children.• Being an entertainer, making skiing enjoyable, while also improving guests ability.• Keeping guests safe in an alpine environment.• Managing large groups on the mountain.• Giving basic instructions in German.

• 

  Verlata Consulting

  Jan 2024 - now

  Power BI Consultant

  Power BI consultant for a firm specialising in legal technology. Key responsibilities include:• Scoping, designing, and implementing custom Power BI reports.• Designing and managing data pipelines using cloud-native technology.• Providing ad hoc Power BI support to a large number of clients.• Developing and deploying off-the-shelf Power BI reporting products.• Collaborating with cross-functional teams to understand data needs to provide tailormade solutions.• Extracting and transforming data from a variety of sources.• Updating training documentation and training offshore teams.• Designing and modeling data at source for reporting purposes.• Keeping up to date with the latest developments to ensure clients receive the highest levelof reporting solutions. Show less