Associate Data Engineer

LOTTE BIOLOGICS; City of Syracuse (NY); On-site; USD 60,000 - 88,000; Full time

Benefits offered by this job

Target bonus of 8%

Job summary

A leading biotechnology company in New York is seeking an Associate Data Engineer to support data engineering activities, maintain enterprise reporting through Microsoft Power BI, and manage data analytics applications. This hybrid role requires on-site presence 50-100% and offers a competitive salary range of $60,000 to $88,000. The ideal candidate must have a bachelor's degree in a relevant field and 1-3 years of experience in a data engineering or analytics position.

Qualifications

• 1-3 years of experience in a data engineering/analytics role.
• Proficiency with MS Office applications.
• Excellent problem-solving and communication skills.

Responsibilities

• Support data engineering activities and maintain data integrations.
• Design and develop ETL processes and data pipelines.
• Collaborate with cross-functional teams for analytics solutions.

Skills

Data engineering activities

ETL/ELT processes

SQL skills

Experience with Microsoft Power BI

Communication skills

Problem-solving

Communication

Education

Bachelor’s degree in Data Engineering, Data Analytics, Computer Science or related disciplines

Tools

Microsoft Power BI

Azure Data Factory

Job description

LOTTE BIOLOGICS

Delivering Therapies That Enable a Healthier World. A new company built on 80 years of tradition. We embody our core values of being Inspired by Science, Embracing Diversity, Fostering Talent, and Connecting Lives. Our mission is to be the most trusted partner in the industry, delivering reliable benefits for patients worldwide.

Position Summary

The Associate Data Engineer will support the organization’s data engineering activities, enterprise reporting through Microsoft Power BI, and maintain IT/OT and data analytics applications. This hybrid position requires employee presence on site 50‑100%.

Duties & Responsibilities

• Support data engineering activities and maintain existing data integrations to various systems.
• Design, develop, and maintain ETL processes and data pipelines to transform data into usable information.
• Assist with maintaining LOTTE’s Data Warehouse and Data Lake, including writing solution abstracts and documentation.
• Implement best practices for data management: governance, quality, and security.
• Monitor and optimize data workflows for performance and scalability.
• Troubleshoot and resolve data‑related issues promptly.
• Collaborate with cross‑functional teams to gather and document business requirements for analytics solutions.
• Design and develop interactive reports and dashboards using Power BI, tailored to stakeholder needs.
• Support existing IT/OT analytic applications and maintain them in an audit‑ready state.
• Generate documentation including design specifications, work instructions, and knowledge‑based articles.
• Provide administrative support to analytical applications such as AVEVA PI, ProcessPad, JMP, InfoBatch, and eForms.

Education & Experience

• Bachelor’s degree in Data Engineering, Data Analytics, Computer Science or related disciplines preferred.
• 1‑3 years of experience in a data engineering/analytics role; experience in biologics production or medical devices is a plus.
• Proficiency with MS Office applications.
• Excellent problem‑solving, presentation, verbal and written communication skills.

Knowledge, Skills, Abilities

• Experience with data engineering activities, ETL/ELT processes, data integrations, and APIs.
• Knowledge of data warehousing concepts (audits, fact tables, metric marts) and database administration best practices.
• Experience with Azure Data Factory – building, managing, and running pipelines; connecting to on‑prem and cloud sources.
• Strong SQL skills: stored procedures, functions, indexing, CTEs, advanced sub‑queries, views, and query optimization.
• Experience creating Microsoft Power BI reports – data source modeling, DAX, end‑to‑end dashboards.
• Team player, open to sharing expertise and learning.
• Effective communication skills to convey technical concepts to non‑technical stakeholders.
• Ability to work independently with minimal supervision while providing escalation when needed.
• Excellent analytical and problem‑solving skills.
• Attention to detail and personal accountability.
• Good interpersonal skills, customer focus, and professionalism.
• Self‑motivated with a strong work ethic and continuous improvement mindset.

Physical Demands

Work within all site facilities, requiring high attention to detail and occasional use of personal protective equipment.

Work Environment

Internally oriented role with frequent collaboration. Requires presence on site 50‑100% and may involve occasional shift work, weekends, and holidays.

Travel

5% travel required.

Target Bonus

8%

Work Location & Pay Range

East Syracuse, NY. New York Pay Range: $60,000 USD – $88,000 USD.

Equal Employment Opportunity

We are an Equal Employment Opportunity (“EEO”) Employer. We believe that women, people of color, veterans, and LGBTQ communities must participate in the work we do, so we strongly encourage applications from people with these identities or who are members of underrepresented communities. If this is the work that you want to do, in a culture of inclusion and excellence with the goal of making our world a healthier place, then please apply today!

Additional Details

• Seniority level: Entry level
• Employment type: Full‑time
• Job function: Pharmaceutical Manufacturing