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 summaryhighly skilled software development professional bringing more than 4 years in software design, development and integration. offering advanced knowledge of cloud components, data ingestion, and java/python/javascript programming languages. skills python, java, html, css, javascript;application frameworks: gcp bigquery, pub/sub, apache beam, k8s, stackdriver, grafana, tableau, sumo logic, datadog, new relic, apigee, angular, node.js, spring mvc, spring boot, spring data, spring cloud, netflix oss,jpa, maven, tomcat, hibernate, express, redis, postgresql, mongodb, docker, restful api, nginx, tensorflow, nlp,react, git, apache bench, postmanapacheapicookingcssdatabasedebuggingdeliveryengineeretlfunctionalgcphtmljavajavascriptleadershiplogicdirectormarketmongodbmvcnlposspostgresqlpricingprogrammingprogresspythonqualityexpressreal-timesoftware developerstableautablestomcatworkshops work history software developer, 12/2018-currentmaxar technologies ltd– ,designed and deployed the first data ingestion pipeline on google cloud platform (gcp) by using cloud pub/sub, cloud dataflow, cloud dataprep, bigquery, and stackdriver to collect, store and monitor event data streaming; the ingestion pipeline helps data scientist team on collecting the order level data/events, iot devices status without touching production database and support real-time data collecting designed and implemented ingestion service and schemas store by using typescript; the ingestion service and schemas store helped the entire team automatic generating unpacking pipeline and secondary table for all internal consumers designed and implemented javascript sdk & ingest url to publish events from backend service, iot devices, and 3rd party service; using jwt token as authorization, apigee as api key management tool collaborated with data scientists team to collect requirements of demand prediction models and delivered etl tables by using bigquery apache beam(dataflow) and cloud dataprep; supported 2 data scientist/engineer team, 4 ml models including order preparation, dynamic pricing, etc implemented kpi dashboards for cross-functional leadership to monitor data growth weekly and for 4-5 teams of data scientists to monitor data ingestion and data quality daily.used tableau and grafana to build data models and visualize data hosting millions of daily data entries led a team of 4 software developers to collect user requirements from the factory operations team, translated the business to technology need to the services team and ensured consensus, spearheaded the build of grafana dashboard to track time-series metrics from iot device.the dashboard was used by the factory team to monitor progress and by the cross-functional data scientist team to build on models built iot device alerting and monitoring system prototypes by ingesting data, customizing apache beam job to run and normalize data, and created real-time alerting functions with zero delay; collaborated with 2 pms to understand user requirements, owned the end-to-end prototype build in 2 weeks, demoed in front of 10+ director-level board members decoupled and migrated the monolithic backend service to microservices by using node.js, restful api designed and implemented the market microservice and database to support food cooking and delivery service by using postgresql, knex, restful api, express.js, and typescript onboarded 100+ incoming software developers nationwide; revamped and expanded knowledge transfer document, conducted workshops and 1:1s to help new joiners set up and understand environments, owned debugging and answered questions.programmer, 03/2016- 12/2018new jersey institute of technology– ,designed and implemented an auto-test-system(ats): handle the entire process including design, development, implementation, and integration designed test packages (data checker, autographing tool, auto-input-data-file module, testing interface, and results checker) based on different standard requirements, ensure accuracy and sustainability of test results. education master of science:,expected in 05/2014-syracuse university-syracuse,nygpa:status-bachelor of science:electrical, electronics engineering technologies,expected in 07/2011-inner mongolia university of science & technology-,gpa:status- skills python, java, html, css, javascript;aapplication frameworks: gcp bigquery, pub/sub, apache beam, k8s, stackdriver, grafana, tableau, sumo logic, dataddog, new relic, apigee, angular, node.js, spring mvc, spring boot, spring data, spring cloud, netflix oss,jjpa, maven, tomcat, hibernate, express, redis, postgresql, mongodb, docker, restful api, nginx, tensorflow, nlp,rreact, git, apache bench, postman,apache, api, cooking, css, database, debugging, delivery, engineer, etl, functional, gcp, html, java, javascript, leadership, logic, director, market, mongodb, mvc, nlp, oss, postgresql, pricing, programming, progress, python, quality, express, real-time, software developers, tableau, tables, tomcat, workshops.