15 days old
2018-06-052018-07-03

Data Modeler (Agile Environment)

Boston, MA 02199
  • Job Code
    624817
  • Payrate
    $65 To $70

BASIC PURPOSE :


The data modeler builds data models that describe data and its relationships in a consistent way to support business and technical objectives.


MAJOR RESPONSIBILITIES:



  1. Develop conceptual/subject area data models and data flow diagrams in an Agile Software Development environment
  2. Facilitate data requirements conversation with business and technical stakeholders resolving conflicts to drive decisions and consensus.
  3. Create, document, and maintain logical and physical database models that are compliant with enterprise standards
  4. Assist in establishing, maintaining, and enforcing data model design principles, techniques, and standards
  5. 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
  6. Analyze existing systems using manual or automated data analysis/profiling to reverse engineer data requirements.
  7. Determine suitable data modeling approach for each project based on business requirements for data capture and access
  8. Ensure the proposed data models follow data architecture guidelines and best practices
  9. Assist developers with complex query development and performance optimization
  10. Performs additional duties as required

JOB REQUIREMENTS :



  1. Bachelor's Degree with a major in Computer Science, Business Data
  2. Processing, Computer Information Systems or related field is required.
  3. Minimum three - five (3-5) years data modeling experience in an agile work-environment delivering transactional and operational, reporting/analytical (EDW/Data Lake/NoSQL) solutions
  4. Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read, irregular dimensions, and surrogate, compound and intelligent keys
  5. Experience with Embarcadero ER/Studio (preferred)


  1. Minimum three - five (3-5) years Relational database (Sybase, Oracle or MS SQL Server) experience (SQL scripts, stored procedures, triggers, etc.)
  2. One to three years Database Administration experience including tuning/optimization
  3. Industry: 3 years experience within the investment and mutual fund management industry, high level knowledge of securities & products, counterparties, positions, and transactions data
  4. Knowledge of Data Modeling in Agile Software Development Framework
  5. Ability to describe the role of data models in supporting diverse use cases such as business processes, BI, data migration or master data management (MDM)
  6. Experience with ETL (Informatica's PowerCenter), data quality, data profiling and ad-hoc query tools (preferred)

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Modeler (Agile Environment)

Randstad Technologies
Boston, MA 02199

Share this job

Data Modeler (Agile Environment)

Randstad Technologies
Boston, MA
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast