Data Modeler

Key Skills

PowerBI, SQL Server, ETL/ELT technologies, Informatica, Data Engineering

Job Description

CGI is looking for a Data Modeler to join the Credit development team. This is an exciting opportunity to work in a fast-paced, Agile team environment The Data Modeler will work with Subject Matter Experts (SMEs) to analyze, discover, define and document data structures organized around objects that relate to the application. The member will develop conceptual, logical and physical data models for OLTP, OLAP databases. This career opportunity is open to all locations across the U.S., but the member must be available to work during mountain work hours.

Your future duties and responsibilities:

• Understand and translate business needs into data models supporting long-term solutions for relational databases.
• Work with database team to implement data strategies, build data flows and develop conceptual data models.
• Build logical and physical data models using standard processes to ensure high data quality and reduced duplication.
• Optimize/update logical and physical data models to support the new requirements. Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments. Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies. Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Develop data models according to standard processes.

Required qualifications to be successful in this role:

2-3 years experience in SQL writing and Data Analysis

• 2-3 years experience in understanding RI, constraints, data relation and flow
• 2-3 years of experience in several types of databases – DB2 (LUW/Mainframe), Oracle, PostgreSQL, SQL Server, others
• 2-3 experience in analyzing the database and working with Solution Architect to come up with solution design per business and application needs
• Expertise in communicating with DBA, understanding all DBA terminologies and working closely with them.
• Experience in testing, debugging and solution crafting
• Experience in requirement gathering
• Experience with production environment handling
• Experience in solely handling client business calls and collecting requirements and working with client DBAs.
• Education: Bachelor's Degree or a level of education, training and experience equivalent to a Bachelor's Degree in related field.

At CGI we call our professionals “members” to reinforce that all who join our team are, as owners, empowered to participate in the challenges and rewards that come from building an extraordinary company. CGI’s benefits include:

Competitive base salaries

Eligibility to participate in an attractive Share Purchase Plan (SPP) in which the company matches dollar-for-dollar contributions made by eligible employees, up to a maximum, for their job category

401(k) Plan and Profit Participation for eligible members

Generous holidays, vacation, and sick leave plans

Comprehensive insurance plans that include, among other benefits, medical, dental, vision, life, disability, out-of-county emergency coverage in all countries of employment;

Back-up child care, Pet insurance, a Member Assistance Program, a 529 college savings program, a personal financial management tool, lifestyle management programs and more

Skills:

• Data Analysis
• Postgre SQL
• Solutions Architecture
• SQL Server

What you can expect from us:

Insights you can act on

While technology is at the heart of our clients’ digital transformation, we understand that people are at the heart of business success.

When you join CGI, you become a trusted advisor, collaborating with colleagues and clients to bring forward actionable insights that deliver meaningful and sustainable outcomes. We call our employees “members” because they are CGI shareholders and owners and owners who enjoy working and growing together to build a company we are proud of. This has been our Dream since 1976, and it has brought us to where we are today — one of the world’s largest independent providers of IT and business consulting services.

At CGI, we recognize the richness that diversity brings. We strive to create a work culture where all belong and collaborate with clients in building more inclusive communities. As an equal-opportunity employer, we want to empower all our members to succeed and grow. If you require an accommodation at any point during the recruitment process, please let us know. We will be happy to assist.

Ready to become part of our success story? Join CGI — where your ideas and actions make a difference.

Qualified applicants will receive consideration for employment without regard to their race, ethnicity, ancestry, color, sex, religion, creed, age, national origin, citizenship status, disability, pregnancy, medical condition, military and veteran status, marital status, sexual orientation or perceived sexual orientation, gender, gender identity, and gender expression, familial status, political affiliation, genetic information, or any other legally protected status or characteristics.