Skip to content

IT Business Intelligence/Data Warehouse Data Modeler

Multnomah County


Are you an experienced data modeler with expert-level experience creating Star Schemas and Dimensional Models? Do you have experience working with cloud-based systems including Azure, Azure Data Lakes and Azure Data Factory? Do you pride yourself on staying up to date on the latest industry trends, especially related to cloud technologies?

Are you seeking more balance between your work and the rest of your life? Multnomah County offers excellent benefits, a focus on work-life balance, and the opportunity to join a dynamic team working on innovative technology solutions.

Multnomah County's Department of County Assets (DCA) is looking for an experienced IT Business Intelligence-Data Warehouse Data Modeler to join our Enterprise Data and Analytics (EDAT) team. The EDAT team is a dedicated IT team focused on building ETL integrations and data warehousing systems to bring data from all County data sources (WorkDay, Questica, Tririga, State systems, Epic/Clarity/OCHIN, etc) into our BI DataMarts. We have both on-prem and Cloud BI solutions. The EDAT team works with our Business Analysts in the County Departments to find the right BI solution to meet their needs so that they can build informative BI reports.

In this role, you will provide expert design, development, tuning and maintenance of complex, mission-critical decision support and Business Intelligence systems. You will be responsible for creating Dimensional Data Models and Fact/Dimension tables. You will create Star Schemas. You will be responsible for data classification, naming, and data design.

As our BI Data Modeler you will be assigned duties across the entire spectrum of technical application and system development. This position participates in the full life-cycle development process of requirements, analysis, design, architecture, development, testing and implementation of Business Intelligence systems. You will work directly with customers and other technical staff to resolve problems and provide technical assistance on the applications in use. You will lead development, quality assurance and research and development efforts within the team and may perform as project lead for cross-functional teams in large development projects.

Your scope of work will range from complex business intelligence software development; data modeling and database design; system, load, regression and user testing; and compliance oversight; to applications support, including technical assistance, training and troubleshooting; systems analysis; project coordination and more.

This position is expected to function as an expert in one or more technical areas, and provide training and mentoring to other staff, as assigned. This position requires developing solutions in the Cloud with Azure, Azure Data Lakes, Azure Data Factories, etc.

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 website. This position also is eligible for overtime pay.

Find the complete job announcement and apply online. This posting will remain open until filled.

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 is the Law poster is available for your reference. Multnomah County is a VEVRAA Federal Contractor. We request priority protected veteran referrals.

Related Jobs

Manager, Product Support   2035 NW Front Ave suite 300, Portland, Oregon new
June 20, 2022
Associate Email Marketing Specialist   2035 NW Front Ave suite 300, Portland, Oregon
June 13, 2022
Digital Advertising Specialist   2035 NW Front Ave suite 300, Portland, Oregon
June 13, 2022
Digital Marketing Manager   Portland, remote, OR
June 1, 2022