Business Intelligence Analyst

ICU Medical Inc; Tijuana; On-site; MXN 360,000 - 600,000; Full time

Job summary

ICU Medical Inc is seeking a data analytics professional to develop and administer information solutions by integrating data from ERP systems. You will design reports, dashboards, and KPIs using BI tools and SQL, ensuring data quality and enabling informed decision-making.

The role involves automating reports, building data models, and supporting cross-functional teams with data-driven insights in a fast-paced environment.

Qualifications

• Bachelor's degree in Information Systems, Computer Engineering, IT, Data Science, Industrial Engineering, or related field.
• 1 to 3 years of professional experience in a similar role.
• Experience with Oracle Database / Oracle ERP or another ERP system.

Responsibilities

• Develop, administer, and improve information solutions by integrating, analyzing, and transforming data from ERP systems.
• Design, develop, and maintain reports, dashboards, and KPIs using BI tools.
• Develop SQL queries to extract, analyze, and validate information from databases.
• Automate reports and analytical processes to increase operational efficiency.
• Provide user support for data, reporting, systems, and analytical tools.

Skills

SQL Development

Power BI

Advanced Excel

Data Modeling

Data Integration

Oracle SQL

Education

Bachelor's degree in Information Systems / Computer Science / IT

Tools

SQL Developer

Oracle Database

ERP systems (SAP, AxDynamics, MFGpro)

Job description

This position is responsible for the development, administration, and continuous improvement of information solutions through the integration, analysis, and transformation of data from ERP systems. The role collaborates with cross-functional teams to design reports, automate processes, ensure data quality, and identify improvement opportunities through Business Intelligence tools and advanced analytics.

Data Management and Administration

• Manage and maintain the integrity of master data and information structures.
• Monitor the quality, consistency, and reliability of decision-making information.
• Investigate, analyze, and resolve discrepancies or issues related to data, configurations, and processes.
• Actively participate in the development of budgets, forecasts, variance analyses, KPIs, weekly reporting, and support for other departments.

Business Intelligence Solution Development

• Design, develop, and maintain reports, dashboards, and performance indicators using Business Intelligence tools.
• Develop SQL queries to extract, analyze, and validate information from Oracle databases.
• Build and maintain optimized data models for analysis and visualization.
• Develop connections, integrations, and data transformation processes between different business platforms and applications.
• Automate reports and analytical processes to increase operational efficiency.

Process Analysis and Improvement

• Analyze trends, patterns, and opportunities for improvement based on available information.
• Identify systemic issues, data inconsistencies, and optimization opportunities.
• Propose and implement solutions designed to improve data quality, availability, and accessibility.
• Participate in digital transformation, automation, and continuous improvement projects.

Functional and Technical Support

• Provide user support for data, reporting, systems, and analytical tools.
• Translate business requirements into technical solutions that deliver value.

Knowledge & Skills

• Bachelor's degree in Information Systems, Computer Engineering, Information Technology, Data Science, Industrial Engineering, or a related field
• 1 to 3 years of professional experience working in similar role
• Oracle Database / Oracle ERP, or experience using another ERP system (SAP, AxDynamics, MFGpro)
• SQL Developer.
• Power BI (Power Query, DAX, and data modeling).
• Advanced Excel skills.
• Relational databases.
• Data integration and transformation.
• Experience developing reports and dashboards.
• Knowledge of business processes and information analysis.