Description

You will design and maintain data architectures and pipelines to support the Virginia Permitting Transparency project.

Responsibilities

• Build and edit Azure Data Factory pipelines to manage data flows.
• Architect and model mission-critical RDBMS, BI, OLTP, and OLAP solutions.
• Manage database needs, reporting, and data research tasks.
• Collaborate with application development teams to provide system enhancements and support.
• Work with customers to resolve file issues and translate business requirements into analytic solutions.

Required Skills

• 5+ years of hands-on experience with Oracle 12c or greater.
• 5+ years of experience in a data architecture position.
• 5+ years of experience building data flows using ETL tools.
• Proven experience with Azure Data Factory.
• Extensive experience in Data Analysis, Data Profiling, Data Flows, and Data Modeling.
• Expertise in profiling and loading files from RDBMS, OLAP cubes, mainframe file systems, web services, APIs, XML, and text files.
• Required experience with Azure Power BI.
• Ability to translate business and technical requirements into comprehensive reporting strategies.
• Strong verbal and written communication skills for presenting complex material to diverse audiences.

Preferred Skills

• Experience with Azure Power Automate.
• Experience with Microsoft SQL Server and Azure Dataverse.

Key Skills

Education

Any graduate