As a Business Data Analyst you will be part of the Data Analytics team that is responsible for delivery of data and analytics solutions supporting the entire firm. This role will be responsible for delivering analytics and visualization products to internal consumers across Operations, Finance, Client Service, and Data Management. The analyst will gather requirements, define the data sourcing required, create the appropriate data pipelines in Alteryx, deliver transformed data to an analytics database, and provide data consumers access via Tableau dashboards.
- Support the ongoing project deliveries of the Data Analytics team
- Creating dashboards & data visualizations to support various business functions
- Improving data governance, data quality validation, and tracking
- Support deployment, automation, and ongoing management of these solutions
- Analyze data using tools such as Alteryx, Tableau, and SQL to develop and automate reports
- Design and develop Alteryx workflows to source, transform, and prepare data for use in Tableau dashboards and for ad-hoc analyses
- Perform activities for data extraction, data validation, data cleansing, data harmonization, exception handling, and data transformation
- Design and build a data inventory including field definitions, list of values, and mapping
- Leverage a variety of tool (Alteryx, SQL, etc.) to assess data quality, prepare automated reports for tracking data quality related metrics, and assist in resolving data quality problems if possible
Minimum Qualifications
- 3+ years of hands-on experience with data analysis, data wrangling/ETL, and data visualization in a business environment, with:
- 2+ years with Tableau and creating data visualizations
- 2+ years with Alteryx for performing data validation, ETL, and data automation
- 2+ years with SQL and various database tools
- Highly proficient in SQL, creating complex queries, and building and analyzing datasets
- Experience with creating Alteryx data flows, and deploying & automating them to Alteryx Server
- Adept at data exploration and able to quickly understand how to link and model disparate data sets
- Basic understanding of data models and concepts, including relational databases, and dimensional models
- Experience in the financial services industry, with an understanding of relevant data domains such as financial instruments, transactions, positions, counterparties, etc.
- Experience with basic data modeling and DDL is a plus
- Strong technical skills and business analysis skills
- Undergraduate degree in engineering, mathematics, statistics, or other quantitative field