| Technical Data Analyst || Location : HYBRID in Richmond, VA (3 days onsite a week) at Richmond, Virginia, USA |
| Email: [email protected] |
| From: Aniket Dhakar, Technocraft Solutions [email protected] Reply to: [email protected] Role: Technical Data Analyst Location : HYBRID in Richmond, VA (3 days onsite a week) Duration: 6 month contract with rolling extensions Position Summary: The Supreme Court of Virginia is seeking to fill an open project contract position of Technical Data Analyst, in the Department of Judicial Information Technologys Web Design Specialty Applications division (WDSA). We are transitioning from multiple legacy business applications and methods to a centralized Enterprise Resource Planning system (ERP). The Technical Data Analyst will perform the following activities to help support the new ERP as it relates to the business and functional areas of Human Resources, Fiscal/Finance, and Information Technology as follows: Conduct data cleansing from multiple database sources, collaborating with stakeholders to ensure accuracy and consistency. Assist in defining data ownership roles and responsibilities as required. Work closely with stakeholders to understand their data needs and provide appropriate solutions. Contribute to the definition and organization of company data assets to populate data models effectively. Assist in developing a strategy for the long-term data platform architecture to ensure scalability and efficiency. Document data-related processes thoroughly for transparency and future reference. Help define and implement data retention policies and procedures in accordance with Virginia State regulations and stakeholder needs. Support database performance by monitoring, evaluating, and suggesting resolution for processing and programming problems. Secure database by preparing access and control policies and procedures and implementing disaster recovery procedures. Essential Functions & Responsibilities: Data Analysis: Analyze volumes of data from various systems (external/internal) to identify trends, patterns, and anomalies. Generate actionable insights to improve business processes and decision-making. Query Data: Write and optimize complex SQL queries to retrieve, manipulate, and report on data efficiently. Troubleshoot and resolve performance issues related to data retrieval. Reporting and Visualization: Create and manage ad-hoc data reports and provide clear and actionable business insights to drive key decisions. System Integration: Organize sessions to collaborate with other IT professionals and business units to integrate systems and applications. Ensure seamless data flow and synchronization. Data Quality and Governance: Implement and enforce data quality standards and governance practices. Monitor and maintain data accuracy, consistency, and security. Documentation and Training: Develop comprehensive documentation for database schemas (using Data Dictionary, ERD/DFD etc.), queries, and data processes. Provide training and support to business user as needed. Continuous Improvement: Stay updated on the latest developments in Oracle technologies and ERP systems. Propose and implement enhancements to improve system performance and data management practices. Knowledge/Skills Required: Minimum of 5 years of experience in data analysis and development, specifically with Oracle/Sql databases (8 years preferred). Proven track record in designing, working, and optimizing database schemas. Strong experience with SQL, PL/SQL, and other database tools. Proficiency in Oracle/Sql database management and development. Experience with data modeling and schema design with Master Data Management (MDM) etc. Knowledge of data warehousing and ETL processes. Familiarity with reporting tools and data visualization. Strong analytical and problem-solving abilities. Experience with complex data analysis and reporting. Excellent verbal and written communication skills. Ability to present complex data findings in a clear and actionable manner to both technical-functional user groups. Additional Skills: Prefer experience with systems (e.g., Oracle E-Business Suite, SAP, etc.) is highly desirable. Knowledge of data privacy regulations and best practices. Strong understanding of software development methodologies (Agile, Waterfall, etc.). Database Querying (SQL, Oracle and/or Crystal). Understanding of the systems development lifecycle (SDLC). Familiarity with project management concepts and practices. Task entry and tracking via Jira (preferred). Adept at report writing and presenting findings. About Our Client: Our client is an Equal Opportunity Employer and maintains a drug-free workplace by both policy and practice. Applicants are considered for all positions without regard to race, color, religion, sex, sexual orientation, national origin, age, marital or veteran status, or the presence of a non-job-related medical condition. Employment and personnel practices conform to all applicable federal, state, and local laws and regulations regarding non-discrimination. While the Company is committed to following this principle in every facet of employment, all employees share in the responsibility to promote and foster a favorable work environment. Keywords: active directory information technology procedural language Virginia Technical Data Analyst || Location : HYBRID in Richmond, VA (3 days onsite a week) [email protected] |
| [email protected] View all |
| Thu Aug 08 21:46:00 UTC 2024 |