Mid-Level Data Analyst

Position Overview

The Mid-Level Data Analyst is responsible for supporting technical design, conducting design reviews, and ensuring application requirements and standards are met. This role involves managing data sets, ensuring data quality, and creating detailed reports and visualizations. The Mid-Level Data Analyst collaborates closely with the OCM team and stakeholders to understand their objectives and to drive data-informed decision-making processes within the organization. This individual will provide data interpretation and analytics support to translate insights into actionable changes.

Key Responsibilities

• Normalize, interpret, and translate large volumes of data
• Apply various data analysis techniques (e.g., comparison to historic data, external research, within similar datasets; trend or visualize data; create pivot table views) to derive usable information about the dataset
• Conduct research or identify sources to contextualize data for interpretation
• Translate observations into assumptions or next steps in guiding our communication and stakeholder engagement
• Create visual aids, charts, and presentations with clear, layman's terms explanations for diverse audiences, including executive briefings and industry meetings
• Anticipate needs and recommend steps to bridge gaps in knowledge or validate assumptions
• Develop data call templates to ensure high quality
• Collaborate with workstream leads and cross-functional leads to infer meaning, brainstorm implications, and recommend measurable improvements
• Identify and manage key performance indicators (KPIs)
• Research and recommend benchmarks based on subject, industry, government use, and data feasibility
• Connect data points across multiple sources to infer stakeholder sentiment, behavior, attitudes, needs, and implications
• Provide storytelling support based on data observations and strategic goals
• Translate data observations, trends, and insights into presentations including charts, visualizations, and pivot tables
• Prepare clear and concise reports, briefings, and action summaries
• Support data management of the Stakeholder Management Tool
• Help design and maintain import files for bulk upload of stakeholder information
• Normalize, sanitize, and prepare data for upload based on import definitions and needs
• Maintain templates to ensure that data pipelines are robust and adaptable
• Perform regular audits of data pipelines and stakeholder information to ensure data integrity
• Conduct data analysis and generate reports, dashboards, and data files to track stakeholder engagement, adoption, and feedback
• Leverage data visualization and BI tools (e.g., Tableau, Power BI, Excel) along with scripting languages (Python, R, SQL) to transform data into meaningful insights
• Monitor the quality and accuracy of data, troubleshoot issues, and resolve discrepancies to ensure data integrity

Required Qualifications

• Education: Bachelor's degree in Data Science, Statistics, Computer Science, or a related field.
• Experience Required: At least 5 years of experience in data analysis or related fields.
• Strong understanding of data analysis methods, statistical modeling, and data visualization
• Proficiency in data analytics tools and software (e.g., Excel, SQL, Python, R, Tableau)
• Advanced data analysis, reporting, and visualization skills
• ServiceNow experience
• Excellent verbal, written, and interpersonal communication skills, with the ability to present complex data clearly

Preferred Qualifications

• Certification in Data Analytics, Statistical Analysis, or related fields is a plus
• Strong ability to interact with employees, management, and vendors at all levels
• Demonstrated skill in taking initiative, showing sound judgment, and making decisions
• Proficiency in configuration, customization, APIs, ACLs, and advanced scripting
• Agile/Scrum related certifications
• ITIL v3 or v4 Certification

Benefits & Perks

• Benefits: Your health comes first - we offer comprehensive medical, dental, & vision insurance that starts the first of the month after you join the team
• Invest in your future - 401(k) Plan with immediately vested employer contributions; no matching required
• Work hard, play hard - generous Paid Time Off (PTO), one additional day of paid wellness leave per calendar year, and ten federal holidays
• Pawsitively pawesome - Pet Insurance (because our little critters are part of our families, too!)
• Invest in your education - Tuition reimbursement, internal training programs, & company-sponsored industry certifications
• Be part of a dynamic and collaborative work environment recently ranked as a Top Work Place by The Washington Post
• Enjoy team building activities, community volunteering, quarterly HQ days, wellness events, happy hours, and family fun events