AVP Front Office Technology (PowerBI / Manager)
Chicago, IL 60606
AVP – Front Office Technology ( PowerBI / Manager )
The Technology Solutions Department is responsible for designing and delivering state of the
art technology solutions that are designed to create efficiency, mitigate risk and grow revenue
for the Firm. Technology Solutions is also responsible for defining, managing and executing a
robust Cyber Security program following the NIST Cyber Security Framework. Technology
Solutions focuses on technical excellence through innovative application designs, robust data
integration and analytics, high availability infrastructure and gold level service for our key
stakeholders with information security embedded throughout. Critical functions within
Technology Solutions include Project Management, Vendor Management, Business Analysis,
Enterprise Data Governance and Stewardship, Application Development and 3rd Party
Integration, Strategic and Secure Infrastructure and Operations. The Technology Solutions
Department collaborates closely with Firm leadership and business unit heads to develop
plans in line with business objectives.
The Technology Solutions Department is looking for a skilled Senior Technical
Lead for the Front Office Reporting & Power Apps Team dedicated to expanding and
enhancing our Front Office reporting capabilities using Power BI and unlocking our CRM data
by leveraging Power Apps and other tools in support of our strategic “ Data is Power” initiative.
The successful candidate must have demonstrated prior experience working in a data
intensive environment, delivering robust and progressive reporting solutions to end users. The
candidate must be able to quickly gain a deep understanding of key business processes and
the supporting enterprise data models to help design and deliver impactful analytic and
reporting technology solutions to enhance those processes. This hands-on role requires
strategic thinking, strong client focus, strong technical leadership and the ability to execute
This individual will be responsible for managing a small team of 2 to 4 resources
and leading the development of functional and non-functional requirements, iteratively
translating those requirements into quality solutions and resolving end-user issues in order to
ensure adoption within the business and realization of the business benefits. This is a client-facing role requiring communication with users and internal / external team members at all
levels so exceptional verbal and written communication skills are a must.
The ideal candidate must be able to perform the following:
− Demonstrate mastery of the enterprise reporting development and delivery domain areas,
using multiple technologies and tool sets.
− Master Power BI Paginated (SSRS) and Power BI and stay abreast of rapid developments
in these technologies. Independently execute complex data analysis across multiple
platforms using Excel, Power BI, Power BI Paginated or other available tools. Utilize
reporting tools to design and deliver dashboards and reports to stakeholders. Participate in
strategic designs of centralized and decentralized reporting platforms based on business
− Become a subject matter expert in the core business functions and technology solutions.
Understand the relationships, dependencies and impact of related business functions to
your area of responsibility. Be a thought partner with our business creating a competitive
advantage through analytics and reporting.
− Build strong and productive relationships with key business stakeholders, sponsors,
technology colleagues and technology vendors to analyze and understand complex
business processes and present them in an understandable and logical format. Develop
detailed requirements documentation including user stories, use cases, design
specifications, business process, data flows and acceptance criteria. Execute projects that
involve team members across all areas including internal and external partners.
− Accountable for deliverables by understanding and balancing the competing demands for
project scope, time and quality. Provide day-to-day consultation and technical leadership,
inclusive of project life cycle planning. Understand and apply the enterprise vision and
strategy to the project solution while balancing tactical needs to deliver.
− Ensure that all delivered solutions meet the highest quality standards and satisfy all
specified business requirements through rigorous validation and testing. Manage support
issues raised by the business through to resolution and within defined support SLAs.
− Confidently facilitate meetings and manage frequent communications with all levels of the
organization including key stakeholders and senior management. Be very resourceful to
proactively identify and engage available resources and subject matter experts in related
areas to achieve your goals, with a strong ability to multitask and manage time and
priorities under pressure while meeting deadlines.
− Mentor others in using analytical and reporting tools, while evaluating and enhancing
existing reports and dashboards.
− Keeps abreast of industry trends through benchmarking and participation in professional
associations in order to advise others of strategic technology direction.
Qualifications & Experience:
− Bachelor’ s degree required
− 7-10 years of work experience in a similar role, preferably in Financial Services
− 4+ years of quality experience using and demonstrating exceptional proficiency with at
least 3 of the following: T-SQL, Data Warehouse, Power BI, SSRS, SSIS and SSAS / AAS
− High level of proficiency with Microsoft Office applications (Word, Excel, PowerPoint, MS
− A solid understanding of the agile development cycle, in particular with 3rd party vendors
− Experience executing small to medium sized projects and general understanding of Project
− Self-motivated, team oriented, flexible and able to multi-task with a positive can-do and ‘ no
job too small’ attitude
− Detail-oriented with excellent analytical and problem-solving skills
− Exceptional interpersonal, verbal, written and presentation skills
− Results oriented with a high level of personal accountability
− Motivated by a fast paced, complex environment
Critical Competencies for Success:
Our Gold Standards Model defines key behaviors and competencies across 4 dimensions:
Leadership, Achieving Results, Personal Effectiveness and Thinking Critically. These
behaviors and competencies drive our ability to win together.
− Leadership: Role models in this area consistently focus on the right goals and priorities
and continually develop themselves and others. Always team players, they influence and
engage with others to contribute to a great culture.
− Achieving Results: Role models in this area are high achievers who develop careful plans
and execute consistently and effectively. They hold themselves and others accountable for
delivering high quality results.
− Thinking Critically: Role models in this area understand our business, rely on analytical
reasoning to define and solve problems and make decisions effectively. They are forward
thinking, anticipating issues and addressing them in advance.
− Personal Effectiveness: Role models in this area build strong relationships and
communicate effectively. They are driven to exceed expectations and adaptable to
The department-specific competencies define the knowledge, skills and abilities that are
needed to successfully perform the functional or technical work of this role.
− Technical Support: Triages, troubleshoots and resolves technical support issues.
Escalates issues as needed.
− Software Development Principals: Utilizes software development, secure programming
principles and a knowledge of programming languages to develop, configure and / or
integrate new software and applications.
− Business Needs Assessment: Identifies business needs across departments within the
Firm to understand the challenges, goals and problems that the business needs to solve
and identifies appropriate technical solutions.
− Data Management and Information Security: Manipulates, restructures and / or queries
data for various purposes, including reconciling issues in the database, designing database
structures and / or generating reports. Adheres to governance principles and maintains
data integrity and security.
− Risk Management: Identifies, forecasts and articulates ways to pursue and manage
informed risks in ambiguous, complex or uncertain situations based on sound value
propositions and an analysis of potential rewards and costs.
− Testing: Evaluates the functionality of an application, system or solution to ensure that
requirements have been met and defects have been identified. Applies an understanding of
end user requirements and usage in the end-to-end system to produce a quality product.
− Industry Knowledge: Demonstrates an understanding of the Firm' s position in the industry,
including its complex structure and competitive advantage in the marketplace. Monitors
industry trends and changes and recognizes their relevancy and implications.
− Technical Communication and Documentation: Documents and communicates technical
processes and procedures in area of specialty to stakeholders. Adapts the level of detail
and specificity based on the needs of the intended audience.
− Vendor Management: Manages and coordinates with external vendors. Researches and
identifies new vendors as needed and monitors performance.
− Relationship Management: Builds and maintains effective partnerships with internal
clients and end users by advising on their needs and options, advocating for their business
within the Technology Solutions department and managing expectations appropriately.
− Project / Program Management: Manages Technology Solutions project elements
considering conflicting priorities, interdependencies, business objectives, communications
and available resources.
− Innovative Mindset: Leverages an agile and creative mindset to drive innovative value
creation, continuous process improvement and proactive learning through new technology,
processes and people