Senior Business Intelligence Analyst

Senior Business Intelligence Analyst

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 include :

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