For the given 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.>> the resume: <<SummaryDetail-oriented and highly organized individual seeking a full-time, accounting position to utilize and apply my educational skills and work experience for the benefit of the organization, as well as my professional growth.
HighlightsGovernment ContractingExperienced with QuickbooksAnalytical reasoningAdvanced computer proficiency (PC and Mac)Indirect Rate CalculationFinancial StatementsStrong organizational skillsEffective time managementGeneral ledger accountingFlexible team player
EducationGeorge Mason UniversityFairfax,VAExpected in2014––Bachelor of Science:Accounting-GPA:GPA: 3.3Northern Virginia Community CollegeSterling,VAExpected in2012––Associate of Science:Business Administration-GPA:Suma Cum Laude GPA: 3.8
ExperienceSuburban Propane-Staff AccountantFruitland,MD,02/2014-CurrentIndependently responsible for all accounting functions (billing, accounts receivable, accounts payable, payroll, general ledger, fixed assets, month/year end close, etc.) for a growing government contractor at the corporate headquartersAligned all financial activity with the regulations of the GAAP.Provide regular analysis of accounting issues and transactionsPost monthly general journal entries, complete monthly bank reconciliations, and prepare month-end supporting schedules including amortization of all prepaid assets and deferred revenue recognitionStreamlined month closing procedures to achieve completion on exact day of month closeMaintain the Fixed Asset Worksheet and associated depreciation schedules; insure proper recording of new purchases and disposals.Record adjusting and reclassification journal entries as necessary Maintain and update various spreadsheets and schedules as related to the yearly indirect rates impacting various contracts and their bill ratesHandle and process check and ACH deposits of over $1 million+ on a monthly basisHelp to maintain customer contracts and setup related Projects for time and expense tracking in the accounting and time tracking system Assist with external DCAA and financial audit requirements including preparing supporting schedules, compiling documentation, responding to questions and other requests to ensure a successful auditCollaborated extensively with auditors during preliminary and year-end audit processes.Collaborate and coordinate with several departments to ensure proper recording and coding of transactions to ensure accurate revenue recognition and indirect rate calculationPrepare and file 1099s in compliance with Federal regulationsComplete annual County Tax Requirements for several counties and assist external tax accountants with their requests to complete filings in 5 plus statesEnsure Quarterly Sales & Use Tax reports are filed in compliance with state regulations.Supplied detailed tax documentation needed to submit accurate corporate returns.Addressed and resolved non-routine, complex and unexpected variances.Oversee bi-weekly payroll and timesheet cycle; including maintaining related records, filing tax forms/reports, processing and reporting voluntary deductions and involuntary deductions such as levies and garnishmentsAssure timesheets are completed in accordance with established policies and contractual agreements.Review vendor invoice transactions, corporate credit cards, and employee expense reports in accordance with prescribed procedures and ensure expenses are posted to the proper accounts.Revised and streamlined inefficient work procedures with automation software.Maintained confidential information, such as pay rates, bonus targets and pay grades.Perform such other accounting, financial, or administrative tasks as may be required from time to time - quite often on short notice - by the CAO or other.Adara Home Health-Accounting & Administrative AssistantMankato,MN,05/2012-02/2014Created invoices in a timely manner, processed deposits, assisted with payroll, followed up with customers to ensure collection of payment, reconciled bank accounts, maintained prepaid asset schedule, as well as other accounting activities.Performed various office and administrative duties such as providing administrative support to the CEO, as well as other employees, placing supply orders, routing of phone calls to appropriate person, and working directly with tech support to ensure proper function of office technology and devices.Provided assistance with employee on boarding, benefits enrollment, and termination.Maintained and reported on several spreadsheets, including bookings, annual recurring revenue, customer user activity, expenses budget vs actual, fixed asset database, and collections reports.Concentrix-Sales AssociateCharlotte,NC,09/2009-11/2011Interacted with customers in a superior customer service environmentManaged and sold inventory in the Fashion Jewelry/Watches and Women's  Shoe Department using Nordstrom's inventory databaseAdvised customers on the benefits and use of products and ensured satisfaction with a follow up purchaseState Of Virginia-Administrative LiaisonDorset,VA,06/2009-06/2009Interacted with executives in a peer coaching environment for CEO's of multinational corporations with international growth aspirations by assisting each speaker during their presentations and socializing with them during other meetings, events, and dinners.Provided secretarial support by taking minutes for each meeting
Skillsaccounting, accounts payable, accounts receivable, administrative support, Adobe Acrobat, ADP, Apple, bank reconciliations, benefits, billing, budget, interpersonal skills, contracts, credit, customer service, database, documentation, financial, fixed assets, general ledger, government, inventory, Excel, Microsoft Office, organizational skills, payroll, policies, presentations, problem-solving skills,  speaker, QuickBooks, recording, reporting, spreadsheets, Tax>>. The result is, No Fit

Fit assessment: No Fit