Lead Data Engineer (R-14415)

Why We Work at Dun & BradstreetDun & Bradstreet unlocks the power of data through analytics, creating a better tomorrow. Each day, we are finding new ways to strengthen our award-winning culture and accelerate creativity, innovation and growth. Our 6,000+ global team members are passionate about what we do. We are dedicated to helping clients turn uncertainty into confidence, risk into opportunity and potential into prosperity. Bold and diverse thinkers are always welcome. Come join us!
Position Overview:The Lead Data Engineer at D&B plays a key role in building the next generation Financial Data warehouse in the Finance space. The position of requires the ideal candidate to be passionate about building next generation extremely large, scalable and fast distributed systems on Microsoft BI stack. 

What You'll Do:

• Designing and developing ETL processes, including data quality and testing, based on the latest enterprise data technologies, including big data, linked data, graph databases, and data virtualization.
• Designing and developing no-SQL and SQL server infrastructure and analytical data stores for enterprise data warehouse integration as well as engineering complex data systems software and data warehouse infrastructure and implementing innovative data processing and integration technologies and database management strategies, to deliver data solutions that are integral to D&B’s proprietary business information service products.
• Interface with stakeholders, gathering requirements relying upon the candidate’s understanding of the business processes as it related to Sales and Revenue recognition, and delivering complete reporting solutions. 
• Defining data capture methodologies and technical requirements for the data warehouse; model data and metadata to build and deliver high quality datasets to support business analysis and customer reporting needs.
• Developing new robust and scalable analytical data stores and pipelines by applying ETL techniques to handle a large volume of data and assisting and executing the development, implementation and administration of technical processes, policies and procedures to ensure database security and integrity.
• Reviewing deliverables throughout data warehouse and data store development to ensure quality of technical requirements and adherence to all quality management plans and standards; and to ensure that database design fulfills functional and technical requirements.

Requirements (Must Have):

• Ideal candidate will have 5+ years of SQL server development and/or NoSQL technology experience.
• Advanced proficiency in TSQL, data modelling, query design, ETL Development, stored procedures, performance troubleshooting and optimization, OLTP and data warehousing fundamentals and principles.
• 5+ years of industry extensive experience in building/operating highly available, distributed systems of data extraction, ingestion, and processing of large data sets using SQL Server.
• Good understanding of relational database design, SQL Server internals and NoSQL.
• Experience using Team Foundation Server (TFS), SQL Server Integration Services (SSIS) and SQL Server Business Intelligence Development Studio and business intelligence tools (SAS, Tableau, Business Objects).
• Proficiency in Python/R for building statistical models and/or data mining algorithms and practical experience of applying these to business problems.
• Bachelor's degree in computer science, engineering, mathematics, or a related technical discipline, or equivalent experience required.
• Proven track record of successful communication of data infrastructure, data models, and data engineering solutions through written communication, including an ability to effectively communicate with both business and technical teams.
• Knowledge of software engineering best practices across the development lifecycle, including agile methodologies, coding standards, code reviews, source management, build processes, testing, and operations.
• Experience working with cloud or on-prem Big Data/MPP analytics platform(i.e. AWS Redshift, AWS S3, Azure Data Warehouse, or similar).

Benefits We Offer· Generous paid time off in your first year, increasing with tenure.· Up to 16 weeks 100% paid parental leave after one year of employment.· Paid sick time to care for yourself or family members. · Education assistance and extensive training resources.· Do Good Program: Paid volunteer days & donation matching.  · Competitive 401k & Employee Stock Purchase Plan with company matching. · Health & wellness benefits, including discounted Gympass membership rates.· Medical, dental & vision insurance for you, spouse/partner & dependents.· Learn more about our benefits: http://bit.ly/41Yyc3d.

Pay TransparencyDun &am