Overview: We are looking for a Technical Data Analyst whose primary job responsibilities would be to perform analysis on Master Data, Transactional and Analytical data. The company is in the process of implementing an ERP system along with many other applications rationalizing key business processes. We are looking for someone who can parse through existing business processes and recognize all the data elements that are being ingested by those processes. Someone who can help us create scripts for data analysis, data conversion, data dictionary / data glossary, data definitions, etc.
*Please Note this position is NOT related to enterprise analytics, business intelligence, big data or data science. We are looking for someone who has data analysis experience in ERP related Master Data Conversion Projects.
Key Responsibilities:
- Work with our business stakeholders to understand the current business processes and document various data elements and sources of data used by those process
- Perform data analysis by digging into the SQL scripts and help us put together the data requirements for the business process
- Work with application teams, SMEs to understand source systems and produce mapping documents for new solutions.
- Study / Analyze source application documents, data models, data profiling and flush out technical requirement documents.
- Good understanding and prior experience in working with ERP conversion/migration projects for data analysis and data conversions.
- Study / Analyze source application documents, data models, data profiling and flush out technical requirement documents.
- Write SQL Code for Data Profiling, Data Quality & Data Validation
- Work with technical teams to build the desired solution as per requirements
- Perform Data validation
- Devise logic procedures, prepare flowcharts, perform ETL/coding, and test/debug output
Key Skills:
- At least 8-10 years of experience writing complex T-SQL queries (SQL Server)
- At least 8-10 years of experience with SQL Server (Stored procedures, Views, etc.)
- Be able to write analyze and tune complex T-SQL scripts
- At least 8 years of experience in data analysis and creating scripts for data validations
- Writing SQL Code for Data Profiling, Data Quality & Data Validation
- Experience with ERP Master Data Conversions.
- Agility to work with cross functional teams
- Have excellent communication skills and partner with both Business & Technology stakeholders
- Strong Analytical and problem-solving skills
- Good to have knowledge of Data Modeling, Data Warehousing, and data virtualization concepts.