Datawarehouse Developer in Chicago, IL
DESCRIPTION The Data Warehouse Developer will have a minimum 6 - 8 years experience in Data Warehousing with general knowledge and understanding of all components of a warehousing architecture, Extensive experience with multiple enterprise Database suits. Requires proficiency in: dimensional data warehousing concepts (Star schema, Snowflake schema), The DW developer will need to create and define data transfer logic to migrate data from the ODS to the warehouse environment to support reporting and query needs. This role supports the accountabilities of the Data Quality Team in the development and delivery of enterprise data tools and applications to support project and production data reports and analytic models as it relates to the delivery of the Project One Up Meta Data Repository (MDR) . This position reports to the Data Quality team lead, and will work closely with the Governance team, project release teams and process teams, as well as 3rd party development consultants that make up the Data Quality Team. Key Role Accountabilities: - Build and coordinate application architecture to support business/analytical requirements to ensure data quality - Analyze data contained in source/target databases and identify cross-system data integrity issues and identify business rules to build applicable queries and processes - Produce technical procedures and documentation for the applications including operations, user guide, training materials, etc - Understand technical issues and identify architecture and code modifications needed to support changing user requirements for multiple applications - Manage gathering of business requirements to support build of applications - Provides assistance and advice to business users in the effective use of applications and information systems - Responsible for the management and strategy of maintaining application environment; ensuring environment structure meets best practice - Build out data entry screens and reporting functionality for Meta Data Repository using industry best practices Required Qualifications - Minimum of 7 years of technology experience with at least 5 years development/hands-on technical roles in the field and relies on experience and judgment to plan and accomplish goals - Knowledge of data architecture and data integration processes using multiple vendor specific packages - Experience working with Master Data in SAP - Technical experience with database technologies, database programming, Web application development, and user support - Strong background in Database architecture and administration using Microsoft SQL Server 2005 or equivalent - 2+ years background in Microsoft .NET, C#, Java, T-SQL, PL/SQL, Excel. There will be development in T-SQL & PL/SQL so they have to have this experience - Proven Project Management experience through the entire SDLC - Strong analytical and problem solving skills - Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities - Proven ability to be flexible and work hard, both independently and in a team environment, in a high pressure on-call environment with changing priorities - Acceptance and willingness to work outside of normal business hours - Results oriented individual who thrives working in a fast paced environment - Exhibit a strong 'can-do', 'will-do' attitude and strong sense of urgency in meeting deadlines - Assist in establishing and maintaining a strong relationship with business partners and manage expectations - Deliver presentations to a variety of audience levels, gaining experience through leading meetings and preparing and giving group presentations - Consistently follows problems to a timely resolution and appropriately escalates issues to appropriate level - Adjusts work assignments and schedule to meet changing priorities for self and others; adjusts to multiple demands/priorities focusing on the big picture - Demonstrates 'out of the box' thinking when confronted with new ideas or change. Identifies opportunities, analyzes issues, designs solutions and integrates best practices for multifunctional areas - Work collaboratively within Fteam, cross-functional teams, and management to establish best practices and win-win solutions - Strong interpersonal skills, including excellent oral, written and listening skills SKILLS C#, Excel, SQL Server, T-SQL Synectics offers competitive salaries and a full suite of benefits. EOE. To Apply to this job go to http://www.GadBall.com or click here