BI & Data Visualization Developer

Citizens Business Bank; Rancho Cucamonga (CA); On-site; USD 90,000 - 130,000; Full time

Job summary

Citizens Business Bank is seeking an experienced BI Visualization Developer to design, develop, and implement enterprise BI solutions. You will work on Power BI dashboards, data marts, and data integrations to turn data into strategic assets for the organization.

The role requires 2–5 years of Power BI experience, strong SQL, data modeling, and ETL skills, with collaboration across IT and business teams to deliver governance and insightful analytics.

Qualifications

• Bachelor's degree in Computer Science, Information Systems or related field.
• 2–5 years of Power BI development and administration experience.
• Strong SQL skills and experience with data warehousing, ETL and BI tools.
• Experience building dashboards, data models, and KPI scorecards.

Responsibilities

• Develop and implement enterprise BI solutions and dashboards using Power BI.
• Design data integrations and data warehouse/ data mart solutions.
• Document data sources, lineage, and governance requirements.
• Collaborate with IT, analytics teams and business units to translate requirements into designs.

Skills

Power BI

Data Visualization

SQL

Analytical skills

Communication

Education

Bachelor's Degree in Computer Science or Information Systems

Tools

SSIS

SQL Server

SSRS

Azure Power Platform

Power Automate

Power Apps

Job description

SUMMARY

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.

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Complies with and stays abreast of all policies and procedures, federal and state laws applicable to the job.
2. Plays an instrumental role in developing the data warehouse and BI strategy and initiatives.
3. Analyzes business and technical requirements, translates them to high level design documents.
4. Design and implement BI tools and processes for data intake from multiple sources.
5. Establish and maintain data security and compliance, access controls, data governance.
6. Design and implement user analytical and visualization tools.
7. Provide support to the BI users on the effective use of reporting tools and data structure
8. 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.
9. 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.
10. With minimal supervision work on a wide range of projects interfacing with development teams, business analysts, IT management and members of the business units
11. Other duties as assigned.
12. Provide, present and promote The Citizens Experience to all external and internal customers.

SUPERVISORY RESPONSIBILITIES

This position has no supervisory responsibilities.

QUALIFICATIONS

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

EDUCATION and/or EXPERIENCE

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.

LANGUAGE SKILLS

This position requires 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. Requires the ability to read, analyze, and interpret general business periodicals, professional journals, technical literature, and government regulations.

MATHEMATICAL SKILLS

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.

REASONING ABILITY

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.

COMPUTER SKILLS

To perform this job successfully, an individual should have the following experience:

• 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.
• 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

OTHER QUALIFICATIONS/SKILLS

• Experience in data management through data modeling, data architecture, and data warehouse is desired.
• 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.

PHYSICAL DEMANDS

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonably accommodations may be made to enable individuals with disabilities to perform the essential functions.

While performing the duties of this job, the employee is regularly required to use hands to finger, handle, or feel; reach with hands and arms; and talk or hear. The employee frequently is required to sit. The employee is occasionally required to stand; walk; and stoop, kneed, crouch, or crawl. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this position include close vision, and ability to adjust focus.

WORK ENVIRONMENT

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

The noise level in the work environment is usually moderate.