TDECU · 3 days ago

Sr. Specialist - Business Intelligence

Sugar Land, TX

Full-time

Onsite

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Auto InsuranceBanking

Insider Connection @TDECU

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Integration servicesReporting servicesBusiness documentationT-sql systemsAnalysis servicesFinancial institution experienceMs officeMicrosoft business intelligence stackC# knowledgeSsis scripting-depth knowledgeT-sqlAnsi sqlStored proceduresBusiness analysisTeam foundation serverSource control systemData integrityData validationProblem-solvingCommunicationTeamwork