ESSENTIAL DUTIES AND RESPONSIBILITIES:
- Participates in a teambased agile development environment.
- Analyzes and understands business users requirements clarifying inconsistencies conflicts or ambiguities to effectively develop solutions that meet business needs.
- Responsible for the design development test release maintenance and technical support of custom data applications such as data pipelines/ETLs/data processing/APIs/Power BI.
- Performs data modelling and database design for data and reporting applications as well as other applications as needed.
- Performs SQL Server database administration in the development environment.
- Evaluates techniques and design patterns and makes recommendations that will improve solution delivery.
- Creates and maintains application runbooks on the supported data and reporting applications.
- Administers Power BI Online environment including managing security data gateways and workspaces.
- Participates in the development and management of governance and frameworks for managing data across the County.
- Leads the development and communication of best practices covering development technologies implementation patterns integration techniques design options and application security.
- Acts as a technical leader in a teambased agile development environment.
- Provides direction and mentoring to Application Services staff assisting them in resolving technical issues and applying best practices.
- Works toward achieving I.T.s Mission Vision and Values.
- Performs other duties as assigned.
EDUCATION and/or EXPERIENCE:
- A Bachelors degree in Computer Science Management Information Systems or a closely related field from an accredited college or university is preferred.
- A combination of experience and education may be considered for a wellqualified candidate.
- Professional certifications in software languages cloud platforms and services (Microsoft Azure preferred) software quality ITIL are preferred.
KNOWLEDGE:
- Strong knowledge of professional software engineering practices software quality assurance practices & best practices for the full software development life cycle including coding standards code reviews source control management build processes testing and operations.
- Knowledgeable in application integration best practices event driven processing and API development.
- Wellversed in systems integration application architecture application security database design and objectoriented design.
- Knowledgeable in enterprise architecture and associated frameworks.
- Knowledgeable in data integration and/or data migration design and implementation data management principles and best practices and the architecture and design of Business Intelligence solutions.
- Working knowledge of waterwall and agile methodologies.
- Understand artificial intelligence and machine learning.
- Familiar with ITIL for IT Service Management.
- Is fully familiar with recognized industry bodies of knowledge both generic and specific.
- Actively seeks out new knowledge for own personal development and the mentoring or coaching of others.
- Develops a wider breadth of knowledge across the industry or business.
- Applies knowledge to help to define the standards which others will apply.
Technology Stack:
- SQL Server TSQL Stored Procedures PowerShell Python C# .NET framework
- Azure Services including Azure Data Lake Azure Data Factory Azure SQL Azure App Service and Azure Service Bus
- GitHub
- Azure DevOps
- SSIS SSRS
- Master Data Services
- Power BI