Data Analyst

Job description

DATA ANALYST POSITION SUMMARY THIS POSITION IS IN STATE, IN OKLAHOMA CITY. IT IS NOT A REMOTE POSITION. Primary responsibility for 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. ESSENTIAL FUNCTIONS To accomplish this job successfully, an individual must be able to perform, with or without reasonable accommodation, each essential function satisfactorily. Reasonable accommodation may be made to help enable qualified individuals with disabilities to perform the essential functions. • 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. SKILLS AND ABILITY 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. WORK ENVIRONMENT While performing the duties of this job, the employee is occasionally exposed to toxic or caustic chemicals, body fluids, blood borne pathogens, and the risk of radiation. The noise level is usually moderate. As the dental practice is heavily dependent on scheduling, the general environment can become hectic at times. Therefore, the employee must be able to handle effectively the normal anxieties associated with the job. EDUCATION, EXPERIENCE & TECHNICAL SKILLS EDUCATION: Bachelor’s degree (four-year college) in a related field preferred (e.g., Information Systems, Computer Science, Data Analytics, Finance, or similar). EXPERIENCE: 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. CERTIFICATIONS & LICENSES: Microsoft Office Specialist Excel/Power Platform Expert Certification COMPUTER SKILLS: • Microsoft Suite of Services (Excel, Teams, Outlook, PowerPoint, Power BI) • SQL (required – ability to write queries involving joins, aggregations, and data validation) • 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 PROFESSIONAL & BUSINESS SKILLS: • 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