Position Description

Developer
Location Headquarters
Apply Now

Data Warehouse Developer

Infinity Sales Group, based in Boca Raton, markets and sells products and services for its Fortune 200 partners.  Using targeted direct response campaigns, both print and online, we get the right offers in front of the right consumers to drive customer acquisition at a high-performance level.  Infinity is searching for an energetic Developer to design, implement, and maintain a new Data Warehouse (DW). The successful candidate will be responsible for all aspects of the DW, focusing on Senior Management business requirements and resulting usage. Will also create data for near real-time dashboard reporting of various KPI’s across the business. This is an exceptional opportunity for a professional who thrives in an entrepreneurial environment and is experienced working closely with senior management.

Responsibilities:

  • Learn, maintain, and transform our existing data to match business needs
  • Design and implement new Data Warehouse infrastructure based on current and future business needs
  • Design and implement ETL processes for the consumption of data from internal and external sources
  • Perform data verification and quality control checks based on business needs to ensure only clean data is stored
  • Plan project timelines and provide regular status updates
  • Collaborate with business and technology stakeholders to ensure data warehouse architecture development and utilization
  • Implement ETL, Report and database change management process
  • Create supporting documentation, such as metadata and diagrams of entity relationships, business processes, and process flow
  • Create plans, test files, and scripts for data warehouse testing, ranging from unit to integration testing
  • Design, implement, test and debug database stored procedures and complex queries to extract, calculate or manipulate information
  • Manage SQL Server along with SQL Server Replication Services
  • Perform monitoring, tuning and performance analytics on new and existing database systems
  • Design and extend data marts, meta data, and data models
  • Communicate issues and resolutions to senior management
  • Other functions and special projects as assigned

 

 

Qualifications & Skills:

  • Bachelor’s degree in Computer Science or related field
  • Proven experience with building a successful data warehouse preferred
  • Minimum 5 years database development experience with excellent knowledge of SQL Server
  • Excellent computer skills and high proficiency in T-SQL
  • Strong interpersonal and communication skills
  • Attention to detail, accuracy and thoroughness is essential
  • Self-motivated and self-directed
  • Knowledge of BI tools and SSAS is a plus
  • Ability to create dashboards is a plus