Job Location: Philadelphia, PA
Job Detail:
Job Description
Overview:
Our client in Northeast Philadelphia is seeking a Data Analyst to join the team. This role is a direct hire position and has an onsite schedule of 5 days per week.
Job Summary
The IT Data Analyst (DA) role is a key team member who supports our ERP systems with integration projects. The DA works with internal and external IT staff & consultants along with the functional and technical stakeholders to gather business requirements and document processes. The DA will coordinate with project stakeholders to effectively implement organizational, process and system reports & dashboards. The incumbent works closely with various internal functional departments (Sales, Marketing, Purchasing, Accounting & Finance and Business Units) to determine requirements, assist with developing & building an optimal solution to satisfy the business objective.
You will also be providing guidance during each phase of project delivery; warehouse data into a Microsoft SQL server-based platform to develop BI reports & dashboards for business stakeholders using Power BI & Phocas and SQL based reporting software tools.
Create and produce ad-hoc business reports and provide timely and effective solutions to management to support day to day data needs for Business operations; formulate and test scenarios, weigh alternatives or options, and determine appropriate recommendations for actionable insights; perform in depth research on root cause of data anomalies uncovered through normal course of analysis; vet recommendations to determine viable options and provide business cases or relevant examples to management; design new methods and best practices for analysis and presentation of comparative data; and guide and mentor junior-level analysts.
Responsibilities
Responsible for all aspects of Data analysis & Reporting Operations
- Provide 1st level production support and take corrective actions for dashboards & reporting
- Review reports and log files on a daily basis and take corrective actions
- Answer production support emails and tickets
- Research and track any & all data, dashboard, & reporting issues.
- Participates in testing at all levels of the development process
- Gather and document reporting functional requirements
- Assist user departments with data/reporting related projects
- Support specific corporate projects related to data analysis
- Work with analysts/consultants on functional/technical specifications for Data Mapping Requirements & Specifications
- Develop/enhance/correct Reporting data translations
- Configure, test and implement reporting system solutions
- Participating in testing at all levels (unit, integration and end-to-end testing); designing and driving testing initiatives; develop and execute test plans towards successful execution
- Communicating project goals, progress, issues and general information via written and verbal mediums as warranted
- Perform in a collaborative, integrated project team environment
Ability to create & maintain reporting for the functional departments, including working in Microsoft SRSS (SQL), Insite, Phocas, Power BI, and other related SQL based applications
- Clear understanding & proficiency in utilizing SQL & Power BI Reporting Tools, with demonstrated work experience over several years.
- Develops and delivers updates for software functionality and enhancements requested to the department leadership & project stakeholders
- Creates reports used for planning within various departments
- Maintains and updates various dashboards and scheduled reports
- Collaborates with stakeholders and business partners regarding operational enhancements along with diagnosing & advising on current impediments to operational success
- Proficiency in utilizing key data analysis and visualization platforms, including but not limited to: Microsoft Excel/PowerPoint/Power BI, Phocas, SQL, Tableau
- Project Management Ability & Status Reporting
- Provide both Technical and Production support for the Reporting Infrastructure
- Interfacing with both Internal (Co-workers) & External users (Customers/Vendors)
- Attention to Detail & Timeliness in responding to issues
- Ability to interact professionally with all Functional Departments
- Support the buildout of intelligence data and assist management with consolidating & condensing information into actionable items, reports, and presentations
- Monitor KPI’s to identify improvement opportunities and area of concerns
- Maintain & update statistical models with dashboards that support strategic initiatives
- Work with cross functional teams to gather inputs for research projects and financial analysis
- Perform ad-hoc analysis and reporting to support the Leadership Team
- Perform all other related duties and special projects as assigned by Management
Required Skills And Experience
- 5-7 years of experience in a Data Analysis and Reporting role
- Must have experience creating and maintaining reports for various departments
- Experience with Data Visualization
- Prior experience using SQL & Power BI Reporting Tools
- Must have attention to detail & timeliness in responding to issues
- Monitor KPIS to identify improvement opportunities and areas of concern
Submit CV To All Data Science Job Consultants Across United States For Free