PL/SQL Data Analyst

Role: PL/SQL Data Analyst

Location: Uptown (Dallas), ONE dayonsite Duration: 18-24+ months. They will renew every 6 months

Management consulting experience HIGHLY desired About the team: Data Team helps our clients transform every aspect of their business. Weare highly skilled at formulating data strategy, defining business andtechnology initiatives across the data management lifecycle, and aligningmulti-year strategic roadmaps with client’s business goals. As digitaltechnologies advance and regulations tighten, today’s consumers – and,therefore, today’s businesses – are becoming more aware of the importance ofgood quality data. We work to establish holistic ways to effectively managedata through the modern data supply chain and facilitate consumption throughanalytics, modelling, AI, machine learning, dashboarding, and reporting. About the Job: As a member of our Sr. Data Team, you will be supporting and analyzing dataanomalies for multiple environments including but not limited to DataWarehouse, ODS, Data Replication/ETL Data Management initiatives. You will workclosely with Business, DBA, ETL and Data Management teams providing analysisand support for complex Data related initiatives. This individual will also beresponsible for assisting in initial setup and on-goingdocumentation/configuration related to Data Governance and Master DataManagement 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 the 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 proactive 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 ongoing 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)