Job Description

Job Title: Data Modeler/Architect
Job Number: 21118
Duration of Contract: 6 Months


Great opportunity to secure a fully remote role!

Our client is searching for an experienced Data Modeler/Architect to join their team. Must have ability to work both independently and collaboratively.  Successful candidates will have excellent solutioning and communication skills.  Proven track record of delivering projects on on-time and with defined scope.

Opportunity Overview:
  • Manage the flow of data from various data sources.
  • Develops Data Models on different data organization platforms to include 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.
  • Create and maintain, conceptual, logical and physical data models defining information requirements to meet end user needs.
  • Collaborate 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.
  • Responsible for assisting with transform logical data models into physical database designs while optimizing the performance and maintainability of the physical database
  • Assists with DDLs creation, maintenance and optimization of the database.
  • 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.
Qualifications & Required Skills:
  • Work with relevant teams and individual to define requirements and translate them into Conceptual, Logical and Physical models.
  • 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.
  • 7+ years of experience working with datasets with strong understanding on how data should be optimized within transactional and big data architectures.
  • 3+ years of experience in health care industry working with extensive amounts of 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.
  •  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.
  • 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.

Educational Requirements:
  • MS/BS in Computer Science, Information Systems, or related field preferred and/or equivalent experience.
Work location and Additional Info:
100% remote

Overture Partners is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, national origin, disability, sexual orientation, gender identity or expression, marital status, genetic information, protected veteran status, or other factors protected by federal, state, and/or local law.





 

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online