Contingent Senior Business Intelligence Developer

ID
2020-10290
Job Locations
US-CA-San Francisco

 

At First Republic, we care about our people. Founded in 1985, we offer extraordinary client service in private banking, private business banking and private wealth management. We believe that personal connections are everything and our success is driven by the relationships we form with our colleagues and clients. You’ll always feel empowered and valued here. 

 

Incredible teams doing exceptional work, every day

In Technology, we support First Republic’s employees and clients through the acquisition, integration and management of the Bank’s information technology systems and services. We drive innovation and explore emerging technologies so our people can be productive and focus on what matters most – providing extraordinary service.

 

This position focuses on the development and delivery of data warehousing and business intelligence solutions including: cubes, dashboards, scorecards, reports, user interfaces, and associated data structures using Microsoft applications and tools. The Business Intelligence Developer interfaces with stakeholders to understand their needs and then translates them into solutions which deliver business value.

 

What you’ll do as a contingent Senior Business Intelligence Developer:

  • Develop reports and dashboards using reporting services (SSRS), Tableau, OLAP cubes (SSAS) and relational databases.
  • Multidisciplinary work supporting data pipelines, data warehouses and reporting services.
  • Design and develop data movements using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures.
  • Follow data standards, resolve data issues, complete unit testing and system documentation for ETL processes
  • Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure database environments are sustainable, code migrations to production.
  • Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
  • Collaborate with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
  • Use business user requirements to improve functionality (speed, performance / usability).
  • Use Big Data technologies such as Kafka, Snowflake and related technologies to store, curate, process and publish datasets for consumption by downstream business users and applications.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability etc.
  • Create solutions utilizing industry standard dimensional models and data architecture to support business users that include data scientists, analysts and non-technical functional users.
  • Respond quickly to bug fixes and enhancement requests and be able to take directions and complete tasks on-time with minimal supervision.
  • Follow coding best practices-Unit testing, design/code reviews, documentation, etc.

 

You could be a great fit if you have:

  • Requires 10+years of progressive experience in developing and supporting data and reporting projects
  • Requires 7+ years of in-depth experience using ETL tools like SSIS, SnowSQL, Informatica and BI tools including SSRS, Power BI, Tableau etc
  • Requires 2+ years of using Snowflake capabilities like Snow SQL, Tasks, Streams, Time travel, Data sharing and stored procedures
  • Advance knowledge of performance tuning related to ETL Development
  • Proficiency in one of the scripting languages such as Java or Python is preferred
  • Expertise in operational data stores and real time data integration is preferred
  • Experience with Reporting and Dashboards including BI data modeling and architecture in financial services industry is preferred
  • Must possess excellent written and oral communications skills and the ability to clearly define projects, objectives, goals, schedules and assignments

Job Demands:

  • Must be able to review and analyze data reports and manuals; must be computer proficient.
  • Must be able to communicate effectively via telephone and in person.

Own your work and your career - apply now

Are you willing to take initiative and make decisions? Are you willing to go the extra mile because you love what you do and how you can contribute as a team? Do you want the freedom to grow and the opportunity to take charge of your own career? If so, then come join us.

 

We want hard working team players. You’ll have the independence to learn, lead and drive change. A culture of extraordinary service, empowerment and stability—that’s the First Republic way.

 

This job description is not intended to be all-inclusive. Employee may perform other related duties as assigned to meet the ongoing needs of the organization. The Company is an equal opportunity employer. In this regard, the Company makes reasonable accommodations for qualified applicants and employees with disabilities in order to enable them to perform all essential job functions, unless doing so creates an undue hardship.

 

First Republic is subject to federal laws that restrict the employment of individuals with certain types of criminal histories, including FDIA Section 19 and FINRA. To the extent not inconsistent with our obligations under those federal laws and regulations, First Republic will consider qualified candidates with criminal histories in a manner consistent with the Los Angeles and San Francisco ban-the-box laws.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.