Data Engineer/Analyst - LLJP00001446 at Softworld Inc

Job Title: Data Engineer/Analyst

Job Location: Lexington, MA, 02421 - 100% Remote - Candidates must be able to support EST hours.

Onsite Requirements:

• S. in related field of study
• This role requires to be a US citizen with an active US Government Secret clearance and/or have the capability to obtain one.
• 12+ year of Data Engineer/Analyst experience
• Strong Data Modeling experience
• Experience building Data Warehouses
• Expertise in SQL, PL/SQL, and any other procedural languages
• Experience designing and building data pipelines.
• Experience with ETL/ELT integrations.
• Understand and navigate a wide array of source data systems (S4/HANA, BW, enterprise data warehouses, relational databases)

Job Description:

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.
• Participated 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 warehouse 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:

• 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.
• 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.
• Involve others to overcome issues. Not afraid to escalate trouble.
• Works independently and is confident using sound discretion and judgement.
• Capable of leading tasks, projects, or programs within the working group.