Data Platform Engineer – GMSGQ

BioSpace; Boston (MA); Hybrid; USD 177,341 - 228,000; Full time

Job summary

An established industry player is looking for a Data Platform Engineer to join their team in Boston. This role involves developing and maintaining ETL processes, optimizing SQL queries, and designing cloud infrastructure. You will collaborate with data analysts to create insightful dashboards and reports while implementing RESTful APIs to enhance data accessibility. The position offers a dynamic work environment with opportunities for remote work. If you are passionate about data engineering and cloud technologies, this is the perfect opportunity to make a significant impact.

Qualifications

• 5+ years of experience in data engineering and cloud technologies.
• Strong expertise in SQL and Python for data manipulation and automation.

Responsibilities

• Develop and maintain ETL processes for data extraction and loading.
• Design and optimize database schemas for efficient data storage.

Skills

ETL processes

SQL

Cloud infrastructure

RESTful APIs

Python

Data visualization

Education

Bachelor’s degree in Computer Science

Tools

Power BI

Tableau

Job description

Job Description

Pursuant to Section 20 C.F.R. 656.10, you are hereby notified that an application for Alien Employment Certification will be filed by Takeda Pharmaceuticals U.S.A. for the following job opportunity:

JOB LOCATION: Cambridge, MA

POSITION: Data Platform Engineer – GMSGQ

POSITION DESCRIPTION: Takeda Pharmaceuticals U.S.A. is seeking a Data Platform Engineer – GMSGQ with the following duties:

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: 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.

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

Qualified applicants can apply at https://jobs.takeda.com. Please reference job #R0145724. EOE

Locations: Boston, MA

Worker Type: Employee

Worker Sub-Type: Regular

Time Type: Full time