Current opportunities >> Position Details >>

Position Details

Job order - J0717-1352 - Permanent Full Time
Title Data Modeler
Category Software Development/ Engineering
City Owings Mills, Maryland, United States

Job Description Data Modeler

Position Description
Seeking a Data Modeler who will work with multiple teams to identify, design and build appropriate dataset and linkages for complex data.


Your future duties and responsibilities
• Support refactoring legacy systems into microservices which integrate with a Hadoop data lake.
• Contribute to evaluating and selecting new tools for data management and promoting industry best data management practices among the development teams.
• Manage metadata for all data sources within a Hadoop data lake.
• Organize, deliver, and ensure data integration support.
• Develops/manages complex data models (conceptual, logical, & physical) in multiple formats (relational, star/snowflake, object-oriented, etc..)
• Analyzes & acquires data from primary and secondary data sources – creating mapping specifications/requirements for use by ETL development resources
• Maintains knowledge on current and emerging developments/trends for assigned areas of responsibility, assesses the impact, and collaborates with management to incorporate new trends and developments in current and future solutions.
• Identifies and recommends process improvements that significantly reduce workloads or improve quality for his/her assigned areas of responsibility.
• Determines how existing applications, systems, databases, interfaces and/or hardware can interact to meet new and emerging enterprise initiatives.
• Provides input and validates project plans, test plans and implementation plans.
• Consults and/or participates in the requirements, design and coding walkthroughs to ensure the development of quality solutions.
• Proactively identifies problems and presents/develops solutions
• Communicates effectively with internal stakeholders and management.



Required qualifications to be successful in this role
Required Skills/Experience:
• 5+ Years of experience implementing relational database designs, data warehousing, data architecture, & data modeling, including strong knowledge of various data modeling approaches and practices (experience with 3NF, star schemas, and multi-dimensional designs)
• 6+ years SQL experience
• 5+ years creating physical data models for relational databases.
• 4+ years of experience working in Hadoop environment, including HDFS, Hive, Sqoop, HBase, Pig, Flume, Parquet, Avro and/or Spark.
• 3+ years of Experience with XML, UML and JSON.
• Knowledge of Informatics, analytics, computational science and service management.
• Experience with ERwin Enterprise Data Modeler or equivalent modeling software.
• Strong written and verbal communication skills.
Nice To Have:
• Understanding of NoSQL databases.
• Ability to logically model healthcare data.
• Experience working with Agile methodologies.



Build your career with us.

It is an extraordinary time to be in business. As digital transformation continues to accelerate, CGI is at the center of this change—supporting our clients’ digital journeys and offering our professionals exciting career opportunities.

At CGI, our success comes from the talent and commitment of our professionals. As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership. All of our professionals benefit from the value we collectively create.

Be part of building one of the largest independent technology and business services firms in the world.

Learn more about CGI at www.cgi.com.

No unsolicited agency referrals please.

CGI is an equal opportunity employer.

Qualified applicants will receive consideration for employment without regard to their race, color, religion, sex, gender Identity, sexual orientation, national origin, age, disability, veteran status, pregnancy, or other status protected by law. CGI will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with CGI’s legal duty to furnish information.




Skills

Reference 560852

Click here to apply