Business Intelligence Analyst

This position is located in Southern California.

If you enjoy numbers and puzzles, or you have an affinity for data of all sorts, then we might be looking for you. We are looking for a qualified Business Intelligence Analyst that will use data to figure out market and business trends for FPCU in order to increase profits and efficiency and to conduct analytical studies to provide results/recommendations to senior management for department and enterprise-wide strategic initiatives. The BI Analyst will ensure effective management of projects from inception through implementation. Considered a key stakeholder/key contributor on highly complex initiatives and project teams.

ESSENTIAL RESPONSIBILITIES:

  • Evaluate operational efficiency and effectiveness
  • Perform qualitative and quantitative analysis relating to operational functions, workflow, processes, and other business related issues. Obtain quantitative and qualitative data of business processes to analyze, determine and promote data driven decisions
  • Analyze and evaluate competitor data and industry trends to understand current business unit competitive posture
  • Design and document dashboards, reports, and thresholds to alert business units to monitor business status and fluctuations
  • Identify and assess business strategies and opportunities; develop appropriate analytical approaches
  • Collect and analyze data; synthesize results of analyses, develop and make recommendations and alternatives based on the full spectrum of internal/external considerations
  • Use data warehousing/business intelligence toolsets to gather, store, and provide access to data in assist management decision making
  • Collaborate with business units and senior management to conduct needs assessment to support organization strategies, tactics, and learning solutions that support business unit objectives
  • Identify areas of improvement; determine solutions; implement enhancements/changes to improve operations, standards and results
  • Collaborate with management to establish objectives, standards, and strategies for delivering updates and changes to reporting and analytical procedures
  • Provide guidance and advice to management on the most effective and efficient use of resources to obtain measurable process improvements
  • Compile, research and analyze trends in support of projects and initiatives
  • Identify and assess business strategies and opportunities; develop appropriate analytical approaches
  • Processing, cleansing, validating the integrity of data used for analysis
  • Doing ad-hoc analysis and presenting results in a clear manner
  • Creating automated anomaly detection systems and constant tracking of its performance
  • Selecting features, building and optimizing classifiers using machine learning techniques
  • Analytical Skills: A major part of the job is to determine what data trends mean. Being able to analyze the data is crucial.
  • Communication Skills: Once the data is analyzed, business intelligence analysts must communicate their findings to the company or their managers.
  • Problem-Solving: Business intelligence analysts need to look at the data trends and recommend solutions for creating more revenue and reducing loss
  • Time Management: Business intelligence analysts work on large projects and many data streams and many deadlines. Being able to juggle it all is crucial to the job
  • Performs other duties as assigned

EDUCATION/EXPERIENCE:

  • Bachelor's degree with four to eight years’ industry experience or equivalent experience
  • 4+ years creating dashboards with data visualization tools, such as Tableau, PowerBI or ClickView.
  • Expert understanding of RDBMS, such as SQL Server, MS Access 
  • 4+ years of advanced SQL skills. Must be able to perform complex joins with multiple tables, across multiple databases and servers.
  • Experience with building complex data models
  • Experience with query performance optimization and EDW best practices is highly desired.
  • 5+ years using advanced Excel skills. Must be able to use VLOOKUPS, PIVOT TABLES, Statistical, Numeric, & String Manipulation functions
  • Experience with common data science languages, such as Python, R. Excellence in at least one of these is highly desirable
  • Understanding application of machine learning techniques and algorithms, such as Linear and logistic regressions, classification models, clustering models, Naive Bayes, Decision Forests is desirable.
  • Good applied statistics skills, such as distributions, statistical testing, regression, etc.
  • Experience in the application of statistical methods, mathematical techniques, forecasting, cost-benefit analysis and related analytical tools
  • Great communication skills
  • Expert skill interpreting, extrapolating and interpolating data for statistical research and modeling
  • Expert skill interpreting and synthesizing large amounts of information
  • Extensive experience in problem resolution including determining root cause, scope and scale of issues
  • Expert skill analyzing statistics and reports to determine business performance and trends
  • Extensive experience that demonstrates the ability to research, compile, and document data, business processes, and workflow
  • Extensive experience in market/consumer research, project management, and analysis in support of strategic planning initiatives
  • Knowledge of project life-cycles and business requirements analysis
  • Extensive experience in managing multiple priorities independently and/or in a team environment to achieve goals
  • Advanced skill in object oriented programming languages preferred.
  • Expert skill resolving conflicting requests and meeting changing requirements
  • Expert skill presenting findings, conclusions, alternatives and information clearly and concisely
  • Extensive experience in demonstrating creativity solving business problems
  • Expert skill maintaining accuracy with attention to detail and meeting deadlines
  • Expert research, analytical, and problem solving skills
  • Advanced verbal and written communication skills
Learn more & apply