Data Warehouse/Business Intelligence Developer

Clifton Park, NY

Share This Job

Job Description



Let’s Work Together


Data Warehouse/Business Intelligence Developer

This position is based in Clifton Park, NY

At nfrastructure, we understand that our success results from our diverse workforce. In every nfrastructure office, you will find challenging projects and smart people with the potential to wow our customers. nfrastructure team members relish the freedom and support they receive to help our customers solve their most challenging problems and create the next generation of dynamic infrastructure solutions in an environment designed to foster collaboration, creativity, excitement and success.

The area: Consulting Services

The Consulting Services department engages itself directly with customers in order to best assess organizational needs. Members of Consulting Services are responsible for finding relevant solutions and providing advice based on industry experience.

The role: Data Warehouse/Business Intelligence Developer
As Data Warehouse/Business Intelligence Developer, you will act independently to assist in formulating system scope and objectives, with a focus on overall Business Intelligence (BI) architecture. You will prepare detailed technical specifications from which programs will be written. The Data Warehouse/Business Intelligence Developer will design, code, test, debug and document the Business Intelligence solutions. This role is a top-level technical contributor in the Business Intelligence team. You will be responsible for understanding, applying and leveraging both knowledge of BI and ETL technologies and knowledge of relevant business processes.


  • Analyze, design and develop Business Intelligence technical solutions leveraging off the shelf technologies such as OBIEE, Informatica, and similar tools
  • Participate in the full development lifecycle within the reporting framework, from developing business intelligence requirements to QA and production deployment
  • Adhere to best Data Warehouse practices when modeling Business Intelligence solutions
  • Design STAR Schema Data Warehouse Models using Facts and Dimensions
  • Communicate both functional and technical designs and changes to all appropriate agents
  • Collaborate with and mentor current development staff in the use of Business Intelligence (OBIEE), Informatica, and Oracle coding language based on numerous prior development activities in these environments
  • Test and review personal development work as well as the work of team members
  • Utilize prior knowledge of related tools and obtain knowledge of other technologies  in support of the organization projects



  • Bachelor’s degree and 3-5 years of programming experience with OBIEE Suite 10g, 11g or equivalent combination of education and experience
  • Extensive RPD Design and Development experience.
  • Complete working knowledge of OBIEE user, object and data security and caching capabilities.


  •  Extensive experience in the professional utilization of Oracle databases and web development tools specifically 10.x and 11.x
  • Experience in all aspects of OBIEE including analysis, design, development, configuration, customization, validation and deployment.
  • Experience in security and server administration.
  • Certification, training, or proven knowledge in Business Intelligence (BI)
  • Strong Knowledge in Dimensional Data Modeling, Data Warehouse and BI concepts.
  • Expertise in Oracle (10g/11g) and other relational databases.
  • Experience in data analysis, data profiling and validation.
  • Superior analytic and troubleshooting skills
  • Proven experience creating innovative solutions with a superior technical approach that drives business strategies

About nfrastructure:
nfrastructure helps large enterprises design, build and operate mission-critical technology infrastructure. Combining proven methods and tools, world-class engineering talent, on-site technical service in every major North American market and tightly integrated low cost remote support, nfrastructure collaborates with customers to deliver sustainable disruptive value. With industry practices in public sector, financial services, retail, healthcare, technology, communications, public safety and energy, nfrastructure works with leading technology hardware and software vendors to provide comprehensive data center, network, security, unified communications, end-point, structured cabling, staffing and outsourcing solutions.

 More information about nfrastructure can be found at

Apply for this job or another online today at

nfrastructure is proud to be an equal opportunity employer; women and minorities are encouraged to apply for positions.