Data Analyst

$140,816 - $183,040/Yr

Wollborg Michelson Recruiting - Oakland, CA

posted 2 months ago

Full-time - Mid Level
Oakland, CA
Administrative and Support Services

About the position

The Administrator of Business Intelligence plays a crucial role in the department, focusing on advanced data analytics techniques to transform complex data into actionable insights and solutions. This position requires a deep understanding of data analysis, synthesis, and predictive modeling, particularly in operational, staffing, material usage, and financial data. The role is integral to conducting quantitative research and analysis, leading data projects, and providing comprehensive support to management. It is important to note that this position is 100% in-office, with no remote work options available. In this role, the Administrator will be responsible for designing, developing, monitoring, and maintaining data pipelines. This includes analyzing and organizing raw data, interpreting trends, and identifying patterns to support departmental needs and enterprise-level data initiatives. The Administrator will build and implement advanced predictive models and machine-learning algorithms to uncover insights and provide actionable recommendations. Utilizing ensemble modeling to enhance forecast accuracy and applying decision tree regression using R or similar programming languages will be key components of the job. The Administrator will also forecast operational needs, staffing levels, railcar availability, and other metrics to optimize resource utilization within the RS&S. Leading and conducting ad hoc and ongoing research projects will be essential, as will providing management with strategic operational scenarios and actionable recommendations for informed decision-making. The role involves defining key performance indicators and building dashboards, scorecards, and reports, ensuring that all graphical documentation meets service level and operational requirements. As the RS&S subject matter expert in data analytics, business intelligence, and operational reporting, the Administrator will provide insights related to reliability, vehicle performance, operations, asset management, staffing, and finance. Evaluating and recommending policy and programmatic changes, implementing these recommendations to enhance departmental effectiveness, and assessing the effectiveness of models and reports will also be part of the responsibilities. The Administrator will document analytical status, prepare interactive reports, and provide actionable insights for better decision-making, supporting the continuous improvement of analytical capabilities within the department. Excellent communication skills are necessary to interface effectively with various staff levels and disseminate and present analysis to management.

Responsibilities

  • Design, develop, monitor, and maintain data pipelines.
  • Analyze and organize raw data, interpret trends, and identify patterns to support department needs and enterprise-level data initiatives.
  • Build and implement advanced predictive models and machine-learning algorithms to uncover insights and provide actionable recommendations.
  • Use ensemble modeling to enhance forecast accuracy and apply decision tree regression using R or similar programming languages.
  • Utilize advanced tools to extract, manipulate, and analyze data.
  • Forecast operational needs, staffing levels, railcar availability, and other metrics to optimize resource utilization within RS&S.
  • Lead and conduct ad hoc and ongoing research projects.
  • Provide management with strategic operational scenarios and actionable recommendations for informed decision-making.
  • Define key performance indicators and build dashboards, scorecards, and reports.
  • Ensure all graphical documentation meets service level and operational requirements.
  • Serve as the RS&S subject matter expert in data analytics, business intelligence, and operational reporting.
  • Provide insights related to reliability, vehicle performance, operations, asset management, staffing, and finance.
  • Evaluate and recommend policy and programmatic changes.
  • Implement recommendations as appropriate to enhance departmental effectiveness.
  • Assess the effectiveness of models and reports.
  • Document analytical status, prepare interactive reports, and provide actionable insights for better decision-making.
  • Support the continuous improvement of analytical capabilities within the department.
  • Disseminate and present analysis to management.
  • Utilize excellent communication skills to interface with various staff levels effectively.

Requirements

  • Bachelor's degree in Computer Science, Information Systems, Statistics, Mathematics, Data Analytics, or a related field from an accredited college or university.
  • Four years of full-time equivalent experience in data analytics or modeling.
  • Knowledge of advanced Excel and data visualization tools (e.g., SQL, DAX, Power BI, Python, R).
  • Knowledge of principles and practices of operations, maintenance, transit, and production-based departments.
  • Knowledge of techniques for operations-based and financial modeling, performance assessment, and comparative analysis.
  • Knowledge of project management, program development, budget preparation, and policy administration.
  • Knowledge of principles of Reliability Centered Maintenance and effective communication.
  • Skill in advanced data visualization and mining technologies for data collection and analysis.
  • Skill in developing and analyzing complex models and reports.
  • Skill in problem-solving, solution implementation, and process improvement.
  • Skill in designing and implementing dashboards and graphical documentation.
  • Skill in research, analysis, and evaluation of service delivery methods.
  • Skill in clear and concise reporting and communication.

Benefits

  • Health insurance
  • Dental insurance
  • 401(k)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service