Business Intelligence Specialist
- Work Arrangement: Work From Home
- Work Location: Philippines
A leading provider of managed IT solutions to businesses and institutions across Minnesota, Michigan, North Dakota, Florida, Ohio, Kansas, Southern California, and New Jersey is seeking a passionate and motivated Business Intelligence & Data Automation Specialist.
With over 40 years of experience and more than 210 employees, the company delivers Fortune 500–level IT support to small and medium-sized businesses. Services include managed IT, cloud solutions, staffing, voice and data systems, storage and virtualization, consulting, and networking.
This role is responsible for transforming enterprise data into actionable insights that support strategic, operational, and tactical decision-making. The position requires a combination of technical and analytical expertise.
The role involves designing, developing, implementing, and maintaining enterprise reporting, dashboards, data models, and automated workflows using middleware, RPA, AI, Power BI, Power Apps, Power Automate, and Snowflake, while ensuring data accuracy, governance, and usability.
This position is part of the Internal IT team and serves as a product tools owner, partnering with business stakeholders to support Configuration Management Database (CMDB) and IT service data across multiple platforms. This is primarily an on-site role, with a hybrid arrangement considered for qualified candidates.
Job Responsibilities- Design, develop, implement, and maintain interactive dashboards and reports to support executive, operational, and departmental reporting needs
- Translate business requirements into KPIs, scorecards, and self-service analytics; optimize performance and implement row-level security
- Develop and maintain Power Platform solutions, including Power Apps, Power BI, and Power Automate, to streamline business processes and workflows such as data ingestion, validation, approvals, notifications, and system integrations, following security and performance best practices
- Design, build, and maintain data models for reporting and analytics; perform data cleansing, transformation, and validation; maintain data dictionaries, metadata, and documentation; support data governance, lineage, and stewardship
- Write, optimize, and maintain SQL queries, views, stored procedures, and functions in Snowflake and relational databases to extract, transform, integrate, and analyze data while ensuring scalability and performance
- Design and support API integrations to connect internal and external systems; monitor and troubleshoot integration issues to ensure data reliability and accuracy
- Support and enhance CMDB and IT service data across platforms by ensuring accuracy, completeness, and alignment with ITIL and organizational standards; develop reporting and dashboards for asset, configuration, dependency, compliance, and lifecycle visibility
- Act as a partner to business stakeholders by gathering requirements, presenting insights and recommendations, and providing training and documentation for report and dashboard usage
- Stay updated on BI, AI, RPA, analytics, and Power Platform capabilities; recommend improvements to reporting, data architecture, and analytics processes; support audit, compliance, and data quality initiatives
- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or a related field, or equivalent experience
- Strong hands-on experience with automation and APIs, including integration across multiple platforms, data modeling, and performance optimization
- Experience developing solutions using the Power Platform
- Strong SQL skills and experience working with Snowflake and relational databases
- Solid understanding of data management, data quality, and governance principles
- Experience integrating data using APIs and working with multiple data sources and systems
- Familiarity with CMDB concepts and IT service management data
- Strong analytical, problem-solving, and critical-thinking skills with high attention to detail
- Excellent communication skills, with the ability to translate technical concepts into business insights
- Experience with ITSM and CRM platforms such as ConnectWise
- Knowledge of cloud platforms (Azure) and cloud-based data services
- Experience with ETL/ELT tools and data pipelines
- Understanding of ITIL frameworks and configuration or asset management
- Relevant Microsoft or Power Platform certifications
- Experience supporting executive-level reporting and strategic analytics initiatives