Title: Data Manager
State Role Title: Salary Non-Specified
Hiring Range: Hiring range for this position is $82,668-$95,068, commensurate with education and experience
Pay Band: UG
Agency: VA Cannabis Control Authority
Location: VA Cannabis Control Authority
Agency Website: https://cca.virginia.gov/
Recruitment Type: General Public - G/ This position is contingent upon the approval of pending legislative actions.
Job Duties
Data Warehouse Architecture and Implementation
• Design and maintain an enterprise data warehouse integrating data from multiple sources.
• Develop and optimize database schemas, ETL/ELT pipelines, and SQL queries.
• Implement data governance, data quality, and documentation standards, including metadata and data dictionaries.
• Monitor and resolve data quality anomalies and inconsistencies.
• Develop and maintain reporting frameworks and recurring data needs
Security and Compliance
• Collaborate with the Information Security Officer to implement data security controls.
• Ensure compliance with state and federal data protection regulations and Authority policies.
• Implement access controls, data classification, audit trails, and remediation of audit findings.
Business Intelligence and Analysis
• Support business intelligence initiatives, analytics, and dashboards.
• Analyze market trends, consumer behavior, and inventory data to support strategic decision making.
• Serve as a primary point of contact for data requests and reporting needs.
• Summarize divisional key performance indicators for the CCA’s annual report.
• Produce surveys and analyze their results to evaluate and inform CCA programs.
Leadership, Collaboration, and Continuous Improvement
• Supervise, mentor, and evaluate a team of data analysts.
• Provide technical guidance and training on data standards, tools, and best practices.
• Collaborate with departments to ensure effective data management practices and to translate business needs into technical solutions.
• Identify and implement improvements to data infrastructure, processes, and technologies.
• Maintain professional, respectful, and service-oriented relationships with all stakeholders.
Other duties as assigned
• Follow workplace safety regulations and adhere to applicable standards, processes, and programs established for your position.
• Report unsafe work conditions to your supervisor.
• Immediately report work-related incidents to your supervisor and participate in accident investigation requests.
Minimum Qualifications
Knowledge, Skills, Abilities (KSA’s)
• Expert knowledge of database design, dimensional modeling, and data warehouse architecture.
• Advanced SQL proficiency and experience with ETL/ELT processes.
• Knowledge of data governance, data quality management, and metadata practices.
• Understanding of data security, privacy, and compliance in regulated environments.
• Strong analytical, organizational, and documentation skills.
• Excellent written and verbal communication skills for technical and non-technical audiences.
• Ability to work independently and collaboratively in a dynamic environment.
Education:
• Master’s Degree in Data Science, Statistics, Information Systems, Computer Science, Epidemiology, or related field; or a Bachelor’s degree with work experience that equates to an advanced degree, or equivalent combination of education and professional experience.
Experience:
• 3-5 years of experience in data management, database administration, or related roles.
• Demonstrated experience with data analysis and reporting.
• Experience writing complex SQL queries or other programming languages to manage databases.
• Experience handling sensitive or confidential data with appropriate security controls.
• Familiarity with business intelligence and analytics tools (Power BI, Tableau, etc.).
Additional Considerations
Preferred (Optional) Experience
• Experience designing and implementing data warehouses or data lakes.
• Experience with ETL/ELT tools and data integration platforms.
• Familiarity with data governance and compliance frameworks.
• Experience supervising teams or projects.
• Experience working in state government or highly regulated industries.
• Experience developing, executing, analyzing, and reporting survey findings.
• Prior collaboration with Information Security teams on data protection and compliance initiatives.
Special Instructions
You will be provided a confirmation of receipt when your application and/or résumé is submitted successfully. Please refer to “Your Application” in your account to check the status of your application for this position.
Contact Information
Name: Angela Nichols
Phone: (804) 540-2290
Email: angela.nichols@cca.virginia.gov
In support of the Commonwealth’s commitment to inclusion, we are encouraging individuals with disabilities to apply through the Commonwealth Alternative Hiring Process. To be considered for this opportunity, applicants will need to provide their AHP Letter (formerly COD) provided by the Department for Aging & Rehabilitative Services (DARS), or the Department for the Blind & Vision Impaired (DBVI). Service-Connected Veterans are encouraged to answer Veteran status questions and submit their disability documentation, if applicable, to DARS/DBVI to get their AHP Letter. Requesting an AHP Letter can be found at AHP Letter or by calling DARS at 800-552-5019.
Note Applicants who received a Certificate of Disability from DARS or DBVI dated between April 1, 2022- February 29, 2024, can still use that COD as applicable documentation for the Alternative Hiring Process.
Reasonable accommodations are available to individuals with disabilities during the application and/or interview processes per the Americans with Disabilities Act. Please call (804)653-9490 for assistance.
The Commonwealth of Virginia is an Equal Opportunity Employer. It is the policy of the Commonwealth of Virginia to prohibit discrimination on the basis of race, sex, color, national origin, religion, sexual orientation, gender identity or expression, age, veteran status, political affiliation, disability, genetic information, pregnancy, childbirth or related medical conditions in the recruitment, selection, and hiring of its workforce.
The Commonwealth of Virginia is located in the South Atlantic region of the United States. It was the 10th state to be admitted to the Union on June 25, 1788. Home to approximately 8 million residents, Virginia is the 12th most populous state in the United States. The capital is Richmond, and its most populous city is Virginia Beach.
The narrative history of the Commonwealth of Virginia often begins with the founding of Jamestown in 1607, near what is now modern day Williamsburg, Virginia. Jamestown became the first permanent English settlement in the New World, and the Virginia General Assembly, established on July 30, 1619, is now recognized as the oldest legislative body in the western hemisphere. When Virginia became a royal colony in 1624, the robust tobacco trade that had been developing in Virginia helped establish the American colonies as a powerful economic force. During the American Revolution, Virginia witnessed the final surrender of British forces at Yorktown and later became known as the birthplace of many revolution-era figures and future American presidents, including George Washington and Thomas Jefferson. To date, 8 United States presidents have been born in Virginia, more than in any other state.
The modern government of Virginia is nearly identical in structure to the federal government, and is divided into 3 branches, these being the executive, legislative, and judiciary branches. The Virginia General Assembly is comprised of the 100-member House of Delegates and the 40-member Senate. A governor and lieutenant governor are elected every 4 years. Governors cannot be elected to or serve consecutive terms. Virginia’s judicial system consists of the Supreme Court of Virginia and the Court of Appeals of Virginia, the Circuit Courts, and the lower General District Courts and the Juvenile and Domestic Relations District Courts. Virginia has 13 electoral votes in presidential elections, and possesses 11 seats in the U.S. House of Representatives.
