Data and Business Intelligence Analyst

Benchmark
United States
2 days ago
Apply on www.builtincolorado.com
Prepare application

Role details

Contract type
Internship / Graduate position
Employment type
Part-time (≤ 32 hours)
Experience level
Expert
Experience required
2 years minimum
Compensation
$47,840.0
Working hours
Regular working hours
Languages
English, Spanish

Tech stack

Microsoft Excel Data Analysis Data Validation Extract Transform Load (ETL) Data Visualization Data Warehousing Relational Databases Database Queries Information Sciences Python (Programming Language) PostgreSQL Machine Learning
+10 more
Metadata Standards Microsoft SQL Server MySQL Oracle (Applications) Power BI Reverse Engineering SQL Databases Computational Statistics Data Management Data Pipelines

Job description

Remote Hiring Remotely in USA Mid level Remote Hiring Remotely in USA Mid level Builds and maintains Power BI reports, dashboards, data models, DAX calculations, and row-level security. Writes SQL queries for reporting, analysis, and data validation; investigates warehouse structures and inconsistencies; and partners with stakeholders and data teams to deliver accurate insights. The role manages recurring and ad hoc reporting requests, communicates findings through data visualization, and supports business decisions across sales, marketing, and operations. The summary above was generated by AI, The Data and Business Intelligence Analyst delivers the reporting and data analysis that drive day-to-day decisions across sales, marketing, and operations at Benchmark Education. This role owns report and dashboard development in Power BI, works directly with business stakeholders to translate their questions into clear, trusted reporting, and builds a working understanding of our data environment to ensure what’s delivered is accurate and useful., * Work directly with stakeholders to understand their needs and translate them into clear reporting and analysis requirements

  • Design, build, and maintain Power BI reports and dashboards, including data models, DAX calculations, and row-level security where needed
  • Own a portfolio of recurring reports including development, maintenance, troubleshooting, and updates as business needs change
  • Write and optimize SQL queries against the data warehouse to support reporting, ad hoc analysis, and data validation
  • Develop a working understanding of the structure and relationships within the data warehouse to navigate it independently and flag inconsistencies
  • Partner with the data team members to communicate reporting requirements and validate that data feeding into reports and dashboards is accurate and complete
  • Tell effective stories about business performance and trends through data visualization
  • Respond to ad hoc reporting requests with accurate, timely turnaround
  • Support stakeholders and other data/report consumers across the business *, Supports value-based healthcare programs through complex SQL analysis, reporting, data reconciliation, program evaluation, payment support, and ad hoc analytics. Works with healthcare and insurance data, develops monthly reports, evaluates new opportunities, and communicates findings to senior and executive leadership. The role requires advanced Excel and large-scale data experience, with preferred expertise in Azure Synapse Analytics, Databricks, PySpark, or Python.

Requirements

  • 2-5 years of professional experience in data analysis, reporting, or business intelligence
  • Bachelor’s degree in a relevant discipline, or equivalent professional experience
  • Demonstrated expertise in Power BI, including data modeling, DAX, and report/dashboard development
  • Strong proficiency in SQL with relational databases (SQL Server, MySQL, Oracle, Postgres), including writing queries to analyze and validate data
  • Proven ability to learn and navigate an existing data environment: reverse engineering data patterns and structures to infer relationships and spot inconsistencies
  • Working knowledge of how data moves through a reporting pipeline, enough to collaborate effectively with data team
  • Functional understanding of advanced analytics concepts (statistical or AI-based techniques) and when to apply them
  • Effective written and verbal communication skills, especially explaining data and reporting to non-technical stakeholders
  • Excellent organization and documentation skills, with strong attention to detail
  • Comfortable owning multiple reports/dashboards independently and prioritizing competing requests, * Hands-on experience building or maintaining ETL/ELT pipelines
  • Experience with advanced statistics, information science, or machine learning
  • Working understanding of Master Data Management techniques and tools
  • Experience with metadata standards and procedures in the publishing industry
  • Experience with ERP tools and processes
  • Experience with project management and implementation of best practices

Benefits & conditions

Remote United States 23-23 Hourly Internship 23-23 Hourly Internship HR Tech * Consulting Supports the Product Innovation Team by modifying and optimizing SQL queries, visualizing data with BI tools, identifying insights, and analyzing enhancements. Participates in coding, testing, documentation, and discussions while providing customer service and managing multiple tasks. The internship requires at least 30 hours per week and emphasizes advanced Excel and visualization skills, plus familiarity with Python and SQL. Top Skills: AWSBusiness Intelligence ToolsExcelPythonSQL

About the company

Benchmark Education Company (BEC) is a leading publisher of core, supplemental, and intervention literacy and language resources in English and Spanish, with valid and reliable digital assessments that inform instruction. BEC is also a provider of exceptional professional development to educators.

BEC is recognized as a responsive publisher that offers equally rigorous and engaging digital, print, and hybrid learning materials grounded in the Science of Reading research. BEC monitors research outcomes carefully to create effective foundational resources that include strong decoding materials with systematic and explicit instruction and high-quality resources focused on language development and comprehension. BEC’s content-rich and authentic texts offer instruction in close reading and analysis, multiple perspectives, and authentic literature while building world knowledge and reflecting the individuality of every student in each diverse classroom.

Family owned and operated for more than 25 years, BEC is committed to partnering with educators to provide the best for all students through resources of exceptional quality, world-class professional learning, and effective and dedicated customer support.

Benchmark Education Publishing (BEC) and its affiliates are proud to be an Equal Opportunity Employer.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.builtincolorado.com
Prepare application

Good distractions

Loading talks and stories from around this role…