SMX Services & Consulting, Inc.
Business Systems Analyst (Power BI)
SMX Services & Consulting, Inc., Caguas, Caguas, us, 00725
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.
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\u2019s degree in Information Technology, Computer Science, Data Analytics, or a related field. 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. Details
Seniority level: Entry level Employment type: Contract Job function: Information Technology Industries: IT Services and IT Consulting Location: Caguas, Puerto Rico
#J-18808-Ljbffr
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\u2019s degree in Information Technology, Computer Science, Data Analytics, or a related field. 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. Details
Seniority level: Entry level Employment type: Contract Job function: Information Technology Industries: IT Services and IT Consulting Location: Caguas, Puerto Rico
#J-18808-Ljbffr