Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

IT Data Warehouse Lead Developer

Expired Job

State Of Virginia Richmond , VA 23234

Posted 2 months ago

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 TDD 1-800-828-1120.

VDOT employees have Shared Values and a Code of Ethics. 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.

Minimum Qualifications

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.

Preferred Qualifications

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.

Special Requirements

This position requires a fingerprint based criminal history background check.

See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Warehouse Lead

Niagara Bottling

Posted 3 days ago

VIEW JOBS 11/11/2018 12:00:00 AM 2019-02-09T00:00 At Niagara, we're looking for Team Members who want to be part of achieving our mission to provide our customers the highest quality most affordable bottled water. Consider applying here, if you want to: * Work in an entrepreneurial and dynamic environment with a chance to make an impact. * Develop lasting relationships with great people. * Have the opportunity to build a satisfying career. We offer competitive compensation and benefits packages for our Team Members. Warehouse Lead Job Summary The team member in this position is capable of performing all duties in the warehouse and is capable of training other team members on the various duties in the warehouse—forklift operation, shipping, receiving and inventory control. Detailed Description * Assigns tasks to team members. * Enforces operational procedures. * Provides guidance, support and direction to warehouse team members. * Covers breaks and lunches for warehouse team members. * Serves as back up for warehouse supervisor. * Supports a safety first philosophy. * Runs needed reports. * Inspects physical condition of warehouse equipment and the warehouse itself, insuring maintenance and housekeeping is occurring as scheduled. * Works with production supervisors to ensure coordination of warehouse activities with production activities. * Reports higher level issues to warehouse supervisor or manager. * Directs the salvage of damaged product and material. * Performs cycle counts and month end inventory. * Regular and predictable attendance. * Please note this job description is not designed to contain a comprehensive list of activities, duties or responsibilities that are required of the employee for this job. Duties, responsibilities and activities may change at any time with or without prior notice. Work Experience/KSA's * Required: * 2-4 years – Years of field experience * 2-4 years – Years of experience in position * 0-2 year(s) – Years of experience supervising team members * experience may include a combination of work experience and education * Preferred: * 3-5 years – Years of field experience * 2-4 years – Years of experience in position * 2-4 years – Years of experience supervising team members * experience may include a combination of work experience and education Competencies * Competent with all warehouse processes, procedures and equipment. * Ability to lead and motivate a group of team members. * Fosters trust and positive work environment * Customer and operational focus * Good verbal and written communication skills. * Ability to communicate and work well with different people at all levels. * Ability to work under pressure in fast paced environment. * Microsoft Office, Word, Excel, Outlook, Oracle. * Demonstrated ability to plan and problem solve in a complex and fluid production environment. * Must be a self-motivated and willing to make decisions with little supervision. * Ability to lead and develop a group of warehouse employees in daily activities. * Ability to create positive change through process improvements. * Ability to give, receive and analyze information. * Forklift certification and racking experience * JD Edwards, People Soft or similar WMS and TMS Education * Minimum Required: * High School Diploma or GED * Preferred: * High School Diploma Certification/License: * Required: forklift certification * Preferred: none Foreign Language * Required: Full Professional Proficiency, English * Preferred: Full Professional Proficiency, English Any employment agency, person or entity that submits a résumé into this career site or to a hiring manager does so with the understanding that the applicant's résumé will become the property of Niagara Bottling, LLC. Niagara Bottling, LLC will have the right to hire that applicant at its discretion without any fee owed to the submitting employment agency, person or entity. Employment agencies that have fee agreements with Niagara Bottling, LLC and have been engaged on a search shall submit résumé to the designated Niagara Bottling, LLC recruiter or, upon authorization, submit résumé into this career site to be eligible for placement fees. Niagara Bottling Richmond VA

IT Data Warehouse Lead Developer

Expired Job

State Of Virginia