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: <<SummarySelf-directed, professional with over ten years experience in managing company administrative and operational needs.Detail oriented with strong organization skills , excellent communication and interpersonal skills. Strong ability to multi-task, manage work flow, meet deadlines, prioritize long and short term goals. Well-versed in planning, budgeting and cost control.
QualificationsImproved department efficiency through implementation of strategic workflow and process improvements.Saved company thousands by renegotiating key contracts.Managed team of personnel.Maintained accurate accounts including cash, inventory, prepaid, fixed assets, accounts payable, accrued expenses and line of credit transactions.Handled customers effectively by identifying needs and efficiently met those needs. Analyzed and resolved client complaints in a timely fashion.
SkillsMS Office, MS Dynamics, QuickBooks, Adobe, Publisher, EFI Fiery, Capture Perfect, Resource POS, Siebel CRM, Leadfoot
ExperienceAdministrative Data Assistant - (Contract Position),XXX5-09/XXX5Acadia Healthcare–Fall River,MA,Processing of requests and corrections to clients' FCC applications via CRM software.  Respond to client inquiries in a timely and accurate fashion. Developed process improvements to enhance workflow.Accounting Assistant - AR,AP & Collections  (Contract Position),01/XXX4-04/XXX4Zitter Health Insights–City,STATE,Posting & proofing of accounts receivable on a daily basis.Verified details of transactions, including funds received and total account balances.Researched and resolved billing and invoice problems.Conducted month-end balance sheet reviews and reconciled any variances.Reviewed entries to ensure accuracy of the G/L.  Reduced outstanding receivables.Franchise Owner / Operator,09/2003-01/XXX4POSTNET–City,STATE,Provided direction on prioritization, and controlled daily operations of the organization.Monitored ongoing expenses relative to budget projections. Improved margins over previous years.Ensured exceptional client service and that team member responsibilities were defined and understood.Cultivated relationships with key vendors and customers to foster ongoing and mutually beneficial business relationships.Reviewed, researched and negotiated insurance, health plans, benefit packages and othercontracts.Created and executed marketing plans. Identified new business opportunities and routinely participated in the sales process.Administrative Assistant - Part Time,08/XXX2-09/XXX3FLOTTEC–City,STATE,Coordinated approval processes of all payables.Received, recorded, cash, checks, and vouchers.Completed monthlybank reconciliations.  Placement of vendor supply orders.Customer liaison for ordertracking, placement, sampleinventory and distribution.International shipping documentation.Scheduled appointments and maintained master calendar.
ExperienceRealtor,04/1999-07/2005Weichert Realtors–Morris Plains,NJ,Residential specialist, annual sales over $2.5 Million. Performed all facets ofsales and closings.Technical Sales,10/1986-05/1994Rame-Hart, Inc–Mountain Lakes,NJ,Domestic and International sales of capital R&D equipment.  Export logistics, contract negotiations.  Presented at symposiums and participated in Industrial Electronics and Chemical trade shows.Regional Business/Credit Manager,08/XXX5-09/XXX5Ms. Desserts–Union,NJ,Created and implemented more efficient receivable business system. AR reconciliation and reporting.   Supervisory responsibility of route drivers.   Credit verification, collections.Sales Coordinator,05/XXX5-08/1984Eva-Tec Marketing–Nashua,NH,Manufacturers' representative for semi-conductors and synergistic components. Liaison between manufacturers, end-users, distributors and sales.Contract and price negotiations.  Participation in trade shows.  Distributor and manufacturer visitation.Account Representative,08/1978-05/1981Medical Billing Services–Cedar Knolls,NJ,Installation of computer billing systems in hospitals and physicians' offices. Training of office personnel on software.  Liaison between physician and all major insurance carriers, Medicare and Medicaid.  Supervisory responsibility andtraining of call center personnel responding to patients and insurance carriers inquiries of medical claims.
EducationAssociate of Science:Business Administration,Expected in1981-County College of Morris-Randolph,NJGPA:Status->>. The result is, No Fit

Fit assessment: No Fit