What are the responsibilities and job description for the Data Analyst position at Ekman Associates, Inc.?
Job Details
Job Description
Title: Data Analyst
Location: Remote
Ekman Associates is a management consulting firm that specializes in developing business, digital, and technology strategy, delivering solutions, and addressing human resource demands.
Summary:
This role focuses on KPI and SLA design, operational reporting, deep business analysis, and Excel-driven modeling rather than heavy data engineering or platform build-out. You will partner with operations and business leaders to define meaningful metrics, monitor service levels, and deliver timely, actionable reports that improve outcomes.
Responsibilities:
- KPI and SLA Development: Lead the definition, documentation, and lifecycle management of KPIs and SLAs that align to business objectives; translate business goals into measurable indicators.
- Reporting and Insight Delivery: Design, maintain, and distribute recurring reports and executive-ready scorecards tracking performance against KPIs and SLAs.
- Operational Analysis: Perform root cause and trend analyses to identify opportunities, risks, and performance gaps; produce concise recommendations and next steps.
- Excel Modeling and Automation: Build robust Excel models, pivot-driven analyses, and automated reporting templates using formulas, advanced functions, and macros when appropriate.
- Minimal Data Querying: Run and validate light SQL queries or extracts as needed to pull data for analysis; collaborate with data teams when complex extraction or transformation is required.
- Stakeholder Partnership: Work closely with operations, account teams, and leadership to ensure metrics are understood, actionable, and adopted across teams.
- Data Quality and Governance: Validate incoming data, document metric definitions and data sources, and escalate discrepancies to ensure trusted reporting.
- Presentation and Storytelling: Synthesize findings into clear presentations and one-page summaries for non-technical audiences.
- Education: Bachelor's degree in Business, Finance, Economics, Statistics, Analytics, or related field, or equivalent experience.
- Experience: 3-5 years in a data or business analyst role with strong emphasis on KPI/SLA work, operational reporting, and Excel-based analysis.
- Tools: Advanced Excel skills including pivot tables, lookup functions, array formulas, and basic macros. Experience with Datadog, Power BI or Tableau for visualization and scorecards.
- Querying: Basic SQL knowledge limited to writing simple selects and filters to extract data; heavy SQL or scripting is not required.
- Analytical Skills: Strong problem-solving, quantitative reasoning, and ability to translate data into actionable recommendations.
- Communication Skills: Clear written and verbal communication with ability to present to senior stakeholders and cross-functional teams.
- Organization: Proven ability to manage multiple reporting streams, prioritize requests, and meet recurring deadlines.
- Experience in media, entertainment, or technology operations.
- Familiarity with formal SLA frameworks and operational performance management.
- Experience documenting metric dictionaries, runbooks, or measurement playbooks.
- Experience working with business teams to operationalize KPIs and drive continuous improvement.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.