Position Summary
The Business Intelligence Manager (BIM) is responsible for the design, development, deployment, and administration of business intelligence solutions using Power BI and associated technologies. This role will primarily focus on extracting data from multiple sources, including SAP, SQL databases, and manual data platforms. The BIM will make necessary transformations as far upstream as possible to ensure a clean semantic model utilizing Star schema methodology. This person will be highly proficient in DAX for developing advanced visualizations, enabling the sales organization to leverage predictive and prescriptive data analytics. They will turn complex datasets into insightful and actionable reports, improving business outcomes related to sales performance, shipment trends, and field execution.
Essential Job Functions
- Develop and manage data models for optimized Power BI reporting
- Perform ETL operations, integrating data from SAP, SQL, etc., into Power BI
- Utilize advanced DAX expressions to create KPIs, visualizations and data analytics
- Working knowledge of basic data query and manipulation concepts/languages: relevant experience includes basic relational database queries and data integration maintenance
- Build ETLs and end-user reports utilizing Rest API and other Data sources
- Provide quality end-user support across the full Business Intelligence platform
- Complete ad-hoc troubleshooting of tooling and platforms as needed
- Tracks new products, promotions, and special products; and provides track reporting to management.
- Provide analysis and interpretation of internal/external market data: highlighting any underlying trends to identify new market opportunities and recommend strategies to increase the organization’s profitability
- Ad Hoc LSEC Projects & Assignments
- Consults with BDM on KPIs and user experience
- Responsible for the generation of statistical reports
- Tracks new products, promotions, and special products; and provides track reporting to management
- Maintains weekly, monthly, and annual reporting to include but not limited to Dashboard reports, costing reports, store listing, etc. and as post as required
- Highly proficient with SAP, VIP, and IDig sales reporting interface
- Managing communication for special focuses, priorities, goals, and strategic initiatives
- Prepare presentations for department and executive management
Position Requirements
- Prior project-based experience working on multi-person project plans
- Collaborations with IT and other relevant departments to plan and execute project objectives
- Prior experience creating content in a Business Intelligence platform (Power BI)
- Demonstrated ability to take initiative and successfully handle and prioritize multiple competing assignments while effectively manage deadlines
- Energetic and focused personality with a demonstrated ability to independently drive value on a technical team
- Must be highly proficient and fully functional in all Microsoft Office applications and be able to effectively utilize all available office management technology
- Professional, articulate, and able to use good independent judgment and discretion
- Must have proven ability to maintain correspondence, discussions, and materials in the strictest confidence
- Outstanding verbal and written communication skills required with the ability to successfully interact at all levels of the organization while functioning as a team player
- Flexibility to travel as needed
Base Pay Range : $93,870 - 134,100 (+)