IT Data Engineer - Virginia Beach, United States - City of Virginia Beach
Description
This position will be filled as a Systems Engineer I ($70, $108, or a Systems Engineer II ($77, $120, depending on qualifications. The Systems Engineer I/II will work on one or more projects simultaneously to support multiple Communities of Interest (COI).Selected candidate will work closely with the team, other IT teams and COI members to:
The Systems Engineer I job duties include but are not limited to:
Data Management :
Maintain and support data analytics platforms, integrate data sources, and work primarily with SQL Server databases including unstructured data.
Data Analysis :
Translate business needs into technical specifications, design and develop data visualization reports and dashboards, perform data analysis to troubleshoot data-related issues and write basic queries.
Data Warehousing :
Participate in data warehouse development, assist in build ETL processes, data models and data integration processes, perform regression, and system testing.
Technical Documentation :
Develop and update technical documentation and communicate regularly with technical, applications, and operational staff to ensure database integrity, security, and optimized performance.
Data Quality :
Identify, communicate, and resolve data quality and data reconciliation issues.
Collaboration :
Work closely with frontend and backend engineers, product managers, analysts, and all business units and engineering teams.
The Systems Engineer II job duties include but are not limited to:
Data Management :
Maintain and support data analytics platforms, integrate complex data sources, and work with SQL Server and other databases including unstructured data.
Data Analysis :
Translate business needs into technical specifications, design and develop complex data visualization reports and dashboards, perform data analysis to troubleshoot data-related issues, write complex queries and perform query optimization.
Data Warehousing :
Design and develop data warehouses, build ETL processes, data models and data integration processes, perform regression, and system testing.
Technical Documentation :
Develop and update technical documentation and communicate regularly with technical, applications, and operational staff to ensure database integrity, security, and optimized performance.
Data Quality :
Identify, communicate, and resolve data quality and data reconciliation issues. Design and develop data quality processes.
Collaboration :
Work closely with frontend and backend engineers, product managers, analysts, and all business units and engineering teams. Research and develop governance, strategy for long-term data platform architecture to support required data infrastructure needs.
This position offers a remote/hybrid work schedule arrangement within the Hampton Roads area.
The City offers a generous and competitive benefits package, which includes health, dental, and life insurance, retirement and savings plans, maternity/paternity leave, holidays, and Paid-Time-Off.
CJIS/PREA Disclaimer:
***This position will provide direct support to the City's Public Safety departments and will have physical access to public safety buildings and/or access to confidential and sensitive public safety databases. As such, and in compliance with federal regulations and guidelines, City of Virginia Beach IT staff and contractors must receive a Criminal Justice Information Systems (CJIS) and may require a Prison Rape Elimination Act (PREA) criminal background clearance prior to employment and annually thereafter while employed or under contract with the City of Virginia Beach. Automatic disqualifiers related to the CJIS and PREA criminal background checks apply, including but not limited to, US Citizenship and/or minimum ten (10) years US Residency requirements.
The City of Virginia Beach is an Equal Opportunity Employer.
#J-18808-Ljbffr