If you are hired to this position, you will be employed by Magnit Global. You will not be employed by City National Bank.

The Opportunity

As a member of City National's Chief Data and Analytics Office, you will drive, develop, and maintain BI reporting solutions for internal clients and colleagues. This is an exciting time of technology advancement and innovation across the bank, particularly within our Enterprise Analytics team.

The Responsibilities

• Develop and test dashboards, visualizations, semantic data models, and reports.  Focus will be on reporting development using SAP Business Objects.
• Develop high level and detailed designs for existing reporting platforms, development activities along with process improvements.
• Work with business users to gather requirements, troubleshoot report issues, and drive resolutions towards completion.  Participate in user acceptance testing.
• Effectively communicating and collaborating with business users, T&I support teams, providing an understanding of the problem and resolution.
• Identify development and data quality issues, performing thorough testing and validation of reports, visualizations and dashboards in conjunction with business users.
• Research and trouble-shoot user-reported issues and incidents related to the BI reporting environment including performance, data discrepancies, access issues, etc.
• Be a self-starter, someone that will take the initiative to learn new things and research solutions without prompting.
• Ability to multi-task various projects and tasks with tight deliverables.
• Fosters and maintains good relationships with colleagues to meet expected customer service levels.
• Develop and maintain positive, productive, and professional relationships with key business users to meet expected customer service levels.

The Qualifications

• Minimum 3 years of BI report development experience using Business Objects 4.2 or above.  Includes experience with Universe Design (IDT/UDT).
• Minimum of 1 year of SQL logic development and support experience. Skills and Knowledge
• Strong SQL and data modeling experience; the capability to troubleshoot joins, conduct performance tuning across heterogeneous sources, and validate the end-to-end data flow process
• Direct experience cleaning data and compiling disparate data sources across multiple databases, ensuring consistent semantic layers and governed data definitions.
• Direct experience with Oracle, MS SQL Server and Snowflake databases is strongly preferred
• BS in Computer Science or a related technical field preferred.
• Direct experience with Tableau or other business intelligence platforms is strongly preferred.
• Excellent analytical and problem-solving skills.
• Excellent oral and written communication and interpersonal skills.
• Strong organizational, multi-tasking, and time-management skills preferred.
• Ability to work independently or within a team for problem resolution
• Must demonstrate ability to multi-task and be flexible.

This is the pay range that Magnit reasonably expects to pay for this position: $59.34/hour - $63.61/hour

Benefits: Medical, Dental, Vision, 401K