Data Analyst
RemoteHunter · United States
- Hybrid
- Full-time
- $94,418 / year
- United States
Tailored resume — keyword-matched to this role.
Hiring manager — we find who's hiring.
Intro email — drafted to reach them directly.
Job highlights
- Analyze data for public service program evaluation.
- Develop interactive reports and dashboards.
- Extract insights from complex datasets.
- Advise leaders on data-driven decisions.
- Manage analytics projects with stakeholders.
About the role
About RemoteHunter's Client
This organization operates in the public service sector, focusing on program evaluation and performance improvement. It addresses challenges related to effective data use in service enhancement by supporting agency leaders and staff with data analysis, reporting, and visualization. The organization serves a broad stakeholder base and emphasizes data-driven decision-making to improve outcomes.
About the Opportunity
The Data Analyst plays a critical role in supporting data and evaluation functions within the agency. This position enables informed decision-making by developing interactive reports and dashboards, extracting insights from complex datasets, and advising program leaders on data-related matters. The role contributes directly to program evaluation and performance improvement efforts, facilitating the agency's effective use of data to enhance services.
Responsibilities
- Develop interactive data reports and dashboards using Microsoft Power BI and Excel based on user requirements.
- Manipulate and extract insights from complex datasets, including automated ETL (Extract, Transform, Load) functions in Power BI, Excel data handling, and SQL query writing.
- Advise program leaders and staff on program evaluation, data collection methods, reporting, and performance improvement.
- Participate in strategic meetings and represent the Data team on agency committees and workgroups.
- Contribute to team knowledge-sharing, peer code/report reviews, and maintain a supportive team culture.
- Engage actively in organizational activities advancing diversity, equity, and inclusion (DEI) values.
- Manage and coordinate complex analytics projects involving multiple cross-functional stakeholders.
Requirements
- Educational background meeting one of the following criteria: Bachelor’s degree in a relevant field, Associate degree plus 1 year of relevant professional experience, or High school diploma (or equivalent) plus 2 years of relevant professional experience.
- Demonstrated experience in data or business analytics, data manipulation, and data visualization.
- Minimum age of 21 years.
- Ability to secure clearance from a tuberculosis (TB) test, fingerprinting background checks, and any applicable state or federal compliance requirements.
- Core technical proficiency in SQL query writing, Power Query data transformations, Power BI report/dashboard development with DAX, and advanced Excel data tools.
- Strong baseline understanding of fundamental statistical concepts and data visualization best practices.
- Hands-on experience with data modeling and navigating complex relational databases.
- Proven skills in planning, organizing, and managing complex data projects with multiple stakeholders.
- Collaborative team orientation and a verified commitment to fostering diversity, equity, and inclusion (DEI).
Preferred Qualifications
- Experience in structured survey design and analyzing raw data from survey responses preferred.
- Familiarity with Git version control and peer review workflows preferred.
- Background or domain knowledge in business analytics, performance improvement, program evaluation, or relevant public service fields preferred.
Pay Range and Compensation Package
- Base salary range: $87,418.00 to $101,418.00 USD per year (starting salary depends on applicable experience).
- Eligibility for structured annual salary increases.
Benefits & Perks
- Generous Paid Time Off package including 5 weeks of vacation/PTO and 11 paid holidays.
- Comprehensive medical, dental, and vision insurance, including specialized coverage for chiropractic care, acupuncture, and fertility treatments.
- 50% employer-covered healthcare premium contributions for dependents.
- Long-term disability, family leave protection, and company-provided life insurance.
- 403(b) tax-advantaged retirement savings plan.
- Fully employer-paid Employee Assistance Program (EAP).
- Employer certification eligibility for the Public Service Loan Forgiveness (PSLF) program.
- Scholarship opportunities and continuous funding for professional development courses.
- Upward mobility with clear promotional opportunities within the agency across California and Washington.
Equal Opportunity Statement
Our client is an equal opportunity employer. They celebrate diversity and are committed to creating an inclusive environment for all employees. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, or national origin.
Key skills/competency
- Data Analysis
- Microsoft Power BI
- SQL
- Excel
- Data Visualization
- ETL
- Data Modeling
- Program Evaluation
- Performance Improvement
- Business Analytics
Skills & topics
- Data Analyst
- Data Analysis
- SQL
- Power BI
- Excel
- Data Visualization
- ETL
- Data Modeling
- Program Evaluation
- Public Service
How to get hired
- Tailor your resume: Highlight your SQL, Power BI, and Excel skills. Emphasize project management and data visualization experience.
- Showcase DEI commitment: Integrate examples of fostering diversity, equity, and inclusion in your application materials.
- Prepare for technical questions: Brush up on SQL queries, Power BI DAX, ETL processes, and statistical concepts.
- Understand the mission: Research the client's focus on public service and program evaluation.
- Network and inquire: Reach out to the hiring manager at *****@remotes.com for role-specific questions.
Technical preparation
Practice SQL query writing and optimization.,Build complex dashboards in Power BI.,Master Excel data manipulation and Power Query.,Review statistical concepts and data modeling.
Behavioral questions
Describe a complex data project you managed.,How do you advise non-technical stakeholders?,Share an experience promoting DEI at work.,How do you handle conflicting stakeholder needs?
Frequently asked questions
- What are the primary tools used by a Data Analyst at this public service organization?
- As a Data Analyst at this organization, you will primarily use Microsoft Power BI and advanced Excel for developing interactive reports and dashboards. You'll also heavily utilize SQL for data extraction and transformation, along with Power Query for ETL processes.
- What is the educational requirement for the Data Analyst role at RemoteHunter's client?
- The educational requirements for the Data Analyst position include a Bachelor's degree in a relevant field. Alternatively, an Associate degree with 1 year of relevant experience or a high school diploma with 2 years of relevant experience is accepted.
- Can I apply for the Data Analyst position if I have experience outside the public service sector?
- Yes, while domain knowledge in public service is preferred, the core requirements focus on demonstrated experience in data analytics, manipulation, and visualization. Your transferable skills in SQL, Power BI, and Excel are highly valued.
- What does the compensation for the Data Analyst role entail?
- The Data Analyst role offers a competitive base salary ranging from $87,418.00 to $101,418.00 USD annually, with eligibility for structured annual salary increases based on applicable experience.
- Are there opportunities for professional development as a Data Analyst?
- Absolutely. The organization provides continuous funding for professional development courses, scholarship opportunities, and clear upward mobility paths for Data Analysts within their California and Washington locations.
- What is the work arrangement for this Data Analyst position?
- This Data Analyst position is advertised as remote, offering flexibility in where you work while contributing to the organization's mission.
- How does the organization support work-life balance for its Data Analysts?
- The organization supports work-life balance with a generous Paid Time Off package including 5 weeks of vacation/PTO and 11 paid holidays, alongside comprehensive health benefits and a fully paid Employee Assistance Program.
- What are the key technical skills required for a Data Analyst at this organization?
- Key technical skills include proficiency in SQL query writing, Power BI (including DAX and Power Query), advanced Excel data tools, data modeling, and a strong understanding of statistical concepts and data visualization best practices.