Data Warehouse/Business Intelligence Developer

The Application Services vision and mission are to proactively participate with our customers to understand their business needs and define related IT services requirements from a strategic perspective. The Team applies a wide range of technologies to solve business problems, and therefore focuses on eliminating redundancies, enhancing resource utilization and ensuring the most effective solution has been both defined and delivered.

POSITION:

The Data Warehouse/Business Intelligence Developer (BI Developer) plays an integral part in the analysis, design and development of ETL/ Data Warehouse tools and web-based application systems. The Data Warehouse/BI Developer will have an opportunity to work in a multi-faceted and dynamic organization with responsibility for designing and developing new reports from user requirements under the guidance of senior developers. The Data Warehouse/BI Developer will modify existing report programs and provide developer, user, technical and operational documentation. The position also performs QA on data that is represented in the reports and cubes, researches issues related to the data, and performs support duties on back-end processing. The person in this position develops in-depth knowledge of the functions associated with business departments to ensure report results match up with source data. The ideal candidate will also understand how to automate business rules and provide data cleansing and data quality analysis. Candidates should also understand fundamentals of data architecture and concepts of data modeling and have knowledge of developing web applications in .NET framework.

Responsibilities include:

• Implementing data transformation from source to target • Working with customers to help finalize user requirements around reports • Data mapping and flow testing for various reports and charts • Providing back-up support on production breakage • Developing intermediate to complex SQL scripts • Producing customer reports by compiling and analyzing data, providing data definitions and report objects, developing data flow diagrams, and schemas as defined by user requirements • Developing report and data distribution systems using Microsoft .Net technologies.

For more information on these positions, including application materials, or to apply to these roles please visit our website at www.multcojobs.org; reference job # 6405-18.

Multnomah County is actively recruiting persons from various ethnic and cultural backgrounds to enhance service to our diverse communities. Bilingual/bicultural candidates are encouraged to apply. An Equal Opportunity Employer