Fiserv Business Intelligence Advisor in Berkeley Heights, New Jersey
Calling all innovators – find your future at Fiserv.
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.
Business Intelligence Advisor
What does a great Business Intelligence Advisor do?
In this role, the Business Intelligence Advisor will be responsible for leading the collection and analysis of a wide range of information and data from various on-premises and cloud database sources and systems, designing, and developing central data warehouse using standard ETL procedures, and building data models and architecture within SQL using complex logics and queries as well as front end reporting using Power BI reports and dashboard using data from these sources. The Associate will be expected to design and maintain highly complex data model, insightfully and accurately evaluate the data, and communicate the data and actionable insights via reports and dashboards. Database development often consists of establishing connections between servers, designing schema and tables, stored procedures, views, and functions.
In this position, we are looking for someone with strong data warehousing and ETL expertise and Business Intelligence/ Reporting experience and a background in design, development and implementation of MS SQL database. This person will work in a collaborative environment communicating and engaging with multiple teams on a regular basis to collect and analyze data to develop database and reporting to further provide actionable insights on a daily/weekly/monthly basis.
As a Business Intelligence Advisor you can look forward to:
Design, develop and implement high-quality and high-performance data base solutions and data warehouses in Microsoft SQL stack across on-premises and cloud environments
Leading and managing data analytics and reporting project deliverables and underlying On-Prem / Cloud infrastructure
Develop, implement, and optimize stored procedures, scripts, and functions using ETL, SSIS and T-SQL for data ingestion, migration, and processing
Identifying prioritization and assigning 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
Analyze existing SQL queries for performance improvements
Prepare user documentation including Technical Design Document, Implementation Plan, unit test cases and other documentation as required.
Deriving actionable insights from management and executive reporting and metrics, and delivering business recommendations
Review and interpret ongoing business report requirements by communicating with multiple business teams in a collaborative environment
You are the kind of person who:
Is self-motivated, detail-oriented, has a passion for understanding the inner workings of applications, and enjoys working in a fast-paced, collaborative environment.
Enjoys working with data, metrics, and designing management reports and dashboards that can communicate actionable insights as per the audience
Is results oriented with excellent communication and interpersonal skills
Is very attentive to details, service-oriented, strong sense of impact of information quality on business decisions.
Minimum Qualifications and Skills
Education – Bachelor’s/Master’s Degree in Computer science / Engineering / Statistics / Economics / Mathematics or related disciplines
Minimum 8 years hands-on experience on Microsoft SQL and Reporting stack: SQL server, SSIS, SSAS, SSRS, T-SQL, DAX, and underlying functions
Minimum 5 years’ experience designing, development and implementing reports and dashboards using industry leading BI tools e.g. Power BI
End to end experience in gathering specifications for design, planning, coding, testing, and deploying of data warehousing and reporting project
Strong expertise in ingesting and migrating data from multiple on-premises and cloud sources
Good exposure and hands on experience with SQL databases creating schemas, physical tables, and relationships, and ability to apply dimensional modeling, and OLAP approaches to solutions.
Experienced in collecting and processing data and conducting analysis, ideally for management and decision-making processes.
Strong data preparation and querying skills using SQL, and performance optimization of SQL, ETL, OLAP and Reporting layers
Experience in regression and unit testing solutions which encompasses code functionality, data constraint requirements and dimensional modeling logic for component calculations.
Experienced working with SSAS (Tabular Model), M query, power query, power pivot, Microsoft Excel
Skilled in ingesting and processing data using direct query, import and hybrid modeling features, and applying DAX logics and functions to create calculated measures and columns
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.
Experience working with gateway, scheduler, App workspace on Power BI Service
Automation of analysis cube activities using AMO/TOM libraries
Ability to analyze and identify source data, grain, dimensions, facts, relationships
Experienced in client communications, understanding objective and scope
Preferred Qualifications and Skills
Financial or Banking industry experience
Experience of Azure or Snowflake environment
Experience working in a global collaborative team environment
Who we are?
Enterprise Client Excellence team’s mission is to deliver a word-class client experience by creating a horizontal operating model, and have enterprise-wide, and top-down alignment around targeted strategic focus areas. This team is focused on leading and driving strategic and operational initiatives sponsored by Fiserv leadership to improve client experience and operational excellence vis-à-vis divisional and enterprise-wide operational processes efficiency improvements, and management and leadership reporting and analytics, leading to increased client reference-ability and retention, higher revenue, and higher client satisfaction. Internally, these initiatives will focus on setting best practices and standards to improve operational effectiveness and internal coordination for quicker resolution of client pain points.
Fiserv is an Equal Opportunity Employer/Disability/Vet.
This role is not eligible to be performed in Colorado, California, New York or Washington.
Please note that salary ranges provided for this role on external job boards are salary estimates made by outside parties and may not be accurate.
Thank you for considering employment with Fiserv. Please:
Apply using your legal name
Complete the step-by-step profile and attach your resume (either is acceptable, both are preferable).
What you should know about us:
Fiserv is a global fintech leader with 40,000-plus (and growing) associates proudly serving clients in more than 100 countries. As a FORTUNE™ 500 company, one of Fast Company’s Most Innovative Companies, and a top scorer on Bloomberg’s Gender-Equality Index, we are committed to excellence and purposeful innovation.
Our commitment to Diversity and Inclusion:
Fiserv is an Equal Opportunity Employer, and we welcome and encourage diversity in our workforce that reflects our world. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by law.
We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.
Warning about fake job posts:
Please be aware of fraudulent job postings that are not affiliated with Fiserv. Fraudulent job postings may be used by cyber criminals to target your personally identifiable information and/or to steal money or financial information.
Any communications from a Fiserv representative will come from a legitimate business email address. We will not hire through text message, social media, or email alone, and any interviews will be conducted in person or through a secure video call. We won’t ask you for sensitive information nor will we ask you to pay anything during the hiring process. We also won’t send you a check to cash on Fiserv’s behalf.
If you see suspicious activity or believe that you have been the victim of a job posting scam, you should report it to your local FBI field office or to the FBI’s Internet Crime Complaint Center.
- Fiserv Jobs