Please find the position details below:
Job Title: Data Modeler
Location: Smithfield, RI or Boston MA or Merrimack NH or Jersey City, NJ
(Hybrid – 2 weeks onsite, 2 weeks remote)
Duration: 12 Months Contract with possibility of extension or conversion
Interview: 2 rounds 1 round technical 2 round CL and SL (HM will be traveling some in the next couple of weeks, so candidates can expect some delay)
Must Have:
PL/SQL: intermediate level
Informatica Catalog experience (NOT informatica ETL experience)
SAP PowerDesigner or similar software
Be able to write queries
Swagger - (don't development API, someone else is building the APIs) You're building the model for what another team will code
Conceptual/logical/physical data models
Nice to Have:
Cryptocurrency experience and knowledge is fine, but not a must
Leadership skills
Financial Industry experience
Qualifications
- Education and Experience (dependent on level)
- A Bachelor’s or Master's degree in Computer Science, Information Technology, or equivalent experience
- 10+ years’ experience with data design, analysis, and development. Development experience weighted towards PL/SQL and ETL tools.
- Demonstrated experience in the following areas : Database Management Systems, Data API design and implementation, PL/SQL, warehouses, data modeling and data profiling.
Description
Data Modeler
The Role
The Data Modeler works closely with business and technical teams to drive the creation of scalable, flexible, well governed, and detailed data design solutions. They drive adoption of enterprise and industry standard modeling methodologies. They partner with project teams to deliver practical & resilient data model designs that meet current business needs and are capable of easily adapting to new needs in the future.
The Expertise and Skills You Bring
- Requirements and Analysis
- Engage with business and technology partners to understand the business requirements, analyze the data gaps, and recommend appropriate solutions.
- Assess objectives, use cases, data requirements and specifications documents created by other analysts.
- Analyze and resolve major data issues that arise during the course of projects or in production environments.
Data Design
- Define conceptual and logical data models, with strong definitions, to capture organizational data needs across multiple subject areas.
- Build physical design for various types of systems such as operational systems, data warehouses, data lakes and others.
- Actively perform dedicated and targeted data analysis to identify risks for management. Strong coordination with key business partners will be required to obtain data sets and confirm results of the analysis.
- Document database solutions and present solutions to product partners, project teams, Data Engineering team and architecture review boards.
- Passionate about technology and delivering solutions in integrated data environments. Current on event driven processing, and Data API developments.
- Lead and facilitate work sessions with business functions and projects to define requirements, business term definitions and logical data models
- Map Technical terms to Business terms in data catalog tool.
Technical Leadership
- Provide strategy, data modeling with accountability on work initiative engagements and timeline. Align and ensure consistency to enterprise standards on technology, tools, and procedures.
- Knowledge of and experience with tools, techniques and processes for complex data gathering, analysis and reporting on data for large organizations.
- Find opportunities to use enterprise data models for new projects to minimize work and data duplication
- Strong interest in playing a technical data steward role and partnering across our business to understand and document our data, appropriate data usages and helping Asset Mgmt. derive the maximum value from its data.