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.

Responsibilities

• Performs data collection, analysis, validation and reporting
• Designs, tests, and documents processes, SQL queries, and stored procedures
• Extracts and analyzes data from various sources, including databases, manual files, and external websites
• Responds to data inquiries from various groups within an organization
• Creates and publishes regularly scheduled and ad hoc reports
• Documents reporting and dashboard requirements and processes, and validates data components, as required
• Interpret data, analyze results using statistical techniques, and provide ongoing reports
• Acquire data from primary or secondary data sources and maintain databases/data systems
• Filter and clean data by reviewing computer reports and performance indicators to locate and correct tracking issues
• Identify, analyze, and interpret trends or patterns in complex data sets

• Locate and define new process improvement opportunities

Skills

• 5 years of experience conducting data analysis, and having experience with relational databases and knowledge of query tools and/or statistical software
• Proven working experience with data analytics or digital marketing data
• Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy
• Technical expertise regarding data models, database design, data mining, and statistical techniques
• Strong knowledge of and experience with reporting/data visualization tools (Tableau, Power BI etc), databases (MySQL etc), and statistical packages (R, STATA, SPSS etc)
• Experience with or strong desire to learn enterprise data systems and tools such as Snowflake, Databricks, dbt, Workato, Fivetran, etc.
• Bachelor's degree required. Preference for background in mathematics or social sciences
• Strong preference for candidates that can learn on the job and integrate with new systems

• Strong analytical and organizational skills also essential

• Negotiation and conflict management skills
• Influencing skills and respect within the organization
• Ability to manage multiple tasks in a fast-paced environment
• Proficiency in use of Microsoft products: Word, Project, Excel, PowerPoint, and Outlook (must have 2 years’ experience using MS Project or equivalent)

*M&S Consulting, as well as its subsidiaries 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 Disabled Veteran, Recently Separated Veteran, Active Duty Wartime or Campaign Badge Veteran, Armed Forces Services Medal, or any other characteristic protected by law.