data warehouse architect North Chesterfield
Job description
Title: Data Warehouse Developer
Hiring Range: Negotiable and Commensurate with Experience
Pay Band: 6
Agency: Department of State Police
Location: North Chesterfield, Virginia
Agency Website: vsp.virginia.gov
Recruitment Type: General Public - G
Job Duties
We are seeking to expand our diverse team of change makers and innovators. As a member of the Virginia State Police family, you would make a difference by serving every city, county, town, resident, and visitor of the Commonwealth through supporting our vast public safety mission. Challenge yourself to make a difference today by applying for a career with the Virginia State Police!
Established in 1932, the Virginia State Police has grown to be the largest police department in the Commonwealth of Virginia. As the mission of the Department has continued to expand, our workforce continues to grow. We embrace our tradition of professionalism and excellence, and we are excited for our future as we continue our journey to become best in class. We are firmly committed to our family-like culture and are seeking to expand our diverse team. We provide an outstanding benefits package, including excellent health insurance, membership in the Virginia Retirement System, deferred compensation, paid leave starting on day one, and other benefits available to Commonwealth of Virginia Employees. Contact Human Resources for additional details.
- Performs hands-on analysis, design, development, and deployment of solutions.
- Designs and develops data warehouse, data modeling and data conversion solutions.
- Follows and improves standards and guidelines for coding, performance optimization, documentation, quality assurance, build deployment and production support.
- Develops product-based performance and scalability options to meet requirements.
- Develops Business Intelligence reporting applications and dashboards.
- Captures and analyzes business requirements for an Enterprise Data Warehouse (EDW).
- Prepares and presents recommendations for data warehouse/business intelligence solutions options that best achieve business needs; simplifies the data landscape, and increases the ability to discover, manage, and analyze data as a whole.
- Maintains a detailed knowledge base of the underlying data and data structures, and manage data content, current and potential future users, and the quality and integrity of data within the EDW.
- Maintains and improves to ensure a modern, robust, flexible, secure, reliable, and efficient technology environment.
- Designs varying levels of complex frameworks to support system-wide technical and business requirements.
- Works closely with the engineering and development teams to identify non-functional requirements, build out data visualizations and data access capabilities in support of business requirements.
- Ensures training, cross training/knowledge transfer occurs for self, team members, across teams and clients.
- Keeps up to date on database warehouse/business intelligence products and technologies.
- Assists and provides direction to co-workers in using new techniques and in solving their more complex technical problems.
Minimum Qualifications
- Considerable knowledge of information systems technology management, data warehousing, and analytics technologies; of large data repositories and/or relational databases; of business intelligence tools; of Oracle, UNIX, and SQL Server environments; and of the analysis, design, and development of data warehouses.
- Skill in the use of computers and using Microsoft Office Applications; extract, transform, and load (ETL) experience with Oracle Data Integrator, and Business Intelligence tools - SAP Business Objects.
- Demonstrated ability to communicate and translate business needs into solutions; to work with large data repositories and/or relational databases; to work with business intelligence tools to analyze data to identify trends or relationships among variables; to work in Oracle and UNIX environments; to provide training on new techniques and solving technical problems; to establish and maintain and efficient technology environment; to provide training on new techniques and solve technical problems; to work effectively independently and as a member of a team; to communicate effectively in English orally and in writing; to maintain an efficient technology environment, and ability to establish and maintain effective working relationships with colleagues, business analysts, data base administrators, information security, project managers, and the general public.
- High School diploma or GED equivalent.
- Experience working with large data repositories and/or relational databases.
- An equivalent combination of training and experience indicating possession of the preceding knowledge, skills, and abilities may substitute for this education and experience.
Preferred Qualifications:
- Graduation from an accredited college or university with a major in information systems, computer science, or related field preferred.
Special Instructions:
A BACKGROUND INVESTIGATION SHALL BE REQUIRED OF EACH SELECTED APPLICANT
Elements of the selection process include the screening of application(s); the interviewing of qualified candidate(s), to include pre-employment testing, a presentation and/or a work sample, if applicable; salary negotiation(s) if applicable; a background investigation; and a medical evaluation if applicable. The anticipated duration of the pre-employment process is determined by the successful completion of the above items.
Applications, cover letters and/or resumes shall only be accepted on-line through the PageUp recruitment management system at https://jobs.virginia.gov. This position is open until filled. Please limit resumes to four pages and cover letters to one page. Any additional attachments received in excess of this will not be considered.
PageUp provides a confirmation of receipt of your application, resume and/or cover letter submitted successfully. Please refer to your PageUp account to check the status of your application for this position. For questions, please contact the Employment Unit of the Human Resources Division at [email protected].
The Department of State Police is an Equal Opportunity Employer. Our policy is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual’s race, color, gender, age, national origin, religion, citizenship status, marital status, sexual orientation, gender identity or expression, transgender status, physical or mental disability, protected veteran status, genetic information, pregnancy, parental status, political affiliation or any other categories protected by applicable federal, state or local laws.
REASONABLE ACCOMMODATIONS ARE AVAILABLE UPON REQUEST
(V)alor (S)ervice (P)ride
About Commonwealth of Virginia
CEO: Terry R. McAuliffe
Revenue: $25 to $100 million (USD)
Size: 10000+ Employees
Type: Government
Website: www.virginia.gov
Year Founded: 1788
