Business Intelligence Developer

Information Technology


The Business Intelligence (BI) Department is responsible for deploying tools to support self-service data retrieval by business unit analysts as well as developing advanced reporting, analysis and process automation, all utilizing the Microsoft BI stack and technologies. The BI Developer supports the department and company by maintaining and improving BI tools and processes that consolidate information from over a dozen independent IT systems and applications as well as developing and supporting new processes and data in a business that always strives to move forward.


The ideal candidate will have a minimum of five years of experience as a SQL Server BI stack, with at least four years focused on SQL Server. They will be comfortable in a dynamic environment with ample opportunity to implement cutting-edge technology. Strong, proven communication skills with business stakeholders is a requirement for success in this position as translating business users’ needs into BI system implementations is the core of our mission within the company.


  • Develop and support the SQL Server BI universe by creating tables, indexes, views, indexed views, functions, triggers, stored procedures, and tuning complex T-SQL queries
  • Design and implement SQL Server 2008 R2/SQL Server 2012 Analysis Services multi-dimensional cubes
  • Automation via scripting tools such as PowerShell (in addition to T-SQL)
  • Create and support data load processes via SSIS and database refreshes
  • Identify inefficiencies and gaps in current BI process and reporting solutions
  • Package queries into stored procedures and jobs for scheduling
  • Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications
  • Develop automated data audit and validation process to ensure end users are getting the right data
  • Experience with full implementation of SDLC
  • Participate in project planning to analyze business requirements and outline solutions
  • Participate in documenting all ETL processes and flows
  • Leads small to medium technical projects for organization projects across platforms or business areas
  • Create and update business intelligence documentation


  • Bachelor's degree in Computer Science or Information Science or related field with a minimum of 5 years of experience
  • Experience and proficiency in Microsoft SQL Server 2005/ 2008 R2/2012 and all its products and features, such as SSIS, SSAS, SSRS and Replication
  • Good knowledge of BI Methodology and best practices
  • Excellent communication skills to be able to work with business owners to develop and define key business questions and to build data sets that answer those questions
  • High-level development skills and experience with T-SQL, SSIS, SSAS  PowerShell scripting and performance tuning
  • Ability to read, analyze, interpret, and prepare technical documents
  • Ability to design systems and applications based on analysts of business unit requirements
  • A strong interest in business or financial reporting and automation
  • Must enjoy learning new technologies and meet new challenges with enthusiasm





Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed