What are the responsibilities and job description for the Data Quality Control Analyst position at Insight Global?
Project ObjectiveThe main aim of this project is to design and implement a data quality control mechanism to validate the accuracy and completeness of CMDB (Configuration Management Database) application-CI (Configuration Items) to server relationship data. Ensuring data integrity within the CMDB is critical for the efficiency and reliability of IT operations and services.ScopeThe scope of this project includes the following key activities : 1. Data Source IdentificationIdentify independent data sources that can be used for validating the relationship data. These data sources must be reliable, accurate, and capable of providing the necessary information for comprehensive validation. Potential data sources include but are not limited to : Existing IT infrastructure databases Network management tools Server inventory systems Manual records and spreadsheets2. Automated Data Extraction and AggregationDevelop an automate process to extract and aggregate data from these identified sources. This process will involve : Designing an extraction method that can interface with multiple data sources Aggregating the extracted data into a unified format for analysis Performing validations against the existing CMDB application data to identify discrepancies Ensuring the automated process is robust, scalable, and maintainable3. Handling Unavailable Source DataIn cases where source data is unavailable, identify and document the approaches necessary to capture the dataset for future automation. This will involve : Analyzing the gaps in available data Developing strategies to capture the missing data Documenting the necessary steps and tools required for capturing the data Implementing manual data validation controls as interim solutionsDeliverablesThe delivery of this project includes the following key components : 1. Documented Data RequirementsA comprehensive documentation of data requirements, including sources and owners, will be provided. This document will outline : The types of data required for validation The sources from which the data will be obtained The ownership and responsibilities associated with each data source Any data quality and integrity standards that must be met2. Data Flow and Process Flow ChartsDetailed data flow and process flow charts for the automated data validation process will be developed. These charts will illustrate : The flow of data from source extraction to aggregation The validation steps and checks performed on the data The integration points with the CMDB application The overall process architecture and workflow3. Implemented Automated ControlThe implementation of automated control for validating CMDB Application CI to server relationship data will be completed. In cases where automation isn't feasible due to the lack of data, the following will be documented and implemented : The approach to capture the necessary data Manual data validation controls as interim measures Plans for transitioning from manual to automated controls as data becomes availableProject Management and TimelineThis section will outline the project management approach and timeline for the project. Key milestones and deliverables will be highlighted, along with the project schedule.1. Project PlanningThe project will kick off with a planning phase, which includes : Defining the project scope and objectives Establishing a project team and assigning roles and responsibilities Creating a detailed project plan with timelines and milestones2. Implementation PhasesThe project will be executed in multiple phases to ensure a structured and systematic approach : Phase 1 : Data Source Identification Conducting a thorough analysis of potential data sources Engaging with data owners to secure accessPhase 2 : Automated Data Extraction and AggregationDeveloping the automated extraction and aggregation processTesting the process with sample dataPhase 3 : Data Validation and Control ImplementationValidating the extracted data against CMDB application dataImplementing automated and manual controls as required3. Monitoring and ReportingContinuous monitoring and reporting will be essential to track the progress and ensure the project's success : Regular status updates and progress reports Periodic reviews and evaluations of the implemented controls Adjusting the project plan as needed based on feedback and findingsConclusionThis project aims to enhance the accuracy and completeness of CMDB application-CI to server relationship data through a comprehensive data quality control mechanism. By identifying and validating independent data sources, developing automated processes, and implementing necessary controls, the project will significantly improve data integrity within the CMDB. The documented deliverables will provide a clear and structured approach for ongoing data validation and management.The successful execution of this project will not only ensure the reliability of IT operations but also support future automation and data management initiatives within the organization.We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity / affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and / or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com . To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy : https : / / insightglobal.com / workforce-privacy-policy / . Required Skills & ExperienceBenefit packages for this role will start on the 31st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and / or other paid time off as provided by applicable law.
