Senior Data Architect. Data Engineer- Remote

• Data Engineer/Architect
• 8-10+ years experience

Combination of NoSQL

Good understanding of JSON Rational Model

MySQL performance tuning

This is Senior engineer who is focused on the data layer.

Right now we are not a big data company We are looking at the flattening JSON. we are connected an analytics tool like tableau to an OLTP system.

This person will be building out and maintaining the data connection paradigm for the company and will help them build data movement tooling and data validation tooling ( It’s ETL tooling)

This person will be supported by other engineers but should be comfortable being the go to data person at the company. We are replacing their integration mechanisms and looking at products like Informatica, Talend, Data Bricks

This person should Like data modelling solving problems making things better someone who does data flow, data movement, and understands data mapping..

Must have AWS experience or be cloud agnostic but must understand AWS.

MySQL RDS vs. MySqL Aurora.. should understand the differences.

Nice to understand Data Security

Longer term, we will want to be building multi tenant systems so an understanding of multi tenancy would be a plus.

Python is a must

Senior Data Engineer

We are seeking a Senior Data Engineer who will establish the Data Engineering foundations and will lead the charge on the continuous improvement, monitoring and design of the storage solutions and data architecture This individual must be highly organized with the ability to stay on top of multiple projects, teams and deliverables across a range of storage and architecture implementations and sizes, ranging from 10GB to 10+TB databases and other stores. The applicant must have willingness and ability to adapt to changing internal and external priorities, while working in a NIST compliant environment.

You will be responsible for enhancing monitoring for existing databases, creating capacity and resource plans, for recommending new options and technologies, and for enhancing and tuning existing databases. You will also be responsible for developing and tuning complex queries, and providing coaching to the broader development team on best practices and industry-standard approaches to data and database access. Additionally, you will be responsible for data architecture and design.

Key Responsibilities

● Architect and design our Data using the industry best practices data architecture and design principles.

● Develop high performance storage solutions across several database publishers

● Work with application architecture, product manager and other stakeholders to create next-generation data stack and data services offerings

● Plan, develop and maintain big data (>10TB) storage solutions across multiple database types

● Develop storage monitoring and maintenance program for existing solutions

● Ensure compliance requirements for storage of customer data across national boundaries

● Participate in solutions architecture during development and delivery cycle

● Monitor industry trends, and work with R&D to pilot new technologies

● Create, maintain, monitor data pipelines, data collection, storage, and data retrieval processes

Qualifications

● 8+ years experience with relational and NoSQL databases

● Experience with AWS infrastructure

● Proven track record of success with big data projects

● Expert understanding of SQL dialects (T-SQL, PL/SQL, etc)

● Experience with multiple storage patterns and techniques (queuing, streaming, data fabric/lake/house/mesh)

● Demonstrated understanding of data engineering principles from storage to data access design

● Experience with multiple ETL frameworks (e.g. AWS Glue, AWS DMS, Databricks, Informatica, Mulesoft)

Extra :

● Experience with OO or scripting languages

● Other cloud experience, such as Azure, GCP

.

Notes:

Remotely, we prefer EST or CST Candidates . PST won’t work . This person can work 10-6 EST and will be attending meetings at 9 AM.

• Bleary@attainsearch,com