Remote Senior Data Modeler

Overview

Remote
Depends on Experience
Full Time

Skills

Data Modeler
Erwin
(Model or Modeling or Modeler)
(ETL or Informatica or Dataware or Data Ware or DWH)
Snowflake or Redshift or AWS or Amazon Web Services or Azure)

Job Details

About Infinite:

Infinite is a global leader in digital engineering and IT services, with over 20 years of experience driving digital transformation. We partner with leading Fortune 1000 companies to deliver innovative, scalable technology solutions that accelerate business outcomes.

With deep expertise in telecommunications, healthcare, banking, and finance, Infinite helps organizations optimize and modernize their technology landscapes to achieve long-term growth and efficiency.

 

Job Description:

Data Modeler

The Data Modeler is responsible for managing the flow of data from various data sources. Develops Data Models on different data organization platforms like relational databases, big data that support the integration and organization of data across systems. Analyze and interpret data to create, review and ad hoc exhibits based on detailed data sets. Perform data mining and analysis that impacts forecasts and risk assumptions.

 

Main Duties & Responsibilities:

  • Work with Business, Architects and System Analysts to fully understand the business requirements and translate them into Conceptual, Logical and Physical models.
  • Create and maintain, conceptual, logical and physical data models defining information requirements to meet end user needs.
  • Partner with development and QA teams to communicate the business rules, data models and ensure test cases target the quality and integrity of the data model.
  • Partner with DBAs to transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
  • Works closely with DBA on the DDLs creation, maintenance and optimization of the database.
  • Analytical ability and business acumen to collect multiple sources of data and draw conclusions.
  • Responsible for building solutions involving large data sets using SQL methodologies• Has strong analytical SQL experience working with dimensional modeling.
  • Deliver projects on-time and to specification with quality.

 

Qualifications:

  • 5+ years of experience working with datasets with strong understanding on how data should be optimized within transactional and big data architectures.
  • 2+ years of experience in health care industry working with healthcare data and major databases.
  • 2+ years of experience with Cloud strategy, architecture, migration and implementation using Azure / AWS / Hadoop• Develops large scale data models to organize and standardize data that helps generate insights and addresses transactional needs.
  • Uses knowledge in Hadoop and cloud technology architectures to determine optimized solution data structures.
  • Uses strong programming skills to assist in the data analysis and discover of the source data.
  • Has strong knowledge of large scale search applications and building high volume data pipelines
  • Expert knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases.
  • Expert knowledge in Hadoop architecture, HDFS commands and experience designing & optimizing queries against data in the HDFS environment.
  • Experience working in agile environment.
  • Ability to handle multiple tasks and adapt to a constantly changing environment.
  • Self-starter with the ability to work independently and take initiatives.
  • Expert hands on experience on any data modelling tools like Erwin, ER studio.
  • Ability to apply mastery knowledge in one of the relational data base (DB2, MSSQL, Teradata, Oracle 8i/9i/10g/11i)
  • Expert ability and hands on experience in SQL is a must
  • Experience with Unix/Linux and shell scripting
  • Strong analytical and problem solving skills
  • Excellent written and oral communication skills, with the ability to articulate and document processes and workflows for use by various individuals of varying technical abilities
  • Ability to learn new tools with minimum guidance and work independently.

 

Minimum Education:

MS/BS in Computer Science, Information Systems, or related field preferred and/or equivalent experience.

 

Additional Skills:

  • Ability to work both independently and in a collaborative environment
  • Excellent problem-solving skills, communication skills and interpersonal skills
  • Ability to demonstrate proficiency in Microsoft Access, Excel, Word, PowerPoint and Visio.
  • Reload from JCDD

 

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.