Business Intelligence Analyst

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

Job summary

ICU Medical Inc in Mexico is seeking a BI/Data Analyst to lead the development, administration, and continuous improvement of information solutions by integrating ERP data, designing reports, dashboards, and KPI models.

You will work with cross‑functional teams, translate business requirements into technical solutions, and help automate processes to improve data quality and decision making.

Qualifications

• Bachelor's degree in a related field is required.
• 1 to 3 years of professional experience in a similar role.
• Fluent in English.
• Experience with Oracle Database / ERP or SAP / AxDynamics / MFGpro.
• Ability to develop SQL queries and build data models.
• Experience designing and maintaining reports and dashboards.
• Strong knowledge of relational databases and data integration.

Responsibilities

• Manage and maintain the integrity of master data and information structures.
• Monitor quality and reliability of decision‑making information.
• Investigate and resolve data, configuration, and process discrepancies.
• Participate in budgets, forecasts, KPIs, and weekly reporting.
• Design, develop, and maintain reports, dashboards, and KPIs.
• Develop SQL queries to extract and validate Oracle data.
• Build optimized data models for analysis and visualization.
• Automate reports to increase operational efficiency.
• Translate business requirements into technical solutions and provide user support.

Skills

Fluent in English

SQL development

Data analysis

Data modeling

Oracle ERP knowledge

Education

Bachelor’s degree in Information Systems, Computer Engineering, Information Technology, Data Science, Industrial Engineering, or related field

Tools

Power BI

SQL Developer

Oracle Database

Job description

Summary

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.

Essential Duties & Responsibilities

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
• Fluent in English
• 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.