Data Engineer with Security Clearance

The Business Intelligence and Data Analytics Team is leading a journey to advance the use of analytics across the organization. We aim to make data readily accessible and trusted, accelerate the time-to-insight, and enable deep-dive analysis on an array of information. In collaboration with our 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 organization. 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. Key responsibilities include but not limited to:

• 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 Must Have:
- Expertise in SQL, PL/SQL and any other procedural languages
- Design, develop, test and document data integrations with source systems such as S4/HANA, BW4/HANA etc., and assist with deployment, validation and hyper care
- Strong understanding of star schema and experience in designing efficient data models for analytical processing. Nice to have:
- Familiarly with cloud data ware house such as Snowflake, Databricks
- Familiarity with Data visualization tools such as Power BI/SAC.
- Familiarity with Erwin or ER/Studio for data modeling.
- Familiarity with Python, R languages
- Web Development/Web-based API processing and GitHub Key soft skills:
- Discipline. Leverage standard best-practice approaches to managing work. Organized, thorough, and well documented.
- Eager to learn. We frequently introduce new toolsets and need the team to adapt.
- Collaboration. Actively inclusive with all stakeholders at various levels of the organization. Openly solicits ideas and feedback.
- Problem Solving. Anticipates obstacles and considers a broad range of alternatives. Involves others to overcome issues. Not afraid to escalate trouble.
- Autonomy. Works independently and is confident using sound discretion and judgement.
- Leadership. Capable of leading tasks, projects, or programs within the working group.