Data Engineer IV

Description Summary: The Data Engineer IV/Data Architect position is responsible to help oversee, design, and maintain a fully operational Enterprise Data Platform and set of products.  This position is instrumental in the design and implementation of SQL databases and solutions to support M3’s new and existing applications and systems; troubleshoot database, performance and server problems; design and write T-SQL queries, store procedures, indexes, and reports; promote and assist in implementation of SQL best practices across departments; ensure stability, reliability and performance of SQL systems in M3’s technical ecosystem.

Essential Duties:

The duties listed below are the essential functions of this position, and they may change as the needs of the company demand. All associates are expected to do what is necessary to get the work done and to cooperate fully with their supervisor’s requests for additional or altered duties.

• Design and develop high-quality database solutions based on modern data techniques and standards as part of the end-to-end development process of application design including data quality, security, accessibility, and data management.
• Translate business requirements into technical specifications for data streams, integrations, transformations, and databases.
• Define data architecture framework, standards, and principles, including data modeling, data mining, and master data techniques.
• Resolve data architecture-related issues by analyzing business needs and collaborating with internal stakeholders and technology teams.
• Define reference architecture and data flows, coordinating with multiple departments, stakeholders, and partners.
• Collaborate with data engineers and developers to visualize and build enterprise level data frameworks and collections.
• Analyze current business data needs and identify opportunities for leveraging Microsoft Azure Data and Analytics services. 
• Assist in installation and configuration of new SQL Servers and Services in on-premise and Azure.
• Review and document all changes made to the database environment.
• Working knowledge of SSIS Packages and Integration Services.
• Promote collaboration within team and across functional teams and business units.
• Experience with Machine Learning and Predictive Analytics optional.
• Other duties as assigned. 

Education/Training/Experience:

• 5-10 years of experience in a Senior Data Engineer or Data Architect position.
• Bachelor’s Degree in IT, MIS or Computer Science highly preferred, or an equivalent combination of education and experience.
• 5 Years of experience handling troubleshooting with SQL Server, Azure SQL Server, Azure Data Lakes and transforming SQL workloads.
• Must have knowledge of a variety of computer software applications in word processing, spreadsheets, database, and presentation software (MSWord, Excel, Access, PowerPoint).
• Specific certifications and training specific to SQL Server Management and Design, Cloud-centric data architecture, and modern data security concepts desired.
• Must have strong written and verbal skills in English and ability to communicate effectively.
• Must be able to build and maintain positive business relationships with co-workers and other business contacts.

Physical Requirements:

• Ability to sit and/or stand for extended periods.
• Ability to perform work on a computer for extended periods.
• Ability to work in the office regularly, or pivot to working at home should emergency situations arise.
• Ability to travel to represent the company’s interests required.
• Ability to attend work per assigned schedule and attend meetings with excellent attendance and punctuality.
• Ability to bend and lift up to 25 lbs.