Data Analyst I

Summary

Guarantee Electrical Company is building its data and analytics function and is seeking a Data Analyst I to join the team. The role involves developing and maintaining BI reports, improving data quality, supporting end users, and contributing to the overall data and analytics foundation of the company.

Responsibilities

• Build and Maintain BI Reports
• Develop, maintain, and continually improve reports and dashboards in Qlik and other BI tools
• Work with stakeholders across the business to understand analytics needs and build reporting solutions that are accurate, intuitive, and ultimately make an impact
• Ensure reports are trusted, well-documented, and align with business requirements
• Analyze data across our operational systems and help identify data quality issues, inconsistencies, and gaps
• Document findings, help recommend fixes, and work on implementations to improve data quality over time
• Build out monitoring solutions to help surface data quality issues where automated fixes are not possible
• Help the team ensure our data warehouse and BI reports meet high enterprise standards
• This may include tying out analytical metrics to source systems, reviewing consistency across reports, maintaining metric definitions, and measuring accuracy
• Work with business and operational users across the company
• Assist them in making the best use of BI software, investigating questions around metrics, and build confidence in using data across the company
• Help drive adoption of dashboards by ensuring users understand and trust the metrics
• Perform ad-hoc analysis to answer business questions, research anomalies, and recommend actions
• Help build out training and documentation artifacts to ensure users are comfortable in BI reports
• Assist in change management for analytics deliverables, including user testing, communicating updates, maintaining documentation, and promoting changes through testing and production environments
• As part of a growing team, you'll have opportunities to grow and contribute outside of your current skill set
• Whether that's building out new analytics solutions, testing tools and software, or implementing standards, you'll have an opportunity to make an impact
• Partnering with stakeholders across the company, you'll help define KPIs and metrics along with building out the solutions to surface those to the business
• The work you do and conversations with stakeholders will help shape how our data environment develops over time

Skills

• SQL skills: You're comfortable writing queries to extract, manipulate, and aggregate data
• Experience building BI reports and dashboards from a major platform (Qlik, Power BI, Tableau, etc)
• Basic Python or similar programming language experience
• Strong Excel skills (pivot tables, lookups, Power Query a plus)
• Clear communication skills. You're able to both explain data concepts to non-technical audiences as well as collaborate with technical team members
• Experience working with end users to gather requirements. Comfortable clarifying expectations and iterating on solutions
• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, related field, or similarly relevant experience
• Analytics experience: 1-4 years of experience as a data analyst, BI developer, or similar role
• Exposure to cloud data warehouses (Snowflake, Databricks)
• Advanced SQL skills. Ability to utilize window functions, CTEs. Exposure to writing stored procedures and common/shared functions a plus
• Experience utilizing APIs to extract and load data
• Exposure to dimensional modeling within data warehouses and/or semantic layers within BI tools
• Intermediate or advanced Python
• Experience working with version control (Git, Azure Devops)
• Exposure to ERPs or construction management software (Viewpoint Vista, Procore)

Qualifications

Must Haves

• SQL skills: You're comfortable writing queries to extract, manipulate, and aggregate data
• Experience building BI reports and dashboards from a major platform (Qlik, Power BI, Tableau, etc)
• Basic Python or similar programming language experience
• Strong Excel skills (pivot tables, lookups, Power Query a plus)
• Clear communication skills. You're able to both explain data concepts to non-technical audiences as well as collaborate with technical team members
• Experience working with end users to gather requirements. Comfortable clarifying expectations and iterating on solutions
• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, related field, or similarly relevant experience

Nice to Haves

• Analytics experience: 1-4 years of experience as a data analyst, BI developer, or similar role
• Exposure to cloud data warehouses (Snowflake, Databricks)
• Advanced SQL skills. Ability to utilize window functions, CTEs. Exposure to writing stored procedures and common/shared functions a plus
• Experience utilizing APIs to extract and load data
• Exposure to dimensional modeling within data warehouses and/or semantic layers within BI tools
• Intermediate or advanced Python
• Experience working with version control (Git, Azure Devops)
• Exposure to ERPs or construction management software (Viewpoint Vista, Procore)

Benefits

• Meaningful impact: Ability to make an impact on a growing team. You won't inherit a lot of technical debt or legacy maintenance. Help shape how the organization uses data for years to come.
• Modern data tools: Exposure to the full data technical stack. Ability to work with Qlik, Snowflake, business applications, and operational systems.
• Mentorship: Leaders experienced in the data space. You'll have an environment to learn from and collaborate with data leaders who also know how to do the work. This role is well-suited for an early career analyst looking to grow both technical and business facing skills over time.
• Cultural Alignment: A collaborative team culture that's willing to invest in learning, growth, development, and a commitment to data-driven decisions. You're encouraged to take ownership of areas as you grow and support the team.
• Primary Location: Full-time onsite at our St. Louis Office
• Travel: Limited travel (branch locations or industry conferences)