Data Analyst III

Gray Inc's Information Technology team is seeking a skilled Data Analyst III to join our team in Lexington, KY.

• Design and develop advanced reports and dashboards using Power BI, applying best practices in storytelling and user experience.
• Perform code and report reviews to ensure quality, maintainability, and adherence to team standards.
• Lead training sessions for end users, empowering them to utilize reports and self-service analytics effectively.
• Monitor Power BI feature releases and updates, integrating new functionalities into team workflows.
• Design and implement complex data models using star schema principles to optimize performance and scalability.
• Apply advanced DAX techniques to create dynamic and calculated measures for complex reporting needs.
• Utilize advanced features of Tabular Editor 3 to optimize data models and reporting workflows.
• Contribute to database design discussions, working with Data Engineers to align structures with reporting requirements.
• Debug and troubleshoot issues in data pipelines, models, and reports to ensure accuracy and reliability.
• Handle ambiguity, actively seeking and driving clarity where needed, and adapt to change.

• Complete advanced DAX training, such as the Mastering DAX course.
• Work toward advanced certifications, such as PL-300 (Microsoft Power BI Data Analyst).
• Refine storytelling and visualization techniques to deliver compelling insights.
• Expand knowledge in integrating Power BI with other platforms and tools, such as Power Automate or Azure.
• Stay informed on emerging trends in data visualization and analytics to drive innovation within the team.
• Investigate ways to leverage AI responsibly and drive adoption of appropriate tools and processes across the team.

• Bachelor’s or Master’s degree in Business Analytics, Information Systems, Data Science, or a related field, with substantial professional experience in data analysis and reporting.
• Advanced proficiency in Power BI, including report design, data modeling, and DAX.
• Strong understanding of star schema design and database principles.
• Advanced SQL skills for querying and transforming complex data sets.
• Proven ability to mentor junior team members and conduct peer code and report reviews.
• Excellent communication and analytical skills, with experience collaborating across teams and stakeholders.

• Familiarity with Power Platform tools like Power Automate or Power Apps for workflow automation and integration.
• Advanced experience with Tabular Editor 3, including macros, Best Practice Analyzer, and DAX debugger.
• Knowledge of database design concepts to contribute to discussions and align reporting needs with database structures.
• Exposure to CI/CD pipelines for automating deployment of reports and datasets.
• Experience with GIT for version control and Azure Dev Ops for project management.

The physical demands described here are representative of those that must be met by a team member to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this position, the team member is frequently required to stand, walk, sit, use hands, reach with hands or arms and talk or hear.

They may occasionally be required to climb or balance, stoop, kneel, or crouch. Must occasionally lift and/or move up to 50 pounds. Specific vision abilities required include close vision. Generally, normal office environment where noise level is moderate and temperature/humidity is controlled. Overtime may be required.

This position has no supervisory responsibilities.

Gray is proud to be an Equal Opportunity Employer and welcomes everyone to apply. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, gender identity, sexual orientation, national origin, or protected veteran status and will not be discriminated against on the basis of disability.