Database Developer

Job Description

Database Developer

NBI, an established leader in the development of professional continuing education seminars across the U.S., is looking for an experienced Database Developer to join our Information Technology department who:

  • Believes in the value of data driven decision-making and is interested in machine learning, predictive analytics and data warehousing
  • Enjoys learning the story behind the data to provide to best solutions for business stakeholders
  • Is skilled at creating star schema structures, data models and BI solutions
  • Enjoys problem solving and identifying solutions
  • Prefers to be challenged and is comfortable working in an environment of change
  • Feels a personal responsibility for delivery of  quality product to end users

Job Responsibilities

Reporting to the IT supervisor you will be responsible for:

  • Providing support to the organization’s business requirements in the application and consumption of information from the Data Warehouse
  • Work with a wide variety of end users to help understand and refine their needs for business intelligence data and reporting tools.
  • In collaboration with business and technology stakeholders, create star schema data models, perform ETLs, build reports and validate results
  • Designing, developing, and supporting new and current ETL processes employing industry standards and best practices to enhance loading of data from and into different source/target systems.
  • Designing, implementing and maintaining SQL Server Analysis Services multi-dimensional cubes
  • Developing automated data audit and validation process to ensure end users are getting the right data
  • Supporting implemented BI solutions by: monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance, communicating functional and technical issues and ensuring that the data warehouse is tuned for optimal performance
  • Participate in project planning to analyze business requirements and outline solutions

Job Requirements

  • Bachelor's in Computer Science, Information Systems, a related field or equivalent work experience
  • 4+ years of experience in information technology, data management, and database development
  • 2+ years of writing complex SQL queries
  • 2+ years of data/dimensional modeling and data warehouse implementation experience
  • 2+ years of ETL building using SSIS or other data integration tools
  • 2+ years of data model development and support using SSAS or similar platform
  • 2+ years of report building using SSRS or similar tool.

 

Preferred Knowledge

 Deep knowledge of the SQL Server environment including SSMS, SSIS, SSAS, SSRS

  • Experience working in the SQL Server BI universe by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries
  • Experience with TFS or other source code management systems

 

 

 

 

This website uses cookies to ensure you get the best experience. We use this information in order to improve and customize your browsing experience, in addition to improving our internal analytics and metrics about our visitors. To find out more about the cookies we use, please see our Cookie Policy.