Business Intelligence Application Developer

Business Intelligence Application Developer

by Brian Borsa|October 6, 2009
  • Permanent
  • St. Louis, MO
  • Reference: STLproverbs4



We are seeking a candidate who will be responsible for developing, implementing, and maintaining a Data Warehouse and Decision Support system to support enterprise-wide business systems. The data warehouse strategy will incorporate SQL Server (2005&2008) based business intelligence solutions. This position will play a key role in the selection of additional supporting tools and delivery mechanisms for an effective enterprise decision support deployment. The major responsibilities include participating in the design, development, and support based on information system project needs and the enterprise strategy. This position acts as team lead on some development functions as relating to BI solutions utilizing the entire suite of Microsoft Business Intelligence applications.


Participating in high level design reviews

Supporting development of every aspect of BI development phase

Developing BI applications to enable end users to access and analyze data in data warehouse and data marts

Developing and implementing relational and multidimensional data marts, OLAP reporting, web interfaces, dashboards, and scorecards

Position will require working closely with the user community and developers to participate in project planning discussions and make recommendations for use of technology and development tools.

Analysis of data warehousing needs from a customer perspective, leveraging the information requirements of a variety of functional units.

Prepare and submit detailed requirement analysis and design specifications for the data warehouse implementation projects, including assistance with hardware sizing, cost, and capacity planning. Helping to develop detail design documents for reporting and analysis projects

Interface with IT management team on methodology and tools, ensuring integration with the overall application strategy

Train and mentor other IT team members in data warehousing and decision support system concepts, tools, and support

Provide support for ongoing data warehousing application and database support. Act as data warehouse resource for others on data warehousing and decision support system concepts, tools, administration, and support

Manage data warehouse development, test and production environments. Perform proactive application monitoring. Develop standards and procedures for development and maintenance of these environments to ensure the security, integrity and availability of the corporation's data. Manage client software, transport and connection facilities, and batch scheduling as required to support the data warehouse solution

Vendor Support: Work with vendor representatives in system implementation, problem resolution, enhancement requests, installation, test and implementation of software fixes and upgrades

Adopt Report Strategy to end users to standardize the data delivery from the Data Warehouse

Define Business Areas and reports in the DW for ad-hoc reporting and data security. Ability to reverse engineer relational data models from existing systems, including proprietary and third-party software packages

Ability to analyze current data model and recommend database design to support current and future business and strategic requirements

Knowledge of data warehouse implementation process from business requirements through logical modeling, physical database design, data sourcing, and data transformation

Job Requirements:

The successful candidate will have substantial practical experience in Data Warehouse implementations from both functional/technical perspective and all aspects of the development life cycle.

3-5 years experience with MS SQL
Server Databases (2005 & 2008)

Experience with database design and development

Proficient in SQL statement and analyzing query performance. Strong SQL, PL/SQL skills.

Relational database knowledge

Strong analytical, problem solving and conceptual skills

Experienced in .NET development

Experience with front-end reporting tools for BI (Microsoft Excel, Reporting Services)

Experience with web based portal tools like SharePoint Portal is a definite advantage

Experience with ETL process using Microsoft DTS or Microsoft SSIS

Understanding multidimensional cubes and MDX a major plus

Knowledge of Lotus Notes/Domino , IBM DB2 based solutions, or IBM AS/400 a plus

Solid understanding of relational database and OLAP technologies.

Knowledge in Extraction/Transformation/Loading processes for Data Warehousing.

The ability to multitask and prioritize assignments in a fast paced environment as well as having excellent spoken and written communication skills are essential.

Excellent communication, organization, leadership, time management, and solution skills

Ability to work independently, but be a team player with the ability to identify issues and be proactive in driving solutions.

To apply for this job email your details to brian@cycle3it.com

Choose a style:

Purchase Now!