Data Modeler-Lousville, KY - Georgia IT Inc.
Lousville, KY
About the Job
Data Modeler
Location: Lousville, KY
Duration: Full Time
Salary plus Benefits
Job Description:
• Structured Query Language (SQL)
• ETL Power BI
• Microsoft Excel
• Critical Thinking
• R or Python-Statistical Programming
• Data Visualization
• Data Warehousing Experience in reviewing the output and potentially "clean it up" before presenting it back to a data steward or it custodian is very useful as is prior experience with Metadex or alternatives. Tasks include any of the items noted below:
• Identify and implement process improvements.
• Lead discussions with cross-functional teams.
• Align best practices and tools based on business needs.
• Responsible for the update of Information Asset Inventories and validation to ensure data and assets are classified appropriately.
• Review and validate metadata repository and metadata association. Improve metadata to add additional value to the organization.
• Support Data Lineage collection and stitching to ensure complete end to end data flow of critical data.
Review, validate, and record data quality information including data quality rules, thresholds, and standard metrics of quality for data elements that support critical business processes.
• Identify and maintain data quality corrective action plans.
• Support compliance assessment process by reviewing and documenting failures from data quality compliance assessment checks.
• Analysis of Root Causes to identify existing or merging risks. Identify opportunities to strengthen controls and reduce residual data quality risks.
• Recommend Master and Reference Data processes and procedures to align with Enterprise Policies and Standards.
• Create and maintain reference data in accordance to defined processes and procedures.
• Manage quality and maintenance of master data as it is created.
• Develop archiving and purging strategies and processes in steward capacity as needed.
• Partner with IT and Legal to ensure archiving and purging activities of data is in compliance with legal requirements.
• Support compliance assessment process by identifying and escalating items that may be a risk to the corporation.
• Partner with IT and other Information Management resources to define and implement Access Management strategies in alignment with Information Governance policies in a Steward capacity.
• Lead Privacy initiatives through classification and analysis of sensitive data.
• Ensure compliance and remediation of sensitive data in accordance to defined policies and processes as a steward. Minimum Requirements
• Bachelor's Degree in Business or Science discipline or 2 additional years of relevant data and analytics or technical experience can be substituted in lieu of a degree in addition to the minimum years of work experience.
• 3 years of experience in an information management practice, business application function, or data delivery;
• Proven experience applying data management practices and tools to address data management risks and concerns during data lifecycle.
• Intermediate SQL knowledge including SQL-based languages.
• Proven ability to build business knowledge through meaningful partnerships at the individual contributor through executive levels.
• Demonstrates the ability to lead efforts of analysis and resolution of problems or issues; identifies when and how to escalate problems to the appropriate level.
• Experience in synthesizing key information / data and research in order to recommend information management initiatives that meet business goals.
• Demonstrated expert communication skills with the ability to deliver presentations to all levels of management including concise presentation of complex technical details.
Location: Lousville, KY
Duration: Full Time
Salary plus Benefits
Job Description:
• Structured Query Language (SQL)
• ETL Power BI
• Microsoft Excel
• Critical Thinking
• R or Python-Statistical Programming
• Data Visualization
• Data Warehousing Experience in reviewing the output and potentially "clean it up" before presenting it back to a data steward or it custodian is very useful as is prior experience with Metadex or alternatives. Tasks include any of the items noted below:
• Identify and implement process improvements.
• Lead discussions with cross-functional teams.
• Align best practices and tools based on business needs.
• Responsible for the update of Information Asset Inventories and validation to ensure data and assets are classified appropriately.
• Review and validate metadata repository and metadata association. Improve metadata to add additional value to the organization.
• Support Data Lineage collection and stitching to ensure complete end to end data flow of critical data.
Review, validate, and record data quality information including data quality rules, thresholds, and standard metrics of quality for data elements that support critical business processes.
• Identify and maintain data quality corrective action plans.
• Support compliance assessment process by reviewing and documenting failures from data quality compliance assessment checks.
• Analysis of Root Causes to identify existing or merging risks. Identify opportunities to strengthen controls and reduce residual data quality risks.
• Recommend Master and Reference Data processes and procedures to align with Enterprise Policies and Standards.
• Create and maintain reference data in accordance to defined processes and procedures.
• Manage quality and maintenance of master data as it is created.
• Develop archiving and purging strategies and processes in steward capacity as needed.
• Partner with IT and Legal to ensure archiving and purging activities of data is in compliance with legal requirements.
• Support compliance assessment process by identifying and escalating items that may be a risk to the corporation.
• Partner with IT and other Information Management resources to define and implement Access Management strategies in alignment with Information Governance policies in a Steward capacity.
• Lead Privacy initiatives through classification and analysis of sensitive data.
• Ensure compliance and remediation of sensitive data in accordance to defined policies and processes as a steward. Minimum Requirements
• Bachelor's Degree in Business or Science discipline or 2 additional years of relevant data and analytics or technical experience can be substituted in lieu of a degree in addition to the minimum years of work experience.
• 3 years of experience in an information management practice, business application function, or data delivery;
• Proven experience applying data management practices and tools to address data management risks and concerns during data lifecycle.
• Intermediate SQL knowledge including SQL-based languages.
• Proven ability to build business knowledge through meaningful partnerships at the individual contributor through executive levels.
• Demonstrates the ability to lead efforts of analysis and resolution of problems or issues; identifies when and how to escalate problems to the appropriate level.
• Experience in synthesizing key information / data and research in order to recommend information management initiatives that meet business goals.
• Demonstrated expert communication skills with the ability to deliver presentations to all levels of management including concise presentation of complex technical details.
Source : Georgia IT Inc.