ETL Business Analyst

Hourly Rate: $38 W2; $44 CTC/1099 Job Description: The ESA II (Application Integration/Cloud) role will be responsible for service delivery and project deliverables within the application support team. This role will identify gaps, needs, and lead improvement efforts to improve service delivery in applications supported by Brown County department of Information Technology. This role will be considered a subject matter expert (SME) in one or more key technologies under the application domain. A key part of this role will be identifying and implementing solutions using modern application development techniques and/or target cloud deployments. It is expected that this role will operate independently, solve complex problems, and fulfill requests with minimal supervision. In the ESA II (Application Integration/Cloud) role, you will be tasked to provide engineering services, participate in the implementation design sessions for applications, monitor and troubleshoot those issues that may impact the supported systems. As a member of the Application Support team, the ESA II (Application Integration/Cloud) will provide secondary support to other members of the team. ESSENTIAL DUTIES: Communicate. Effectively communicates with customers, management and coworkers. Shares appropriate work order and project information. Coordinates and schedules meetings with users of all levels and is punctual. Keeps calendar up to date. Self-Directed. Works and researches independently with little or no direct supervision to perform day-to-day operations. Ensures work is followed through to completion and on time. Prioritize. Performs activity based on urgency by logically prioritizing work orders, projects, maintenance and break-fix work. Troubleshoot. Performs intermediate and advanced troubleshooting. Identifies root cause of problems. Identifies roadblocks and finds possible alternatives with appropriate urgency. Escalates problems to management, the customer and/or vendors. Deploys solutions in a timely manner. System Maintenance. Maintains existing systems, programs, interfaces and reports according to changing requirements, user needs, funding changes and/or best practices. This includes: Investigating impact of modifications and adjustments to existing systems software and interfaces. Managing and performing system upgrades, migration or retirement by coordinating, planning, scheduling, testing and communicating changes through the change management process. System monitoring and performance evaluation, making recommendations as needed. Preventative maintenance Ensuring backup and recovery of system and data Working with the vendor or partner as required. Training. Responsible for identifying and providing training and assistance where required. Identifies and requests necessary self-training. Team Participation. Attends and actively contributes to department, team and ad-hoc meetings Works with Help Desk staff and provides 2nd level support for unresolved work orders. Participates in the Information Technology after hours call rotation Leads or participates with teams to meet department and county projects or goals. Completes TS Department operations and tasks as assigned. Documentation. Develops and maintains technical documentation for supported systems. Completes work order detail, time reporting, project updates, problem logs, equipment transaction forms and other required documentation. Compliance Complies with laws, regulations, policies, procedures and standards, such as HIPAA. Planning Identifies opportunities for process improvement or eliminating waste. Assists with short and long term budget planning. Prepare operational plans for supported systems. Technical Skills 2 -5 years of experience in full life cycle development Experience in modern application programming languages, such as C#, Node, React Experience working with ETL tools such as SSIS, Azure Data Factory, or similar tools. Experience with SQL, database designs and working with tools such as SQL Management Studio Experience with common debugging tools, such as Insomnia, Postman, Fiddler, Wireshark Proven professional experience in a cloud platform such as Azure, AWS or GCP Understanding of all phases of the software development lifecycle Acts as Subject Matter Expert (SME) for multiple systems. Become familiar with operations as required to support the customer(s). Manage or assist with delivery of system components or entire systems using various tools Provide support to other teams in areas like with networking, application support, and providing level 1 or 2 support coverage, etc. Cyber Security. Participates in cyber security training. Also assists with the development and implementation of cyber security systems and disaster recovery plans. May participate in the handling of cyber incidents. Champions security for managed systems. Promotes cyber security with the customer & community. Advocates security of data and information in transit and at rest as required. Projects. May lead or participate on project teams including communications, project definition, budget, needs assessment, process improvement and all aspects of execution. This may include leading Systems Analyst I's, Systems Analyst IIs, vendors and customers. Professionalism. Interacts professionally and appropriately with others, without regard to individual characteristics. Demonstrates a personal commitment to create a hospitable and welcoming environment. Fosters respect for all individuals and points of view. NON-ESSENTIAL DUTIES: Performs related functions as assigned. Required Skills:

• Bachelor's degree in Computer Science, Information Systems, Computer Science, Computer Engineering or Software Engineering or equivalent. (5 years)
• Five (5) or more years of experience in Information Technology, or in a related area. (5 years)
• Five (5) or more years of experience in supporting applications in an enterprise environment. (5 years)
• Ability to work well with departmental personnel and users. (5 years)
• Ability to work independently or as a member of a project team. (5 years)
• Working knowledge of Windows operating system and Microsoft Office; specifically Word, Excel and Outlook. (5 years)
• Ability to quickly identify and resolve support problems. (5 years)
• Ability to coordinate multiple problems and projects. (5 years)
• Ability to establish and maintain effectively working relationships with staff and users. (5 years)
• Ability to communicate effectively both orally and in writing. (5 years)
• Ability to work the required hours of the position. (5 years)