Bus Analyst II – AMZ010578

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

MULTIPLE POSITIONS AVAILABLE

Employer: Bop LLC

Offered Position: Business Analyst II – AMZ010578

Job Location: 1500 Broadway, New York, New York 10036

Position Responsibilities

Support senior management by managing metrics reporting and performing data mining and big data analysis to provide strategic advice on business forecast models. Collect business use cases, research and evaluate opportunities to help Amazon leverage its data to support business functions through complicated mathematical modeling. Analyze forecast and metrics data. Automate reports for promotional and project launch campaigns. Utilize database technologies, including SQL, ETL, and Oracle to design, develop, and evaluate highly innovative business intelligence tools and automated reports for campaign targeting and optimization. Transform complicated business problems into mathematics modeling and provide data-driven solutions. Perform statistical analysis, including clustering, cross-session and panel data regression using R, SAS, STATA, and SPSS. Establish scalable, efficient, automated processes for large scale data analyses, model development, model validation, and model implementation.

Basic Qualifications

Position Requirements: Bachelor's degree or foreign equivalent in Business Administration, Computer Science, Engineering, Mathematics, Statistics, Economics, or a related field and one year of experience in the job offered or as a Business Analyst, Business Intelligence Engineer, Data Engineer, Data Miner or a related occupation. Must have one year of experience in the following skill(s): using database technologies, including SQL, ETL or Oracle; processing large, multi-dimensional datasets from multiple sources including Kibana, OBIEE, Datanet or equivalent data extraction tool; and developing automated reporting using advanced MS Excel skills including macros.

Schedule & Salary

40 hours/week, 8:00am – 5:00pm, Salary Range $81,700 - $143,100/year.

Preferred Qualifications

Please see job description and position requirements above.

Equal Opportunity

Amazon is an equal opportunity employer and does not discriminate on the basis of protected veteran status, disability, or other legally protected status.

Inclusive Culture & Accommodations

Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during the application and hiring process, including support for the interview or onboarding process, please visit https://amazon.jobs/content/en/how-we-hire/accommodations for more information. If the country/region you’re applying in isn’t listed, please contact your Recruiting Partner.