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:
<< highly skilled, accomplished it software developer with strong experience in software design, development and implementation of enterprise billing and order management applications. she is experience d in using java/j2ee technologies on windows platform for reputed organisations and demonstrate strong experience in j2ee technologies such as spring, jsp, json and servlets. jessica also has good understanding of python programming. technical skills j2ee framework : spring 2.5, spring 3.0servers: apache tomcat 5.0, 5.5database/tools: mysql, oracle, maria db, /sql developer, toadversion control: git.web services: soap, rest, uddi, wsdl.technologies : j2ee (servlets, jsp, jdbc, ejb, java mail), bootstrap, spring batch, spring boot, java, json, junit, python, oracle, html, css.ide / programming tools: eclipse 3.2, eclipse 3.3, mars, netbeans, visual studio education new york institute of technologymanhattan,nyexpected inmay 2016––:computer science-gpa:4.0gpacomputer science summa cum laudeuniversity of mumbaimumbai,expected inmay 2014––:computer engineering-gpa: experience panjiva- , 10/2016-currenttest data management project​description:test data management is a web based application that is used to automate the manual efforts involved in test data setup. it helps to synchronize data in different system and has the ability to retrieve smart samples from production data.responsibilities:designed and developed notification module using spring framework, java mail and jdbc template.involved in design and documentation of enhancement of scheduled scenario module.involved in unit testing and integration testing.provided with daily production support. attending scrum calls to plan and prioritize the activities.involved in creating and merging branches in the repository using git. developed stored procedures and triggers using maria db & oracle.worked on deployment of application.worked on build configuration of application using maven.involved in build and development activities of test environment.environment: spring boot, spring batch, java, apache tomcat, oracle, maria db, db2, jenkins, maven, git​pearson- , 10/2016-currentbilling automation projectdescription:billing automation is a billing software that is used for validating bills (invoices). it highlights bills that are outliers in comparison to historical data and confirms that data in bills is in acceptable limits.responsibilities:responsible for identifying defects, correcting defects and verifying defect fixes and quality related activities by utilizing java, spring and oracle.responsible for writing test cases in test driven development using junit and cucumber.completed automation end to end continuous integration pipeline using tools such as jenkins, maven, git and sonar.preparing test case and test case results during unit testing.environment:java, spring boot, spring batch, java scheduler, tomcat, rest api, oracle, junit, cucumber, jenkins, sonarqube, jfrog, git, aws.skilljar- , 04/2015- 09/2016purchase & order management system project​description:purchase and order management system is a web based application that is used to sort orders based on lead times. it helps to synchronize data in different database system and has the ability to retrieve available inventory from database.responsibilities:implemented payment module using java, spring batch, spring boot, json and jsp.developed soap web services for payment module.created maven archetypes for generating fully functional rest web services supporting json message transformation.developed stored procedures & triggers using mysql and oracle.installation of tomcat server.involved in creating and merging branches in repository using git.worked on end to end continuous integration pipeline using tools like jenkins, maven, git and sonar.environment:java, spring batch, spring boot, servlet, jsp, json, webservices, oracle, mysql, maven, jenkins, git, sonar.new york institute of technology-college project.2016- 04/2016description: this automated software helps in managing details of sales, discounts, payment, products and inventory. it reduces the manual efforts of managing & tracks all the details automatically.​developed and implemented tracking module using python and json.implemented java and jsp and java mail for alert module. skills ajax, apache, api, automate, automation, billing, version control, cvs, data management, database, documentation, eclipse 3.2, eclipse 3.3, xml, db2, ibm web sphere 6.1, ide, inventory, j2ee, java, jsp, javascript, jdbc 3.0, jndi, jquery, json, managing, mars, mail, mvc, mysql, , pl/sql, order management, programming, python, quality, scrum, servers, servlet, servlets, soap, toad, tomcat 5.0, weblogic, xslt.