LDA HMIS Development Analyst Senior

Current employees: Please apply through the employee portal to be considered for this opportunity.

Pay Range:

Department:

Job Type:

Exemption Status:

Closing Date (Open Until Filled if No Date Specified):

The Opportunity:

This position will close once 150 applications have been received, regardless of the listed closing date. We encourage early submissions.

Overview

Are you an IT professional who is a passionate problem solver?

The Department of County Assets (DCA) Information Technology Division is seeking a skilled Senior Development Analyst LDA to join our team. In this role, you will dive into the full spectrum of software development from identifying customer needs to launching and supporting the critical systems they use. This is a Limited Duration Appointment (LDA) expected to last up to 2 years, though it may end at any time. 

We are specifically looking for a candidate with experience in Snowflake and WellSky Database environments to support our Homeless Management Information System (HMIS) and other Health & Human Services business applications.

As the HMIS Development Analyst Senior, you will:

• Design and develop moderate to complex data solutions, n-tier applications, and interfaces. You will be hands-on with coding, unit testing, and troubleshooting to improve functionality and performance.
   

• Lead requirements gathering, design architectures, and ensure compliance with change control processes. You will 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 our partners in Health & Human Services

Our Commitment to Safety, Trust and Belonging:Multnomah County is committed to developing, nurturing and continually improving workforce equity by identifying and addressing the structural and policy barriers to equal employment opportunity faced by our employees and communities.

To Qualify

We will consider any combination of relevant work experience, volunteering, education, and transferable skills as qualifying unless an item or section is labeled required. Please be clear and specific about how your background is relevant.

Minimum Qualifications/Transferable Skills:

• 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.

• Required Knowledge, Skills and Abilities (KSAs):

KSAs Required Include:

Development and Support of Applications/Concepts:

• 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).

Development and Support of Application/Tools:

• 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).

Preferred Qualifications/Transferable Skills:You do not need to have the following preferred qualifications to qualify. However, we may consider these when identifying the most qualified candidates.

• 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.

Screening and Evaluation

The Application Packet: Your completed application must include the following items:

A completed online application.

A resume:Please detail your relevant experience and education. Be sure to include the name of employer, location, dates of employment, your title, and a brief summary of your responsibilities for each role.

A cover letter:Expands on your resume, describes why you are interested in this position, and specifically addresses how you meet the Minimum Qualifications and Required KSAs listed above.
 

The Selection Process:

• Initial review of minimum qualifications: We may do an additional preferred review and/or send out additional supplemental questions to identify those highest qualified.

• Technical Assessment: Candidates may be asked to complete a technical exam or assessment to verify the specific Knowledge, Skills, and Abilities listed above.
  Consideration of top candidates: We will consider qualified candidates in order of rank and score. This may include panel interview(s), a hiring interview, and/or additional testing .

• Background check: Finalists must pass a thorough criminal records check.

Equal Pay Law:Please be advised that the pay range listed for this position is intended to provide general guidance on the earning potential for the role. However, actual compensation will be determined in accordance with the Oregon Equal Pay Law and will take into account factors such as the candidate's relevant experience, education, seniority, training, and/or tenure. Candidates should expect that initial offers will be made within the listed pay range and may not be at or near the top of the range.

Additional Information

• Type of Position: This is an hourly, AFSCME Local 88 union-represented position and is eligible for overtime.

• Location:Multnomah Building, 501 SE Hawthorne Blvd, Portland, OR 97214.

• Schedule:Monday - Friday, 8:00am - 5:00pm. There is flexibility with start/end times.
  Telework:This position is designated as “routine telework,” meaning you will be working remotely (from home); a hybrid schedule also is available. As with all routine telework positions, employees may be required to come into the office on occasion. The designation of Routine Telework may be subject to change at a future time. 

• Residency Requirement:All employees must reside in Oregon or Washington. We are unable to sponsor work visas, including H-4, H-1B, F-1 OPT, or STEM OPT.

Compensation and Benefits:Multnomah County offers an exceptional benefits package, including employer-funded retirement savings, health and dental insurance at very low cost to full-time employees, paid parental leave, wellness programs, and a focus on work-life balance.

Serving the Public, Even During Disasters: All County employees have a role in serving the public during inclement weather, natural disaster, or other types of community emergency response. You may be reassigned to a role in the emergency response to support critical community needs.

In accordance with Oregon Law, Multnomah County is not collecting school attendance dates in the initial application process; please do not include these dates in your resume, cover letter and other application materials.

Diversity and Inclusion: At Multnomah County, we don't just accept difference; we value it and support it to create a culture of dignity and respect for our employees.

We are proud to be an Equal Opportunity Employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran or protected veteran status, genetic information and other legally protected characteristics. The EEO Know Your Rights poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals.

Veterans’ Preference: Under Oregon Law, qualifying veterans may apply for veterans’ preference. Review our veterans’ preference page for details about eligibility and how to apply.

Accommodation under the Americans with Disabilities Act: We gladly provide reasonable accommodation to anyone whose specific disability prevents them from completing an application or participating in this recruitment process. Please contact the recruiter below in advance to request assistance. Individuals with hearing or speech impairments may contact the recruiter through the Telecommunications Relay Service by dialing 711.

Questions?

Recruiter:

Email:

Phone:

Application information may be used throughout the entire selection process. This process is subject to change without notice.

Disclaimer: This announcement is intended as a general descriptive recruitment guide and is subject to change. It does not constitute either an expressed or implied contract.

Job Profile: