Job Description :
Job Description: Dean Foods is looking to add an exceptional contributor to the Data & Analytics team who will help implement centralized master data. This team is responsible for managing master data applications and we are constantly looking for opportunities to improve the internal customer experience through consistent and scalable data management solution. This is exciting time to join a fun and dynamic team at the Dean Foods that is largest dairy providers and a trusted source of goodness for millions of families. The Data Engineer, Master Data will report in to the Senior Manager of Data & Analytics within Information Technology, Data & Analytics team (D&A)
Responsibilities
Join existing project building and supporting master data repositories and enterprise database.
Perform analysis, data profiling, development, and integration of disparate systems throughout all phases of the project life cycle.
Develop extensions and customizations to the services tier of MDM.
Supporting requirement analysis, system analysis, design, development, testing, implementation.
Develop data models which supports data enrichment and extendibility
Perform automation and optimization work on new and existing models.
Provide MDM development support and detailed technical knowledge of MDM products.
Analyzes and defines detailed MDM processes, tasks, data flows, and dependencies.
Provide technical knowledge of ETL and create integration solutions.
Produces detailed MDM technical design specifications
Work with data and information architects to choose a reference architecture or data integration style to meet individual project needs.
Play a key role in information governance, contribute to development guidelines.
Assist in defining technical best practices for data movement, data quality, data cleansing and other ETL related activities.
Work with Data Management Analyst to ensure proper documentation and definitions are incorporated into the Enterprise Data Dictionary.
Required Skills
Ability to work with limited oversight
Provide professional consulting service

Technical Skill / Certification / Education Requirements: Desired Development Skills
Visual Studio, C#, .NET, Windows Communication Framework (WCF)
IIS, ASP.NET, CNET, SharePoint Development
Visual Studio, CNET, Windows Workflow Foundation 4.5, AppFabric, IIS, WCF
ETL experience (Informatica, Integration Services, etc
Data warehouse experience, or experience with at least 1 multidimensional OLAP tool
Required Development Skills
Enterprise data management, integration, analytical, and data quality skills.
Hands-on experience with MDM configurations - Data modeling & Data Mappings (Landing, staging and Base Objects), Data validation, Match and Merge rules, writing and customizing user exits.
Solution development for MDM system with deep expertise on all aspects of (Microsoft Master Data Services (MDS), Profisee Master Data Maestro (preferred), etc MDM implementation options.
Profisee 6.x, preferably 7.x
Understanding of SOA, Data Integration, Data Quality, Data Architecture and MDM, project life cycle phases, best practices and processes.
Participated in and led the requirement gathering/solution architecture for MDM initiatives.
Experience in integrating external business application with MDM using batch processes, services, API, and message queues a significant advantage.
T-SQL Development skills including developing stored procedures and ETL processes.
Extensive experience in MS SQL Server, SSIS, SSAS, SSRS and comparable data management tools.
Experience with lifecycle management – developing, testing, documenting, implementing, automating, and maintaining system changes.
Proficiency in Microsoft Excel, Visio and PowerPoint.
Familiarity with Lean Software Development and Agile methodologies.

Competency / Soft Skill Requirements: • Demonstrated ability to quickly learn new systems.
Excellent analytical and technical skills with high attention to detail: demonstrated strength in problem-solving.
Excellent verbal, written and interpersonal communication skills.
Demonstrated strong customer focus.
Strong organizational skills with the ability to manage multiple projects and analysis.