Data Engineer - Parametric

Morgan Stanley•Seattle, WA

49d•Hybrid

About The Position

The Data Engineer is responsible for the design, structure, and maintenance of data. A data engineer ensures the accuracy and accessibility of data relevant to an organization or a project. In this role the Data Engineer needs to be able to take business requirements and design and architecture end to end that fully supports the business needs. The Data engineer needs to be proficient in writing and optimizing SQL queries. They need to be able to document ideas and proposals which will include creating ER diagrams and architectural documents that document the transformation of data throughout its lifecycle. A successful Data Engineer must possess solid analytical skills and be detail-oriented. This role requires the ability to communicate effectively as part of a larger team within the information technology department. Additionally, you will need to explain complex technical concepts to non-technical staff. Since development of data models and logical workflows is common, a Data Engineer must also exhibit strong visualization skills, as well as creative problem-solving.

Requirements

Bachelor's in Computer Science, Mathematics, or Engineering or equivalent work experience
2+ years of data engineering experience
1+ years of experience with Snowflake
1+ years of experience in AWS (or similar cloud technologies) cloud stack including S3, IAM, Athena, SNS, SQS, and EMR.
2+ years of SQL Server and experience with tools such as SSIS and SSRS
Programming experience in Python and Linux bash
Demonstrated experience with agile or other rapid application development methods
Demonstrated experience with object-oriented design, coding and testing patterns as well as experience in engineering (commercial or open source) software platforms and data infrastructures
Solid understanding of data modeling and understanding of different data structures and their benefits and limitations under particular use cases
Experience using Big Data batch and streaming tools
Ability to collaborate and partner across a diverse team
Effective communication skills with business user, stakeholders and other developers
Ability to create strong work ethics and committed teams, foster open dialogue, and promote individual and team success

Responsibilities

Works with team members to design and implement data solutions in alignment with the project schedule.
Codes, tests, and documents new or modified data systems to create robust and scalable data platform for our applications.
Works with developers to make sure that all data solutions are consistent.
Expands and grows data platform capabilities to solve new data problems and challenges.
Creates data flow diagrams for all of business systems.
Implements security and recovery tools and techniques as required.
Help to create and maintain a data catalog for each project.
Interprets data results to business customers.
Design of the logical model and implements the physical database to support business needs.
Conducts logical and physical database design.
Designs key and indexing schemes and designs partitioning.
Develops, tests, implements, and maintains database management applications.
Constructs and implements operational data stores and data marts.
Ensures database changes are reviewed and approved according to database design standards and principles.
Resolves conflicts between models, ensuring that data models are consistent with the ecosystem model (e.g., entity names, relationships and definitions).
Models best practices in data management.
Contributes in creating, refining, managing and enforcing data management policies, procedures, conventions and standards.
Evaluates and provides feedback on future technologies and new releases/upgrades.
Contributes to the establishment of business continuity & disaster recovery requirements, methods and procedures for data systems and databases.

Benefits

Medical
Prescription Drug
Dental
Vision
Health Savings Account
Dependent Day Care Savings Account
Life Insurance
Disability and Other Insurance Plans
Paid Time Off (including Sick Leave consistent with state and local law, Parental Leave and 20 Vacation Days annually)
10 Paid Holidays
401(k)
Short/Long Term Disability