Sr. Specialist - Business Intelligence

Position Title:Sr. Specialist- Business Intelligence

Reporting Manager: Director- Insights & Analytics

• Integration Services ETL (Extract, Transform, Load): Responsible for design, testing, and implementation of ETL processes for delivering data extracts and final data reports as well as loading fact and dimension tables in the data warehouse. Monitors integration services database to determine job status, troubleshoot, and resolve any issues that occur while running ETL jobs. Responsible for Data Warehouse Star Schema design.

• Reporting Services: Develop and deploy reports to the self-service portal. Maintain folder level security based on active directory groups. High level summary and self-service reporting and dashboards. Reporting against, multiple data warehouses, source systems (SQL Server and Oracle), and SSAS database in multidimensional mode and Power BI mode.

• Business Requirements Documentation: Responsible for ticketing system report requests with detail from all the various data sources, requirements, and time estimates. Maintain DBA Tools database with reports and extract information as well as Integration Services packages. Work with project management teams for documentation details. Technical report documentation of data extracts, automation processes, and data analytics. Prepare strategies and provide business solutions as per requirements.

• Analysis Services: Design and implement multidimensional mode database and Power BI mode data model including stand alone and through SharePoint.

• Completes all mandatory compliance testing within designated time frame and other compliance assignments including Office of Foreign Assets Control (OFAC), Unusual Activity Reports (UAR), and Security processes.

• Vendor Management: Ability to manage vendor relationship and monitor performance to service level agreements.

• Implements processes as required by the Bank Secrecy Act and TDECU policies and procedures including but not limited to completing and submitting Currency Transaction Reports, being knowledgeable of signs of unusual financial activities, and reporting signs of unusual activity and/or completing reporting for Suspicious Activity Report as appropriate per procedure.
• Administer projects, prepare updates, and implement all phases for the project to achieve all project objectives.
• Stays abreast of changes within the credit union relating to services and procedures.

Minimum Qualifications:
Education: Bachelor's degree required or equivalent years of experience.
Experience: A minimum of 5 years experience in integration services, reporting services, business documentation, and T-SQL systems. A minimum of 3 years experience in Analysis Services. Experience in a financial institution preferred

Knowledge, Skills, and Abilities:
Competent with MS Office (Word, Excel, PowerPoint, Access, Visio)
Working knowledge of Microsoft Business Intelligence stack (Integration Services, Reporting Services, and Analysis Services)

C# knowledge for SSIS scripting
In depth knowledge of SISS and its capabilities.
Knowledge of T-SQL and ANSI SQL stored procedures with multiple parameters.
Ability to perform business analysis and documentation.
Experience in Team Foundation Server or other source control system.
Ability to do data integrity and validation; and manage multiple priorities simultaneously.
Excellent written and oral communication skills to Identifies, researches, and resolves the technical problems.

Ability to work both independently and within teams.

Physical Demands and Work Environment:
(The physical demands and work environment characteristics described herein are representative of those that must be met by an employee to successfully perform essential functions of this position and/or may be encountered while performing essential functions. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.)
While performing the essential duties of this position, an employee would frequently be required to stand, walk, and sit. An employee must frequently lift and/or move up to 10 pounds and may occasionally lift and/or move up to 25 pounds to perform essential position functions.
Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually moderate.

Disclaimer: The above statements are intended to describe the general nature and level of work being performed by people assigned to this job. They are not intended to be an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

Texas Dow Employees Credit Union is an equal opportunity employer, dedicated to a policy of non-discrimination in employment on any basis including race, color, age, protected veteran status, sex, religion, disability, genetic information, national origin or other status protected by federal, state or local law. Consistent with the American Disabilities