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 2 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

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.
Download the
LiveCareer app and find
your dream job anywhere

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 Modeler

Accenture Inc

Posted 3 months ago

VIEW JOBS 8/31/2018 12:00:00 AM 2018-11-29T00:00 Accenture is a leading global professional services company, providing a broad range of services and solutions in strategy, consulting, digital, technology and operations. Combining unmatched experience and specialized skills across more than 40 industries and all business functions – underpinned by the world's largest delivery network – Accenture works at the intersection of business and technology to help clients improve their performance and create sustainable value for their stakeholders. With approximately 425,000 people serving clients in more than 120 countries, Accenture drives innovation to improve the way the world works and lives. Visit us at People in our Client Delivery & Operations career track drive delivery and capability excellence through the design, development and/or delivery of a solution, service, capability or offering. They grow into delivery-focused roles, and can progress within their current role, laterally or upward. Business & Technology Integration professionals advise upon, design, develop and/or deliver technology solutions that support best practice business changes Job Description A data modeler will be responsible for creating and maintaining conceptual, logical and physical data models and will be creating one or more data models depending on use cases including transactional, integration, data warehouse and analytical systems. * Data modeler will have to work with the business team, comprising of stakeholders and analysts, and information technologists to understand data requirements for the program. * Perform data profiling/analysis activities that will help establish, modify and maintain a data model. * Create conceptual data model to identify key business entities and visualize their relationships. * Create detailed logical models identifying all the entities, attributes and their relationships along with the characteristics associated with each of those. * Convert logical models to physical models for the databases in use and provide DDLs to the implementation teams. * Create a taxonomy/data dictionary to communicate data requirements that are important to business stakeholders. * Test the DDLs and ensure the models are deployed to all environments and are consistent. * Lead and participate in design workshops to facilitate an understanding of business data needs and how they are mapped to the data model. * Facilitate resolution of model conflicts created by competing business requirements. * Partition data models into landing, integration, data mart, and reporting layers. Support review, signoff and adoption of data models in collaboration with global businesses, architecture and delivery teams. * Articulating modelling principles to other modelers and business users. Accenture Inc Boston MA

Data Modeler

Expired Job

Tekfortune Inc.