Business Analyst II, PXT Empl Onboarding&Admin Svcs

The ideal candidate will have experience working with large datasets and distributed computing technologies. The candidate relishes working with large volumes of data, enjoys the challenge of highly complex technical contexts, and, is passionate about data and analytics. He/she should be an expert with data modeling, ETL design and business intelligence tools, has hand-on knowledge on columnar databases such as Redshift and other related AWS technologies. He/she passionately partners with the customers to identify strategic opportunities in the field of data analysis & engineering. He/she should be a self-starter, comfortable with ambiguity, able to think big (while paying careful attention to detail) and enjoys working in a fast-paced team that continuously learns and evolves on a day to day basis.

Key job responsibilities
This role primarily focuses on deep-dives, creating dashboards for the business, working with different teams to develop and track metrics and bridges.

- Design, develop and maintain scalable, automated, user-friendly systems, reports, dashboards, etc. that will support our analytical and business needs
- In-depth research of drivers of the Operations teams
- Analyze key metrics to uncover trends and root causes of issues
- Suggest and build new metrics and analysis that enable better perspective on business
- Capture the right metrics to influence stakeholders and measure success
- Develop domain expertise and apply to operational problems to find solution
- Work across teams with different stakeholders to prioritize and deliver data and reporting
- Recognize and adopt best practices in reporting and analysis: data integrity, test design, analysis, validation, and documentation
- Maintain BI architecture including our AWS account, database and various analytics tools. - 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc. ) and data visualization tools such as Tableau experience
- Bachelors degree or equivalent
- Experience defining requirements and using data and metrics to draw business insights
- Experience with Excel
- Experience with SQL
- Experience making business recommendations and influencing stakeholders
- Experience partnering with executive-level leaders to identifying and solving business issues