Top Stack Hiring for Business Intelligence Analyst (Hybrid) at Philadelphia, Pennsylvania Full Time

NOTE: This is a hybrid position with 2 days per week in their Center City office required.

Top Stack has been retained by a wealth management organization with offices in Center City, Philadelphia, PA to identify a Business Intelligence Analyst to join their team. This is a full-time, salaried position with a competitive base and best in class benefits package and culture!

NOTE: 1 to 3 years experience. This is a junior to mid position with a salary that reflects years experience.

You will be part of a dynamic team that places significant value on the role of Business Intelligence Analyst in supporting its business. The position offers a unique opportunity shape and contribute to future departmental strategy, harnessing the modern automation and analytics toolbox. This is a new role created specifically to deliver solutions to clients and help modernize the skillset of the team.

Job Duties:

• Learn about the company’s data architecture to effectively run Microsoft SQL queries, power queries, and OLAP queries to collect, prepare, and transform data for client deliverables ad hoc and as a part of streamlined data pipelines.
• Automate quality control and data preparation processes using Alteryx or other tools to eliminate manual work for the team.
• Build python programs to calculate advanced analytics that would otherwise be impossible without a programming language.
• Innovate process improvement solutions with the long-term goal to outsource or automate repeatable tasks.
• Provide subject matter expertise on advanced tools and methods such as Python, Microsoft technology stack, Adobe, Alteryx, Artificial Intelligence, APIs, file transfer and job scheduling, or others.
• Supporting and a resolving complex ad-hoc queries and requests from various stakeholders including teams, clients, and others.
• Prepare regular reporting cycle client materials, including standardized and custom client deliverables that may require sourcing data from various systems and editing data within Excel and PDF file formats.

Education and Experience:

• 1-3 years of experience in a Business Intelligence or Data Engineering role.
• Bachelor’s Degree or higher in Computer Science, Applied Math, Engineering, Business Intelligence or Data Analytics for business, or similar quantitative subject area.
• Ability to recognize process improvement opportunities, and design and implement those ideas, primarily through the use of a modern technology toolbox.
• Practical experience with data transformation and preparation within various data architectures (i.e. low end excel up to higher end data warehouse).
• Experience using computer languages (SQL, M Language, DAX, Python) to manipulate data and draw insights from large data sets.
• Experience with data modelling in Power BI or similar BI tools.
• System expertise using Microsoft Power BI (or other BI tools), SSRS, Power Automate, and SQL Server Studio, and Alteryx.
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
• Excellent communication skills for managing and translating complex concepts into easily understandable terms.
• A drive to learn and master new technologies and techniques.
• General knowledge of finance and investments.