Business Intelligence Analyst

We are looking for a sharp, curious Business Intelligence Analyst to join our growing data team. In this role you will transform raw data into clear, actionable insights that drive strategic decisions across the organization. You will own the full analytics lifecycle — from querying source systems and building data models to publishing polished Power BI dashboards consumed by senior leadership.

Key Responsibilities

• Design, develop, and maintain interactive Power BI dashboards and reports for business stakeholders across Sales, Finance, Operations, and Marketing.

• Write complex SQL queries to extract, transform, and validate data from relational databases and data warehouses.

• Partner with business teams to understand reporting requirements and translate them into scalable BI solutions.

• Monitor data quality and pipeline health; investigate and resolve data discrepancies proactively.

• Document data definitions, business logic, and report methodology to support self-service analytics.

• Present findings and dashboard walk-throughs to both technical and non-technical audiences.

• Contribute to the development and governance of a centralized data model and semantic layer.
• 3+ years of experience in a BI, data analytics, or reporting analyst role.

• Advanced SQL skills — comfortable with window functions, CTEs, subqueries, and performance tuning.

• Hands-on experience building production-grade Power BI reports, including knowledge of DAX, Power Query, and data model design.

• Solid understanding of data warehousing concepts

• Ability to work independently, manage multiple priorities, and deliver results in a fast-paced environment.

• Strong analytical mindset with excellent attention to detail and a commitment to data accuracy.

• Clear written and verbal communication skills; able to translate complex findings into plain-language narratives.

Competencies preferred:

• Python proficiency for data manipulation and automation (pandas, NumPy, or similar libraries).

• Familiarity with dbt or other data transformation frameworks.

• Exposure to statistical analysis and predictive modeling.

• Power BI Service administration experience (workspaces, row-level security, deployment pipelines).

Work Environment

The following work environment characteristics are representative of those an employee encounters while performing the essential functions of this job:

• Open office, cubicle, individual or shared office

• Conference rooms or open offices

• Conferring with users on manufacturing shop floor

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

What do we offer

• Competitive salary and performance bonus.

• Comprehensive health, dental, and vision benefits.

• Flexible / remote-friendly working arrangements.

• Annual professional development budget and access to data conferences.

• A collaborative, data-driven culture where your work has direct business impact

What We Do

General Stamping & Metalworks is a leading supplier of stampings and assemblies to the North American solar power industry, which is forecasting another decade of double-digit growth. In addition, we are a key supplier to market leaders in a diverse set of industries including outdoor power equipment, agricultural and construction equipment, recreational vehicles and industrial trucks.

GSM has been in business since 1922, and we realize that our employees spend a large portion of their lives working; therefore, we have invested in the finest facility and grounds in the fabricating industry. We also invest in state-of-the-art equipment, technology, and in our greatest resource, our employees.

What Makes Us Different

GSM is proud of our diverse, welcoming workforce, and we make every effort and investment to ensure their success and provide a path to build better lives. We offer:

• Excellent wages
• Tuition reimbursement program
• Cafeteria
• Fully equipped fitness center
• Locker rooms with showers
• Air-conditioned welding department
• Employee wellness initiatives (on-site flu vaccination, wellness care, and EAP resources)
• Comprehensive health, dental, vision, life, and disability benefits
• 401(K), holiday pay, and vacation accrual that starts on the date of hire
• Advancement opportunities only a growing company can provide