Business Analyst II — Forecasting & BI Automation

Socket.dev; New York (NY); On-site; USD 82,000 - 143,000; Full time

Job summary

Bop LLC in New York is seeking a Business Analyst II to drive data-driven decisions through advanced analytics and reporting. You will collect use cases, perform data mining, and create models to forecast business performance, while building scalable BI solutions that automate reporting for campaigns and launches.

Strong SQL/ETL/Oracle skills and Excel automation are essential. Apply by communicating insights to senior management, transform complex problems into mathematical models, and deliver

Qualifications

• Bachelor's degree or foreign equivalent in a related field and one year of experience in the job offered or related roles.
• Experience with SQL, ETL, and Oracle.
• Experience processing large, multi-dimensional datasets from multiple sources.
• Developed automated reporting using MS Excel macros.

Responsibilities

• Support senior management by managing metrics reporting and performing data mining and big data analysis to provide strategic advice on forecast models.
• Collect business use cases and research opportunities to help leverage data for business functions through mathematical modeling.
• Analyze forecast and metrics data and automate reports for campaigns and launches.
• Use SQL, ETL, and Oracle to design, develop, and evaluate innovative BI tools and automated reports.
• Transform business problems into mathematical modeling and provide data-driven solutions; perform statistical analyses and scalable processes.

Skills

SQL

ETL

Oracle

Kibana

OBIEE

Datanet

Excel macros

Education

Bachelor's degree or foreign equivalent in Business Administration, Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field

Tools

Kibana

OBIEE

Datanet

Oracle

Job description

Bop LLC in New York is seeking a Business Analyst II to drive data-driven decisions through advanced analytics and reporting. You will collect use cases, perform data mining, and create models to forecast business performance, while building scalable BI solutions that automate reporting for campaigns and launches.

Strong SQL/ETL/Oracle skills and Excel automation are essential. Apply by communicating insights to senior management, transform complex problems into mathematical models, and deliver