Senior Business Intelligence Engineer - Aero-Glen International

Overview of the Position:

The Senior Business Intelligence Engineer will define the team's business intelligence (BI) vision, strategy, and best practices. The position will lead the design, implementation, and delivery of high impact BI solutions for a fast-growing environment with limited guidance. Business partner with internal stakeholders to define, plan, and build complex analytical solutions to inform sales performance, inventory management, operational metrics, and more. This position will also translate strategic and operational data needs of multiple business units into the necessary data models, ETL pipelines, reports, and visualizations.

Essential Duties and Responsibilities:

• Collaborate with functional leads to design, develop, and maintain complex visualizations to monitor and report business performance metrics.
• Work with business users to understand their data needs, gather requirements, and ensure the developed reports & dashboards align with business objectives.
• Clean, manipulate & transform raw data from various ERP sources to prepare for analysis & calculations within Power BI & SSRS.
• Implement data governance best practices to ensure data accuracy, consistency, and compliance with security and privacy regulations.
• Implement data security measures within Power BI to control access to sensitive information.
• Proactively identify opportunities to improve data quality, performance, and usability of existing dashboards and reports.
• Design & build dynamic reports with custom visualizations, filters & calculations using DAX expressions.
• Optimize data models, calculations and data loads to ensure efficient report loading, timely deliver and responsiveness.
• Provide technical guidance and support to stakeholders in leveraging dashboards and data insights to enhance decision-making processes related to security.

Other Knowledge, Skills, and Abilities:

List the licenses, certificates, and registrations that are required to perform the essential duties of this job.

• Experience working directly with business stakeholders to translate between data and business needs.
• Demonstrated ability managing, analyzing and communicating results to senior leadership.
• Effective communication skills, written and verbal including collaboration skills.
• Advanced critical thinking ability, comfortable solving problems routinely with attention to detail.
• Advanced proficiency in SQL, with expertise in writing complex queries, optimizing query performance, and tuning database operations for large-scale datasets.
• Experience building semantic models, reports, dashboard and app deployment using Power BI.
• Strong working knowledge of Azure, SharePoint and related applications.
• Ability to work in a fast-paced, deadline-driven environment
• Experience designing and managing RLS
• Certificates in relevant technologies (ie. Power BI)

Education / Experience Requirements: 10+ years of professional experience required. Must have 7+ yrs of SQL & SSMS experience; 7+ yrs of Power BI, DAX, and SSRS development experience; 7+ yrs of experience developing and managing data migrations utilizing SSIS.

Other Qualifications:

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.

Language Skills: Ability to read, analyze, and interpret general business periodicals, professional journals, technical procedures, or governmental regulations. Ability to write reports, business correspondence, and procedure manuals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.

Mathematical Skills: Ability to calculate figures and amounts such as discounts, interest, commissions, proportions, percentages, area, circumference, and volume. Ability to apply concepts of basic algebra and geometry.

Reasoning Ability: Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables.

Physical Demands and Work Environment:

The physical demands described here are representatives of those that must be met by an employee to successfully perform the essential functions of this job.

• Is frequently required to talk or listen.

• Is regularly required to sit and use hands to finger, handle or feel.
• Is occasionally required to stand, walk, reach with hands and arms, and lift up to 10 pounds.
• Works in moderate noise levels.