BI and Data Solutions Lead

Pay Range: $100,000- $150,000

Position Overview

We are seeking a highly motivated, inquisitive, and creative BI and Data Solutions Lead to join our successful 24 location Optometric practice in Indiana. This role is pivotal in transforming raw data from various systems and services into meaningful and actionable insights for our leadership. The ideal candidate will possess a blend of technical expertise, creativity, curiosity, problem-solving, excellent communication skills, and a deep understanding of our business and systems.

Responsibilities

• Extract, analyze, and interpret data from multiple data stores, including MS SQL, APIs, unstructured text, and some undocumented systems, to provide comprehensive and actionable reports.
• Work closely with various departments to understand their data needs, leveraging your knowledge of the business to provide new and valuable insights.
• Create and maintain complex MS SQL queries to extract and transform data.
• Create and maintain SSIS packages to extract and process data, ensuring accuracy and efficiency.
• Create and administer Microsoft PowerBI dashboards and workspaces.
• Create and maintain SQL Reporting Services (SSRS) to develop and deliver clear, insightful, and easily consumable reports (less SSRS than PowerBI).
• Prepare, cleanse, and integrate data from various sources to ensure it is ready for analysis and reporting.
• Design and implement new systems and processes to enhance efficiency, working with software engineers when needed.
• Serve as the go-to expert for all company data, driving data-informed decision-making and ensuring data integrity.
• Tackle broad and undefined data challenges by using creativity, intelligence, and persistence to develop innovative solutions.
• Present findings clearly and effectively through written and verbal communication, tailoring the message to the audience.
• Seek out and uncover new data connections and opportunities to enhance reporting and analytics capabilities.
  
  

Qualifications

• Ideal but not required – Bachelor’s Degree in Computer Science, Information Technology, Data Science, Informatics, Business, or a related field.
• Required – 5 years of experience in data analysis, SQL querying, ETL, and Power BI creation.
• Required – Advanced proficiency writing MS SQL queries.
• Required – Advanced proficiency building Power BI dashboards.
• Ideal but not required – experience using SSIS and SSRS.
• Strong written and verbal communication skills.
• Demonstrated ability to work independently, be self-motivated, and handle complex and undefined tasks.
• Exceptional curiosity, creativity, and problem solving in approaching data challenges.
• Deep understanding of our business, systems, and how technology works, with the vision to develop new solutions.
  
  

Primary Challenges

• Handling broad and undefined data to create meaningful insights.
• Working independently as the sole expert on company data, with minimal documentation and support.
• Developing creative and clear reports for diverse business divisions.
• Overcoming resistance from vendors or data sources to extract necessary data.
  
  

Work Environment

This position offers the flexibility to work fully remotely, with a preference for a hybrid in-office/remote arrangement.

Ideal Candidate Vision

The ideal candidate is someone who thrives on challenges and has the vision and persistence to turn ambiguous data into actionable insights. They are not just technically proficient but also deeply understand our business and how various systems integrate and function. Their intelligence and creativity allow them to see possibilities where others see obstacles, and they have the drive to figure out complex data puzzles, often with minimal guidance or documentation. This role is perfect for someone who can stare into the abyss of undefined data and emerge with clear, valuable insights that drive our business forward.