Mid-Level Data Analyst

Job Description

The Mid-Level Data Analyst is responsible for conducting in-depth data analysis to provide actionable insights for stakeholders. 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.

 

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 to layman’s terms and explanations as requested by customers and for a diverse range of audiences (including executive briefings, Town Halls, Industry Sync meetings, etc)
• 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 to how we communicate with stakeholders, and recommend measurable improvements
• Identify and manage key performance indicators (KPIs)
• Research and recommend benchmarks based on subject, industry, Government use, and feasibility of obtaining data
• Connect data points across multiple sources to infer information about stakeholder sentiment, behavior, attitudes, needs, and implications for the team
• Provide storytelling support based on data observations and strategic goals
• Excellent written and verbal communication skills, with the ability to craft and deliver high-quality communication products
• Translate data observations, trends, and insights into presentations (e.g., create charts, visualizations, pivoting, etc.)
• Prepare summaries of insight into clear and concise reports, briefings, and actions (e.g., requesting additional clarification via taskers, changes to our communications based on implications or inferences)
• Supporting data management of 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 to evolving stakeholder management requirements and stakeholder needs
• Understanding basics of data quality, including integrity and reliability
• Perform regular audits of data pipelines and stakeholder information to maintain currency of data
• Conduct data analysis and generate reports, dashboards, and data files based on stakeholder information to assist in tracking stakeholder engagement, adoption, and feedback.
• Leverage a variety of data visualization and BI tools (e.g., Tableau, Power BI, Excel) along with scripting languages such as Python, R, or SQL to transform data into meaningful insights for stakeholders based on Government requirements
• Monitor the quality and accuracy of data, interpret and troubleshoot any issues, and resolve discrepancies to ensure data integrity and meaningful information

Qualifications

Required Qualifications

• Bachelor’s degree in Data Science, Statistics, Computer Science, or a related field.
• 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.
• 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 the decision
• Proficiency in configuration, customization, APIs, ACLs, and advanced scripting
• Agile/Scrum related certifications
• ITIL v3 or v4 Certification