Data Engineer/Analyst - Lexington, United States - Softworld Inc

Description

Job Title:
Data Engineer/Analyst


Job Location:
Lexington, MA, % 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.