> Markdown version of [/jobs/ext/599257-application-data-analyst-on-site-in-wa](https://www.wearedevelopers.com/jobs/ext/599257-application-data-analyst-on-site-in-wa). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Application/Data Analyst (ON SITE in WA) - **Company:** PetroCard, Inc. - **Location:** Kent, WA, United States - **Experience:** Expert - **Salary:** $85,000.0 - $130,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Business Systems, Databases, Crystal Reports (Reporting Software), Data Validation, Data Files, Data Integration, Extract Transform Load (ETL), Data Mapping, Relational Databases, Database Queries, Disaster Recovery, Knowledge Management, Lookup Table, Microsoft SQL Server, Performance Tuning, Powerpivot, Power BI, Sage Accounting, Salesforce.Com, SQL Stored Procedures, SQL Databases, SQL Server Reporting Services, Data Streaming, Systems Integration, Boomi, Backend, Powerquery, Data Loader, Performance Monitor, Integration Frameworks, Salesforce Object Query Language (SOQL), User Administration - **Published:** June 18, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=b33935c04b8688d3 ## About the Role Do you have experience in Systems integration?, Do you have a Bachelor's degree?, * 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. * Experience using Salesforce including Reports & Dashboards, Flows, Data Loader, SOQL, and Workbench is a plus. * Experience with Boomi or other data-integration platforms * Strong documentation habits and attention to detail. ## Description 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., * 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. Database Administrator * 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. ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Developing the Backend with Stefan Lingler, CTO at Shpock](https://www.wearedevelopers.com/videos/100360-developing-the-backend-with-stefan-lingler-cto-at-shpock) - [Data Science, ML & AI in the Oil and Gas Industry at NDT Global - Dr. Katja Träumner](https://www.wearedevelopers.com/videos/1308-data-science-ml-ai-in-the-oil-and-gas-industry-at-ndt-global-dr-katja-traumner) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) - [Nest.js - TypeScript in the backend can also be clean](https://www.wearedevelopers.com/videos/1033-nest-js-typescript-in-the-backend-can-also-be-clean) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) ## Related Articles - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)