BI Analyst / Data engineer / Data warehouse, Tableau, Looker reporting *** direct end client ***

Analytics, Business intelligence, Dashboard, Data QA, ETL, Engineering, FIX, Framework, GCS, Looker, Marketing, Monitoring, Reporting, SQL, Tableau, Troubleshooting, Marketing business intelligence, Marketing reporting, Marketing Dashboard, Datorama, Liverap, Data warehouse, Operations, Sarbanes-Oxley, BI Analyst, Google BigQuery, Data analyst, data engineer, Data management, Data visualization, BQ, ELT, Python, Pandas, Process flow, Visualization, KPI, Metrics, Data validation, Financial technology, Senio Analyst, Senior BI Analyst, Looker Developer, Pricing, Dashboards
Contract W2, Contract Independent, Contract Corp-To-Corp, 8 Months
Depends on Experience

Job Description

- Launch External reporting for 2 pilot partners (build SQL data pipelines ETLs, create Tableau dashboards)
- Create internal processes & external trainings for onboarding partners
- Incorporate feedback from partners and iterate on next version of dashboards
- Build out data pipelines and dashboards for remaining partners PL/CC partners

Senior Analyst will be responsible for developing and delivering various dashboards for external reporting. This role will maintain in-depth knowledge of Tableau as a visualization tool and new features as they become available. The analyst will engage in the development of highly critical Tableau dashboards for strategic and high impact projects with external stakeholders.

Responsibilities
- Develop advanced data visualizations using Tableau and Tableau Mobile best practices to effectively solve business problems
- Analyze/curate large volumes of data using BigQuery
- Design, build and maintain dashboards in Tableau
- Develop and own validation processes to ensure data accuracy across various dashboards and partner repositories
- Resolve issues and bug fixes as part of the validation process and maintain the new feature request roadmap
- Provide recommendations for reporting improvements and build proof-of-concept processes utilizing best practices for data management.
- Build dashboard tutorials, document process flows, best practices, and requirements of various use cases in a way that can be understood by technical and business stakeholders.
- Manage row level security, access and performance aspect of the Tableau dashboard
- Support ad-hoc dashboard and data requests to provide insights to various teams
- Work with the business development teams to research data issues, data validation and sign-offs
- Build Develop and provide training on new and existing dashboards to various business units

Minimum Basic Requirement:
- 4+ years of experience with SQL
- 4+ years of experience with Tableau as a data visualization tool for insight synthesis and presentation
- Strong problem-solver able to identify opportunities for growth or improvement to advance the goals of our both our partners and our business

Preferred Qualifications:
- Fintech, financial services, consulting or a similar strategic or analytical experience
- Familiarity with credit risk concepts and credit bureau reporting
- Experience with software development, especially in building automation
- Ability to communicate qualitative and quantitative results clearly, succinctly and confidently in verbal and written communications
- Ability to independently thrive in a fast-paced, dynamic, and often ambiguous work environment
- Ability to work cross functionally and assert influence internally/externally

--------------------------------------------------------------------------------------------------------------------------------------------
Generate and distribute detailed pricing reports to internal and external stakeholders
Investigate and communicate data discrepancies relative to trends and expectations, partnering with respective departments across the company to gain additional insight and recommending solutions
Support cross-functional business partners in developing and handling specific pricing requirements
Analyze and reconcile complex datasets to facilitate timely and accurate financial close

As a Sr. Pricing Analyst, you will support the pricing operations, reporting, and analytics capabilities for some of our most strategic businesses. You will help enable the team to deliver on financial and strategic objectives through developing processes and analyses that will facilitate revenue operations. You should have a high sense of ownership, a natural interest in continuously improving the way the business processes are run and a strong ability to communicate with non-financially minded peers. The role will report to our Lead Pricing Analyst.

What you’ll do:

Business support / revenue reporting

Generate and distribute detailed pricing reports to internal and external stakeholders
Investigate and communicate data discrepancies relative to trends and expectations, partnering with respective departments across the company to gain additional insight and recommending solutions
Support cross-functional business partners in developing and handling specific pricing requirements
Analyze and reconcile complex datasets to facilitate timely and accurate financial close

Establishing new processes / automation

Help establish and automate recurring processes towards efficient and scalable solutions
Develop methods to identify, monitor, and remedy data gaps and inconsistencies
Support creation of standardized reporting frameworks to improve speed and accuracy

What’s great about the role:

High impact, high visibility role where you’ll play a key role in shaping the understanding, reporting and strategic direction of established business units
Unique opportunity to be embedded in the business while providing objective and financial perspective that is grounded in data
Work in a highly cross functional and collaborative environment

Minimum Basic Requirements:

Bachelor’s degree in Math, Economics, Finance, Business or another related field
3 to 6 years of relevant work experience (experience in Internet, technology or high growth companies preferred)

Preferred Qualifications:

Self-starter, intellectually curious and a fast learner with high standards for accuracy
A rigorous analytical mind able to effectively communicate findings to non-financial partners
Previous experience improving existing processes and creating new processes to meet changing business needs
Ability and comfort working cross-functionally with finance, engineering, and business teams
Extremely proficient in Excel, SQL, and Google Workspace
Bonus Experience: Data Visualization (e.g., Looker)

--------------------------------------------------------------------------------------------------------------------------------------------
Create self-service and automated reporting in support of Banking Product & Services team (Looker and/or Tableau dashboards)

Aggregate datasets across third-party banking platforms (Build SQL scripts and automate using Airflow/other tools)

Partner with cross-functional stakeholders to iterate on dashboards and scope additional metrics of interest

Senior Analyst will be responsible for developing and delivering reporting dashboards for the Banking Product & Services team. This role will require a strong understanding of banking industry operational metrics and reporting best practices. The analyst will engage in the development of critical datasets to be used for cross-functional reporting.

Responsibilities
Collaborate with stakeholders across Banking Products & Services, Business Development and Analytics teams to define KPIs and scope dashboard requirements
Analyze/curate large volumes of data using BigQuery
Design, build and maintain dashboards in Looker
Build automated reports and alerts using Looker dashboards and email/Slack integrations
Develop and own validation processes to ensure data accuracy across dashboards and data sources
Resolve issues and bug fixes as part of the validation process and maintain backlog for dashboard enhancements
Provide recommendations for reporting improvements and build proof-of-concept processes utilizing best practices for data management.
Build dashboard tutorials, document process flows, best practices, and requirements of various use cases in a way that can be understood by technical and business stakeholders.
Support ad-hoc dashboard and data requests to provide insights to various teams
Work with the business development teams to research data issues, data validation and sign-offs
Build, develop and provide training on new and existing dashboards to various business units

Minimum Basic Requirement:
4+ years of experience with SQL
4+ years of experience with Looker, Tableau, or similar data visualization tool
Strong problem-solver able to identify opportunities for growth or improvement to advance the goals of our both our partners and our business

Preferred Qualifications:
Fintech, financial services, consulting or a similar strategic or analytical experience
Familiarity with banking risk concepts and KPIs (including fraud)
Experience with software development, especially in building automation
Ability to communicate qualitative and quantitative results clearly, succinctly and confidently in verbal and written communications
Ability to independently thrive in a fast-paced, dynamic, and often ambiguous work environment
Ability to work cross functionally and assert influence internally/externally


--------------------------------------------------------------------------------------------------------------------------------------------
Support SOX operations and related reporting requests.
Support revenue data daily operations and related ETL/Analytics requests.
Set up data quality monitoring/alerting rules for core BI pipelines and work with business stakeholders/engineers to troubleshoot and fix the issues surfaced.
Build robust reporting solutions and Looker dashboards based on business requirements

Partner with stakeholders across the organization, understand their current and future analytical goals and deliver scalable reporting solutions meeting their needs.
Use tools and programing methods to build ETL pipelines that transforms and loads large volume of data to BQ data warehouse.
Work closely with engineers to troubleshoot and resolve data quality issues and maintain high level of data accuracy in analytical data platform.

Dice Id : 10126850
Position Id : JP00000519
Originally Posted : 1 year ago
Have a Job? Post it