Job Description:
The Business Intelligence (BI) Specialist is responsible for designing, developing, and enhancing Power BI reports, streamlining data processes, and driving data integration across various departments and applications. This role plays a critical part in improving end-user adoption of Microsoft Dynamics CRM, integrating it with Power BI and our (ERP), and optimizing connections with other platforms like Jira, WordPress, Magento 2, Commerce Connect, Zapier and CPQ. A strong understanding of relational databases and technical problem-solving skills is essential to drive business insights and improve overall data flow.
Responsibilities:
- Power BI Development & Enhancement
- Design, develop, and enhance Power BI dashboards and reports for various departments to improve decision-making.
- Collaborate with stakeholders to understand reporting needs, ensuring reports are optimized for business goals.
- Maintain and improve existing Power BI reports, ensuring data accuracy and consistency.
- Data Integration & Streamlining:
- Manage data integration efforts between but not limited to Microsoft Dynamics CRM, ERP and Power BI.
- Streamline data processes across additional applications, including CPQ, WordPress, Magento 2, ECC, ECM, Zapier and Jira, ensuring seamless data flow and connectivity.
- Implement and optimize end-user adoption of Dynamics CRM, providing training, documentation, and support.
- Be a driver for the marketing team to develop, assist and support marketing initiatives in relation to business applications (CRM, leads, Opportunities)
- Document IT Processes and Projects using SDLC Model
- Database Management & Technical Support:
- Work with relational databases to design efficient data models that support BI reporting and analytics.
- Troubleshoot data issues, provide technical support, and ensure data integrity across all integrated systems.
- Monitor and Resolve IT Help Desk Tickets regarding business application issues
- Cross-functional Collaboration & Training:
- Collaborate with cross-functional teams to understand business needs, prioritize BI development, and deliver solutions that support data-driven decisions.
- Provide ongoing training and support to end users, fostering a data-informed culture within the organization.
Qualifications:
- Bachelor’s degree in data science, Information Technology, Business, or related field.
- 2+ years of experience in Business Intelligence, Data Analysis, or a related field.
- Proficiency with Power BI, Microsoft Dynamics CRM, and ERP software.
- Familiarity with additional platforms like WordPress, Magento 2.
- Strong understanding of relational databases and data modeling techniques.
- Excellent analytical and problem-solving skills with attention to detail.
- Ability to work cross-functionally and communicate effectively with both technical and non-technical stakeholders.
- Must be available and able to travel overnight throughout North America.
- Design/maintain project plans and ensure on-time task completion.
Pay range and compensation package:
