Datawarehouse Developer IV in Chicago, IL
Job Description: 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. SAP/ERP Master data/Meta data is a required skill. Candidates must currently be in the Chicago area now. There will only be face-to-face interviews. There will be some travel to Plano. Role: This role supports the accountabilities of the DMO 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 Client Program Meta Data Repository (MDR) This position reports to the DMO Data Quality team lead, and will work closely with the DMO Governance team, project release teams and process teams, as well as 3rd party development consultants that make up the DMO Data Quality Team The DMO Data Quality Senior Developer Lead position requires strong business skills and would be responsible for reviewing, analysing and building/modifying applications including script build, coding, testing, debugging and installing patches/enhancements to support DMO applications and environment The position requires at least 7 years of experience in the field or in a related area. You must have expert knowledge of relational databases, metadata governance, Web and Client Server concepts, and be able to rely on experience and judgment to plan and accomplish goals. 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 DMO applications Manage gathering of business requirements to support build of DMO 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 DMO 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: .NET C# Excel SQL Server T-SQL Desired: Required Qualifications: Role Requirements: 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 Background in Microsoft .NET, C#, Java, T-SQL, PL/SQL, Excel 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 DMO team, cross-functional teams, and management to establish best practices and win-win solutions Strong interpersonal skills, including excellent oral, written and listening skills To Apply to this job go to http://www.GadBall.com or click here