Data Analyst

Dental Depot•Oklahoma City, OK

8d•Onsite

About The Position

This position is in-state, in Oklahoma City. It is not a remote position. The primary responsibility is hands-on analytic reporting, data infrastructure support, and development within the organization’s reporting platform (DDI). This position reports directly to the Senior Business Intelligence Engineer and supports the Business Intelligence team in executing reporting, database, and data integration workstreams, including report development, data modeling, and system optimization. This is an execution-focused role responsible for building, maintaining, and improving reporting outputs and underlying data structures. The position emphasizes technical competency, attention to detail, and the ability to produce accurate work within established systems and processes.

Requirements

Adaptability - Ability to adapt to change in the workplace and adjust to evolving business needs and priorities.
Organized - Possesses strong organizational skills and follows structured processes in completing work.
Detail Oriented - Demonstrates a high level of attention to detail and accuracy in all deliverables.
Analytical Skills - Ability to apply structured thinking and logical reasoning to technical and data-related problems.
Accuracy - Ability to perform work accurately and thoroughly, validating outputs before delivery.
Communication Skills - Ability to communicate clearly and effectively when gathering requirements, reporting issues, and providing updates.
Cross-Functional Collaboration - Ability to work effectively with internal stakeholders across departments to support reporting needs.
Problem Solving - Ability to troubleshoot issues independently and propose multiple potential solutions prior to escalation.
Technical Aptitude - Demonstrates a strong foundational understanding of data structures, reporting tools, and technical systems.
Accountability - Takes ownership of assigned work and follows through to completion with minimal oversight.
Work Ethic - Demonstrates reliability, urgency, and a consistent commitment to producing high-quality work.
Bachelor’s degree (four-year college) in a related field preferred (e.g., Information Systems, Computer Science, Data Analytics, Finance, or similar).
2+ years of experience in data analytics, reporting, or related technical roles (internships, academic projects, or hands-on experience acceptable).
Experience working with structured datasets and reporting tools required.
Microsoft Suite of Services (Excel, Teams, Outlook, PowerPoint, Power BI)
SQL (required – ability to write queries involving joins, aggregations, and data validation)
Ability to follow established processes and technical standards with consistency
Strong attention to detail in data handling, validation, and reporting outputs
Ability to manage multiple tasks and meet deadlines in a structured environment
Willingness to learn and develop technical skills on the job
Ability to approach problems methodically and avoid making unsupported assumptions
Clear written and verbal communication for task updates, issue identification, and resolution
Ability to work independently while aligning with team direction and priorities

Nice To Haves

Snowflake or similar cloud data platforms (preferred)
Familiarity with ETL/ELT processes and data pipeline concepts
Familiarity with AI-assisted tools (e.g., ChatGPT, Copilot) to support workflow efficiency and technical problem solving
Microsoft Office Specialist Excel/Power Platform Expert Certification

Responsibilities

Support the Business Intelligence team in building, maintaining, and optimizing Power BI dashboards and reports within the company reporting platform (DDI).
Write and modify SQL queries to support reporting, data extraction, validation, and troubleshooting.
Work with relational datasets, including joining multiple tables and validating outputs for accuracy and consistency.
Assist in the development and maintenance of data pipelines, transformations, and structured datasets within Snowflake or similar environments.
Execute data preparation, cleansing, and validation processes to ensure data integrity across reports and systems.
Troubleshoot reporting and data issues, identifying root causes and resolving issues without introducing downstream errors.
Follow established development standards, naming conventions, and documentation practices.
Assist in automating recurring reporting processes and improving workflow efficiency.
Work directly with internal stakeholders to gather report requirements, clarify objectives, and ensure alignment with business needs.
Document report logic, data definitions, and technical processes clearly and consistently.
Perform routine audits of reports and datasets to identify discrepancies, inconsistencies, or performance issues.
Support testing, validation, and deployment of new or updated reports and data processes.