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:
When you work for Multnomah County, you make a positive impact on your community. Join a diverse, dynamic workforce committed to serving everyone who lives, works or does business in Multnomah County. Our goal is to create a more vibrant, equitable and inclusive community.
Overview
Multnomah County IT is searching for a limited-duration (LDA) IT Data Modeler Senior P rofessional. Limited Duration Assignments (LDA) are expected to last up to two (2) years, but may end sooner.
We are seeking a Senior IT Data Modeler with a strong analytical mindset, exceptional communication skills, and a talent for problem solving. The ideal candidate should be a natural leader capable of managing data modeling projects and fostering collaboration. Proficiency in documenting, a commitment to ethical standards, and deep technical expertise in data modeling and database management are essential. Additionally, the candidate should excel in change management, ensuring smooth transitions in the database system change control process. If you have these skills and have a passion for data modeling and analytics, we invite you to join our team and contribute to our data-driven success.
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. County employees across the organization have stepped forward to develop a strategic plan and help create a workplace where everyone can reach their full potential. Learn more by reading our Workforce Equity Strategic Plan and exploring our Core Competencies for all County employees.
Essential Job Duties:

• Lead and manage data modeling projects in collaboration with departments and outside agencies to build integrated solutions.
• Plan, define requirements, design, develop, and maintain logical and physical data models for complex decision support systems.
• Participate in the architecture of middle tier components as they relate to backend database requirements.
• Lead the development of standards for metadata and interact with business analysts and application developers to ensure accuracy of metadata.
• Collaborate with Stakeholders to understand their data needs and develop solutions that meet those needs.
• Document and maintain the data models, as well as training others on how to use them.
• Provide expert design, development, performance tuning, and maintenance of complex mission critical data and analytic systems.
• Automate the management of database server performance tuning and database life cycle utilizing database administration tools.

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:

• A bachelor's degree. In lieu of a degree, we will consider equivalent years (7 to 10 years) of qualifying training and/or experience.
• Minimum of 3 years of experience that demonstrates the ability to perform the duties of the position (Equivalency 7-10 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 level of skills and knowledge around Data Modeling techniques and processes (including Dimensional Models, Star Schemas. Fact and Dimension Entities, Fact and Dimension Attributes, source to target mappings)
• Expert level of skills with Data Modeling tools (example: Erwin, Mural Boards, Swagger)
• Expert level of skill with SQL programming including stored procedures, query plans, functions and views
• Advanced knowledge of or skill in Microsoft SQL Server Integration Services (SSIS)
• Advanced Knowledge and Skill - Data Transformation Tools (SSIS, Azure Data Factory, Azure Data Lakes, Cloud, etc)
• Advanced Knowledge and Skill - Source control (Azure DevOps, Subversion, GIT)
• Advanced Knowledge and Skill with Cloud API and Microsoft Azure API management (Postman)
• Working Knowledge and Skill - Cloud Technology (Azure etc)

Preferred Qualifications/Transferable Skills: Y ou do not need to have the following preferred qualifications/transferable skills to qualify. However, keep in mind we may consider some or all of the following when identifying the most qualified candidates. Please clearly explain on your application how you meet any of the following preferred qualifications/transferable skills.

• Experience with AWS Redshift Serverless
• Experience with Snowflake
• Experience with Matillion Data Productivity Cloud
• Experience with Informatica Intelligent Data Management Cloud

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: T he 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: We may do an additional preferred review and/or send out additional supplemental questions to identify those highest qualified.
• Consideration of top candidates: We will consider qualified candidates in order of rank and score from the list of eligible candidates. This may include panel interview(s), a hiring interview, and/or additional testing to determine the best candidates for a position.
• Reference check: All finalists must pass a thorough reference check.

Additional Information:
This recruitment may be used to fill full-time, part-time, temporary, limited duration and on-call positions.
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. The onsite work location for this position is the Multnomah Building, 501 SE Hawthorne Blvd.,Portland, OR.
Type of Position: Represented position
Location: 501 SE Hawthorne Blvd., Portland OR, 97214
Schedule: A variety of work schedules are available. Some examples:

• 5-8s: 8 hours a day Monday through Friday
• 4-10s: 10 hours a day Monday through Thursday
• 4-10s: 10 hours Tuesday through Friday
• 4-9-4: 9 hours a day Monday through Thursday 4 hours on Friday. Etc...

Inclement Weather and Disasters
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