26 days old

IT Data Warehouse Analyst

Crescent Bank & Trust, Inc
Carrollton, TX 75006
  • Job Code

Crescent Bank is looking for a talented professional to fill an open position as a Data Warehouse Developer. The Data Warehouse Developer will be responsible for developing, implementing and maintaining data warehouses using the Microsoft SQL Server Data Tools and SQL Toolsets in both on-premise and cloud configurations. This will include developing and maintaining SSIS packages, SSAS Tabular models, Power BI and SSRS reports as well as TSQL in Stored Procedures and Functions. This position requires excellent communication and technical skills.

Company Profile:

Crescent Bank is a privately owned, state chartered, FDIC insured commercial bank. We have been in business for over 25 years and are located in over 20 states. While our primary business is providing auto loans to those who have a hard time securing a loan, we also provide a variety of personal and business banking services throughout Louisiana. We strive for employee advancement and growth. We offer a wide variety of benefits. Unlike your average bankers, we actually have fun.

  • Paid Vacation, Personal, Holiday, Bereavement, and Jury Duty

  • Medical, Dental, and Vision Insurance

  • AD&D and Multiple Life Insurances

  • Long and Short Term Disability Insurance

  • Flexible Spending Accounts (Medical and Dependent)

  • Wellness Programs

  • 401(k) with Company Match

  • Tuition Reimbursement

  • Free No Fee Savings and Checking Accounts

Essential Duties and Responsibilities:

  • Develop and maintain existing SSIS packages for data integration.

  • Develop and maintain SSAS Tabular models to meet business needs

  • Develop and maintain job execution plans with ActiveBatch Enterprise Job Scheduler

  • Monitor job queues to ensure they are functioning as expected

  • Provide business users the data required for metrics and analysis

  • Develop and maintain PowerBI/SSRS reports to meet business needs

  • Performance tune T-SQL queries using profiling tools and execution plans

  • Provide application technical support for all enterprise business applications, reporting and analytics

  • Position requires exposure to highly sensitive customer information

  • After hours on call availability required

Position Requirements:

  • Bachelors Degree in Computer Science, Information Systems or other technical field desired

  • 5+ years of SQL Server development experience

  • SQL Server Integration Services development experience

  • SQL Server Reporting Services & PowerBI development and portal maintenance experience

  • SQL Server Analysis Services development experience

  • Azure Cloud experience

  • Demonstrated proficiency with current releases of Microsoft SQL Server developing T-SQL, Stored Procedures, Views, Tables and Indexes

  • Ability to collaborate effectively with business users to translate business requirements into technical Requirements

  • Excellent documentation, analytical and problem solving skills

  • Experience with Collection industry technologies a plus

  • Continuous Integration experience also a plus

  • Experience with R, Python and Machine Learning also a plus

Equal Opportunity Employer/Veterans/Disabled

Posted: 2021-02-08 Expires: 2021-03-09
Sponsored by:
ADP Logo
Sponsored by:
Bank of America Logo

Featured Jobs[ View All ]

Featured Employers

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

IT Data Warehouse Analyst

Crescent Bank & Trust, Inc
Carrollton, TX 75006

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast