Business Systems Analyst - Job Description

Business Systems Analyst - ConsultantWe are seeking a skilled and adaptable Business Systems Analyst Consultant 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 priori􀆟ze business and data requirements for system enhancements and data initiatives.  System Integra􀆟on & 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.  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.  ITDG is committed to building a community of experts with diverse backgrounds, disciplines, and perspectives who are passionate about our mission. ITDG is proud to be an Equal Opportunity and Affirmative Action Employer that is committed to hiring a diverse and talented workforce.  Our opportunities are open to Section S3 Residents.