Get job as soon as 2 days (HURRY UP) ENROLL NOW or Call   +1 (804)-454-3215
+

Data Modeler / Analyst


Job ID : 15347

Job Title : Data Modeler / Analyst

Location : Durham, NC

Company Name : MSYS Inc.

Industry : Information Technology

Salary : $68,130 - $119,830  per year

Job Type : Contractor

Posted on: 2020-09-01


Required Skills : DBMSs, SQL, MDM, OLTP, Warehousing, Data Marts

Benefits : No benefits are available


Primary Responsibilities:

  • Capture requirements from the business and technical staff to analyze data requirements and recommend appropriate solutions.
  • Document database solutions and present solutions to project teams, Data Engineering team and architecture review boards;
  • Integrate data into existing enterprise logical model and physical data stores to avoid data redundancy.
  • Ensure all technical database decisions result incoherent system designs which use the most effective methods and tools; Use modeling tool to capture clear definitions of data elements and produce code to effect database changes.
  • Implement data solutions to satisfy business requirements and act as mentor and provide guidance and leadership to junior members of team.
  • Perform research into emerging technologies, define data solution standards and guidelines, and drive technical approaches at a tactical level, serving as the data engineering member on FI and cross-Fidelity systems projects.
  • Provide data warehousing / dimensional modeling and OLTP modeling expertise as well as write and maintain the business rules, logic and SQL queries

Education and Experience:

  • Degree required along with 10 years of experience in a technical field (analysis, development, database administration, report development).
  • 6 years of experience in relational data modeling preferred & Data Analysis.

Skills and Knowledge:

  • Knowledge of financial services business knowledge of institutional brokerage business preferred.
  • Excellent requirements gathering and written and verbal communication skills; Ability to manage workload across multiple projects and balance deadlines
  • Excellent presentation and negotiation skills; Expert knowledge of systems development methodologies, specifically Agile.
  • Dexterity in using data modeling tools such as Power Designer or Erwin. Prefer experience with Power Designer.
  • Knowledge and understanding of different database platforms, such as, Oracle, Postgres, Hadoop, Snowflake, Netezza, DB2; Advanced ability to use SQL to query data on any of the above DBMSs.
  • Knowledge and in-depth exposure to modeling strategies, such as relational (logical, physical), star, snowflake, unstructured, to support OLTP, Warehousing and Data Marts, Data Lakes, MDM).

Skills Desired below:

  • Data Modeling Skills Strong working knowledge of logical and physical data modeling for (primarily) operational applications
  • Analysis Skills Strong understanding of how to gather data requirements and translate them into modeling solutions
  • Technical Skills Strong SQL querying skills and understanding of DDL script content (generated from data modeling tool)
  • Soft skills such as self-motivated, high energy, strong written and oral communicator, ability to juggle multiple projects at once

Latest Jobs For You

  • Software Developer Engineer in Test SDET

    Louisiana Economic Development Bossier City, La.

    Responsibilities: Design, develop and implement test plans, manual test scripts, and automated...

    View Job
  • Senior SDET Engineer

    Cynet Systems Hartford, CT

    Job Description: Middle and Large Commercial IT is looking for an experienced, energetic, and ...

    View Job
  • Sr Software Test Engineer

    COX Enterprises Irvine, CA

    Job Description: A highly qualified Senior Quality Assurance Test Automation Engineer will ...

    View Job
  • Network Engineer

    Tech USA Downingtown, PA

    Responsibilities: Review and provide input to new technical requirements Ability to ...

    View Job
  • Sr. Big Data Developer

    Synechron Weehawken, NJ

    Skill Requirements: Hands-on expertise with Big data Technologies (Apache Spark, Hadoop, HDFS,...

    View Job

Thanks For Your Feedback

We’re an equal opportunity provider.
All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.
OPTnation.com is not a Consulting Company/Training Company/H1B Sponsor.

Attach A Resume First