Enterprise Programmer Analyst- Data and Analytics*
Enterprise Programmer Analysts - Data and Analytics* (EPAs) perform complex and advanced business systems analysis and database, application, data pipeline, programming and analytic reporting architecture and development. This position assumes a leadership role in architecting and developing enterprise data platforms, data frameworks and solutions for departments and serves as an integral part of the change management process.The EPA - Data and Analytics position(s) are experts at:
- Acting as the Lead Architect who mentors subordinate staff with technical blueprinting and data initiatives which may result in the selection of third-party software or coordinating development of custom-built application and data solutions for data initiatives, in accordance with data lifecycle management.
- Architecting data solutions that deliver value to customers, taking into consideration project budget, scalability, business continuity, standard practices, licensing, county policies, cross-department regulations, and potential impacts to countywide infrastructure.
- Data frameworks, data architecture, and practices that take into consideration multi-department, multi-agency, and multi-system requirements, security, and data recovery.
- Developing specialized solutions that enhance data sharing across departments; promoting collaborative infrastructure and providing geographic context for countywide strategic initiatives and decision-making.
- Architecting and creating reports and dashboards, data pipelines, and advanced data concepts such as data warehousing, ETL, ELT, and being an expert on BI platforms such as Power BI, ArcGIS Online, and Tableau.
- Providing subject matter expertise when collaborating with technical and business personnel across all departments in the maintenance and support of hardware and software, along with the interactivity and interfaces between those businesses and applications.
- Integrating Artificial Intelligence technology into data solutions and the data technology stack.
- Azure Synapse
- Azure Data Factory
- Azure Data Lake
- One Lake
- Fabric
- Data Warehousing
- Spark
- Python
- R
- .Net/.Net Core
- ASP/ASP.Net
- SQL Server
- Power BI
- Tableau
- ArcGIS
- Power Platform
- Azure AI Foundry
- Copilot
- Copilot Studio
- XML
- JSON
- ETL/ELT