Swoon · 16 hours ago
Business Analyst
Kent, WA
Full-time
Hybrid
Mid Level
$50/hr - $55/hr
4+ years expSwoon is seeking an intermediate-level Data Analyst to support project identification, validation, and scoping efforts through detailed data analysis and reconciliation. This role focuses heavily on working with datasets across Excel, SAP, and ArcGIS, identifying discrepancies, validating accuracy, and providing clear insights and recommendations.
ConsultingHuman ResourcesInformation TechnologyLegalStaffing Agency
Responsibilities
Gather, review, and analyze data and records from multiple systems, including Excel, SAP, and ArcGIS
Merge, reconcile, and validate datasets to identify potential projects and confirm scope accuracy
Investigate conflicting or incomplete data by reviewing archived records and PDF documentation as needed
Analyze data trends and summarize findings into clear, actionable recommendations
Utilize Excel extensively to combine and analyze data sets (pivot tables, lookups, conditional logic, formatting)
Support data validation related to geographic information, maps, and location-based datasets
Collaborate with internal stakeholders to clarify data requirements and resolve discrepancies
Qualification
Required
4–7 years of experience in data analysis, project analysis, or a related analytical role
Advanced Excel proficiency, including: Pivot tables, Lookup formulas (VLOOKUP/XLOOKUP or equivalent), Conditional statements and conditional formatting
Demonstrated experience combining and analyzing datasets (not manual matching)
Strong attention to detail with the ability to validate data accuracy across systems
Ability to interpret data, identify trends, and communicate findings clearly
Preferred
Experience using Power Query
Working knowledge of SAP
Basic SQL experience (used occasionally; not required)
Familiarity with ArcGIS or other mapping tools
Knowledge of the Puget Sound area and ability to interpret geographic data
Exposure to gas utility operations or utility industry data
Company
Swoon
In 2010, Swoon launched an agile, client-focused team that is not only savvy in our core industries but elbow-deep, every day, getting to know the strongest talent in the technology and professional fields.
501-1000 employees
H1B Sponsorship
Swoon has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (2)
2022 (1)
2021 (1)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Andy Baker
Co-Founder and Leadership Advisor
Alyssa Holtz
Client Partner
Company data provided by crunchbase