LOTTE BIOLOGICS is looking to support the organization's data engineering activities, enterprise reporting through Microsoft Power BI, and help maintain IT/OT and data analytics applications.
Requirements
- Experience with data engineering activities, ETL/ELT processes, data integrations, and experience with APIs.
- Demonstrated knowledge of Data Warehousing concepts – Audits, Fact Tables, Metric Marts, and knowledge of database administration best practices.
- Experience in working with Azure Data Factory – Building, managing, and running pipelines. Connecting to a variety of data sources, on-prem and cloud.
- Knowledge of SQL – Demonstrated ability to write stored procedures, functions, create/ properly use indexes, CTEs, advanced sub-queries, views, and advanced knowledge of query performance optimization.
- Experienced in creating Microsoft Power BI reporting – data source modeling, DAX, and building dashboards end-to-end.
- Proficiency with MS Office Applications
Responsibilities
- Support data engineering activities and assist with maintaining existing data integrations to various systems.
- Design, develop, and maintain ETL processes and data pipelines to transform data into usable information for the organization.
- Assist with maintaining LOTTE’s Data Warehouse and Data Lake – this also includes writing solution abstracts and documenting all associated components.
- Monitor and optimize data workflows to ensure performance and scalability.
- Troubleshoot and resolve data-related issues promptly.
- Design and develop interactive reports and dashboards using Power BI – tailoring them to specific stakeholder needs.
- Support existing IT/OT analytic applications – assist with maintaining validated applications in an audit ready state.
Other
- This is a hybrid-based position requiring employee presence, on site 50-100%.
- Collaborate with cross-functional teams and stakeholders to gather and document business requirements for analytics solutions.
- 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.
- Excellent problem-solving, presentation, verbal, and written communications skills
