BI Developer III

About the role

This position is the subject matter expert for business intelligence reporting related to all company needs. This individual is responsible for networking with stakeholders, setting realistic expectations and designing/developing BI solutions that best meet the enterprise needs of Kenco Group, as well as system administration functions of the BI software and infrastructure. This position will also act as a technical lead for the BI Team and will support Advanced Data Analytics (AI/Machine Learning) efforts.

Responsibilities

• Answer any technical questions (researching as needed) and lead the BI Team in Power BI technical innovation.
• Gather requirements from all necessary corporate business sponsors for future BI development.
• Communicate requirements to the BI Team for planning and translate to technical specifications for the ETL Team.
• Design, develop, test, and validate dashboards/reports, based upon best practices, using Power BI.
• Aid end-users with necessary training to make them proficient users.
• Document processes, flows, policies, and procedures and other misc. tasks as assigned by the Manager.
• 24/7 rotational on-call BI technical support.
• Routinely perform analysis and make presentations to key business take holders, including customers.

Qualifications

• Bachelor’s degree from a four-year College or University in Information Technology, Statistics or related field is required. Masters preferred.
• 5-7 Years of experience with financial, human resource, and risk management applications, data, and metrics.
• 3-5 Years of Warehousing/Logistics/Transportation Industry experience preferred.
• 5-7 Years gathering requirements and designing/developing Power BI dashboards.
• 5-7 Years of experience in SQL development.
• 2-4 Years of experience with AWS infrastructure support (EC2, Step Functions, Lambda).
• 2-4 Years of experience with Power BI Administration through QMC.
• Advanced Power BI Development: Data Modeling, Data ingestion, DAX, Dashboard design/development.
• Power BI Administration - Proficiency in: Governance and tenant settings, licensing and workspace management, row-level security, deployment pipelines, gateways and data connectivity.
• Understanding of data warehouse purpose and design practices (schema types, typical structure, SSMS).
• General understanding of MS Active Directory.
• Keen eye for detail and thoughtful investigation of data before relying upon it.
• Depth and breadth in quantitative analysis knowledge.
• Excellent quantitative modeling, statistical analysis, and problem-solving skills.

General Competencies

• Business Acumen - Knowledgeable in current and possible future policies, practices, trends, technology, and information affecting his/her business and organization.
• Communicate for Impact - Proactively communicate with all stakeholders throughout the life cycle of programs and projects.
• Influence Others - Quickly find common ground and can solve problems for the good of the organization with a minimal amount of noise. Authentically gains trust and support of peers.
• Manage Transitions / Change Management - Effectively plan, manage and communicate changes in processes with appropriate stakeholders.
• Strategic Agility - Enable Kenco to remain competitive by adjusting and adapting to innovative ideas necessary to support Kenco’s long-term organizational strategy.

Travel Requirements

This position is expected to travel approximately 25% or less. A passport is not required, but recommended.

Benefits

• Medical insurance including HSA, HRA and FSA accounts
• Supplemental insurance including critical illness, hospital indemnity, accidental injury
• Dental Insurance
• Vision Insurance
• Basic Life and Supplemental Life
• Short Term and Long Term Disability
• Paid Parental Leave
• 401(k)
• Paid Time Off approximately 2 weeks (accrual begins on Day 1 of employment)
• Employer Paid Holidays- 10 days