Analysis Skills, Artificial Intelligence (AI), Automation, Best Practices, Business Analysis, Code Reviews, Communication Skills, Construction, Continuous Deployment/Delivery, Continuous Improvement, Continuous Integration, Data Analysis, Data Management, Data Modeling, Data Science, Data Sets, Data Visualization, Database Design, Database Technology, Debugging Skills, Debugging Tools, DevOps, Equipment Maintenance/Repair, Food Production, Food and Beverage Industry, Git, Identify Issues, Information Technology & Information Systems, Mentoring, Microsoft Product Family, Microsoft Windows Azure, Network Operations Center, Performance Tuning/Optimization, Physical Demands, Power BI, Problem Solving Skills, Professional Services, Project Design, Project/Program Management, Real Estate, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), Source Code/Configuration Management (SCM), Star Schema, Storytelling, Team Player, Trend Analysis, User Interface/Experience (UI/UX)
Gray Inc's Information Technology team is seeking a skilled Data Analyst III to join our team in Lexington, KY.
Responsibilities:
Why Gray?
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.
What we expect… (Essential Functions)
- 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.
Professional Development and Continuous Learning
- 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.
Qualifications:
Who we want… (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.
Nice to Haves but not required
- 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.
The new team member should…
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.
Physical Demands & Work Environment
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.
Supervisory Responsibilities
This position has no supervisory responsibilities.
EEO Disclaimer
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.
LI-MT1