Senior Data Analyst

3 weeks ago


Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

Job Title: Senior Data Analyst

Job Description:

We are seeking a highly skilled Senior Data Analyst to join our team at Pyramid Consulting, Inc. As a Senior Data Analyst, you will be responsible for collecting and writing detailed data transformation and financial process requirements.

Key Responsibilities:

  • Collect and write detailed data transformation and financial process requirements.
  • Create and take responsibility for project deliverables.
  • Create and maintain technical, process and data-related documentation.
  • Create, analyze, execute and enhance complex Excel-based and Python-based processes, data controls and data reconciliations.
  • Support acceptance testing; create and execute test cases; analyze and reconcile complex test results using Excel and Python.
  • Improve and automate validations and input preparation processes.
  • Maintain, update and track development features and stories in JIRA.
  • Troubleshoot, track and resolve project issues, project dependencies and configuration changes.
  • Lead the analysis, requirements and testing of financial reports using advanced Excel and custom Python code.
  • Perform complex data and reports analysis involving financial, forecasting and risk data.
  • Assess impacts from data sources and product changes to systems and processes.
  • Create engaging and detailed materials including user guides, specification documents, release notes and testing results.
  • Support a variety of project management activities, including control requirements and execution, issue troubleshooting and analysis, data conversion and cataloging, and user training.

Key Requirements and Technology Experience:

  • Key Skills: Python, SQL, data transformation.
  • Degree in accounting, quantitative finance, statistics, mathematics, economics, data analytics or a related quantitative field preferred, with 1-3 years of relevant work experience.
  • Work experience and proficiency in programming and/or data mining languages such as SQL, Python or SAS.
  • Experience working with large data sets and relational databases.
  • Outstanding quantitative, analytical, and problem-solving skills.
  • Excellent presentation, communication and writing skills.
  • Ability to use SQL to query and display large data sets while maximizing the performance of workbooks.
  • Proven experience writing SQL to query complex data structures and working with analytics.
  • Expertise with Python coding.
  • Expertise with financial statements and general ledger/subledger data is strongly preferred.
  • Ability to translate complex business requirements into technical specifications.
  • Excellent competency with advanced Excel is required.
  • Outstanding attention to detail and accuracy.
  • Knowledge of application development following Agile methodology.
  • Experience working with different databases and understanding of data and financial reporting concepts.
  • Experience with implementing or modifying financial systems or applications, preferably related to accounting functions.
  • Strong data and financial analytical skills; Ability to quickly understand complex financial concepts; Mortgage industry experience preferred.
  • Ability to juggle and prioritize large number of activities.
  • Proactive problem solver and has the ability to think holistically and creatively.
  • Ability to focus on precision, accuracy, reliability, delivery and schedule.
  • Outstanding ability to leverage data and reporting tools to deliver high-impact solutions.
  • Phenomenal teammate with a positive attitude.
  • Must have 3+ years of hands on experience with data transformation and reconciliation.
  • Must be proficient with Excel.
  • Must have advanced querying experience and have worked with SQL.
  • They should have experience in the finance industry (accounting) - Previous fintech would be ideal.
  • Should have experience with general ledgers/sub ledgers. Should have experience using python for analysis.

About the Company:

Pyramid Consulting, Inc. is a leading provider of consulting services to the banking and financial industry. We are committed to delivering high-quality solutions to our clients and are seeking a talented Senior Data Analyst to join our team.



  • Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

    Job DescriptionPyramid Consulting, Inc. is seeking a highly skilled Senior Data Analyst to join our team.Main Responsibilities:Collect and analyze complex data sets to inform business decisions.Develop and maintain technical documentation to ensure data integrity.Collaborate with cross-functional teams to implement data-driven solutions.Key...

  • Senior Data Analyst

    4 weeks ago


    Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

    Job DescriptionWe are seeking a highly skilled Senior Data Analyst to join our team at Pyramid Consulting, Inc. This is a contract opportunity with a potential for long-term engagement.Key Responsibilities:Collect and document detailed data transformation and financial process requirements.Create and deliver project outcomes.Develop and maintain technical,...


  • Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

    Job Title: Senior Financial AnalystPyramid Consulting, Inc. is seeking a highly skilled Senior Financial Analyst to join our team. As a Senior Financial Analyst, you will be responsible for providing financial analysis and support to our clients in the financial industry.Key Responsibilities:Perform trade processing, confirmation, and settlement.Process and...

  • Risk and Data Analyst

    4 weeks ago


    Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

    Job Title: Risk and Data AnalystWe are seeking a highly skilled Risk and Data Analyst to join our team at Pyramid Consulting, Inc. As a Risk and Data Analyst, you will be responsible for analyzing and interpreting complex data to identify potential risks and opportunities for growth.Key Responsibilities:Design and manage financial forecasting executions in...


  • Dinan, Bretagne, United States Booz Allen Hamilton Full time

    Job Opportunity: Data Visualization AnalystBooz Allen Hamilton is seeking a highly skilled Data Visualization Analyst to join our team. As a key member of our data analytics team, you will be responsible for designing, developing, and maintaining interactive visualizations and dashboards using Power BI.Key Responsibilities:Develop and maintain data...


  • Dinan, Bretagne, United States Capital One Financial Corp Full time

    About the Role:Capital One Financial Corp is seeking a highly skilled Senior Quantitative Analyst to join our team in McLean, Virginia. As a key member of our Global Finance team, you will be responsible for developing and enhancing our capital markets modeling and analytical framework.Responsibilities:Partner with various lines of business to develop and...


  • Dinan, Bretagne, United States NTT DATA Full time

    Job Title: Senior Sales Executive - US Department of CommerceAbout the Role:We are seeking a highly experienced Senior Sales Executive to join our team in McLean, Virginia. As a Senior Sales Executive, you will be responsible for driving sales growth and identifying new business opportunities within the US Department of Commerce.Key Responsibilities:Develop...

  • Senior FOIA Analyst

    4 weeks ago


    Dinan, Bretagne, United States Peraton Full time

    Job Title: Senior FOIA AnalystPeraton is seeking a highly skilled Senior FOIA Analyst to join our team. As a Senior FOIA Analyst, you will be responsible for responding to public and official requests for review and release of classified and/or sensitive customer information under the FOIA, PA, or E.O Mandatory Declassification Review (MDR).Key...


  • Dinan, Bretagne, United States SLCG Economic Consulting Full time

    Job Opportunity at SLCG Economics ConsultingWe are seeking a highly motivated and detail-oriented Financial Data Analyst to join our team at SLCG Economics Consulting. As a key member of our team, you will play a crucial role in supporting our researchers and staff in the preparation of financial reports and expert testimony.Key Responsibilities:Conduct data...


  • Dinan, Bretagne, United States Capital One Full time

    Capital One is seeking a highly skilled Financial Analyst to partner with business customers on driving strategic business direction that leads to sustainable performance.As a Financial Analyst, you will have the opportunity to work for a company that invests in ways to tell stories, view trends, and diagnose results in a more compelling and visual...


  • Dinan, Bretagne, United States NTT DATA Full time

    Job Title: Senior Sales Executive - Federal Civilian AgenciesJob Summary: NTT DATA is seeking a Senior Sales Executive to join our Federal Health & Civilian Team. This is an individual contributor role, fully remote to DC Metro-based individuals. The Sales Executive will drive identifying, developing, and capturing IT Solutions and Professional Services...


  • Dinan, Bretagne, United States Pyramid Consulting Full time

    Pyramid Consulting, Inc. is seeking a highly skilled Senior Financial Analyst to support our client\u0027s Asset Liability Management (ALM) desk. This is a contract opportunity with a minimum duration of 03 months and potential for long-term engagement.Key Responsibilities:Perform trade processing, confirmation, and settlement.Process and report on...

  • Senior Tax Analyst

    4 weeks ago


    Dinan, Bretagne, United States Clark Construction Group Full time

    Job SummaryThe Senior Tax Analyst will be part of an in-house team and have a range of responsibilities including federal and state tax planning, compliance and reporting, and assisting with strategic projects and key process improvements for the tax department. The Tax team partners across the organization to ensure risks are mitigated and planning ideas...


  • Dinan, Bretagne, United States Hexaware Technologies Full time

    Unlock Your Potential as a Security Logging ExpertAt Hexaware Technologies, we're on a mission to drive digital transformation and innovation for businesses worldwide. As a Senior Security Logging Analyst, you'll play a critical role in helping us achieve this goal.What You'll Do:Develop a project plan to review application logging capabilities against...

  • Senior FOIA Analyst

    4 weeks ago


    Dinan, Bretagne, United States Peraton Full time

    Job SummaryWe are seeking a highly skilled Senior FOIA Analyst to join our team at Peraton. As a Senior FOIA Analyst, you will be responsible for responding to public and official requests for review and release of classified and/or sensitive customer information under the FOIA, PA, or E.O. 13526 Mandatory Declassification Review (MDR).Key...


  • Dinan, Bretagne, United States Pyramid Consulting, Inc Full time

    Job Title: Systems Analyst ProfessionalWe are seeking a highly skilled Systems Analyst Professional to join our team at Pyramid Consulting, Inc. This is a 06+ months contract opportunity with long-term potential and is located in a hybrid setting.Job Summary:The successful candidate will have a strong background in IT analysis methodologies, including...


  • Dinan, Bretagne, United States BAE Systems USA Full time

    **Job Summary**BAE Systems USA is seeking an experienced Financial Analyst to support its Integrated Range Support Program in performing Financial Analysis and resulting customer reporting on a daily, weekly, and monthly basis. The Financial Analyst will be responsible for analyzing, updating, and maintaining large quantities of data in short periods of...


  • Dinan, Bretagne, United States BAE Systems USA Full time

    Job SummaryBAE Systems USA is seeking a highly skilled Senior Full Motion Video Analyst to join our team. As a Senior FMV Analyst, you will be responsible for analyzing and interpreting full motion video (FMV) to support critical national security missions. This is a unique opportunity to work with cutting-edge technology and be part of a dynamic team that...


  • Dinan, Bretagne, United States Lessard Design Inc. Full time

    Job Title: Senior Financial Planning AnalystLessard Design Inc. and Metropolitain Development Group are seeking a Senior FP&A Manager to strengthen their financial forecasting, budget management, and operational analysis. This role is pivotal for driving the firm's financial strategy and ensuring the alignment of financial and business metrics with the...


  • Dinan, Bretagne, United States Capital One Full time

    At Capital One, we're committed to driving innovation and disruption in the financial industry. As a Senior Quantitative Analyst, you'll be part of a team that's leading the next wave of change, using cutting-edge technologies like cloud computing and machine learning to unlock new opportunities for our customers.**Responsibilities and Skills:**Partner with...