Business Systems Analyst (Power BI) Onsite

SMX Services & Consulting, Inc.; Caguas (PR); On-site; USD 60,000 - 90,000; Full time

Benefits offered by this job

On-site work

Job summary

SMX Services & Consulting, Inc. seeks a skilled Business Systems Analyst to design, implement, and optimize data warehouse solutions and Power BI reports across ERP, E-commerce, and ECM platforms running on IBM iSeries and Windows servers in Puerto Rico.

You will gather requirements, model data, and ensure data quality while collaborating with cross-functional teams. Strong SQL, ETL, and IBM iSeries familiarity are highly valued. This is an on-site role with standard business hours.

Qualifications

• Bachelor's degree in Information Technology, Computer Science, Data Analytics, or a related field.
• 5+ years of experience as a Business Systems Analyst or similar role with strong focus on data analysis, reporting, and data warehouse environments.
• Hands-on Power BI experience (DAX, data modeling, report design).
• Strong SQL and experience with relational databases (SQL Server, DB2, Oracle).
• Experience with ERP, E-commerce, and ECM systems; IBM iSeries and Windows Server familiarity is a plus.

Responsibilities

• Design, develop, and maintain data warehouse solutions using Power BI for reporting.
• Analyze business processes and document workflows for improvements.
• Gather and prioritize business and data requirements for system enhancements and data initiatives.
• Collaborate with ERP, E-commerce, and ECM teams for integration and testing of data flows.
• Create user documentation and train users on dashboards and reports.
• Support cross-functional IT and data projects with timely delivery.

Skills

Power BI

Data modeling

SQL & DB2

ERP systems

IBM iSeries

ETL processes

Education

Bachelor's degree in IT/CS/Data Analytics

Tools

SQL Server

DB2

Oracle

Job description

We are seeking a skilled and adaptable Business Systems Analyst with strong expertise in data warehousing, Power BI, and database technologies to join our team. The successful candidate will play a key role in analyzing, designing, and implementing solutions across our core business systems, including ERP, E-commerce, and Enterprise Content Management (ECM) systems running on IBM iSeries and Windows servers.
Key Responsibilities:

• Data Analysis & Reporting: Design and develop data models and dashboards using Power BI to support business decision-making. Collaborate with stakeholders to ensure reporting meets analytical and operational needs.
• Data Warehouse Management: Participate in the design, development, and maintenance of enterprise data warehouse solutions. Ensure data consistency, quality, and accessibility across systems.
• Database Development & Integration: Work with relational databases to extract, transform, and load (ETL) data from various sources into centralized repositories. Optimize SQL queries and manage stored procedures as needed.
• Business Process Analysis: Work closely with business units to analyze and document workflows, identify improvement opportunities, and recommend technology solutions.
• Requirements Gathering: Elicit, document, and prioritize business and data requirements for system enhancements and data initiatives.
• System Integration & Testing: Assist in planning and testing data flows between systems to ensure reliable and accurate integration, especially between ERP, E-commerce, and ECM platforms.
• Documentation & Training: Develop documentation for data processes, business rules, dashboards, and reports. Train users to navigate and interpret Power BI reports and dashboards effectively.
• Project Support: Contribute to cross-functional IT and data projects, ensuring timely delivery aligned with business goals.

Qualifications:
Education: Bachelor's degree in Information Technology, Computer Science, Data Analytics, or a related field.
Experience:

• At least 5-8 years of experience as a Business Systems Analyst or in a similar role with a strong focus on data analysis, reporting, and data warehouse environments.
• Hands-on experience with Power BI, including DAX, data modeling, and report design.
• Solid experience with SQL and working knowledge of relational databases (e.g., SQL Server, DB2, Oracle).
• Familiarity with ERP systems, E-commerce platforms, and ECM systems is highly desirable.
• Experience working in IBM iSeries and Windows Server environments is a plus.
  

Skills:

• Strong analytical and critical thinking skills with a data-driven mindset.
• Ability to translate business needs into technical solutions and insights.
• Proficient in database querying and performance tuning.
• Effective communication and interpersonal skills for cross-team collaboration.
• Capable of managing multiple projects in a dynamic environment.

100% OnSite
Monday - Friday 9-6pm