Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Business Analyst with SQL and Snowflake

Ace Stack

Business Analyst With SQL And Snowflake

Location: McLean, VA (ONSITE)

Experience: 10+ years

Full Time

Summary

We are seeking an experienced Business Analyst with strong SQL and Snowflake expertise to support data-driven initiatives for a leading financial services client in McLean, VA. The ideal candidate will have a strong background in business analysis, data analysis, requirements gathering, and working closely with technical and business stakeholders to deliver scalable reporting and analytics solutions.

Key Responsibilities

  • Gather, analyze, and document business and functional requirements from stakeholders.
  • Work closely with business users, product owners, and technical teams to define data and reporting needs.
  • Perform data analysis and validation using SQL and Snowflake.
  • Write complex SQL queries to extract, analyze, and reconcile data from multiple sources.
  • Support data mapping, data lineage, and data quality initiatives.
  • Translate business requirements into functional specifications, user stories, and acceptance criteria.
  • Assist in UAT planning, test case creation, execution, and defect tracking.
  • Collaborate with Data Engineers, BI Developers, and QA teams to ensure successful delivery.
  • Create dashboards, reports, and business insights using enterprise reporting tools.
  • Participate in Agile/Scrum ceremonies and provide regular status updates.

Required Skills

  • 8+ years of experience as a Business Analyst / Data Analyst.
  • Strong hands-on experience with SQL (joins, subqueries, CTEs, window functions, aggregations).
  • Hands-on experience with Snowflake data warehouse.
  • Experience analyzing large datasets and performing data reconciliation.
  • Strong understanding of data warehousing concepts and ETL processes.
  • Experience writing business requirements documents (BRD), functional requirements documents (FRD), and user stories.
  • Excellent communication and stakeholder management skills.
  • Experience working in Agile/Scrum environments.
Ace Stack
Vacancy posted 10 hours ago
Similar jobs that could be interesting for youBased on the Business Analyst with SQL and Snowflake in Mc Lean, VA vacancy
  • $76.7k - $127.9k

     ...environment? As an experienced Business Data Analyst - Data Engineer II you will...  ...so, consider an opportunity with Deloitte under our Project...  ...toward defined outcomes.Use SQL to independently extract, validate...  ...or Tableau.SQL skills, with Snowflake experience preferred, and... 
    SQL
    Local area
    Visa sponsorship

    Deloitte

    McLean, VA
    2 hours ago
  •  ...Job Title: IT - Senior Business Process Analyst Location: McLean, VA- Hybrid onsite 3x a week Duration...  ...and reporting tools, combined with a proven ability to manage projects, document...  ...MicroStrategy, - 1+ years of experience with SQL, Python, or PowerShell. - 1+ years of... 
    SQL
    Contract work
    Work at office
    3 days per week

    Noblesoft Solutions

    Mc Lean, VA
    15 days ago
  • $96.3k - $154.4k

     ...recruiters may be communicating with job seekers about supposed...  ...workflows with governed, reusable business data products on a modern...  ...products on it. The core stack is Snowflake and dbt, organized around a...  ...objects, performance and cost-aware SQL, role-based access concepts,... 
    SQL
    Temporary work
    Local area
    Remote work
    Flexible hours
    Day shift

    Kapitus

    Arlington, VA
    2 days ago
  •  ...Job Description Job Description Snowflake Data Engineer Location: Remote, Washington, DC Duration: 4 months...  ...and maintain database solutions using Microsoft SQL Server and SSIS. Collaborate with business and technical teams to gather requirements and deliver... 
    SQL
    Remote work

    ARK Solutions, Inc.

    Washington DC
    4 days ago
  •  ...PowerBI, or Tableau . ~ Exhibit proficiency in SQL and database development, particularly with platforms like Amazon Redshift . ~ Understand and...  ...Experience in technical writing and/or technical business process analysis . Strong familiarity with... 
    SQL

    Saxon Global

    McLean, VA
    2 days ago
  • $60 - $75 per hour

     ...zilliontechnologies(dot)com // (***) ***-**** Technical Business Analyst $70/HR - $75/hr w2 Duration: Long Term Ongoing Project with NO end Date Direct Banking Client Hybrid...  .../Experience: Ability to write SQL queries Problem solving skill – Works well... 
    SQL
    For contractors
    Local area
    Remote work
    3 days per week

    Zillion Technologies, Inc.

    Vienna, VA
    10 days ago
  • $120k - $150k

     ...ReesePiper Companies is seeking a Senior Business Analyst - Card Integration & Data Mapping to...  ..., and integration activities associated with credit card portfolio conversions and mergers...  ...data mapping, requirements gathering, SQL, Advanced Excel, and data reconciliation... 
    SQL
    3 days per week

    ZP Group

    McLean, VA
    2 days ago
  •  ...zilliontechnologies(dot)com Technical Business Analyst – Digital Applications & API Integration...  ..., VA Duration : Long term ongoing with no end date Compensation* Pay rates...  .../Experience: Ability to write SQL queries Problem solving skill – Works... 
    SQL
    Hourly pay
    For contractors
    Local area

    Zillion Technologies, Inc.

    Vienna, VA
    16 hours ago
  • $100k - $140k

     ...Responsibilities An Average day: As the Business Analyst II you will support a large enterprise...  ...and data centers. You will collaborate with cross-functional teams to gather, analyze...  ...concepts and data analysis (e.g., SQL, Excel). Strong communication and stakeholder... 
    SQL
    For contractors
    Immediate start

    AMERICAN SYSTEMS

    Arlington, VA
    3 days ago
  •  ...Business Analyst Senior Location Information: Request Location HQ3 Flexibility in Location: Must...  ...Furlough: No Required Skills: SAS, SQL, Data Mining, Rapid SQL, Microsoft Suite...  ...analytical skills, ability to interact with business and technical teams, flexible,... 
    SQL
    Permanent employment
    Flexible hours

    Samprasoft

    Mc Lean, VA
    2 days ago
  • $64.5k - $157.1k

     ...Description:CGI Federal is seeking a Momentum Business Analyst to support ongoing Operations &...  ...testing, documentation, and collaboration with both client and internal teams. Ideal candidates...  ...Developing proficiency in Momentum ERP, SQL, client relationship building, and... 
    SQL
    Work at office
    Local area

    CGI

    Arlington, VA
    1 day ago
  •  ...Possible Job Responsibilities Must haves include Pyspark, Hadoop, Snowflake. Must have programming experience in Python, Spark for data processing and analysis. Must have strong SQL experience. Experience with AWS Cloud is preferred. Cleanse, manipulate and analyze large... 
    SQL

    Samprasoft

    Mc Lean, VA
    2 days ago
  • $58k - $136.2k

     ...in information technology and business and a passion for learning? Are...  ...so, joining CGI as a Business Analyst could be the ideal opportunity...  ..., but encouraged.Working with various clients in the US Federal...  ...of Experience in working with SQL, Python, Java, HTML or CSS . Strong... 
    SQL
    Contract work
    Interim role
    Local area

    CGI

    Arlington, VA
    1 day ago
  • Senior Business Analyst, Credit Loss Forecasting As a Senior Business Analyst in Liquidity Market...  ...loss projections Partnership: Work closely with colleagues across Capital One Credit...  ...market research 1+ years of experience in SQL querying 2+ years of experience in... 
    SQL
    Temporary work

    Capital One

    Mc Lean, VA
    1 day ago
  • Business Analyst Professional Location: Hybrid - McLean VA (3 Days/2Days) Assignment Type: Contract Only Work Authorization: This requirement...  ...through sub-vendors - one layer deep. Must Haves: Jira SQL Experience with Reading Python code. Not development experience Microsoft... 
    SQL
    Contract work
    Work at office

    Samprasoft

    Mc Lean, VA
    2 days ago
  • $111.2k - $126.9k

     ...Overview Sr. Business Analyst - US Card Summary: As a Senior Business Analyst at Capital...  ...major company challenges. You will team with world-class professionals to develop and...  ...market research ~1+ years of experience in SQL querying ~2+ years of experience in... 
    SQL
    Full time
    Temporary work
    Part time
    Local area

    Capital One

    McLean, VA
    4 days ago
  •  ...Sr. Business Analyst, Commercial Real Estate Summary: As a Senior Business Analyst for our $5...  ...analytical rigorsomeone who isn't satisfied with an "acceptable" answer but drills deep...  ...research ~1+ years of experience in SQL querying ~2+ years of experience in business... 
    SQL
    Temporary work

    Capital One

    Mc Lean, VA
    10 hours ago
  •  ...Sr. Business Analyst Business Cards & Payments (BC&P) | Build the Future. At BC&P, we bring a...  ...major company challenges. You will team with world-class professionals to develop and...  ...market research ~1+ years of experience in SQL querying ~2+ years of experience in... 
    SQL
    Temporary work

    Capital One

    Mc Lean, VA
    1 day ago
  • IT - Senior Business Process AnalystJob#: 3058347Job Description:Business Intelligence Project...  ...development and reporting tools, combined with a proven ability to manage projects,...  ...Experience with MicroStrategy· Experience with SQL, Python, or PowerShell.· Experience with Amazon... 
    SQL
    Contract work
    Work at office
    3 days per week

    Apex Systems

    McLean, VA
    1 hour ago
  •  ...Cvent Business Analyst Role Cvent's Financial Systems IT team is hiring a Business Analyst to...  ...these platforms. This role suits someone with solid, hands-on Coupa experience who is...  ...and collaborate across teams. ~ Basic SQL and Oracle tables knowledge ~ Excellent... 
    SQL
    Work at office

    Cvent

    Mc Lean, VA
    2 days ago
  • $60k - $80k

     ...Business Analyst The Business Analyst will report to, and work closely with, our central operations team lead. In this role you will need to identify and implement data...  ...Excel/Google Sheets required; experience with SQL/R/Python is a plus). ~ An innate understanding... 
    SQL
    Temporary work
    Immediate start
    Remote work
    Visa sponsorship

    Empower

    Mc Lean, VA
    2 days ago
  • About the job Snowflake Data Engineer Position: Snowflake Data Engineer...  .... You will work closely with our data analysts and other team members to...  ...data analysts to understand business requirements and translate them...  ...processes - Proficient in SQL and data modeling -... 
    SQL
    Full time
    Contract work

    Talent Hive

    Mc Lean, VA
    2 days ago
  •  ...assign tasks, manage timelines, deliverables, escalations • Work with business unit teams to understand and gather requirements for new...  ...Products (Loans, Cards, Deposits, Payments) • Experience in writing SQL queries for reporting and analysis • Excellent process management... 
    SQL

    3B Staffing LLC

    Mc Lean, VA
    2 days ago
  •  ...Senior Business Analyst, Deal Economics & Analytics As a Senior Business Analyst at Capital One...  ...major company challenges. You will team with world-class professionals to develop and...  ...research ~1+ years of experience in SQL querying ~2+ years of experience in business... 
    SQL
    Temporary work
    Private practice
    Local area

    Capital One

    Mc Lean, VA
    1 day ago
  • $116.35k - $210.33k

    Business Data Analyst / MethodologistThis position requires that you currently possess an active TS/SCI with Polygraph clearance to be considered.Leidos is seeking an experienced Business...  ...data visualization tools.Experience with SQL, MS Access, Oracle, SQL Server, or... 
    SQL
    Full time

    Leidos

    McLean, VA
    3 days ago
  • $87.7k - $157.8k

     ...Purpose: Provides in-depth business knowledge and advanced technical...  ...requirements. Consults with end users to test and debug applications...  ...candidate brings advanced SQL, Snowflake, Databricks knowledge,...  ...validation. Partners with business analysts, Risk Adjustment stakeholders... 
    SQL
    Full time
    Part time
    Work experience placement
    Work at office
    Remote work
    Flexible hours

    Centene Corporation

    Washington DC
    19 days ago
  • $115k - $145k

     ...Senior Business Analyst Location(s) Arlington, Virginia | Atlanta, Georgia | Chicago, Illinois...  ...operational excellence. You will partner with stakeholders, internally and externally,...  ...Experience analyzing data using SQL or similar tools to support business decisions... 
    SQL
    Remote work

    Koch Industries

    Arlington, VA
    1 day ago
  • Job Title: SR. BUSINESS ANALYST Location: Mclean,VA Duration: 12+ Months Visa: USC, GC, H1B and EAD...  ...seeking a Senior IT Business Analyst with experience in Operations Research, Systems...  ...and modeling tools such as Python, R, SQL, Excel, Power BI, Visio, or comparable platforms... 
    SQL
    Contract work
    H1b

    Btree Solutions

    Mc Lean, VA
    2 days ago
  • $120k - $130k

    Business Analyst The Business Analyst provides sustainment and documentation support for the BOSS...  ...integration tests and migration reconciliation with engineers and QA. Use VA-authorized AI...  .... Jira, Agile backlog refinement and SQL/data reconciliation Salary range: $120,0... 
    SQL
    Temporary work
    Immediate start
    Flexible hours
    Shift work

    Integral Federal

    Mc Lean, VA
    2 days ago
  • $101.1k - $115.4k

     ...Senior Business Analyst- PULSE - Global Payment Network Summary: As a Senior Business Analyst...  ...major company challenges. You will team with world-class professionals to develop and...  ...market research ~1+ years of experience in SQL querying ~2+ years of experience in... 
    SQL
    Full time
    Temporary work
    Part time

    Capital One

    Mc Lean, VA
    4 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Business Analyst with SQL and Snowflake. Be the first to apply!