Data Modeler

Data Integration Specialist

The Data Integration specialist is a subject matter expert of data integration solutions and data architecture. You will be responsible for the technical development of any new data integration solution to be plugged into the overall enterprise data architecture.

You will be supporting the Data Engineer to organize data at the macro and micro levels, creating data models that enable the implementation of the intended business architecture, key data entity diagrams, and a data inventory to implement the architecture vision.

Responsibilities

1. Understand and translate business needs into data models supporting long-term solutions.
2. Work with teams to implement data strategies, build data flows, and develop conceptual data models.
3. Optimize and update logical/physical data models to support new/existing projects.
4. Maintain conceptual, logical, and physical data models along with corresponding metadata.
5. Recommend opportunities for reuse of data models in new environments.
6. Perform reverse engineering of physical data models from databases and SQL scripts.
7. Evaluate data models and physical databases for variances and discrepancies.

Requirements

1. Min. 8+ years of hands-on relational, dimensional, and/or analytic experience (using RDBMS, dimensional, NoSQL data platform technologies, and ETL and data ingestion protocols).
2. Expertise in modeled data for investment and fund management domains.
3. Bachelor's or master's degree in computer/data science or related experience.
4. Experience with end-to-end data pipeline implementation with cloud services such as Azure Data Factory/AWS Glue.
5. Data manipulation, data integration design and development including T-SQL, SSIS, and APIs.
6. Data warehouse tech: experience developing OLAP cubes and/or in-memory data models.
7. Business Intelligence technology (e.g., Power BI).
8. Good understanding of data lifecycle and architecture best practices.
9. Systems integration experience with SAP systems is a bonus.