Data Engineer

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 #J-18808-Ljbffr