What are the responsibilities and job description for the Senior Business Intelligence Analyst position at CEN?
GENERAL DESCRIPTION OF POSITION
The Senior Business Intelligence Analyst is responsible for designing and developing complex SQL using various tools such as Microsoft Report Builder, SSMS, and PowerBi.
ESSENTIAL DUTIES AND RESPONSIBILITIES
1. Advanced proficiency in SQL for writing complex queries and understanding database schemas. This duty is performed daily.
2. 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.
3. Develop SQL scripts, SQL stored procedures and SQL Views for various reporting and data development projects. This duty is performed weekly.
4. Collaborate with various teams (such as marketing, finance, operations) to understand their data needs. This duty is performed weekly.
5. 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.
6. High level of accountability and a dedication to producing high-quality work that is easily consumable by end users. This duty is performed daily.
7. Excellent time management and prioritization skills; ability to manage multiple projects and priorities and meet established timelines. This duty is performed daily.
8. Critical thinking, analytical, logical problem solving, organizational, and presentation skills. This duty is performed weekly.
9. General understanding of SSIS packages. This duty is performed monthly.
10. 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.
11. 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.
12. The ability to work in a constant state of alertness and in a safe manner. This duty is performed daily.
13. Complete required BSA/AML training and other compliance training as assigned. This duty is performed quarterly.
14. Perform any other related duties as required or assigned.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty mentioned satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
EDUCATION AND EXPERIENCE
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.
COMMUNICATION SKILLS
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.
MATHEMATICAL SKILLS
Ability to work with mathematical concepts such as probability and statistical inference, and fundamentals of plane, algebra, solid geometry and trigonometry.
CRITICAL THINKING SKILLS
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.
REQUIRED CERTIFICATES, LICENSES, REGISTRATIONS
Not indicated.
PREFERRED CERTIFICATES, LICENSES, REGISTRATIONS
Licenses/Certifications: 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.
SOFTWARE SKILLS REQUIRED
Advanced: 10-Key, Database
Intermediate: Accounting, Alphanumeric Data Entry, Presentation/PowerPoint, Programming Languages, Spreadsheet, Word Processing/Typing
RESPONSIBILITY FOR WORK OF OTHERS
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.
WORKING CONDITIONS
Normal working conditions as found within an office setting, wherein there is controlled temperature and a low noise level, plus a minimum of distractions.
ENVIRONMENTAL CONDITIONS
The following work environment characteristics described here are representative of those an employee encounters while performing 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.
PHYSICAL ACTIVITIES
The following physical activities described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions and expectations.
Semi-repetitive, low physical. Semi-repetitive type work which requires periods of concentration for varied time cycles as prescribed by the tasks.
While performing the functions of this job, the employee is continuously required to use hands to finger, handle, or feel, talk or hear; regularly required to sit, reach with hands and arms; occasionally required to walk. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision.
ADDITIONAL INFORMATION
-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)