Business Data Analyst - Military veterans preferred

ASC Engineered Solutions


North Kingstown, Rhode Island

AREA OF INTEREST: Information Technology & Computer-Related
POSITION TYPE: Full-time


Job Title: Business Data Analyst


About the Company

Following the 2019 merger of Anvil International and Smith-Cooper International, our unified company relaunched in March 2021 as ASC Engineered Solutions. Under a single name and logo, ASC Engineered Solutions continues our focus on improving the customer experience every day and striving to deliver service excellence. For more than 150 years we have provided the finest-quality pipe products and services with integrity and dedication to superior customer service at all levels. ASC Engineered Solutions provides expertise and product solutions for a wide range of applications, from plumbing and mechanical, HVAC, industrial and fire protection to mining, and oil and gas. Our comprehensive line of products includes: pipe couplings, plain-end fittings, valves, cast and malleable iron fittings, forged steel fittings, steel pipe nipples and couplings, pipe hangers and hardware, channel and strut fittings, mining and oil field fittings, and much more.

ASC is looking for a Business Data Analyst that is proficient in data analysis, warehousing, and reporting. In this role, you will be responsible for building and maintaining reporting tools that currently support PPS operations. Strong scripting skills in SQL and Python are essential, as you will be writing queries and data transformation scripts across multiple environments. Experience with visualization tools also required for presenting insights effectively.

The Business Data Analyst is proficient in data analysis, warehousing, and reporting. In this role, you will be responsible for building and maintaining reporting tools, including dashboards, to track data and define KPIs. Strong scripting skills in SQL and Python are essential, as you will be writing queries and data transformation scripts across multiple environments. Experience with visualization tools like PowerBI and Tableau is also required for presenting insights effectively.

How you will help:

• Collect, analyze, and report business data
• Write queries or data transformation scripts using SQL and Python
• Use large data sets to define KPIs and generate reports in excel, Access, PowerBI, Tableau, Hubspot, and Dynamics and other like platforms
• Build and maintain sales, operations, planning and PMO dashboards and other reporting tools to track data
• Build predictive models
• Help maintain data frameworks with the corporate IT team
• Assist with process improvement with business unit and the corporation

What you will have:

• Bachelor's degree in computer science, statistics, or a related field (master's degree a plus)
• Experience in data analysis, warehousing, and reporting (3-5 years preferred)
• Experience using BI tools (Tableau, Looker) for data visualization and reporting
• SQL skills and experience with other programming languages associated with data analytics, including Python and R
• Experienced in designing user-friendly interfaces.
• Attention to detail
• Analytical skills

Summary of Company Benefits Here

Location(s): North Kingstown, RI-110



Equal Employment Opportunity/M/F/disability/protected veteran status

PI240750997