Centennial Bank ยท 5 months ago
Senior Business Intelligence Analyst
Centennial Bank is seeking a Senior Business Intelligence Analyst responsible for designing and developing complex SQL and creating reports using various BI tools. The role involves collaborating with multiple teams to understand their data needs and ensuring the quality and performance of BI solutions.
BankingFinanceFinancial Services
Responsibilities
Advanced proficiency in SQL for writing complex queries and understanding database schemas. This duty is performed daily
Develops and deploys new reports and various visual representations including self-service reports using RPB, Power BI, and other BI Tools to meet the reporting needs of the organization. This duty is performed daily
Develop SQL scripts, SQL stored procedures and SQL Views for various reporting and data development projects. This duty is performed weekly
Collaborate with various teams (such as marketing, finance, operations) to understand their data needs. This duty is performed weekly
In-depth understanding and application of the BI reporting life cycle, including Requirements Gathering, Analysis, Design and Development, Testing, Work Estimation and Supporting Documentation. This duty is performed weekly
High level of accountability and a dedication to producing high-quality work that is easily consumable by end users. This duty is performed daily
Excellent time management and prioritization skills; ability to manage multiple projects and priorities and meet established timelines. This duty is performed daily
Critical thinking, analytical, logical problem solving, organizational, and presentation skills. This duty is performed weekly
General understanding of SSIS packages. This duty is performed monthly
Conduct reviews of peer data and reporting development to ensure solutions meet regulation standards, are built for performance, and meet development best practices. This duty is performed monthly
Solve complex data issue using data analyst skills to determine root cause problem for data integrity and data quality issues. This duty is performed weekly
The ability to work in a constant state of alertness and in a safe manner. This duty is performed daily
Complete required BSA/AML training and other compliance training as assigned. This duty is performed quarterly
Perform any other related duties as required or assigned
Qualification
Required
Advanced proficiency in SQL for writing complex queries and understanding database schemas
Develops and deploys new reports and various visual representations including self-service reports using RPB, Power BI, and other BI Tools to meet the reporting needs of the organization
Develop SQL scripts, SQL stored procedures and SQL Views for various reporting and data development projects
Collaborate with various teams (such as marketing, finance, operations) to understand their data needs
In-depth understanding and application of the BI reporting life cycle, including Requirements Gathering, Analysis, Design and Development, Testing, Work Estimation and Supporting Documentation
High level of accountability and a dedication to producing high-quality work that is easily consumable by end users
Excellent time management and prioritization skills; ability to manage multiple projects and priorities and meet established timelines
Critical thinking, analytical, logical problem solving, organizational, and presentation skills
General understanding of SSIS packages
Conduct reviews of peer data and reporting development to ensure solutions meet regulation standards, are built for performance, and meet development best practices
Solve complex data issue using data analyst skills to determine root cause problem for data integrity and data quality issues
The ability to work in a constant state of alertness and in a safe manner
Complete required BSA/AML training and other compliance training as assigned
Technical degree required in such disciplines as Computer Engineering, CPA, etc., plus 4 years related experience and/or training, and 3 years related management experience, or equivalent combination of education and experience
Ability to read, analyze, and understand common scientific and technical journals, financial reports, and legal documents; ability to respond to complex or difficult inquiries or complaints from customers, regulatory agencies, or members of the business community
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane, algebra, solid geometry and trigonometry
Ability to define problems, collect data, establish facts, and draw valid conclusions. Ability to interpret an extensive variety of technical instructions in mathematical or diagram form and deal with several abstract and concrete variables
Carries out supervisory responsibilities in accordance with the organization's policies and applicable laws. Responsibilities may include but not limited to interviewing, hiring and training employees; planning, assigning and directing work; appraising performance, rewarding and disciplining employees; addressing complaints and resolving problems
Supervises a small group (1-3) of employees in the same or lower classification. Assigns and checks work; assists and instructs as required, but performs same work as those supervised, or closely related work, most of the time. Content of the work supervised is of a non-technical nature and does not vary in complexity to any great degree
Experience must include development of BI solutions (metadata, reporting, analytics, dashboards, report definitions, data extracts, etc.) (Financial sector preferred)
Advanced level of executing, implementing and supporting BI solutions based upon business requirement, content knowledge and multiple data source types
Experience must include knowledge of SQL (designer, queries)
Preferred
Technical certifications in relevant application(s) strongly preferred (i.e., PowerBi)
Associate Certified Analytics Professional (aCAP, Comptia Data+) or another vendor-neutral analytics certification preferred
Company
Centennial Bank
Centennial Bank offers businesses, investors, and municipalities a wide range of commercial, retail banking, and related financial services.
H1B Sponsorship
Centennial Bank has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2021 (1)
Funding
Current Stage
Late StageLeadership Team
Recent News
Home BancShares, Inc.
2025-10-15
2024-06-05
Company data provided by crunchbase