fbpx
Lead Data Engineer Lead Data Engineer

Lead Data Engineer

Location: Remote, Kuala Lumpur

Category:• AWS
• SQL

What's the Project?

Our client believes that everyone should be able to define & control their bodies, health & well-being. Their mission is to build a direct-to-consumer, virtual-first healthcare platform. In building this platform, they are focused on providing agency, reliability, and transparency to their members
The current healthcare system is not accountable to the patients it serves. Therefore, to achieve the mission our client believes it is imperative to build and retain direct (paying) relationships with the community by offering them products that meet critical needs and delight them. Over time this will result in our client, on behalf of the community, being able to remake more and more of the currently broken system from the inside out.
Your job will be to assess and optimize the existing data pipelines and ensure they are scalable. In order to support business intelligence and data analytics you will drive the design of the architecture of the underlying data platform.

You Perfectly Match If you have:
  • 5+ years of commercial experience with hands-on Data Architecting, Modeling, and Data Warehousing stack including AWS Redshift and other equivalent modern technologies
  • Experience with AWS solutions
  • Familiarity with GIT and release engineering strategies
  • Deep experience with SQL design and architecture best practices (i.e. third normal form, index management, constraints, and foreign key relationships, etc.).
  • Expertise in query tuning and performance optimization.
  • Experienced in creating ERD diagrams
  • Strong SQL abilities and experience with massive relational database systems.
  • Strong knowledge of all traditional Data Warehouse-related components (Sourcing, ETL, Data Modeling, Infrastructure, BI, Reporting) and the modern tools to support those components
  • Ability to clearly explain and justify ideas when faced with competing alternatives
  • Track record of working in Scrum / Agile software teams
  • Proficient in spoken and written English
Nice to have:
  • Bachelor’s degree or higher in a technical field of study
  • Experience with Postgres, Aurora (MySQL), DynamoDB
  • Familiarity with the AWS Lamda, Kafka
  • Familiarity with continuous delivery and DevOps, understanding of common database administration tasks and concepts such as backup & restore, recovery models, integrity checks, and replication methods.
  • Flexibility and creativity in solution design – including leveraging emerging technologies
Your day-to-day activities:
  • Work as part of multifunctional teams to own the design and architecture of data platform and pipelines.
  • Convert logical models into physical data models employing sound database normalization techniques.
  • Create physical database objects like tables and views with appropriate data types, foreign keys, constraints, and upfront design and maintenance of proper indexes.
  • Create and maintain easy to follow technical documentation of data models.
  • Serve as a go-to resource for questions related to existing and proposed logical and physical data models.
  • Perform SQL code reviews and ensure that new database code meets company standards for readability, reliability, and performance.
  • Assist with resolving the performance of poorly executing stored procedures and queries.
  • Support team initiatives by developing tools and identifying opportunities for process automation; assist in evaluation and selection of standard tools for the department.
  • Support building and deploying the infrastructure for ingesting high-volume data from various sources.
  • Support developing and maintaining the data-related scripting for build/test/deployment automation.
  • Research individually and in collaboration with other teams on how to solve problems.
  • Partner with team and research, design, test, and evaluate new technologies and services as it applies to data warehousing and architecting.
  • Partner with the team to maintain an organization-wide view of current and future strategy and approach as it applies to data warehousing and architecting.
  • Identify and resolve bottlenecks and bugs.

Ready to dive in?

Contact us today or apply below.

Sarah Chin

Sarah Chin
Recruiter

Kuala Lumpur, Malaysia

Apply Now

5mb max, .pdf,.xlsx,.xls,.doc,.docx,.ppt,.pptx formats.

© 2022 Newfire

Amazon Consulting Partner
Disruptor