BI Analyst

---

Job description

BI ANALYST

Location; Irvine, CA

Job Description

The Business Intelligence (BI) Analyst is responsible for leading the efforts to define requirements and develop solutions for their BI projects. This involves the execution of data analysis, report and dashboard creation, and requirements assessment. Serving as a key liaison between the business and the development team, s/he will translate business needs into useful data.

Business Requirements (75%):

• Collect and document business requirements using interviews, document analysis, requirements workshops, surveys, site visits, business process descriptions, user stories, use cases, scenarios, business-process and workflow analysis.
• Critically evaluate information gathered from multiple sources and reconcile conflicts.
• Proactively communicate and collaborate with external and internal customers to understand processes, analyze information needs and define functional requirements.
• Serve as the conduit between the business unit and the BI development team.
• Successfully engage in multiple initiatives simultaneously and able to meet project deliverable deadlines.
• Work independently with users to define concepts.
• Review and edit requirements, specifications, business processes and recommendations related to proposed solution.
• Lead and perform complex analysis in an evolving data environment.
• Extract and analyze data, patterns, and related trends as needed, with the subsequent ability to synthesize the data into information consumable by organization.
• Provide data extraction, reports, dashboards, analysis, and consultation services across organization.
• Design and roll out Business Intelligence solutions to end users.
• Ensure high levels of Business Intelligence availability through support functions and in-depth testing.
• Participate in strategic design, implementation, and maintenance of Business Intelligence software and systems, including integration with databases and data warehouses.
• Provide application analysis and data modeling design to collect data for centralized data warehouse.
• Extract data from databases and data warehouses for reporting and to facilitate sharing between multiple data systems.
• Proficient in the use of query and reporting analysis tools.
• Standardize data collection by developing methods for database design and validation reports.

Additional Responsibilities (25%):

• Accountable for properly following all IT standards, processes, and methodologies as applicable including but not limited to Quality Assurance (QA).
• Other responsibilities and accountabilities may be assigned based on business and organization needs.
• Sets priorities for other team members on a particular initiative or project.
• Manages user expectations regarding appropriate milestones and deadlines.
• Will assist in orientation, training, work assignment and checking of less experienced developers and analysts.
• Serves as technical consultation to leaders in the IT organization and functional user groups.
• Provides documentation and status updates on behalf of a larger IT group or work stream.
• Collaborates with customers and stakeholders as well as other members of IT.
• Provide continuous improvement and implementation of ideas.

Qualifications

• Four-year college or commensurate work experience.
• 3+ years of analysis experience.
• Must have knowledge of AWS Infrastructure including S3, Redshift and RDS.
• Expertise in MS Excel.
• Expertise in SQL and relational databases.
• Strong communication (verbal and written) and interpersonal skills to translate key insights from complex analyses into actionable business insights.
• Proven ability of looking at solutions in unconventional ways- seeing opportunities to innovate and leading the way.
• Preferred Qualifications:
• Advanced degree in Science and Technology related field.
• Experience with building multi-dimensional data models to serve as a foundation for future analyses.
• Experience with predictive modeling.
• Experience with data visualization tools like Tableau and Microsoft Power BI.
• Technical Skills:
  • Expert:
    • Business Acumen
    • Business Alignment
    • Requirements Definition
    • Risk Management
  • Proficient:
    • Oral and Written Communication Skills
    • Operational Process Flows relating to Manufacturing and Warehouse Management
    • Quality Assurance & Controls
    • Analytical skills

Platinum Resource Group is a professional level consulting firm, providing resources to Fortune 1000 client companies in the areas of technology, human resources, accounting, finance, business systems and supply chain, on a contract and interim basis. PRG has operations in Orange County, San Diego, Los Angeles, and San Francisco. As a W-2 employer we offer our consultants direct deposit bi-weekly payroll, health, dental, vision benefits, paid holidays, and referral bonuses.

- provided by Dice