Currently we are having following opportunity with one of our client:
Title:SQL Database Developer
Location:Williston, VT, USA
BS Computer Science or a related field
Minimum 3+ years of hands-on experience with MS SQL of various versions, predominantly SQL 2008. Experience with Microsoft database architecture and technologies; indices, stored procedures, replication, performance tuning.
Experience with ETL process and technologies used to realize an enterprise level data warehousing solution; SSIS, SSAS, SSRS, etc.
Business Objects Development experience including developing BO universes, reports, dashboards and scorecards. Experience with Web Intelligence.
Experience in design/development of data marts and data Warehouses for supporting marketing and sales systems
Experience requiring in-depth knowledge of data cleansing/data quality and consumer data integration practices
Knowledge of database architecture, design and implementation. Ideally, in Consumer Packaged Goods, Branded Goods or Grocery/Retail Industry
Ability to construct architectural deliverables related to data architecture (data structure diagrams, data/information models, process models, etc.). Must be able to clearly document technical specifications
Strong problem-solving and analytical skills.
Able to multi-task and manage multiple project/task assignments simultaneously
Strong written and verbal communication skills with ability to facilitate change
MS Certified SQL Developer a plus
Essential Duties and Responsibilities-
Design and develop marketing business applications using SQL, database utilities, ETL tools and business intelligence systems.
Activities also include troubleshooting and optimizing SQL Stored procedures and supporting data transfers/extracts leveraging using ETL technologies (SSIS).
Participate in data modeling design, customer data integration and marketing data architecture design to support consumer database marketing development initiatives.
Develop and support load and extract scripts and technical processes to manage GMCR consumer strategy level data assets
Create reports, universes, dashboards and scorecards using Business Objects tools including drill, hierarchy navigation and customizations as per specifications.
Design and develop Business intelligence queries and scripts using SQL for our data analytic practices.
Perform general database administrative tasks to include the design and development of new schemas, security management, and creation of scripts to automate tasks across development, test and production systems.
Support analytical development and application of propensity models to our data warehouse systems
Support our cross business unit data integration through new and existing data marts/data warehouses.
Participate in the development of enterprise data policies that outline the appropriate data ownership, stewardship and audit requirements, as well as service-level agreements, that must be established and maintained to guide the appropriate use of information in business and IT processes.
Highly motivated self-starter, detail and quality oriented and able to work independently.
Send the updated resume to firstname.lastname@example.org