Remote Data Integration Specialist

Summary

Join Enterra Solutions as a Data Integration Specialist and collaborate with clients' business and IT data groups to onboard their data onto our solution(s) and deliver high-impact business solutions.

Requirements

• Bachelor’s Degree in a STEM (Science, Technology, Engineering or Math) subject
• Experience in a client-facing/consulting role
• Experience in data wrangling (harmonization, cleansing, transformation etc.) using Python, Jupyter notebooks or R
• Excellent verbal and written communication skills. Ability to clearly communicate complex data relationships to both internal and client teams. This includes documentation, presentations, and individual analysis sessions
• Experience in specifying requirements using different approaches such as use cases, activity diagrams, sequence diagrams and state charts, data dictionaries, class or entity relationship diagrams
• Distinctive problem-solving and analytical skills, combined with strong business sense
• Strong proficiency with Microsoft Office (Word, Excel, PowerPoint and Visio)
• Knowledge of data technologies such as Relational Databases, Databricks, Snowflake or similar

Responsibilities

• Specify data requirements to the client and understand the data available/received from the client
• Map the data available with the data requirements to: Identify any gaps, issues and nuances; and determine the impact and design appropriate remedies
• Specify the transformation needed to load the client data into the Enterra solution data models
• Work with data engineers to ensure the correct implementation of the specifications
• Validate the data load process
• Perform initial data wrangling to derive and verify mapping to defined metadata and data requirements
• Perform additional data wrangling to support new features at the client and create specifications for inclusion into the product offering
• Understand any planned upcoming changes that may impact the client data (e.g., creation of a new data lake or other data sources)
• Comprehend and specify the cadence of data refresh needed to support the client deliverables
• Test the client specific instance of the Enterra business solution
• Highlight and specify opportunities or gaps within the Enterra data models and offerings

Benefits

• Remote work permitted
• Occasional travel may be needed based on client or project requirements