Senior Data Analyst

1 day ago

McLean, United States Pyramid Consulting, Inc Full time

Immediate need for a talented Senior Data Analyst. This is a 04+months contract opportunity with long-term potential and is located in Mclean VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.


Job ID:24-46177

Pay Range: $55 - $60/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).

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.
  • Asses 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.


Our client is a leading Banking and Financial Industry, and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply online for immediate consideration.


Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.


By applying to our jobs, you agree to receive calls, AI-generated calls, text messages, or emails from Pyramid Consulting, Inc. and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here.

  • Financial Data Analyst

    5 days ago

    McLean, United States Zillion Technologies, Inc. Full time

    USC, GC, H1B ONLYOpen for only W2 - USC or GCJob Title : Data Analyst SeniorLocations:. : Onsite (Hybrid) in McLean, VA on Tuesday, Wednesday and Thursday Job Description:Must have: 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...

  • Financial Data Analyst

    5 days ago

    McLean, United States Zillion Technologies, Inc. Full time

    USC, GC, H1B ONLYOpen for only W2 - USC or GCJob Title : Data Analyst SeniorLocations:. : Onsite (Hybrid) in McLean, VA on Tuesday, Wednesday and Thursday Job Description:Must have: 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...

  • Data Analyst

    5 months ago

    McLean, United States Hexaware Technologies Full time

    Hexaware is hiring System Analyst / Data Analyst, candidates need to work onsite at McLean, VA (Hybrid Model).System Analyst / Data AnalystJob Type: Fulltime/ContractJob Location: McLean, VANeed candidates who are Local to McLean OR willing to relocate to McLean.Work Model: Onsite from Day1 – Hybrid (3 days onsite, 2 days remote)Job Description:5 to 7...

  • Data Analyst

    4 months ago

    McLean, United States Hexaware Technologies Full time

    Hexaware is hiring System Analyst / Data Analyst, candidates need to work onsite at McLean, VA (Hybrid Model).System Analyst / Data AnalystJob Type: Fulltime/ContractJob Location: McLean, VANeed candidates who are Local to McLean OR willing to relocate to McLean.Work Model: Onsite from Day1 – Hybrid (3 days onsite, 2 days remote)Job Description:5 to 7...

  • Senior Data Engineer

    3 weeks ago

    McLean, United States Infinitive Inc Full time

    Job Title: Senior Data EngineerWe are seeking a highly skilled Senior Data Engineer to join our dynamic team at Infinitive Inc.About the Role:The ideal candidate will have a strong background in data engineering, with expertise in Databricks, DevOps tools (Jenkins/Terraform), and data modeling concepts (3NF, Dimensional, Data Vault). As a Senior Data...

  • Senior Analyst Master Data Management

    1 month ago

    McLean, United States Hilton Full time

    Description***This role is based at our corporate office in McLean, VA***This is your chance to be a part of an in-house Technology team that’s creating consumer-facing, cutting-edge technologies revolutionizing the hospitality industry around the world! As a Senior Analyst Master Data Management, you will bring your technical skills to a hospitality...

  • Business Data Analyst

    2 weeks ago

    Mclean, United States Zachary Piper Solutions, LLC Full time

    Piper Companies is seeking a Business Data Analyst (Loan Servicing) to join one of the nation's largest premier credit unions based in Mclean, VA . The Business Data Analyst will analyze loan performance metrics and create interactive reports and dashboards using BI tools. This position will be hybrid in Mclean, VA! Responsibilities of the Business Data...

  • Senior Analyst Master Data Management

    1 month ago

    McLean, United States Hilton Full time

    ***This role is based at our corporate office in McLean, VA*** This is your chance to be a part of an in-house Technology team that’s creating consumer-facing, cutting-edge technologies revolutionizing the hospitality industry around the world! As a Senior Analyst Master Data Management, you will bring your technical skills to a hospitality company with an...

  • Motion GEOINT Analyst

    4 months ago

    McLean, United States Global Dimensions Full time

    Global Dimensions is a HUBZone, service disabled, veteran-owned small business based in Fredericksburg, VA. We are a dynamic, expanding company with exciting opportunities in language/culture, training/education/instruction, IT, cyber security, and intelligence. Global Dimensions is currently seeking Senior Motion GEOINT Analysts for positions in McLean,...

  • Data Analyst

    4 weeks ago

    McLean, United States Strategic Staffing Solutions Full time

    Data AnalystLocation: McLean, VA (Hybrid - Mon & Fri Remote, Tue-Thu Onsite)Pay: $50/hr - W2 ONLYContract Durations: 6+ MonthsJob Description:We are seeking a skilled Data Analyst to join our dynamic team in McLean, VA. The ideal candidate will have a strong analytical background and experience working with large datasets, performing data analysis, and...

  • Data Visualization Analyst

    4 days ago

    Mclean, United States Booz Allen Hamilton Full time

    Job Number: R0207404 Data Visualization AnalystThe Opportunity:As a data analyst, you love diving into data and turning it into meaningful insights. With the abundance of structured and unstructured data, you understand the importance of transforming complex data sets into useful information to solve challenges. As a data analyst at Booz Allen, you can use...

  • Data Analyst

    2 weeks ago

    Mclean, United States Zachary Piper Solutions, LLC Full time

    Piper Companies is seeking a Data Analyst (Loan Servicing) to join one of the nation's largest premier credit unions based in Mclean, VA . The Data Analyst will analyze loan performance metrics and create interactive reports and dashboards using BI tools. This position will be hybrid in Mclean, VA! Responsibilities of the Data Analyst include: Analyze...

  • Data Analyst

    7 days ago

    McLean, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analyst. This is a 06+months contract opportunity with long-term potential and is located in Richmond, VA/McLean, VA (Hybrid). Please review the job description below and contact me ASAP if you are interested. Job ID:24-46091 Pay Range: $40 - $45/hour. Employee benefits include, but are not limited to, health...

  • Loan Servicing Data Analyst

    2 weeks ago

    Mclean, United States Zachary Piper Solutions, LLC Full time

    Piper Companies is seeking a Loan Servicing Data Analyst (Consumer Banking) to join one of the nation's largest premier credit unions based in Mclean, VA . The Loan Servicing Data Analyst will analyze loan performance metrics and create interactive reports and dashboards using BI tools. This position will be hybrid in Mclean, VA! Responsibilities of the...

  • Senior Regulatory Analyst

    2 days ago

    McLean, United States Larson Maddox Full time

    A leading financial services firm is looking to add you to it's team as it's next Senior Regulatory Analyst! This is an exciting opportunity to join a firm that offers continued growth. You will be part of a team that values research, analysis, and reporting to ensure it stays compliant. This role will also operate on a hybrid basis in McLean, VA working...

  • Data Analyst

    2 weeks ago

    McLean, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analyst. This is a 06+ Months Contract opportunity with long-term potential and is located in McLean, VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-14653Pay Range: $50 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental,...

  • Data Analyst

    2 weeks ago

    McLean, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analyst. This is a 06+ Months Contract opportunity with long-term potential and is located in McLean, VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-14653Pay Range: $50 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental,...

  • Data Analyst

    1 week ago

    McLean, United States Pyramid Consulting, Inc Full time

    Immediate need for a talented Data Analyst. This is a 06+ Months Contract opportunity with long-term potential and is located in McLean, VA (Hybrid). Please review the job description below and contact me ASAP if you are interested.Job ID:24-14653Pay Range: $50 - $55/hour. Employee benefits include, but are not limited to, health insurance (medical, dental,...

  • Data Analyst

    6 days ago

    McLean, United States Intelliswift Software Full time

    Job Title: Data Analyst - 3rd Party Risk Management Location: McLean, VA 22102 (Hybrid)Duration: 6 months, CTHContract Type: W2 Pay Rate: $45 - $51.26/HourRequired SkillsMust have 5+ years of experience.Understanding of Enterprise Third Party Risk ManagementAnalyze Enterprise data to independently extract KRIs and KPIs while summarizing resultsAggregate...

  • Data Analyst

    5 days ago

    McLean, United States Intelliswift Software Full time

    Job Title: Data Analyst - 3rd Party Risk Management Location: McLean, VA 22102 (Hybrid)Duration: 6 months, CTHContract Type: W2 Pay Rate: $45 - $51.26/HourRequired SkillsMust have 5+ years of experience.Understanding of Enterprise Third Party Risk ManagementAnalyze Enterprise data to independently extract KRIs and KPIs while summarizing resultsAggregate...