Senior IT Data Modeler (LDA)

Job description

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

Pay Range:

$ - $ 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:

Join Multnomah County as our next IT Data Modeler Senior Professional.

Limited Duration Assignments (LDA).

This position offers a unique opportunity to drive digital transformation at the county, enhancing public service delivery through innovative technology solutions.

Working with a dedicated team and across the county, you will be at the forefront of creating meaningful change in the community and to be part of a culture of respect, collaboration, and fulfillment.

Limited Duration Assignments (LDA) are expected to last up to two (2) years, but may end sooner.

You're a collaborative problem-solver with a growth mindset, adept at uncovering the stories data has to tell.

We're seeking a Senior IT Data Modeler (LDA) who is a strong analytical leader with excellent communication and problem-solving skills.

You'll manage data modeling projects, foster collaboration, and ensure smooth database system changes.

Deep technical expertise in data modeling and database management, along with a commitment to ethical standards and clear documentation, are essential to help us make data-driven decisions.

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

Find more details on our benefits website.

If you're passionate about data and analytics and have these skills, apply today.

What You'll Be Doing:

Leading the Data Charge: You'll be the architect behind our data, leading and managing data modeling projects that build integrated solutions for Multnomah County, collaborating with various departments and outside agencies.

Crafting Data Blueprints: You'll be responsible for the full lifecycle of data models, from planning and defining requirements to designing, developing, and maintaining both logical and physical data models for our critical decision support and transaction processing systems.

Setting the Standard: You'll lead the development of metadata standards, ensuring accuracy and consistency, and work closely with business analysts and application developers to make sure everything aligns seamlessly.

Optimizing Performance: Your expertise will be vital in providing expert design, development, performance tuning, and maintenance for our complex, mission-critical data and analytic systems.

Collaborating and Mentoring: You'll partner with stakeholders to understand their data needs, develop solutions, and even train others on how to best utilize our data models.

Ensuring Data Integrity: You'll work hand-in-hand with network administrators to ensure the confidentiality, security, scalability, and recoverability of our data and databases, establishing and enforcing technical and procedural standards.

To Qualify

We believe in considering a wide range of experiences! 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 from an accredited college or equivalent years experience (4 years) of qualifying training and/or experience.

AND

A minimum of 3 years of experience that clearly demonstrates your ability to perform the duties of this position (Total Equivalency 7 years of qualifying training and/or experience).

Ability to pass a criminal records check.

The following specific knowledge, skills, and abilities (KSAs) are necessary for success in this role:

Advanced knowledge of or skill in Azure Cloud (Azure SQL Managed Instance, Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure DevOps, Azure Boards, etc).

Working knowledge of or skill with Snowflake.

Advanced knowledge of or skill with Business Intelligence Data Marts, and Data Warehousing, including design and best practices.

Advanced experience working with developers to build ETLs for loading data for reporting.

Advanced knowledge of or skill will database logging tools (Ex: Idera, RedGate Monitor, Splunk, etc.).

Working knowledge or skill with BI reporting platforms, functionality, and tools (Tableau and Tableau Server, Power BI and Power BI Report Server, SSRS, etc.).

Advanced knowledge in installing, performance tuning, maintaining, securing, and administering an on prem MS SQL Server database and Cloud environments.

Working knowledge in installing, performance tuning, maintaining, securing, and administering a MS Integration Services (SSIS) environment.

Working knowledge of security, authorization, and authentication in Microsoft Active Directory and Azure Entra ID.

Working knowledge of MS SQL Server and Azure cloud backup and recovery design and implementation.

Basic knowledge of networking and firewall concepts.

Basic knowledge of Microsoft Windows Server administration.

Basic knowledge of SAN/NAS Storage management and concepts.

Basic knowledge of virtualization technology using MS Windows Hyper-V or VMWare.

Basic knowledge of MS Windows Server high availability technologies Application Development, architectures, languages, and/or tools.

Advanced knowledge of RDBMS management tools including MS SQL Server Management Studio.

Working knowledge of or skill in developing on a SQL Server platform using Transact SQL (T-SQL) including stored procedures, query plans, functions, views, indexes, and triggers.

Working knowledge of or skill in database modeling, data conversion, and ETL tools, such as SSIS.

Basic knowledge of Administrative Scripting (C#, WMI, PowerShell, Rs Utility, MSBuild).

Preferred Qualifications/Transferable Skills: You 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

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.

The Application Packet:

A completed online application.

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

Required cover letter that expands on your resume, addresses why you are interested in this position and demonstrates how your experience and skill set align with the minimum and preferred qualifications listed.

The Selection Process: For details about how we typically screen applications, review ouroverview of 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

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.

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.

Note: The application and resume should demonstrate your work experience/skills and how they relate to those shown in the Overview, Essential Job Duties and To Qualify sections of the job announcement.

Please be thorough, as these materials will be scored to determine your eligibility for an interview.

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.

We are not able to sponsor H-B1, F-1 OPT or STEM OPT visas.

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

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.

In accordance with , 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 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 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:

Phone:

+1 (503) 2604572

Application information may be used throughout the entire selection process.

This process is subject to change without notice.

Job Profile:

6406 - Development Analyst Senior

Required Skill Profession

Computer Occupations