Description

You will design and manage data architectures and pipelines for the Virginia Permitting Transparency project.

Responsibilities

• Build and edit Azure Data Factory pipelines to manage data flows.
• Architect and model mission-critical RDMS, BI, OLTP, and OLAP solutions.
• Perform data research, profiling, and analysis to resolve file issues.
• Translate business and technical requirements into comprehensive reporting strategies.
• Collaborate with application development teams to provide system enhancements and support.

Required Skills

• 5+ years of experience in a data architecture position.
• 5+ years of hands-on experience with Oracle 12c or greater.
• 5+ years of experience building data flows using ETL tools.
• Proficiency with Azure Data Factory for ETL process implementation.
• Extensive experience in Data Analysis, Data Profiling, and Data Modeling.
• Expertise in profiling and loading data from RDBMS, OLAP cubes, mainframe file systems, web services, APIs, XML, and text files.
• 5+ years of experience with Azure Power BI.
• Ability to architect solutions leveraging multiple DBMS technologies.
• Strong communication skills for presenting complex material to technical and business users.

Preferred Skills

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

Key Skills

Education

Bachelor's degree