BI & Data Visualization Developer

Citizens Business Bank•Rancho Cucamonga, CA

2d•$104,061 - $150,888

About The Position

This role will enable the company’s use of data as a strategic asset of corporate goals and objectives. The incumbent will be responsible for strategically designing, developing, and implementing enterprise-level BI solutions, data integrations and analytical applications. This role is responsible for understanding and documenting data sources, usage and lineage for enterprise information. The DW-BI & Visualization developer must drive the completion of projects within the established scope, while simultaneously plan for and manage the unknown future of BI requirements in a dynamic environment. The ideal candidate will have extensive hands on experience as a BI Visualization Developer working with Power BI, creating prototypes, dashboards and data marts.

Requirements

Bachelor’s Degree (B.A.) from four-year College or university in Computer Sciences, Information Systems, or other related field.
2 – 5 years of experience in Power BI and Power BI Administration (setting up workspaces and users with permissions, roles and security, etc.), SQL Server and Reporting Services SSRS, data warehouse, ETL and BI technologies, and advanced query and SQL skills.
Strong communication skills, both written and oral, with the ability to write reports, business correspondence, and procedure manuals, as well as the ability to effectively present information and respond to questions.
Ability to read, analyze, and interpret general business periodicals, professional journals, technical literature, and government regulations.
Ability to work with mathematical concepts such as probability and statistical inference, discounts, interest, commissions, proportions, percentages, area, circumference, and volume.
Ability to apply concepts of basic algebra and geometry.
Strong analytical skills with the ability to solve practical problems and deal with a variety of concrete variables in situations where only limited standardization exists.
Ability to interpret a variety of instructions furnished in written, oral, diagram, or schedule form.
2 - 5 years of most recent experience using Data Visualization tool and Microsoft Power BI.
2+ years of experience in MS Excel, Pivot Tables, charts, graphs, dashboards, Power Pivot, Power view, and Power Map.
Proficient in developing reports, dashboards, KPI Scorecards, DAX solutions, and data source connections.
5 years’ experience in developing ETL solutions using SSIS and other SQL Server tools.
2 – 5 years’ experience and knowledge of Data Modeling for Business Intelligence and Data Visualization.
Strong analytical and troubleshooting skills.
Understanding of best practices for common ETL design techniques such as change data capture, key generation, and optimization.
Deep understanding of relational and dimensional database domains.
Knowledge of master data management, metadata management, information lifecycle design, and development.
Motivated self-started, detail and quality oriented and ability to handle multiple competing priorities.
Must be a strong team player with a positive attitude and enthusiasm to get things done.
Ability to present to various levels of the organization, including executive management.
Excellent communication (both written and verbal) and interpersonal skills.

Nice To Haves

Experience and knowledge of working with cloud-based IT infrastructure and platforms, specifically Microsoft Azure Power Platform (Power Bi, Power Automate (Flow), and Power Apps) a plus
Experience in data management through data modeling, data architecture, and data warehouse is desired.

Responsibilities

Complies with and stays abreast of all policies and procedures, federal and state laws applicable to the job.
Plays an instrumental role in developing the data warehouse and BI strategy and initiatives.
Analyzes business and technical requirements, translates them to high level design documents.
Design and implement BI tools and processes for data intake from multiple sources.
Establish and maintain data security and compliance, access controls, data governance.
Design and implement user analytical and visualization tools.
Provide support to the BI users on the effective use of reporting tools and data structure.
Identify requirements, design, create, deploy, monitor and support BI reports and dashboards, shared object and cubes to empower discovery and information-sharing for business users.
Utilize expertise and knowledge of data modeling, ETL, and report design for department initiatives, and produce detailed documentation including data flow diagrams, logical diagrams, and data lineage documents.
With minimal supervision work on a wide range of projects interfacing with development teams, business analysts, IT management and members of the business units.
Other duties as assigned.
Provide, present and promote The Citizens Experience to all external and internal customers.