Design and develop systems for the maintenance of the business's data warehouse, ETL processes, and business intelligence. Design, development, testing and maintenance of enterprise data warehouse and enterprise integration services.
Accountable for the full cycle of consulting, design, coding, testing and documentation of the company's data warehouse. Work closely with data analysts, data scientists, and other data consumers within the business in an attempt to gather and populate data warehouse table structure, which is optimized for reporting. Responsible for the development of integrity, security, and processing of business data and files.
Design and supports the database and table schemas for new and existent data sources for the data warehouse. Design and development of Data Marts. Partners with Data modeler and Data architect in an attempt to refine the business's data requirements.
Develop/create and support the ETL in order to facilitate the accommodation of data into the warehouse using SSIS/Datastage and other technologies. Develop a new data engineering process that leverage a new cloud architecture and will extend or migrate our existing data pipelines to the new architecture as needed. Works with Senior Technical Analysts and Developers to translate requirements into technical specifications.
Participates in modernizing the EDW/platform by utilizing data architecture best practices. Collaborates with the EA team to build solutions that support VDOT's reporting, analytics, data exploration and data science needs. Leads process improvement initiatives and sets best practice standards for development.
This position is eligible for telework opportunities; availability, hours, and duration are at the sole discretion of the Department Manager in accordance with VDOT's Teleworking policy. Additional vacancies may be filled from this recruitment. VDOT is responsible for building, maintaining and operating the state's roads, bridges, tunnels and ferry systems.
Through the Commonwealth Transportation Board, VDOT also provides funding for airports, rail and public transportation. Virginia has the third largest state-maintained highway system in the country, employing just over 7,000 employees across the Commonwealth of Virginia. In addition to a rewarding work experience, VDOT offers core benefits including competitive health and life insurance programs, pre-tax spending accounts, and leave programs.
Employees participate in a State Retirement Plan; a tax-deferred Retirement Savings Plan with employer-matching provisions is also available. Employees are eligible for participation in a Short and Long Term Disability Program after one year of employment. Miscellaneous benefits include paid holidays, training and tuition assistance programs, wellness programs, etc.
VDOT is an Equal Opportunity Employer by both policy and practice. Applicants are considered for all positions without regard to race, sex, color, national origin, religion, age, veteran status, political affiliation, genetics, or against otherwise qualified persons with disabilities. It is the intent of VDOT's employment and personnel practices to conform to all applicable federal, state and local laws and regulations regarding non-discrimination.
AmeriCorps, Peace Corps and other national service alumni are encouraged to apply. View details and knowledge, skills and abilities for applicant evaluation at local VEC or http://www.vdot.jobs. TDD 1-800-828-1120.
VDOT employees have Shared Values and a Code of Ethics. http://www.virginiadot.org/about/missionandvalues.asp. We encourage all those who apply to review these values and ethics. If you share our values, we invite you to apply. Your success in our organization depends upon sharing these values and keeping this Code of Ethics.
Experience as a project lead or manager. extensively familiar with ETL (Extraction, Transformation & Load), data warehousing, and business intelligence tools such as business objects, PowerBI and Tableau. Advanced knowledge of database design and modeling in the context of data warehousing.
Understanding of Agile methodologies and processes. Skilled in diagnosing complex data warehouse ETL processes, business logic failures, and data flows, in order to quickly resolve issues. IBM Datastage, Erwin, SQL Server (SSIS, SSRS, SSAS), ORACLE, T-SQL, Azure SQL Database, Azure SQL Datawarehouse.
Operating System Environments (Windows, Unix, etc.). Scripting experience with Windows and/or Python, Linux Shell scripting. Experience with key data warehousing architectures including Kimball and Inmon, and broad experience designing solutions using a broad set of data stores (e.g., HDFS, Azure Data Lake Store, Azure Blob Storage, Azure SQL Data Warehouse, Azure CosmosDB. Extensive knowledge of data analytics technologies as well as analytical and dimensional modeling.
Must have knowledge of Excel, MS Project, MS Visio, and MS Team Foundation Server, which will all be necessary in the creation of visually and verbally engaging ETL, data designs and tables as well as the communication of documentation and reporting. College degree with major coursework in computer science, engineering, business administration or a related field; equivalent experience or training may substitute for degree.
Advanced understanding of data integrations. Strong knowledge of database architectures.
Strong analytical and problem solving skills. Ability to build strong relationships both internally and externally. Ability to negotiate and resolve conflicts.
Ability to effectively prioritize and handle multiple tasks and projects. Strong written and verbal communication skills.
This position requires a fingerprint based criminal history background check.
State Of Virginia