IT Development Analyst Senior

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

Pay Range:

$54.03 - $66.41 Hourly

Department:

Department of County Assets (DCA)

Job Type:

Regular Represented

Exemption Status:

United States of America (Non-Exempt)

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

The Opportunity:

This Work Matters...

Are you passionate about shaping the future of technical applications and systems? Join our team as a IT Development Analyst Senior, where you'll play a central role in driving our Enterprise BI Solutions forward!

As a IT Development Analyst Senior specializing in Enterprise BI Solutions, you'll be involved in the full life-cycle development process of Business Intelligence systems. Your responsibilities include collaborating with customers and experts, troubleshooting issues, leading development tasks, and ensuring quality and innovation within the team. With expertise with on-prem as well as cloud platforms like Snowflake, Azure, and Azure Data Lakes, you'll design tailored solutions. Your main focus will be supporting the DDAP team, particularly in Data Analytics and Business Intelligence systems. We're looking for someone skilled in handling complex software projects and delivering high-quality results within constraints, making this an excellent opportunity for experienced candidates in Azure, Data Lakes, ADF, and similar solutions.

Essential Job Duties:

All of these job duties specifically relate to Data and Analytics and Business Intelligence technical areas.

Software Development:

• Architect, design, document and develop complex enterprise data mart, data structures and data ETL solutions.

• Lead and coordinate design and definition of processes, guidelines and methodologies for data management, data delivery, data conversion, data integration, and data quality.

• Create and maintain jobs, dynamic database objects, tables, files, and indexes to support computer applications implemented in a database environment using SQL, functions, stored procedures, triggers and views.

• Research and document solutions to potential data quality issues; perform data audits, reviews, and validation to ensure data integrity.

Application Support:

• Coordinate with key partners as needed to resolve issues with supported environments, applications and processes.

• Perform upgrades, enhancements, maintenance and continuing support of existing applications and tools.

• Troubleshoot complicated environmental problems as needed, providing the final escalation point within the county for technical issues for County Data and Analytics and Bl technologies. Determine root causes and find permanent fixes to supported systems' problems .

System Analysis:

• Map ambiguous customer business intelligence and reporting needs to the appropriate technologies and solutions

• Work with customers to translate business needs to technical solutions, and explain technical concepts in business terms. Develop, review, and maintain system and data dictionary documentation.

• Promote best practices, industry standards, and provide insight on software trends and technologies

Project Coordination/Management:

• Coordinate technical tasks through all phases of the software development life cycle; develop and oversee project work plans, including defining project implementation schedules and priorities; collaborate with functional teams to translate user needs into solutions; serve as a project or technical lead; coordinate the work of others.

• Provide project management in collaboration with departments and outside agencies to build integrated solutions; build consensus with management, users, and vendors to problem solve development needs; formulate scope and objectives for software development projects and define outcomes; develop and recommend solutions

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. For details about how we typically screen applications, review our overview of the selection process page.

Minimum Qualifications/Transferable Skills*:

• Bachelor's degree (in lieu of degree, equivalent years of experience will be considered)

AND

• Five (5) years experience that demonstrates the ability to perform the duties of the position. (Equivalency 9 years of qualifying training and/or experience).

• The specific knowledge, skills and abilities listed below.

Specific knowledge, skills and abilities (KSAs) required for this role:

● Expert skills with tools and processes around application deployment. (examples: Azure DevOps, Octopus).

● Working Knowledge and Skill with Cloud API such as Microsoft Azure API

management (Postman).

● Advanced skills in database modeling, data conversion and ETL tools such as SQL Server Integration Services (SSIS), Azure Data Factory (ADF) , and Snowflake

SnowSQL.

● Advanced Knowledge and Skill

• Data Transformation Tools (SSIS, Azure Data Factory, Snowflake Snowpark, etc).

● Advanced skills with data warehousing design, BI concepts and best practices.

● Advanced level of skill and knowledge with Cloud technologies (Azure, Azure Data Lakes, Azure Blob storage, Snowflake).

● Advanced level of skill and knowledge in Microsoft Azure, Azure DevOps, Azure SQL, Azure storage accounts, other Azure PaaS technologies.

○ source code control and version management

○ software build tools

○ application deployment

● Advanced level of skill and knowledge with scripting languages (PowerShell, T-SQL C#, Python, Javascript).

● Expert level of skill with SQL programming including stored procedures, query plans, functions and views.

● Advanced level of skill and knowledge with Agile development methodology.

● Advanced knowledge of designing, developing and implementing reports including parameters, filters and leveraging advanced reporting features in tools such as Power BI, Tableau, and SSRS (SQL Server Reporting Services).

● Working Knowledge and Skill

• Security & Privacy Protocols (HIPAA, SSL, User & File Security) Thorough knowledge of Information Security, audit, and regulatory guidelines.

• Transferable skills: Your transferable skills are any skills you have gained through education, work experience (including the military) or life experience that are relevant for this position. Be sure to describe any transferable skills on your application and clearly explain how they apply to this position.

SCREENING AND EVALUATION

The Application Packet:

Screening and Evaluation

The Application Packet:

• A completed online application.

• A resume covering relevant experience and education. Please be sure your resume includes the following for each employer: name of employer, location, dates of employment, your title, a brief summary of your responsibilities, and the number of employees under your supervision.

• A cover letter detailing how your experience and training qualifies you for this role, addresses why you are interested in this position, and demonstrates how your experience and skill set align with the minimum and preferred qualifications listed.

Note: The application, resume and cover letter should demonstrate your work experience/skills and how they relate to those shown in the Overview, Essential Job Functions and To Qualify sections of the job announcement. Please be thorough, as these materials will be scored to determine your eligibility for an interview.

The Selection Process: For details about how we typically screen applications, review our overview of the selection process page. We expect to evaluate candidates for this recruitment as follows:

• Initial review of minimum qualifications

• Technical exam

• Consideration of top candidates

• Background and reference checks

ADDITIONAL INFORMATION

Routine 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. All employees must reside in Oregon or Washington; the county cannot support ongoing telework from other locations. We are not able to sponsor H-B1 visas.

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

Location: This position is officially housed in the Multnomah Building, 501 SE Hawthorne Blvd. Suite 400, Portland, Oregon, 97214.

Teleworking and Work Schedule: A variety of work schedules are available that cover core business hours. Work with your manager to find the best one.

.

Serving the Public, Even During Disasters

Everyday, Multnomah County staff work together to serve as a safety net for our communities. During a disaster, this safety net becomes even more critical. All County employees have a role in serving the public during inclement weather, natural disaster, or other types of community emergency response. During these emergency responses, while typically there begins with a call for volunteers, county employees may ultimately be reassigned from their current position to a role in the emergency response in order to support the critical needs presented by our communities. For more information, please visit the Disaster Service Worker Information page.

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:

Allison Conkling

Email:

allison.conkling@multco.us

Phone:

+1 (503) 2604572

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:

6406

• Development Analyst Senior