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:
<<professional summaryover 7 years of progressive human resources experience in multi-faceted business environments. a vast experience in human resources data analysis and reporting, coordinating staffing and corporate activities, well as a demonstrated ability to manage a diverse rang of tasks and able to meet deadlines in a time efficient manner. skills hris oracleability to multi-taskaudit preparation and reportingperformance management systemseffective communicationstrong interpersonal skills work history hris data coordinator, 02/2008- 09/2014engie– ,maintained the data integrity of oracle r12 which housed all employee information and affected other systems used within the company using effective auditing procedures.first point of contact for all hrms related issues; for both hr and colleagues. handled all related inquires. ,employee and manager self service.processed benefit changes into vendor electronic enrollment system (united healthcare pos & hdhp and guardian dental & std)produced adhoc reports for all levels of management across the company.assisted hr and payroll to resolve discrepancies that show up when running payroll. also addressed and resolved general payroll related inquires.collaborated with compensation team to evaluate, update, and upload jobs on sharepoint.worked with recruiters to ensure applications in i-recruitment were created and processed accurately.coordinated with the information system team to ensure all hr processes and requests are executed. included but not limited to testing test scripts.human resources assistant/receptionist, 08/2006- 02/2008kimball midwest– ,created requisitions to offset vendor invoices, and order office supplies using oracle.assisted with and coordinated the planning of corporate events such as holiday parties, meet and greet with current ceo, flu shots, etc.supported human resources staff with performance reviews and new hire orientations.composed and executed general correspondence and proposalsassisted hiring managers with summer intern programprovided support to hr staff members and other administrative personneledited and posted job openings internally. also, updated and maintained job descriptions on the hr drive.coordinated complex interviews, travel schedules, accommodations and trip logistics for candidates and executives.inventory associate, 08/2006- 10/2012ace hardware– ,communicated with carriers to avoid delays in meeting deliverables.supported 2nd shift managers on daily operational issues.verified physical inventory counts.operated and keyed in audited data in the warehouse maintenance system with a high level of accuracy.conferred with customers to expedite or locate missing, misrouted, delayed merchandise.tracked time spent on assignments each day for about 80 associates for productivity reporting.verified computations against physical count of stock.operated electric pallet jacks, forklifts and machinery safely.office associate, 01/2005- 08/2006danaher– ,communicated with carriers to avoid delays in meeting deliverables.investigated, prepared and processed data of overdue vehicles.supported 2nd shift managers on daily operational issues.conferred with customers to expedite or locate missing, misrouted, delayed merchandise.participated in the annual “cranbury drug free fair”.directed guests and routed deliveries and courier services.answered and managed incoming and outgoing calls while recording accurate messages.administrative assistant, 02/2004- 09/2004spirtas wrecking company–city,state,tracked business accounts with vendors using exceltracked funds flow in and out of various sub ledgersreconciled accounts, facilitated payments and receipt of fundsmanaged vendor relations at all levels.maintained all logs and reporting documentation.ordered and distributed office supplies while adhering to a fixed office budget.answered and managed incoming and outgoing calls while recording accurate messages.customer service rep, 03/2003- 09/2003call sciences–city,state,communicated with customers through email and telephone to resolve open issues.answered product related questionscreated and maintained billing spreadsheets.performed reconciliation between various customers.investigated and resolved customer inquiries and complaints in a timely and empathetic manner.referred unresolved customer grievances to designated departments for further investigation. education master of science:marketing,expected in2004-college of st. elizabeth-morristown,njgpa:status-bachelor of science:business administration,expected in2002-college of st. elizabeth-morristown,njgpa:status- skills administrative, billing, documentation, email, funds, guardian, , inventory, access, excel, microsoft office, oracle, payroll, performance reviews, personnel, pos, processes, proposals, recruitment, reporting, spreadsheets, telephone, travel arrangements, troubleshooting, vendor relations.