Capco, a Wipro Company
Sr. Data Analyst - PL/SQL
About the team:
Capco's Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client's business goals. As digital technologies advance and regulations tighten, today's consumers - and, therefore, today's businesses - are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.
About the Job:
As a member of our Sr. Data Team, you will be supporting and analyzing data anomalies for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. You will work closely with Business, DBA, ETL and Data Management teams providing analysis and support for complex Data related initiatives. This individual will also be responsible for assisting in initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions. We are looking for someone who has a passion for data, along with good SQL, analytical and communication skills.
What You'll Get to Do:
Investigate and Analyze data anomalies and data issues reported by Business
Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
Assist in break fix and production validation as it relates to data derivations, replication and structures
Assist in configuration and on-going setup of Data Virtualization tool
Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
Gather information from various Sources and interpret Patterns and Trends
What You'll Bring with You:
4+ years of SQL and PL/SQL experience working in OLTP, Data Warehouse and Big Data databases. PL/SQL is a must have
Previous Management Consulting experience
4+ years in a Data Analyst role
Strong attention to Detail
2+ years writing medium to complex stored procedures a plus
Ability to collaborate effectively and work as part of a team
Extensive background in writing complex queries
Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
Good communication skills and self motivated
Works well in a team environment
Denodo Experience a plus
Big Data Experience a plus (Hadoop, MongoDB, Exadata)
Why Capco?
A career at Capco is a chance to help reshape the competitive landscape in financial services. We launch new banks, transform existing ones, and help our clients navigate complex change. As consultants, we work on the front-end business design all the way through to technology implementation.
We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering.
Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or ability to focus on our clients and make a difference to the business. We offer the opportunity for everyone to learn rapidly, take on tough challenges, and get promoted quickly. We take pride in our creative, collaborative, diverse, and inclusive culture, where everyone can #BYAW.
We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees.
Ready to take the Next Step?
If this sounds like you, we would love to hear from you. This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.
We have been informed of several recruitment scams targeting the public. We strongly advise you to verify identities before engaging in recruitment related communication. All official Capco communication will be conducted via a Capco recruiter.
Individuals seeking employment at Capco are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation.
About the team:
Capco's Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client's business goals. As digital technologies advance and regulations tighten, today's consumers - and, therefore, today's businesses - are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.
About the Job:
As a member of our Sr. Data Team, you will be supporting and analyzing data anomalies for multiple environments including but not limited to Data Warehouse, ODS, Data Replication/ETL Data Management initiatives. You will work closely with Business, DBA, ETL and Data Management teams providing analysis and support for complex Data related initiatives. This individual will also be responsible for assisting in initial setup and on-going documentation/configuration related to Data Governance and Master Data Management solutions. We are looking for someone who has a passion for data, along with good SQL, analytical and communication skills.
What You'll Get to Do:
Investigate and Analyze data anomalies and data issues reported by Business
Work with ETL, Replication and DBA teams to determine data transformations, data movement and derivations and document accordingly
Work with support teams to ensure consistent and pro-active support methodologies are adhered to for all aspects of data movements and data transformations
Assist in break fix and production validation as it relates to data derivations, replication and structures
Assist in configuration and on-going setup of Data Virtualization tool
Assist in keeping documentation up to date as it relates to Data Standardization definitions, Data Dictionary and Data Lineage
Gather information from various Sources and interpret Patterns and Trends
What You'll Bring with You:
4+ years of SQL and PL/SQL experience working in OLTP, Data Warehouse and Big Data databases. PL/SQL is a must have
Previous Management Consulting experience
4+ years in a Data Analyst role
Strong attention to Detail
2+ years writing medium to complex stored procedures a plus
Ability to collaborate effectively and work as part of a team
Extensive background in writing complex queries
Extensive working knowledge of all aspects of Data Movement and Processing, including ETL, API, OLAP and best practices for data tracking
Good communication skills and self motivated
Works well in a team environment
Denodo Experience a plus
Big Data Experience a plus (Hadoop, MongoDB, Exadata)
Why Capco?
A career at Capco is a chance to help reshape the competitive landscape in financial services. We launch new banks, transform existing ones, and help our clients navigate complex change. As consultants, we work on the front-end business design all the way through to technology implementation.
We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering.
Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or ability to focus on our clients and make a difference to the business. We offer the opportunity for everyone to learn rapidly, take on tough challenges, and get promoted quickly. We take pride in our creative, collaborative, diverse, and inclusive culture, where everyone can #BYAW.
We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees.
Ready to take the Next Step?
If this sounds like you, we would love to hear from you. This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.
We have been informed of several recruitment scams targeting the public. We strongly advise you to verify identities before engaging in recruitment related communication. All official Capco communication will be conducted via a Capco recruiter.
Individuals seeking employment at Capco are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, gender identity, or sexual orientation.