Data Engineer

M&S (which stands for Management and Solutions) was conceived in 2002 with the vision of creating highly effective teams of elite consultants to deliver strategic process and technology solutions to enterprise organizations across the US. Our commitment to delivery in complex environments and long-term customer success has merged process and technology into innovative solutions, established deep pockets of expertise, and enabled innovative transformation for evolving businesses.

We have intentionally cultivated steady growth focused on being approachable and helpful to our dearly valued clients and closely cared-for employees. M&S people simply “care hard”, and this reflects in our work products, our interactions, and our culture.

Job Description:

Work with stakeholders and the internal development team to guide the technical development of enterprise data solutions. The Data Engineer is a combination of a business and technical customer-facing role that will be accountable for the end-to-end customer data architecture, development, deployment, and support.

Job Responsibilities:

The Data Engineer will be responsible for working with stakeholders to identify opportunities to leverage data to drive business value. In addition they are responsible for mining and analyzing data to drive efficiency and optimization, develop custom data models and algorithms, and develop processes and tools to monitor production systems and data accuracy.

Required Skills:

• Minimum of 1 year of experience designing and implementing a full-scale data warehouse solution based on Snowflake.
• Minimum 3 years experience with Relational Databases (Oracle preferred but not required)
• Very Advanced SQL knowledge
• Agile software development experience
• Experience with Data Warehousing and Dimensional Data Modeling (experience with dbt Cloud Preferred)
• Experience with Data Integration and Pipeline Ingestion Tools such as Fivetran, Talend, or Informatica
• Experience in developing production-ready data ingestion and processing pipelines using Java, Spark, Scala, Python.
• Cloud Experience (AWS or Azure)
• Experience with reporting/data visualization tools (Tableau, Power BI),  databases (Oracle, MySQL etc), and statistical packages (R, STATA, SPSS)
• Bachelor degree or equivalent experience (mathematics or social science preferred)
• Self-starter who can act autonomously as well as thrive in a strong team environment
• Be able to work with, clarify, and find creative solutions for ambiguous and sometimes challenging requests
• Have excellent written and verbal communication skills
• Technical expertise regarding data models, database design, data mining, and statistical techniques
• Be able to effectively and efficiently troubleshoot data issues and bugs

*M&S Consulting proactively fulfills its role as an equal opportunity employer. We do not discriminate against any employee or applicant for employment because of race, color, sex, religion, age, sexual orientation, gender identity and expression, national origin, marital status, physical or mental disability, status as a protected veteran, or any other characteristic protected by law.