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:
<<summaryto utilize my customer relations and management background to obtain a position with a company that places importance on efficiency and success. employ natural leadership and interpersonal skills to build relationships throughout the organization. highlightsguest servicesinventory control proceduresmerchandising expertiseloss preventioncash register operationsproduct promotions experience accountant, 07/2015tocurrentair communities– ,accounting for six companiesmaintained confidential information, such as pay rates, bonus targets and pay gradesprocessed payroll, electronic deposits and employee pay adjustmentsreconciled all bank and credit card accountsprocessed journal entries, online transfers and payments (internal and external)analyzed cost control and provided timely financial information to support company goalscost effective purchasing (office equipment & supplies, janitorial, food & beverage)reviewed book entries to ensure accuracy of the g/lassisted the cfo with the production of the monthly financials and management reportsprepared monthly and annual expense forecasts, including any necessary recommended action required to manage costs to achieve budgettracked and verified accurate receipt of purchase orders and verified costs against vendor invoicesprocessed a/p weekly, working with 50+ vendorsprocessed company purchase orders and communicated with customers regarding ordersresearched and resolved collections and billing disputes with tact and efficiencyresearched and resolved billing and invoice problems​director of finance & accounts, 05/2014to 07/2015exeter hospital–.responsible for daily entry of accounting transactions.received, recorded, and deposited cash and checks as well as reconciled records of bank transactions.verified purchase orders, managed accounts payable invoices and supplied payments to vendors on a weekly basis.reconciled all bank and credit card accounts.researched and resolved collections and billing disputes.processed payroll, electronic deposits and employee pay adjustments for 70+.issued paychecks to contractors on a bi-weekly basis.issued w2.s to employees & 1099.s to contractors.maintained confidential information, such as pay rates, bonus targets and pay grades.processed journal entries, online transfers and payments.produced monthly financial summaries and reports.maintained employee files, incident reports, unemployment claims and training progress.maintained office inventory.operations & trainingconsultant, franchisee & general manager, 01/2004tocurrentdomino's pizza–,state,training & operations consultantjuly 2015 - currentassist six store franchise in training staff and streamlining operations in accordance with corporate standardsmonthly unannounced inspections to inspect product and operation standardswork with store managers in developing effective action plans for improvement and guide team members in execution of determined plansfranchiseejune 2007 - february 2011grow a performance culture, based on teamwork, innovation and training creatively constructing advertising and promotional deals in accordance with corporate initiativesimplemented and maintained corporate standardsdrive revenue and reduce expenditures to meet and exceed revenue and profit targetsmaintain integrity of stores, including coding, sanitation, equipment and major applianceslabor and food cost management; inventory managementcommunity and customer relationsestablished and implemented internal training and time-management programhandled tasks related to payroll, inventory and job schedulingmanaged accounts payable and accounts receivable in conjunction with company accountantsprepared reports, spreadsheets, and administrative documents maintained office calendars, open and prioritize mail, receive and prioritize phone callsgeneral managerfebruary 2004 - jessica 2007orchestrating and directing crew consisting of up to 20 people.hire, develop and promote talented employees who fit the unique cultures of the restaurant environment.improve operational statistics and efficiency.patient service representative, 05/2012to 10/2016patient first urgent care–.consistently build positive report with patients while accurately and efficiently registering in a timely manner.perform daily administrative duties including: cash management and internal quality assurance.insurance processing and communication.patient account resolution and billing assistance.provide preliminary assessment of patient health.serve as liaison between patients and medical providers.mentor new employees on company policies and practices.develop and implement client service techniques to better serve both the patient and corporate needs.compliance and comprehension of hippa regulations.effectively prioritize tasks education bachelor of science:accounting,expected intostrayer university-fredericksburg,vagpa: skills.