LDA HMIS Development Analyst Senior

Multnomah County•Portland, OR

1d•Remote

About The Position

The Department of County Assets (DCA) Information Technology Division is seeking a skilled Senior Development Analyst LDA to join their team. This role involves the full spectrum of software development, from identifying customer needs to launching and supporting critical systems. This is a Limited Duration Appointment (LDA) expected to last up to 2 years, though it may end at any time. The position requires experience in Snowflake and WellSky Database environments to support the Homeless Management Information System (HMIS) and other Health & Human Services business applications. The HMIS Development Analyst Senior will design and develop moderate to complex data solutions, n-tier applications, and interfaces, with hands-on coding, unit testing, and troubleshooting to improve functionality and performance. They will lead requirements gathering, design architectures, and ensure compliance with change control processes. The role involves performing all levels of testing from unit to regression testing to ensure high-quality delivery. Collaboration with internal and external teams is key to identifying technical alternatives, influencing decision-making, and providing leadership on moderately complex projects. The analyst will translate business needs into technical solutions and explain complex technical concepts in business terms to partners in Health & Human Services.

Requirements

Bachelor's degree (in lieu of degree, equivalent years of experience will be considered) AND 3 years of experience in application design and development, and deployment processes
Ability to pass a criminal records check.
Advanced skill and knowledge of Data Architectures and Design (normalized, dimensional, UML modeling, OLAP).
Advanced skill and knowledge of User Interface Design and Tools
Data Warehousing, Data Lake (Snowflake).
Advanced skill and knowledge of Job Scheduling Tool/Scheduling Tasks and Processes (AutoSys, SOL Server, Windows Scheduler).
Advanced skill and knowledge of File transfer (FTP, SFTP).
Advanced skill and knowledge of Distributed Environment Utilities (FTP, Telnet, Attachmate, ODBC).
Advanced skill and knowledge of Database Tools (Microsoft SOL Server Enterprise Manager, Query Analyzer, Profiler).
Advanced skill and knowledge of Database Management Systems (Oracle, SOL Server).
Advanced skill and knowledge of Microsoft Visual Studio (Model Builder, Solution Builder).
Advanced skill and knowledge of Database Executable Objects (Stored procedures, functions, views and triggers).
Advanced skill and knowledge of ETL Tools (Microsoft DTS/SSIS, VBScript, ADF).
Advanced skill and knowledge of ANSI SOL Languages (T-SQL, PL-SOL).
Knowledge of Data Modeling Tools.
Skill and knowledge of Web Languages (JavaScripWBScript, HTML/XHTML/HTML5, ASP, ASP.net MVC, ASP.net, JQuery).
Knowledge of Web Servers (IIS, Apache Tomcat).
Advanced skill and knowledge of Source Control (GIT).
Knowledge of Report Management Tools (Snowflake, Tableau).

Nice To Haves

Experience working with Health & Human Services business application systems, specifically WellSky.
Demonstrated ability to communicate complex technical concepts to non-technical interest holders.
Experience providing technical leadership for moderately complex projects.

Responsibilities

Design and develop moderate to complex data solutions, n-tier applications, and interfaces.
Perform hands-on coding, unit testing, and troubleshooting to improve functionality and performance.
Lead requirements gathering, design architectures, and ensure compliance with change control processes.
Perform all levels of testing from unit to regression testing to ensure high-quality delivery.
Collaborate with internal and external teams to identify technical alternatives, influence decision-making, and provide leadership on moderately complex projects.
Translate business needs into technical solutions and explain complex technical concepts in business terms to partners in Health & Human Services.