Data Warehouse/Business Intelligence Developer

NEST - Gloucester City, NJ3.4

Full-timeEstimated: $110,000 - $130,000 a year

Do you want to use your hands-on technical skills, lovefor data and strong desire to learn the business to own and drive an analyticstransformation?

Every day within NEST, amazing ideas are born and quicklybecome solutions to address our biggest challenges. We consider our ability to make decisions and easilypivot one of best attributes. NEST is aprivately owned 25-year-old company that is experiencing rapid growth andbuilding a team of technology savvy self-starters who want to innovate in acreative environment. At our core, NESTis a company built on data. This datahelps us provide the most competitive pricing in the Facility Management Servicesindustry and our vision is to begin to use Artificial Intelligence to predictivelyidentify business opportunities for both NEST and our clients.

The Data Warehouse/Business Intelligence Developer will beresponsible to develop, implement, and maintain the Data Warehouse and BusinessIntelligence systems and programs that enable NEST, and our Clients, to performat the highest level. He or she will workclosely with Financial Business Analysts, Business Users, the Facilitate ProductTeam and Senior Leaders to solve complex business problems. The ideal candidatehas a strong background in developing and delivering data warehouse andinformation marts to help drive business insights. He or she must have a deep passion for allthings data related and an ability to implement creative and efficientsolutions using the latest technologies and techniques. You will interact dailywith a leadership team that values speed, quality and incremental change as we continueour agile transformational journey.

Essential Functions:

As we grow our culture, mindset and capability, we want youto help us lead this change. Thisposition is responsible for delivering the complete technology solution – whichincludes database, business/logic layer code, information marts and interactivereporting as well as the following functions:

· Apply Agile Software Development Lifecyclemethodology to develop the solutions

· Ensure enterprise data warehouse solutionscreated under his/her responsibility adhere to departmental standards,appropriate controls and audit trails exist, and are thoroughly tested prior toinstallation in production environment

· Identify and document data gaps between currentand future business processes

· Analyze and translate user requirements intotechnical design and development projects

· Design, develop and maintain enterprise datawarehouse and information marts

· Assist Financial Business Analysts and other Engineersin identifying data fields and executing data conversion

· Lead the project team and/or business users inexecution of data validation and quality

· Document issues as they surface and collaboratewith project team and/or business users to resolve identified issues

· Monitor and assist project team and/or business usersin the execution of user acceptance testing

· Provide on-going enterprise data warehousetechnical support and training

· Provide documentation, technical specificationsand infrastructure requirements for each development Project

· Continuously monitor industry trends, standardsand technologies. Research, recommend and apply new technologies as they emerge

· Perform feasibility analysis consideringtechnical, infrastructural, organizational and economic aspects to alternativesolutions

· Perform project management activities includingtask identification, effort and duration estimates, task dependencies andsequencing, critical path analysis, resource assignment and evaluation,conflict and problem resolution

· Design interactive reports and dashboards usingvisualizations that help users quickly identify expectations and/or processesrequiring attention

Required Qualifications of Every Candidate (Education,Experience, Knowledge, Skills and Abilities):

· Preferred Bachelor’s Degree with 3 years+relevant experience

· 2 years of accumulated professional experiencein the following areas:

o Business intelligence and data warehousedevelopment technologies: SQL Server Integration Services (SSIS), SQL Serverand TSQL Procedures

o Database development experience: SQL Server

o Dimensional data modeling design andimplementation

o Data warehouse monitoring, analysis andperformance tuning

· Ability and desire to learn the business processsupported by IT

· Customer service mindset

· Strong interpersonal communication and trainingskillsets

· Ability to work independently and as part of ateam

· Project management and problem-solving skillsets

· Ability to provide examples of work

Highly Qualified Candidates Will Also Possess TheseQualifications:

· Bachelor’s degree in Computer Science, MIS or Engineering

· Experience working with visualization tools suchas PowerBi or Tableau

· Experience working with Machine Learning Tools

· Experience working in an Agile environment

· Experience working with Data Warehouseautomation tools

· Strong history of delivering value addedsolutions to business users

· Experience with Microsoft SQL Server ReportingServices(SSRS)

· Experience with Microsoft SQL Server AnalysisServices(SSAS)


· Data Analytics

· Problem Solving

· Project Management

· Business Intelligence (BI)

· Analytics

· Integration

· SQL Server Integration Services (SSIS)

· PowerBi / Tableau

· Enterprise Data Management/Architecture

NEST is an EEO Employer

Job Type: Full-time


  • relevant: 2 years (Preferred)

Additional Compensation:

  • Bonuses

Work Location:

  • One location


  • Health insurance
  • Dental insurance
  • Vision insurance
  • Retirement plan
  • Paid time off
  • Professional development assistance
  • Tuition reimbursement

This Company Describes Its Culture as:

  • Detail-oriented -- quality and precision-focused
  • Aggressive -- competitive and growth-oriented
  • Innovative -- innovative and risk-taking
  • Outcome-oriented -- results-focused with strong performance culture
  • Stable -- traditional, stable, strong processes
  • People-oriented -- supportive and fairness-focused
  • Team-oriented -- cooperative and collaborative


  • Monday to Friday