Data Platform Engineer - GMSGQ

BIOSPACE
Cambridge, MA, United States
5 days ago
Apply on www.juju.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$177,341 - $228,000
Working hours
Regular working hours
Job source

Tech stack

Cloud Computing Databases Data Infrastructure Extract Transform Load (ETL) Data Migration Data Retrieval Data Warehousing Database Storage Structures Python (Programming Language) Query Optimization Power BI Cloud Services
+15 more
SQL Stored Procedures SQL Databases Data Streaming Systems Integration Tableau (Software) Data Processing Scripting Freeform SQL Data Storage Management Database Optimization Database Performance Indexer Information Technology Restful APIs Data Pipelines

Job description

  1. Develop and maintain ETL processes to extract data from multiple applications, transform it into a usable format, and load it into data warehouses or databases.
  2. Implement automation for data pipeline tasks to ensure continuous and reliable data flow with minimal manual intervention.
  3. Write and optimize complex SQL queries for data retrieval, manipulation, and reporting purposes.
  4. Design cloud infrastructure and services and implement and configure cloud services, including computing, storage, and networking.
  5. Deploy, manage, and monitor applications on the cloud and ensure applications are running efficiently and effectively.
  6. Design and maintain database schemas, tables, and relationships to ensure efficient data storage and retrieval and optimize database performance through indexing, query optimization, and resource management.
  7. Design, develop, and maintain RESTful APIs and implement authentication and authorization mechanisms for them.
  8. Write efficient and reusable Python scripts for various automation tasks and develop scripts for data processing, data migration, and system integration.
  9. Develop and maintain dashboards, reports, and visualizations to provide insights to stakeholders using tools like Power BI, Tableau, or custom SQL-based reports.
  10. Collaborate with data analysts and business users to understand their requirements and translate them into technical solutions. Up to 20% remote work allowed.

Requirements

REQUIREMENTS: Bachelor’s degree in Computer Science, Engineering, or related field plus 5 years of related experience. Prior experience must include:

  1. Design database structures and schemas for SQL-based databases to efficiently store and retrieve data, meeting data requirements and business needs.
  2. Create databases, including tables, indexes, views, and stored procedures, and optimize SQL scripts and indexing strategies for fast data retrieval.
  3. Develop data pipelines using a variety of services to ensure smooth data flow using cloud technologies.
  4. Implement REST principles for designing RESTful APIs using Python.

Benefits & conditions

Full time. $177,341 - $228,000 per year. Competitive compensation and benefits.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.juju.com
Prepare application

Good distractions

Loading talks and stories from around this role…