Business Intelligence Specialist

Key Skills

Database, DataGrip, Design of Experiment, ETL frameworks, PowerBI, Snowflake, SQL

Job Description

ConnectWise, Inc. is seeking a self-motivated and results-driven Business Intelligence Specialist with emphasis on ETL, Data Engineering, Data Modeling and Business Analysis utilizing SQL, DBT and Snowflake. This person will be responsible to support, maintain and enhance our ability to accurately report corporate and operational metrics and KPIs. The person will be working with a team of individuals who are passionate about their work and who collaborate closely with others to develop the right business solutions. 

As a Business Intelligence Specialist, you will have the opportunity to grow your data engineering, , business analysis, data analysis, sales, marketing and finance reporting skills. You will also be offered the opportunity to contribute to strategic and tactical planning to successfully implement Business Intelligence solutions.

Essential Duties and Responsibilities:

• Create, support and maintain enterprise data warehouse and Snowflake.
• Utilize your experience with SQL to create, support and maintain DBT models and Power BI reports.
• Leverage DBT, Informatica or other ETL technologies to extract, transform and load data from other systems.
• Adhere to development testing and deployment standards or help define standards if they are not already in place.
• Perform requirements gathering and data gathering for business review. Interact with various team members to ensure reports are fulfilling user requirements, are efficiently designed and are easy to support and maintain. Mentor junior members on the team to build their expertise in the area of requirements gathering.
• Perform root cause analysis as a means of addressing data issues. Escalate to others in the organization to drive change.
• Work with teams across the organization to ensure data is organized, captured and designed to support the business need.
• Participate in multiple projects simultaneously.
• Define understand and recommend changes to existing reporting environment in alignment with the current business needs and direction.
• Generate and deliver query results to internal customers on an ad-hoc basis. When possible or necessary, combine ad-hoc requests into a single project to improve effectiveness and efficiency of the BI team

Knowledge, Skills, and/or Abilities Required:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Experience developing complex SQL statements, stored procedures, functions and working with Snowflake, SQL Server, SQL Service Management Studio, DataGrip or DBT
• Strong knowledge of a variety of report design tools, Snowflake preferred but more important is to demonstrate strong SQL skills.
• Strong strategic thinking skills, with a demonstrated ability to identify business issues/opportunities and to frame business questions. Must be willing to grow in the area of suggesting design options and recommendations based on experience and best practices for report design.
• Database administration experience a plus.
• DBT experience a plus
• Fact finding, problem solving and negotiation skills.
• Ability to understand complex data models.
• Must possess a professional presence suitable for interaction in meetings, in-person or via email. Must have excellent presentation and communication skills.
• Familiarity with SharePoint and Microsoft applications, particularly Excel, Access, etc.
• Excellent organizations skill, attention to quality, self-motivation and a desire to succeed.
• Self-motivated to grow skillset in the following areas: Data Engineering, Power BI, Snowflake, ETL, Relational Databases, stored procedures, dimensional modeling, sales force automation, customer relationship management systems and other systems within the organization.

Educational/Vocational/Previous Experience Recommendations:

• Bachelor’s Degree or equivalent experience required.
• 2 years relevant experience

Working Conditions:

• Professional office environment
• Some travel may be required

Only local candidates need apply.