Data Analyst II

Overview

We are seeking an experienced Data Analyst II in our Lexington, KY office.

Why Gray?

Gray is a fully integrated, global service provider deeply rooted in engineering, design, and construction, along with smart manufacturing and equipment manufacturing services. Consistently ranked as a leader in the industry, we focus on the following markets for domestic and international customers: Food & Beverage, Manufacturing, Automotive, Distribution, Mission Critical, and Commercial.

Founded in 1960, Gray’s robust offering enables us to create one-of-a-kind solutions at the highest levels of customization, delivering unmatched precision and partnership to some of the world’s most sophisticated organizations. Still, these areas don’t define Gray—our people do. Passion, commitment, and a great team spirit all speak to the team members at Gray.

What we expect (essential functions) …

• Develop and maintain reports, dashboards, and visualizations using Power BI.
• Design and implement data models using star schema principles to optimize report performance and usability.
• Write advanced SQL queries to clean, transform, and validate data for reporting.
• Apply DAX to create dynamic and calculated measures, enhancing report functionality.
• Debug and troubleshoot issues in reports and data models, ensuring accuracy and reliability.
• Maintain a catalog of reports and dashboards, documenting descriptions, intended audience, key metrics, and usage instructions.
• Contribute to the business-facing data catalog by logging newly created reports and ensuring proper metadata tagging.
• Collaborate with stakeholders to validate requirements and deliver actionable insights.
• Document workflows, requirements, and processes to ensure consistency and reproducibility.
• Begin informing database design decisions in collaboration with Data Engineers, ensuring alignment with reporting objectives.
• Desire to pursue professional development and continuous learning. This team member will:

• Be strongly encouraged to complete advanced DAX training, such as the Mastering DAX course, to build high-performing, dynamic reports.
• Continue to refine storytelling and data visualization skills, focusing on creating user-friendly, impactful dashboards.
• Advance their knowledge of star schema design and best practices for data modeling.
• Explore opportunities to use Tabular Editor 3 for optimizing models and improving workflows.
• Gain familiarity with Power Platform tools to expand capabilities in automation and integration.

Who we want… (Requirements)

We are looking for a capable and proactive Data Analyst II to join our growing analytics team. This role is ideal for individuals who have a solid foundation in data analysis and reporting and are ready to take on more advanced responsibilities, including creating impactful dashboards, collaborating with stakeholders, and optimizing data models.

As a Data Analyst II, you will design and maintain reports, dashboards, and visualizations using Power BI while ensuring alignment with business objectives. You will work on data transformations, troubleshoot issues, and begin contributing to the design and optimization of data models.

• Bachelor’s degree in Business Analytics, Information Systems, Data Science, or a related field, or equivalent practical experience.
• 2-4 years of experience in a data-related role with hands-on experience in BI tools such as Power BI or Tableau.
• Proficiency in DAX (Data Analysis Expressions) for creating calculated measures and columns in Power BI reports.
• Advanced understanding of SQL for querying and transforming data.
• Familiarity with star schema design and its application in reporting.
• Strong communication and analytical skills, with the ability to manage multiple priorities effectively.
• Experience with GIT for version control preferred (creating branches, making commits, and managing pull requests).
• Familiarity with VS Code and Azure DevOps for project collaboration preferred.
• Experience with Tabular Editor 3 for advanced data modeling and report optimization preferred.
• Exposure to Power Platform tools such as Power Automate or Logic Apps preferred.
• Knowledge of data governance and security principles.

The new team member should…Be a results-driven individual who is skilled at creating impactful visualizations and providing actionable insights. You should enjoy collaborating with stakeholders, solving complex data problems, and continuously enhancing your technical skills.

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. 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-DG1