Current opportunities >> Position Details >>
Position Details Job order - J0123-2707 - Permanent Full Time Title Data Modeler Category Software Development/ Engineering City Halifax, Nova Scotia, Canada Job Description Data Modeler Position Description CGI is offering an exciting opportunity as a Data Modeler in a digital environment. As a senior member of CGI’s national data practice providing retail banking solutions and services to credit unions, you will be joining an experienced and dynamic team of global IT professionals serving our clients across Canada and the world. As the data modeler, you will lead the activities associated with designing, developing and enhancing a multi-layer data storage and access solution. Your knowledge of data modelling, data profiling, data analysis and Database development as well as your agile delivery experience will be leveraged to assist with enabling and enriching our strategic data services roadmap. In addition to working on a small team of dedicated IT professionals, you will collaborate directly with the CGI management team and progressive clients. Your passion for researching new data-centric technologies and tools, ability to articulate the pros and cons of various data modelling concepts, and your proficiency for designing and developing data solutions will be relied upon to promote success throughout our journey. If you are searching for a role that allows you to apply your data modelling knowledge and expertise in an exciting environment and work on a team that is eager to collaborate and propel data-centric solutions, this is definitely opportunity is for you. Key Responsibilities: • Understand and translate business needs into data models supporting long-term solutions • Work with the overall application development team to implement new data strategies, build data flows and develop data models • Design and creation of ETL process from disparate data sources • Create logical and physical data models using best practices to ensure high data quality and reduced redundancy • Optimize and update logical and physical data models to support new and existing projects • Maintain conceptual, logical and physical data models along with corresponding metadata • Design the migration of existing ON PREM Datawarehouse / legacy data solution to Azure. • Design Gateways for bridging ON PREM and Azure Databases. • Design and implement a centralized data security and access control using windows active directory • Perform reverse engineering of physical data models from databases and SQL scripts • Evaluate data models and physical databases for variances and discrepancies. • Analyze data-related system integration challenges and propose appropriate solutions. • Guide your team members and other on available data driven capabilities as well as limitations, performance requirements and associated interfaces • Design and development of SQL Server Datawarehouse and DataMart • Performance enhancement of existing Datawarehouse for faster data retrieval by the reporting tools. Must Have Requirements: • Minimum 10+ years of experience in Information Technology and 7+ years of Data Modeling experience. • Demonstrated experience in designing and developing complex SQL Server Data warehousing solutions • Demonstrated Experience in BI, ETL (SSIS), Data Warehousing, ODS Data Marts, and performance tuning methods. • Proven track record of experience in data modeling and evaluating data from multiple sources, reconciling conflicts, decomposing high-level data into details as well as taking details and bringing to a higher level for general communication. • Experience with data profiling, cleansing, and conforming rules. • Demonstrated experience developing, validating, publishing, maintaining LOGICAL and PHYSICAL data models • Demonstrated experience using common data modeling tools and technologies • Demonstrated experience in developing, publishing, and maintaining all documentation for data models • Demonstrated experience working with the De-Normalized/OLAP systems is mandatory • Demonstrated experience with tools such as Erwin or ER-Studio • Good understanding of the OLTP/Transactional/3NF Data Modelling concepts is needed • Demonstrated experience with designing and building different types of Transactional, Periodic Snapshot and Accumulating snapshot Fact tables • Demonstrated experience with designing Dimension tables including population of Slowly Changing Dimensions • Demonstrated experience with gracefully extending the current Data warehouse artifacts • Demonstrated experience with documenting the Data warehouse tables using Enterprise Business Matrix Nice to Have Requirements: • Strong experience with MS SQL Server, MySQL databases is preferred. • Exposure to AWS & Azure Cloud based technologies is highly preferred • Knowledge of emerging modeling techniques and experience in physical data modeling for relational and NoSQL/unstructured databases. • Knowledge and experience working specifically in the retail banking and/or credit union space • Knowledge of data governance principles and best practices • Experience working with dimensionally modeled data in the financial domain • Experience designing BI solutions using Microsoft technology solutions: SQL Server SSAS, SSRS & Power BI Required Level of Education: • Bachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience Position is based in Halifax, Nova Scotia. Must have authorization to work in Canada. *LI-AD1 Your future duties and responsibilities Required qualifications to be successful in this role 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. Skills Data Analysis Data Modeling SQL Data Engineering Data Warehousing Data Visualisation Reference 1032279 Click here to apply