Business Intelligence Advisor

Fiserv

Milwaukee, WI

Full Time

Senior

14 days ago

Job Description

About the Role

We're Fiserv, a global leader in Fintech and payments, and we move money and information in a way that moves the world. We connect financial institutions, corporations, merchants, and consumers to one another millions of times a day - quickly, reliably, and securely. Any time you swipe your credit card, pay through a mobile app, or withdraw money from the bank, we're involved. If you want to make an impact on a global scale, come make a difference at Fiserv.

Key Responsibilities

Analyze, design, develop, implement, lead and manage high-quality and high-performance data base solutions and data warehouses in Microsoft SQL stack across on-premises and cloud environments
Develop, implement, and optimize stored procedures, scripts, and functions using ETL, SSIS and T-SQL for data ingestion, migration, and processing
Identify prioritization and assign tasks to the team gathering requirements and creating business requirement documentation
Build dynamic and interactive management and executive reporting and dashboards in industry leading business intelligence tools
Work closely with business partners and analysts to understand the data requirements and to analyze and design the necessary data flow and database architecture
Prepare user documentation including Technical Design Document, Implementation Plan, unit test cases and other documentation as required
Derive actionable insights from management and executive reporting and metrics, and deliver business recommendations
Review and interpret ongoing business report requirements by communicating with multiple business teams in a collaborative environment

Requirements

8+ years' experience on Microsoft SQL and Reporting stack: SQL server, SSIS, SSAS, SSRS, T-SQL, DAX (Power BI), and underlying functions: strong data warehousing and ETL expertise and Business Intelligence/ Reporting experience
Experience in gathering specifications for design, planning, coding, testing, and deploying of data warehousing and reporting project
Experience with SQL databases creating schemas, physical tables, and relationships, and ability to apply dimensional modeling, and OLAP approaches to solutions
Experience in collecting and processing data and conducting analysis, ideally for management and decision-making processes
Experience in regression and unit testing solutions which encompasses code functionality, data constraint requirements and dimensional modeling logic for component calculations
Experience working with gateway, scheduler, App workspace on Power BI Service
Bachelor's in Computer Science, Engineering, Statistics, Economics, Mathematics or related disciplines

Nice to Have

Master's Degree
Financial or Banking industry experience
Experience of Azure or Snowflake environment
Implementing RLS security and other methods to restrict reports and metrics to limited audience, including creating the roles and object security as per data access requirements from business
Automation of analysis cube activities using AMO/TOM libraries

Qualifications

Bachelor's in Computer Science, Engineering, Statistics, Economics, Mathematics or related disciplines

Benefits & Perks

Medical, Vision and Dental Benefits
Fuel Your Life Wellness Program
401k, Employee Stock Purchase Plans and Incentives & Bonuses
Paid Time Away
Comprehensive benefit plans to suit your unique needs
Resources to elevate your well-being
When Fiserv performs well, so does your financial health
Celebrating inclusion in the workplace

Working at Fiserv

We maintain a strong focus on diversity and inclusion through Employee Resource Groups that promote our inclusive culture where associates can share perspectives, exchange ideas, and elevate careers. We value in-person collaboration as an essential part of the role, fostering stronger onboarding and productivity. Fiserv is committed to equal opportunity employment and creating a supportive environment for all employees.

Apply Now