Technical Data Analyst
Fully Remote! Salary Range is 160k to 180k.
You will work as a member of the DMO (Data Management Office), to perform activities required to provide effective control of banking data.
Principal Duties and Responsibilities
Provide Technical services for the DMO team to support the following activities DMO performs
Data Quality Profiling
- Maintain Data Quality rules in IBM InfoSphere for select processes onboarded by DMO
- Work with DMO Function Leads and data analysts to create new Data Quality Rules by interpreting technical details / SQL Queries etc. that would help create logic for capturing data quality issues
- Troubleshoot IBM technical issues and manage upgrades
- Support DMO production processes on daily basis
Data Lineage
- Utilize Manta tool for producing Data lineage automatically and troubleshoot technical issues and manage upgrades.
- Decipher technical documentation, Data Flow diagrams, SQL Queries, Stored Procedures, SSIS packages and various scripts to document Data Lineage manually where required.
- Review the Data Lineage with IT and DMO data analysts
Qualifications
- Bachelor’s degree in finance, accounting, business, economics, mathematics, physics, or computer science
- Prior working experience in Financial Industry / Data Governance / Data Management Office
- At least 10+ Years working with Databases such as SQL Server & Oracle (Advanced SQL Writing skills)
- At least 5+ Years working IBM InfoSphere and Manta
- Programming experience in VBA / .NET / C# / Python, Advanced Excel skills