Job Actions

Job Information

Data Modeler
BOSTON MA 02133
Category: Other
  • Your pay will be discussed at your interview

Job code: lhw-e0-90669284

Company Profile

System One Services

Contact Company


Local Information

Laugh while you Look

Sponsored Ads

Summary

  Job posted:   Thu Jun 7, 2018
  Distance to work:   ? miles
       
  1 Views, 0 Applications  
 
Data Modeler
Data ModelerBoston, MA








Apply with System One











Type:Contract


Category:Information Technology


Job ID:129439


Date Posted:06/05/2018




Data Modeler





Our financial client in Back Bay, Boston is looking for a Data Modeler to join their team for a long-term, ongoing contract. In this role, you will be responsible for building data models that describe data and its relationships in a consistent way to support business and technical objectives.





Responsibilities:



+ Develop conceptual/subject area data models and data flow diagrams in an Agile Software Development environment


+ Create, document and maintain logical and physical database models that are compliant with enterprise standards


+ Facilitate data requirements meetings with business and technical stakeholders in order to resolve conflicts and drive decisions and consensus


+ Assist in establishing, maintaining and enforcing data model design principles, techniques and standards


+ Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes and data relationships as well as the definition of business rules governing the integrity, archiving and audit requirements of the data


+ Analyze existing systems using manual or automated data analysis/profiling to reverse engineer data requirements


+ Determine suitable data modeling approach for each project based on business requirements for data capture and access


+ Ensure the proposed data models follow Data Architecture guidelines and best practices


+ Assist developers with complex query development and performance optimization






Requirements:



+ Bachelor's degree in Computer Science, Business Data Processing, Computer Information Systems or relevant discipline


+ 4+ years of Data Modeling experience in an Agile work-environment delivering transactional and operational, reporting/analytical (EDW/Data Lake/NoSQL) solutions


+ Understanding of enterprise and reporting modeling concepts including dimensional modeling, snowflakes, slowly changing dimensions, irregular dimensions and surrogate, compound and intelligent keys


+ 3+ years of experience in Relational database (Sybase, Oracle or MS SQL Server) experience (SQL scripts, stored procedures, triggers, etc.); 2+ years of Database Administration experience including tuning/optimization


+ 3+ years of experience within the investment and mutual fund management industry, high level knowledge of securities & products, counterparties, positions, and transactions data


+ Experience with Embarcadero ER/Studio preferred


+ Excellent communication and time management skills, detail-oriented and organized


+ Ability to thrive in a fast-paced environment as well as manage multiple projects simultaneously






*Client is unable to sponsor candidates*





If you are a fit for this role, apply today!






Apply with System One

















More Information »