Business Systems Analyst (Power BI) Onsite

Creative Solutions Services, LLC; Caguas (PR); On-site; USD 75,000 - 110,000; Full time

Job summary

Creative Solutions Services, LLC in Puerto Rico is seeking a skilled Business Systems Analyst with strong Power BI and data warehousing expertise to design, analyze, and implement solutions across ERP, E-commerce, and ECM systems on IBM iSeries and Windows servers.

You will translate business needs into technical data models, develop dashboards, optimize SQL, and collaborate with stakeholders to ensure reliable data integration and impactful reporting. This is an on-site role with standard hours.

Qualifications

• Bachelor's degree in IT, Computer Science, Data Analytics, or related.
• 5–8 years as a Business Systems Analyst or similar with focus on data analysis and data warehousing.
• Hands-on Power BI experience including DAX, data modeling, and report design.
• Strong SQL skills and familiarity with relational databases (SQL Server, DB2, Oracle).
• Experience with ERP, E-commerce, and ECM systems is highly desirable.

Responsibilities

• Data Analysis & Reporting: design and develop data models and dashboards using Power BI to support decision-making.
• Data Warehouse Management: contribute to design, development, and maintenance of enterprise data warehouse solutions.
• Database Development & Integration: extract, transform, and load data from sources into centralized repositories; optimize queries.
• Business Process Analysis: document workflows and identify improvement opportunities.
• Requirements Gathering: elicit and prioritize business and data requirements for system enhancements.
• System Integration & Testing: assist in planning and testing data flows between ERP, E-commerce, and ECM platforms.
• Documentation & Training: develop documentation for data processes and train users on Power BI reports.
• Project Support: assist cross-functional IT and data projects to ensure timely delivery.

Skills

Power BI

SQL

Data Warehousing

Data Analysis

ETL

DAX

Reporting

Documentation

Education

Bachelor's degree in IT / CS / Data Analytics

Tools

IBM iSeries

DB2

Windows Server

ERP systems

E-commerce platforms

ECM systems

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