This job board retrieves part of its jobs from: Toronto Jobs | Emplois Montréal | IT Jobs Canada

Bringing you the hottest job offers in California

To post a job, login or create an account |  Post a Job

New

Ajinomoto Foods North America, Inc.: Bi Analyst

Ajinomoto Foods North America, Inc.

This is a Full-time position in City Of Montclair, CA posted June 10, 2021.

Ajinomoto Foods North America, Inc.US-CA-OntarioJob ID 2021-3660# of Openings 1Job Field Information TechnologyJob Type Regular Full-TimeShift First ShiftOverviewThe Analyst will be responsible for designing reports and analytic solutions, gathering reporting requirements and documenting business processes as needed.

The analyst will handle ad-hoc data requests, develop reports, dashboards and scorecards in Power BI, complex reports using SSAS and SSRS, write SQL queries and make sure the output data meets expectations.

The analyst will work with users to collect enterprise and customer reporting requirements and manage timelines and expectations.

Also engages with other teams, departments and stakeholders to make sure all the reporting solution development requirements are well documented, fully understood and delivered per expectations.

The Analyst will be the first in line to answer users’ calls and emails addressed to the BI team.Responsibilities* Creates reports using Power BI, SQL Server Reporting Services environment with an In-depth understanding of the report life cycle* Design and develop Reports, Scorecards and Dashboards using Power BI and other data visualization tools for various organizational metrics and KPIs.* Perform ad-hoc data analysis and manual data refreshes.* Elicit business requirements from Subject Matter Experts using interviews, document analysis and requirements workshops.* Use the gathered requirements to develop logic for reporting, analytics or IT application support.* Ability to Understand data standards and identify data abnormalities.

Instill data quality in all solutions delivered.* Create / Modify existing tabular model, SSIS packages* Maintain close alignment with all customers (internal, external)* Ability to reconcile data between two more systems using SQL, Power BI and/or ExcelQualifications* Bachelors’ degree or higher in Data Management, MIS and/or other data-related or equivalent experience* Minimum 3 years of experience in related business analyst or data/reporting analyst roles* Knowledge of one ERP is required (JDE preferred)* Responsible for designing, developing, and deploying BI Reports and Analytics Dashboards using Microsoft technologies including Power BI, SQL, Excel etc.* Ability to support BI full lifecycle including analysis, requirements gathering, design, development, release and support/maintenance phases* In-depth experience with MS analytics Stack (SQL Server, SSAS Tabular, Power Query, Power BI, DAX and SQL)* Experience in Extraction, and Transformation and Loading (SSIS)* In-depth experience with Associated Development Tools Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS* Superior documentation and organizational skills.

Must be detail oriented* Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources* Must possess and demonstrate excellent verbal, written, and interpersonal communications skills* Must be a self-starter, work with minimal supervision, able to multi-task and focus on delivering results* Analytical, quantitative and logical with raw intellectual ability* Advanced working knowledge of Excel and PowerPointPI138351087