First Community Bank
  • 24-Dec-2019 to 31-Jan-2020 (EST)
  • Business Intelligence & Analytics (Corporate Center - Bluefield VA)
  • Bluefield, VA, USA
  • Salary
  • Full Time

Medical, Dental, Vision, Life Insurance, 401(k)


At First Community Bank, we are committed to making our community, the places where we live and work, a better place each day. With a true focus on "community banking," employees find that they can make an impact through company-sponsored programs such as paid volunteer time, matching gifts for charitable contributions and team participation in charitable events. Through a comprehensive wellness program, employees and their families challenge themselves to healthier lifestyles and receive the necessary motivation and tools. With over 40 locations in four states, First Community Bank offers competitive benefits and the personal service you would expect from a company that knows your community. We welcome all applicants and look forward to new colleagues joining our community!

 

Duties:

The Data Warehouse Developer is responsible for designing and delivering data models used for organizational business intelligence and analysis. Other responsibilities include designing database objects to meet ongoing enterprise and departmental business intelligence and data warehousing solutions. Design, develop, and test dimensional data models using Star and Snowflake schema methodologies under the Kimball method. Design, develop and maintain OLAP cubes using SSAS. Design, build, test and execute ETL packages using SSIS. Perform extensive data analysis of source transaction systems and create complex queries using T-SQL.

 

Qualifications:

Bachelor's degree in Computer Science or related discipline or equivalent experience.

Three years of experience in Microsoft stack (SQL Server, SSIS, SSMS, SSAS).

Highly skilled in SSMS and SSIS.

Experience in Visual Studio to connect to Analysis Services and creating and managing cubes.

Experience in writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.

Self-starter with initiative to search for solutions to problems.

Understand different data models such as normalized, de-normalized, star, and snowflake.

Attentive to detail and accuracy.

First Community Bank
  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Share This Page
.