Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Data Modeler

Expired Job

Tekfortune Inc. Boston , MA 02108

Posted 4 months ago

Data Modeler
Boston, MA

Job Summary:
Role is aligned to client's Data & Analytics Center of Excellence (CoE) organization and is responsible for the implementation and design extensions of the logical and physical data model which will make up the Client's Intelligently Designed Schema.
Role will be viewed as the subject matter expert on the BIDS model and will work collaboratively with others in Data Governance, Data Engineering, and Data Products to ensure source data is mapped appropriately into the model and that the model supports the needs of customer facing data applications providing predictive analytics and rapid insights. Role must have core competencies in both the ability to communicate and influence effectively as well as a passion and seasoned ability to create data schemas which support and drive insights using any & all types of data.

Principle Responsibilities:
(essential job duties and responsibilities)
*Design, model and implement Standard Input and Output files which represent the business needs and can be used across the BIDS model.

*They will facilitate consistent business analysis, data acquisition and access analysis and design, and physical expression in the data platform
*Analyze Business Requirements, design logical data models and systems functions collaboratively as part of an Agile cohort
*Define Standard Integration points for data being captured into the Data Platforms
*Integrate Master Data and Reference data processes into the path
*Implement data/information architecture standards, policies and procedures into the BIDS model as determined by the CoE Data Governance process
*Structure, attributes and nomenclature of data elements, and apply accepted data content standards to technology projects.

*Present for review, verification, and approval the Conceptual and Logical data models to be implemented ensuring naming convention and proper definition of all objects and relationships.

*Convert the Logical models in to Physical models, and generate the delta or forward engineer DDL script, and execute in the data platform.

*Create complex views and materialized views and tune for performance.

*Administer and manage the users and privileges on Erwin or ER/Studio Data Architect tool
*Manage the repository server and all projects to follow the best standards and to keep them in sync with Prod.

*Publish data models, conduct training on BIDS model to developers, BA's, DA's, and QA resources

Skills and Experiences:

  • Strong background in data modeling (3NF, star schema, data vaults) with at least one implementation of a vendor packaged (i.e. Teradata, IBM) logical data model product, preferably in the pharmaceutical, health care, or financial services industry

  • Bachelor's degree with 5+ years of pharmaceutical, healthcare, or financial services industry experience.

  • At least 3+ years designing 3NF models and dimensional models for financial data warehouse products using industry standard tools such as Embarcadero (preferred) and Erwin.

  • Experience in modeling other data warehouse concepts such as Standard Input Files, Standard Output Files, Data Lake, Big Data, and Master Data Management is required.

  • Data Quality and Data Governance concepts and experience is required

  • Excellent inter-personal and communication skills

  • Must work well in a team environment


  • Value Driven

  • Results Oriented* *

Minimum Qualifications:

  • 7+ years or relevant work history

  • 5+ years in a data modeling focused role

  • Trained in Agile methodologies

  • Experience with enterprise modeling solutions such as ER/Studio, Erwin, or Power Designer

  • Background in cloud based EDWs (RedShift, Big Query, Snowflake)

    Preferred Qualifications:
  • Experience with AWS RedShift

  • Experience with enterprise BI solutions (Qlik, Tableau, Power BI)

  • Experience in a health industry (pharma or med tech)


  • Bachelor's in Computer Science, Information Systems or similar degree

Data Modeler

upload resume icon
See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Analyst / Modeler

Iconma, L.L.C.

Posted 6 days ago

VIEW JOBS 1/12/2019 12:00:00 AM 2019-04-12T00:00 Data Analyst / Modeler Location: Boston, MA Duration: 6 months Description: Client Investments is looking to bring on a senior level technologist who has excellent data skills and has experience within private investment (specific classes listed below). This person should have strong data modeling, manipulation with the Microsoft stack (2013 and above) Day to day-Building software to acquire, scrub, move and organize relevant data sets Creating investment dashboards and models Technology Experience * Data modeling, movement, exception handling and reporting (Microsoft SQL server stack) * Azure based data architectures * Agile (Scrum / Kanban) * Team player, can engage directly with business / investment professionals Business Experience * General investments experience (Research, Porfolio Analysis and Construction) * Specific experience with natural resources (Oil, Gas, Metals / Mining, Timber, Agriculture) * Nice to have: experience with private equity, real estate investments Iconma, L.L.C. Boston MA

Data Modeler

Expired Job

Tekfortune Inc.