Programmer Remote

The Business Intelligence and Data Analytics Team is leading a journey to advance the use of analytics across the Lab. We aim to make data readily accessible and trusted accelerate the timetoinsight and enable deepdive analysis on an array of information. In collaboration with our Lab partners our projects aim to uncover the story hidden in the data and to leverage data science techniques to predict outcomes and inform next actions.
Data Engineer/Analyst will work on designing building and implementing a data foundation to support a strategic analytics project that drives strategic growth for the lab. This involves liaising with functional teams that build or acquire the underlying data application owners to understand raw or source data structures and end users to accurately design strategic data marts. Finally designing and building data pipelines ETL/ELT integrations constructing and modifying data marts preparing (cleaning transforming) data and collaborating with extended team members to design impactful business solutions.
Data Engineer/Analyst needs to have specifically deep expertise in data management techniques ability to drive effective support of data analysis and model management and experience with IT project management practices.

Standardize data and reporting across businesses and teams to enable consistency and quality of key business data.
Design develop test and document data integrations and assist with deployment validation and hyper care.
Participate in designing overall logical & physical data warehouse and data mart models and architectures to support business requirements.
Develop and maintain SQL PL/SQL Python as needed.
Assist with review to confirm technical feasibility of integration development objects based on integration principles and best practices.
Understand and navigate a wide array of source data systems (S4/HANA BW enterprise data warehouses relational databases IT systems in house and COTS applications documents APIs unstructured data big data Vector database etc.).
Analyze data and assist with developing insights (e.g. via data visualization tools like Power BI / SAC) to enable business decision making
Propose new methodologies to demonstrate data to improve existing methodologies.
Developing prototypes and proof of concepts for required solutions.
Implementing information security standards in enterprise data warehouse.
Document solutions through high/low level design documentation.

Nice to Have:

Education & Experience: Bachelors plus 12 years of relevant work experience.

Work Authorization: US Citizenship is required due to the nature of the work.