About the role
About the Company
The Oracle Data Analyst is responsible for collecting, analyzing, validating, and reporting data stored within Oracle databases and Oracle-based business applications. This role supports the data validation between old and new Oracle systems to identify the root cause of the discrepancies(between old and new) and find ways to fix them without impacting other processes.
About the Role
This role supports the data validation between old and new Oracle systems to identify the root cause of the discrepancies(between old and new) and find ways to fix them without impacting other processes.
Responsibilities
Analyze large datasets from Oracle databases to identify discrepancies and perform root cause analysis to come up with solutions. Develop, maintain, and optimize SQL queries, stored procedures, and data extraction processes. Perform data validation, reconciliation, and quality assurance activities. Collaborate with business users to gather reporting and analytical requirements. Monitor data integrity and recommend improvements to data governance practices. Support data migration, integration, and transformation initiatives. Create and maintain documentation for data models, reports, and business rules. Troubleshoot data issues and provide timely resolutions. Leverage AI wherever possible to speed up the data discrepancy analysis. Assist in developing performance metrics and KPI reporting frameworks.
Qualifications
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business, or a related field.
Required Skills
Strong proficiency in Oracle SQL, PL/SQL and relational database concepts. 7+ years of experience in data analysis. Strong communication verbal and written communication skills. Ability to communicate with business users in business-friendly language. Oil and gas industry experience. Work with general direction and takes ownership of deliverables. Knowledge of ETL processes and data warehousing concepts. Strong analytical and problem-solving skills.
Preferred Skills
Informatica experience is preferred. Backend application development. Familiarity with data integration technologies. Understanding of data governance and master data management. Knowledge of Agile project methodologies.
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!
Similar Jobs
About the role
About the Company
The Oracle Data Analyst is responsible for collecting, analyzing, validating, and reporting data stored within Oracle databases and Oracle-based business applications. This role supports the data validation between old and new Oracle systems to identify the root cause of the discrepancies(between old and new) and find ways to fix them without impacting other processes.
About the Role
This role supports the data validation between old and new Oracle systems to identify the root cause of the discrepancies(between old and new) and find ways to fix them without impacting other processes.
Responsibilities
Analyze large datasets from Oracle databases to identify discrepancies and perform root cause analysis to come up with solutions. Develop, maintain, and optimize SQL queries, stored procedures, and data extraction processes. Perform data validation, reconciliation, and quality assurance activities. Collaborate with business users to gather reporting and analytical requirements. Monitor data integrity and recommend improvements to data governance practices. Support data migration, integration, and transformation initiatives. Create and maintain documentation for data models, reports, and business rules. Troubleshoot data issues and provide timely resolutions. Leverage AI wherever possible to speed up the data discrepancy analysis. Assist in developing performance metrics and KPI reporting frameworks.
Qualifications
Bachelor's degree in Computer Science, Information Systems, Data Analytics, Statistics, Business, or a related field.
Required Skills
Strong proficiency in Oracle SQL, PL/SQL and relational database concepts. 7+ years of experience in data analysis. Strong communication verbal and written communication skills. Ability to communicate with business users in business-friendly language. Oil and gas industry experience. Work with general direction and takes ownership of deliverables. Knowledge of ETL processes and data warehousing concepts. Strong analytical and problem-solving skills.
Preferred Skills
Informatica experience is preferred. Backend application development. Familiarity with data integration technologies. Understanding of data governance and master data management. Knowledge of Agile project methodologies.
About Affinity
Welcome to Affinity Group — your trusted partner in business and technology consulting. As a carbon-neutral company certified by ClimatePartner and recognized by the Globe and Mail as one of Canada's fastest-growing companies, we are dedicated to delivering an unrivalled experience for our employees, consultants, and clients.
Professional Excellence Across Disciplines:
- Cyber Security Solutions: Protecting your operations with cutting-edge security measures.
- Data Analytics and Business Intelligence: Transforming data into strategic insights.
- Digital Transformation: Pioneering digital innovations to future-proof your business.
- Enterprise Applications: Streamlining business processes through advanced software solutions.
- Project Management: Delivering projects with precision and efficiency.
- Technology Strategy & Architecture: Crafting robust IT frameworks to support scalable growth.
Delivering Tailored Solutions: We provide flexible, bespoke solutions designed to meet the specific demands of your business, driving your success forward with precision and innovation.
Global Reach with Affinity International: Expand your capabilities with our international talent solutions. Discover how we bring global expertise to your local and international projects at affinity-group.ca/international-companies.
Empowering Our Consultants: We are committed to facilitating professional growth and success. Explore a wide array of job opportunities through our referral program, AffinityEARN. Find your next challenge on our jobs page at affinity-group.ca/jobs or LinkedIn.
Ready to Enhance Your Business? Contact us today to discuss how we can support your goals. Email us at Sales@affinity-group.ca for inquiries and solutions tailored to your needs.
Join the innovative and supportive environment at Affinity Group, where we transform challenges into opportunities and individual potential into achievements. Discover more about how we can collaborate on our website below!