Application/Data Analyst

Petrocard • Kent, WA

2h • $85,000 - $130,000 • Onsite

About The Position

This role combines Data Analysis, ERP Application Administration, and Database Management. Responsibilities span analyzing complex data from multiple business systems, administering critical applications such as Sage 100, PDI Enterprise, and Salesforce, and maintaining the SQL Server environment that supports them. The ideal candidate brings strong analytical and technical skills, is detail-oriented, and can communicate findings clearly to a broad range of stakeholders. This is an in-office position at our corporate office in Kent, WA, reporting to the Director of Strategic IT.

Requirements

• Bachelor's Degree or equivalent combination of education and experience.
• 5+ years in a role combining data analysis and database or application administration.
• Strong SQL skills including queries, views, tables, relational database concepts, performance tuning, and best practices.
• Experience supporting an ERP, CRM, accounting, and/or G/L systems.
• Proficiency building reports and visualizations; ability to connect and blend data from multiple sources.
• Strong documentation habits and attention to detail.

Nice To Haves

• Experience using Salesforce including Reports & Dashboards, Flows, Data Loader, SOQL, and Workbench is a plus.
• Experience with Boomi or other data-integration platforms

Responsibilities

• Extract and analyze complex data sets sourced from ERP, CRM, and SQL databases to support business decision-making.
• Build and maintain ETL pipelines connecting ERP, CRM, and SQL environments.
• Perform data-mapping in integration platforms to normalize and combine data sets into reliable, documented data models and to synchronize data across multiple systems.
• Build reports, dashboards, and visualizations using Power BI, SSRS, Crystal Reports, and Excel (Power Query, Power Pivot, XLOOKUP).
• Translate findings into clear communication materials for a broad range of stakeholders, including non-technical audiences.
• Partner with stakeholders to validate analysis and ensure results accurately support operational and strategic decisions.
• Document integrations, data flows, and system dependencies to maintain organizational knowledge.
• Administer Sage 100, PDI Enterprise, and Salesforce, including user management, security, and configuration.
• Evaluate and coordinate software upgrades; review release notes for potential business impact.
• Troubleshoot application issues and support business users across finance and operations workflows.
• Participate in disaster recovery planning and testing for supported systems.
• Maintain SQL Server environments including replication, agent jobs, security permissions, and performance monitoring.
• Create and manage tables, views, stored procedures, functions, and report queries.
• Build automated jobs, alerts, and data quality checks to proactively identify issues.
• Support backend integrations between business systems and assist with troubleshooting data flow failures.

Benefits

• Competitive pay range $85,000 - $130,000, DOE, and bonus potential.
• 401k Plan with dollar-for-dollar company match up to 5%.
• Subsidized Medical/Dental/Vision plans for individual and family coverage.
• Company-paid Short-Term and Long-Term Disability insurance.
• Company-paid Life and AD&D Insurance with buy-up options for individual and family coverage.
• Generous Paid Time Off and paid holidays.
• Employee Fuel Discount program.
• Great suburban location offers an easier commute and parking is free.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: Associate degree