Job description:
general summary the sr business systems database software engineer will be a key player in designing, implementing, and optimizing our data architecture to support our production, accounting, business intelligence, and financial reporting functions. this position will collaborate closely with cross-functional teams, including production, finance, technology and operations, to ensure seamless data integration and provide actionable insights for strategic decision-making. job functions design, administer and maintain a robust and scalable data warehouse for our solver-based corporate performance management (cpm) system within the microsoft azure cloud environment.utilize domain knowledge of production tracking tools such as shotgrid and ftrack to streamline data collection and analysis processes, feeding into the data warehouse.manage azure based sql databases, ensure data integrity, performance and security for both the data warehouse and other relevant databases.develop and optimize python apis to facilitate efficient and secure data access and retrieval from the data warehouse.collaborate with accounting and finance departments to gather, transform and integrate financial data into the data warehouse architecture for accurate financial and operational reporting.build comprehensive and insightful financial and operational reports, leveraging the data warehouse.create and implement well-organized data collection processes and thoughtful schema taxonomies to ensure data accuracy, consistency and ease of reporting.take a hands-on approach in a green space to build new financial and operational reporting processes and operations that span various departments and workflows.provide ongoing support and troubleshooting for data-related issues, ensuring data quality and availability for reporting purposes. qualifications 5+ years of professional experience in computer science, information technology, finance or a related field as a database architect, database engineer or similar role.proficiency in microsoft azure services and architecture, with experience in designing and implementing cloud-based data warehousing solutions, required.strong working knowledge of sql databases, data modeling, and performance optimization techniques.proven experience developing python apis for data retrieval and integration.demonstrated ability to collaborate effectively with cross-functional teams, including production, finance, technology and operations departments.expertise in working with production tracking tools such as shotgrid and ftrack.advanced skills in microsoft excel for building financial and operational reports.excellent problem-solving skills and the ability to navigate complex business and financial requirements.strong communication skills, both written and verbal, with the ability to convey technical concepts to non-technical stakeholders.self-motivated, detail-oriented and adaptable to changing business needs.a passion for continuous learning and a proactive attitude towards exploring advanced topics and emerging technologies. physical demands and work environment the physical demands and work environment characteristics described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. physical demands: while performing the duties of this job, the employee is required to walk; stand; sit; use hands to operate standard office equipment; reach with hands and arms; balance; stoop; talk or hear both in person and by telephone. the employee must lift andor move up to 15 pounds. vision abilities include close vision, distance vision, and the ability to adjust focus.work environment: while performing the duties of this job, the employee works under typical office conditions and is exposed to variable indoor temperatures. the noise level is usually quiet or moderate. location on-site in hillsboro, or and also eligible for hybrid work remote eligible. salary salary is commensurate with skills and experience. disclaimer the above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. they are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of personnel so classified. please review our employment disclaimer and materials submission agreement.

Resume:
<<summaryhighly motivated sales associate with extensive customer service and sales experience. outgoing sales professional with track record of driving increased sales, improving buying experience and elevating company profile with target market. skills filemaker, sql, javascript, and .net languages. asp.net (2 years), vb.net (2 years), javascript (4 years), microsoft office (6 years), sql (2 years), vba (1 year) experience software engineer, 06/2014- 12/2016– ,ucompose 2.0 production management system.2015 above and beyond award recipient.filemaker.ipads, , printing.converted an existing production and inventory management system from primarily paper-based to ~95% device-based.implemented ipads at the production, inventory, and shipping levels.pc-based and printable reports for administrative staff.reduced input lag from one day to minutes; gave administrative users real-time production reports.allowed supervisors to create different versions of recipes (e.g.in case of ingredient shortage), and to swap out recipes for a production run, recalculating ingredient needs instantly.real-time production reports, combined with a "production queue" of upcoming jobs, gave supervisors vastly increased flexibility in responding to customer needs, output irregularities (pro and con), and ingredient shortages.allowed us to comply with sqf standards by enabling supervisory staff to approve every step of the production process maintenance system.ipads for maintenance technicians.ipad and pc layouts for maintenance manager.touch-based design scheme developed with maintenance workflow in mind scoutboss.sql database.javascript and rest api.enabled boy scout units to enter orders for popcorn.enabled council and district leaders to manage orders for their units.provided printable invoices and various reports used by council and district leaders.calculated commission percentages, tracked payments, and directed award-winners to their respective prize sites based on council building-wide wifi.added wireless access points to all warehouses and loading docks.in conjunction with the production management system, made it possible to keep all aspects of production, inventory, shipping, and receiving up-to-date.reduced lag time from 1+ day to minutes or hours.software engineer, 04/2012- 05/2014rue la la– ,developed administrator interface allowing organizations to file corporate documents with the secretary of state.imported 180 years of corporate data from a mainframe dump file into the current sos database using a winforms application running a batch routine.developed a system wherein 600 business-filing relationships could be filed using an asynchronous, modular webpage designed to be utilized by administrative and public users alike, with varying permissions based on user role.developed a web page to allow users to add to, delete from, and update these relationships instantaneously, and preview the resulting form.utilized dynamsoft's javascript api to deliver client-side scanning and image upload functionality.allows users to add official documents to the government datastore with the click of a button.implemented user-friendly audit trail functionality that could be applied to any table in the database with the switch of a parameter.utilized telerik reporting tools to generate date-range reports on new businesses, invoice receipts and remitter letters, and state-issued certificates voter registration project.used telerik reporting and user interface tools to allow efficient, dependable maintenance of voter registration information.implemented one-touch scanning process that incorporated barcode created via javascript.barcodes are read by scanning software and used to associate the scanned image with a specific voter change record.used in a multi-step voter record confirmation process.assisted with a winforms application used in onsite polling in iowa elections.business intelligence analyst, 07/2010- 07/2012rue la la– ,utilized bi tools to deliver analytical data to business users.leveraged data warehouse knowledge at the semantic and presentation levels.network margin project.held on-site jad session with clients.daily meetings with clients to reiterate requirements and gauge progress.created 50-page user's guide to the network margin system. education and trainingbachelor's:computer science,expected inmay 2010-university of wisconsin-platteville,wigpa:status-computer science skills.net, asp. .net, administrative, , council, client, clients, data warehouse, database, dependable, filemaker, filing, government, image, inventory management, inventory, javascript, letters, mainframe, meetings, access, microsoft office, windows, network, manage orders, page, production management, progress, read, real-time, receiving, reporting, scanning, scheme, shipping, software engineer, sql, supervisory, switch, user interface, vba, web page, workflow.