CGI Technologies and Solutions, Inc.
Senior Data Engineer
CGI Technologies and Solutions, Inc., Denver, Colorado, United States, 80285
CGI Technologies and Solutions, Inc. Senior Data Engineer Denver, Colorado Apply Now
Category:
Software Development/ EngineeringAlternate Location(s):
United States, Connecticut, BloomfieldPosition ID:
J1024-1748Employment Type:
Full TimePosition Description:CGI is seeking a Senior Data Engineer or Analyst for our Data Platform and Analytics Engineering (DPaAS) team in the Finance Technology group. The Senior Data Engineer will provide functional expertise and guidance for key data projects within DPaAS and bring expertise and industry-standard methodologies to define better development.The CGI Partner will be responsible for the functional requirements for new feature development to support the build-out of new and/or enhance existing data platform services in AWS Redshift and/or Oracle cloud environments, leveraging extensive experience in data analysis, design, and architecture supporting data engineering functions.Your future duties and responsibilities:Partner with client internal and vendor external teams in functional design, technical design, and guide the development of the Data Analytics platform.Gather and assess requirements and assist with translation into optimal analytical solutions.Facilitate client requirements and conversations through prototyping to gather requirements on KPIs and other reporting requirements.Translate and convert business requirements into Data Analytics functional design documents to support the business and technical teams.Deliver functional design documents that are comprehensible to end users and the technical team.Create source to target data lineage mapping documents for mapping and validating data elements from multiple source systems to the target system.Provide direction and guidance with mapping and validating data elements from multiple source systems to the target system.Walkthrough the functional design documents and related deliverables with the technical team and business team to seek sign-off.Responsible for providing functional guidance to technical resources.Review and provide feedback on the technical design documents from the technical team to ensure alignment with the functional design document and leverage best practices from a data warehousing perspective.Develop different ad-hoc and/or user-specific reports and queries to support the business team.Provide functional support in the form of research, documentation updates, and enhancement requests during the testing phase to ensure identified defects are valid and need to be addressed by the technical team.Support data reconciliation to ensure the KPIs, balances, and field-level data within dashboards/reports match expected outcomes to ensure data accuracy and completeness.Responsible for performing extensive data analysis & data mining leveraging various tools and summarizing the results/insights comprehensively.Required qualifications to be successful in this role:At least 8+ years of diverse technology experience with a minimum of 6 years’ experience in DWBI application design, development, and implementation.5+ years with skill sets in designing dimensional models, good knowledge of relational databases & data warehouses (AWS Redshift & Oracle experience preferred), SQL, PL/SQL, and functional experience in Tableau reports/dashboards.Experience in other BI/reporting tools such as ThoughtSpot, OBIEE, etc. will be a plus.Experience in documenting key deliverables such as Requirement Gathering, FIT/GAP Analysis, ETL specs, Business model design, Functional Design for Reports, and Data Mapping.Strong experience in customization & implementations of Data Warehouses using ETL and BI Reporting tools.Have a strong understanding of the BI architecture including physical data models, ETL, logical business models, and subject areas.Detail-oriented with strong experience in performing data analysis.Strong data management principles around data architecture, modeling/design, data quality, security, data organization, and operations.Education:
Bachelor's degree in computer science or related field.Compensation:
A reasonable estimate of the current range is $76,300 - $146,800.Skills:Data AnalysisOraclePowerBuilderPythonSQLWhat you can expect from us:Life at CGI is rooted in ownership, teamwork, respect, and belonging. 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. Come join our team—one of the largest IT and business consulting services firms in the world.Qualified applicants will receive consideration for employment without regard to legally protected status or characteristics.
#J-18808-Ljbffr
Category:
Software Development/ EngineeringAlternate Location(s):
United States, Connecticut, BloomfieldPosition ID:
J1024-1748Employment Type:
Full TimePosition Description:CGI is seeking a Senior Data Engineer or Analyst for our Data Platform and Analytics Engineering (DPaAS) team in the Finance Technology group. The Senior Data Engineer will provide functional expertise and guidance for key data projects within DPaAS and bring expertise and industry-standard methodologies to define better development.The CGI Partner will be responsible for the functional requirements for new feature development to support the build-out of new and/or enhance existing data platform services in AWS Redshift and/or Oracle cloud environments, leveraging extensive experience in data analysis, design, and architecture supporting data engineering functions.Your future duties and responsibilities:Partner with client internal and vendor external teams in functional design, technical design, and guide the development of the Data Analytics platform.Gather and assess requirements and assist with translation into optimal analytical solutions.Facilitate client requirements and conversations through prototyping to gather requirements on KPIs and other reporting requirements.Translate and convert business requirements into Data Analytics functional design documents to support the business and technical teams.Deliver functional design documents that are comprehensible to end users and the technical team.Create source to target data lineage mapping documents for mapping and validating data elements from multiple source systems to the target system.Provide direction and guidance with mapping and validating data elements from multiple source systems to the target system.Walkthrough the functional design documents and related deliverables with the technical team and business team to seek sign-off.Responsible for providing functional guidance to technical resources.Review and provide feedback on the technical design documents from the technical team to ensure alignment with the functional design document and leverage best practices from a data warehousing perspective.Develop different ad-hoc and/or user-specific reports and queries to support the business team.Provide functional support in the form of research, documentation updates, and enhancement requests during the testing phase to ensure identified defects are valid and need to be addressed by the technical team.Support data reconciliation to ensure the KPIs, balances, and field-level data within dashboards/reports match expected outcomes to ensure data accuracy and completeness.Responsible for performing extensive data analysis & data mining leveraging various tools and summarizing the results/insights comprehensively.Required qualifications to be successful in this role:At least 8+ years of diverse technology experience with a minimum of 6 years’ experience in DWBI application design, development, and implementation.5+ years with skill sets in designing dimensional models, good knowledge of relational databases & data warehouses (AWS Redshift & Oracle experience preferred), SQL, PL/SQL, and functional experience in Tableau reports/dashboards.Experience in other BI/reporting tools such as ThoughtSpot, OBIEE, etc. will be a plus.Experience in documenting key deliverables such as Requirement Gathering, FIT/GAP Analysis, ETL specs, Business model design, Functional Design for Reports, and Data Mapping.Strong experience in customization & implementations of Data Warehouses using ETL and BI Reporting tools.Have a strong understanding of the BI architecture including physical data models, ETL, logical business models, and subject areas.Detail-oriented with strong experience in performing data analysis.Strong data management principles around data architecture, modeling/design, data quality, security, data organization, and operations.Education:
Bachelor's degree in computer science or related field.Compensation:
A reasonable estimate of the current range is $76,300 - $146,800.Skills:Data AnalysisOraclePowerBuilderPythonSQLWhat you can expect from us:Life at CGI is rooted in ownership, teamwork, respect, and belonging. 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. Come join our team—one of the largest IT and business consulting services firms in the world.Qualified applicants will receive consideration for employment without regard to legally protected status or characteristics.
#J-18808-Ljbffr