Data Analyst III

Gray Construction•Lexington, KY

1d•Onsite

About The Position

Gray Inc's Information Technology team is seeking a skilled Data Analyst III to join our team in Lexington, KY. Gray is a fully integrated design-builder delivering end-to-end solutions across construction, professional services, specialty equipment, and real estate. Since 1960, Gray has grown from a regional contractor to a nationally ranked industry leader, serving top domestic and international companies in the following markets: Manufacturing, Food & Beverage, Data Centers, Advanced Technology, and Distribution. Our integrated approach allows us to deliver value at every phase of a project—from designing and building state-of-the-art facilities to fabricating custom process equipment and implementing advanced automation. But what truly defines Gray is our people. Our success is driven by passionate, collaborative team members who take pride in their work, value strong relationships, and are committed to doing the right thing for our customers and one another. At Gray, you’ll find a culture built on teamwork, accountability, and the opportunity to make a meaningful impact. “Personal growth precedes Gray’s growth.” – Stephen Gray, President & CEO, Gray, Inc.

Requirements

We are looking for an experienced and skilled Data Analyst III to join our analytics team. This role is ideal for individuals who have demonstrated expertise in data analysis and visualization, possess strong technical proficiency, and are ready to mentor others while contributing to the team's success.
As a Data Analyst III, you will take the lead in creating advanced reports and dashboards, optimizing data models, and conducting code and report reviews. You will collaborate with stakeholders to deliver actionable insights while driving team processes and best practices.
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.
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.
Be an innovative problem solver with the ability to independently develop impactful visualizations and models while mentoring others. You should have a passion for continuous improvement and enjoy contributing to a collaborative, results-oriented team environment.

Nice To Haves

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 DevOps for project management.

Responsibilities

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.
Ability to handle ambiguity, actively seeking and driving clarity where needed, and be adaptable to change.
Required to complete advanced DAX training, such as the Mastering DAX course.
Actively work toward advanced certifications, such as PL-300 (Microsoft Power BI Data Analyst).
Continue refining 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.