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.
Responsibilities:
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