> Markdown version of [/jobs/ext/609567-data-analyst-ii](https://www.wearedevelopers.com/jobs/ext/609567-data-analyst-ii). 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). --- # Data Analyst II - **Company:** Astreya Partners - **Location:** United States (Remote available) - **Salary:** $66,120.0 - $104,400.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Databases, Data Infrastructure, Data Systems, Data Visualization, Pivot Tables, Standard Sql, Macros, Conditional Formatting - **Published:** June 12, 2026 - **Apply:** https://www.dice.com/job-detail/23a9c288-df65-41a7-bc88-69afd8995668 ## About the Role Bachelor's degree (B.S/B.A) from four-college or university and 2 to 5 years' related experience and/or training; or equivalent combination of education and experience Builds productive internal and external working relationships Exercises judgment within defined procedures and practices to determine appropriate action SQL skills; including creating and modifying macros, as well as creating dashboards using SQL coding Excellent written communication skills High level of attention to detail Advanced Excel skills to include; formulas, functions, pivot tables, lookup and reference formulas (i.e. vlookups), statistical formulas (countifs, sumifs), macros (ability to create new and edit existing), conditional formatting, importing data, creating graphs/charts, etc. Ability to independently analyze large amounts of data; including the ability to identify, analyze, and interpret trends, gaps, patterns in complex data sets Preferred Qualifications: Experience using Google PLX Dashboards Physical Demand & Work Environment: Must have the ability to perform office-related tasks which may include prolonged sitting or standing Must have the ability to move from place to place within an office environment Must be able to use a computer Must have the ability to communicate effectively Some positions may require occasional repetitive motion or movements of the wrists, hands, and/or fingers ## Description Uses professional concepts and company objectives to resolve complex issues in creative and effective ways Works on complex issues where analysis of situations or data requires an in-depth evaluation of variable factors Your Roles and Responsibilities: Create data visualizations Troubleshoot and test database technical issues with development team Create monthly Excel and Google Sheets files from database Independently analyze data sets to identify opportunities for increased accuracy and efficiency Perform quality assurance on data to determine potential data gaps Handle data-related technical issues and support data infrastructure needs Assemble large, complex data sets that meet functional / non-functional business Work with data and analytics experts to strive for greater functionality in our data systems. Other duties as required. This list is not meant to be a comprehensive inventory of all responsibilities assigned to this position ## Related Videos - [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) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Kubernetes and Microservices with Multi-Model Databases](https://www.wearedevelopers.com/videos/382-kubernetes-and-microservices-with-multi-model-databases) - [Making Data Warehouses fast. A developer's story.](https://www.wearedevelopers.com/videos/302-making-data-warehouses-fast-a-developer-s-story) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Modularity: Let's dig deeper](https://www.wearedevelopers.com/videos/1200-modularity-let-s-dig-deeper) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [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 Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story)