Business Intelligence Specialist

Covia is a leading supplier of minerals and material solutions to the industrial and energy markets. Covia’s rich legacy includes many achievements across industries and capital success through partnership. Our ability to deliver the right product, to the right place, at the right time, is unmatched. Just as strong is our commitment to building partnerships that help our customers succeed.

Quality and innovation are at the foundation of Covia; but our real strength is our people. Covia employs a diverse and highly-skilled team of professionals to convert natural minerals into engineered solutions for our customers. Every member of our team has a valuable opportunity to help shape our future and make a positive impact on the world around us through our commitment to the locations where we live and work.

COVIA IS COMMITTED TO EMBRACING AND PROMOTING DIVERSITY AND INCLUSION (D&I) WHERE WE WORK, WITH WHOM WE DO BUSINESS, AND WHERE WE LIVE. We strive to create an inclusive culture where diversity is valued and respected and where all feel included and engaged. We are intentional in our efforts to bring Team Members together and create opportunities to contribute their unique skills, experiences, and perspectives in the pursuit of Covia’s business growth objectives. Enabling all Team Members to perform at their best while being themselves is fundamental to the Clearly Covia Values and Culture.

Covia is looking for a dynamic Business Intelligence Specialist to join its Corporate IT team at its Independence, OH location. This individual will have a successful track record of developing robust BI solutions, preferably using Microsoft BI tools and technologies (Azure). The Business Intelligence Specialist will be responsible for the design, development, implementation, management, and support of database, ETL, analytics and visualization processes and environments to provide mission critical data and reporting to operational and executive management.

Working with cross-functional teams, you will be required to gather and document business requirements for data analysis and reporting projects. Using modern BI concepts, tools, and platforms, you will be instrumental in developing reporting and visualization solutions that provide the data necessary for business growth and process improvement and optimization.

As a member of the Corporate IT team, you will apply proven communication, analytical, problem-solving and leadership skills to expand Covia’s business analytics competency and maximize the benefits of IT investments. You will have full access to our investment in training, software, and hardware from market leading vendors.

The successful incumbent will have the following Key Accountabilities:

• Production Support:
  • Provide monitoring and support as required to ensure the availability and performance of enterprise data and BI environments for both external and internal users
  • Timely troubleshooting and resolution of production issues through analysis and review of data flow and transformation logic
  • Ongoing end-user access and usage support
  • Participate as an escalation point of contact for critical after-hours incidents
• BI Development:
  • Gather and transform business requirements and analysis into specifications that will be used to drive quality solutions
  • Provide development estimates and timelines for scheduling and planning
  • Design, build and implement ETL scripts & pipelines, BI reports, and data visualizations & dashboards
  • Optimize complex SQL stored procedures, scripts, functions, and other BI components for best performance
  • Produce technical documentation that supports deployment, testing, and ongoing production support
  • Complete design, development, testing and technical documentation tasks in a timely manner and at required level of quality
  • Ensure configuration management and change controls are implemented for your sphere of influence
• Data Analysis & Validation:
  • Routine and advanced data query and analysis activities and projects using available data tools for month close validation and ad-hoc data reporting requests
  • Define and implement data quality processes to monitor and detect data quality issues
• General:
  • Ability to both thrive in a team environment and work independently
  • Design and implement best practices, guidelines, and repeatable processes
  • Collaborate with governance, risk, and compliance personnel on network security, data privacy, SOX, and other regulatory compliance requirements

The successful incumbent will have the following Minimum Qualifications:

• Bachelor’s degree in Computer Science, Computer Engineering, Information Systems or related computer field strongly preferred. 5+ years of relevant experience may be considered in lieu of a degree. Minimum education required: Associates Degree in IT field.
• Technical vendor certifications are preferred
• Required Experience (5+ years):
  • Advanced SQL query and procedure development (SQL Server, Oracle, DB2, etc.)
  • Data warehouse and dimensional modeling experience
  • End user requirements analysis and support
• Additional knowledge and experience in one or more of the following technologies:
  • Azure Data Factory or SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS) tabular models and cubes
  • Power BI or SQL Server Reporting Services (SSRS)
  • DAX measures and expressions
• Basic Knowledge of Microsoft Azure cloud data platforms and products
• Experience with development tools and processes such as Visual Studio, Azure DevOps, GIT/GitHub, VS Code, SQL Server Management Studio (SSMS), Azure Data Studio, PowerShell, REST API
• Highly self-motivated and directed; logical and efficient with strong problem-solving skills; ability to thrive in rapidly changing environment under minimum supervision.
• Tactful with strong written and verbal communication skills; ability to build relationships within and outside the organization
• Ability to present complex ideas in a clear, concise fashion to technical and non-technical audiences
• Ability to maintain confidentiality with sensitive internal and external information.
• Ability to travel up to ten percent to locations outside Ohio and training classes

Benefits:

• Excellent Healthcare Benefits – medical, vision, dental
• 401K with company matching
• Vacation + Paid Holidays
• Disability, Life / AD&D, and Long Term Care Insurances
• Employee Assistance Program

At Covia, we strive for and support a diverse workforce as we firmly believe this lays the foundation of our success. Our compelling culture supports inclusion, individuality and respect within the workplace. We are committed to providing employment opportunities to the most qualified candidate based on work-related factors and without regard to non-work-related factors including race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, or veteran status.

The organization offers competitive salaries, advancement opportunities, and a full range of benefits.

An Equal Opportunity Employer

IND2

#LI-REMOTE

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)