Data Modeler

Data ModelerCategory: Software Development/ Engineering Main location: United States, Connecticut, Bloomfield Position ID: J0826-1819 Employment Type: Full TimeCGI is seeking to hire an experienced Data Modeler to support enterprise data design initiatives for a healthcare client. The consultant will translate business and technical requirements into conceptual, logical, and physical data models; develop source to target mappings; and profile data across enterprise platforms. Strong SQL and data warehousing expertise are essential, and healthcare or payer experience is strongly preferred. This position is located on-site in Bloomfield, CT (Preferred), Lafayette, LA in a Hybrid working Model.Design, document, and maintain conceptual, logical, and physical data models for enterprise data initiatives. Develop and validate source to target mappings for data integration, migration, and transformation efforts. Profile source data to assess structure, completeness, consistency, and data quality issues. Write and optimize SQL for data analysis, validation, reconciliation, and warehouse environments. Collaborate with data architects, engineers, subject matter experts, and business stakeholders to translate requirements into scalable data designs. Maintain model documentation, definitions, and standards to support shared understanding and traceability. Contribute to enterprise data governance, design reviews, and continuous improvement activities.At least 6-10 years of experience as a Data Modeler: Demonstrated experience in data modeling and database design, including conceptual, logical, and physical models. Hands on experience developing and documenting source to target mappings. Hands on experience with Erwin Data Modeler. Strong data analysis and profiling skills, including the ability to identify and communicate data quality issues. Advanced SQL skills and practical experience working with data warehouse environments. Strong SQL and data warehousing expertise are essential, and healthcare or payer experience is strongly preferred. Ability to translate business and technical requirements into clear, implementable data designs and 's degree in computer science or related field.Together, as owners, let's turn meaningful insights into action. Life at CGI is rooted in ownership, teamwork, respect and belonging. Here, you'll reach your full potential because… You are invited to be an owner from day 1 as we work together to bring our Dream to life. That's why we call ourselves CGI Partners rather than employees. We benefit from our collective success and actively shape our company's strategy and direction. Your work creates value. You'll develop innovative solutions and build relationships with teammates and clients while accessing global capabilities to scale your ideas, embrace new opportunities, and benefit from expansive industry and technology expertise. You'll shape your career by joining a company built to grow and last. You'll be supported by leaders who care about your health and well-being and provide you with opportunities to deepen your skills and broaden your horizons. Come join our team—one of the largest IT and business consulting services firms in the world.