Work Shift: PH Mid Shift (5 PM) or PH Night Shift (9PM)
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

Qualifications

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

Preferred / Good To Have

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

Business Intelligence & Data Automation Specialist

Data and Automation Specialist