Job description:
position title: senior accountant organization: jewish family service of san diego department: family and community services division organization: jewish family service of san diego position type: full-time (37.5+ hoursweek), exempt salary: $82,000 - $88,000year total compensation: in addition to standard pay, compensation for this position includes: comprehensive, low-cost healthcare coverage for employees generous employer 401(k) contributions employer-covered life insurance time away from work: being able to take time away from work is critical in bringing your best self to work. time off benefits for this position include: generous paid vacation time and sick leave 17 paid holidays, including federal, jewish, and floating holidays 2 wellness days to be taken any time during the year to support employees mental wellness position overview:the senior accountant is an integral part of the financial planning function within the finance & accounting team. the position works closely with a range of departments and programs, including program directors and senior staff. the candidate must be a self-starter who is diligent, proactive, detail oriented, and is expected to contribute significantly to the finance & accounting team. under the direction of the senior directorcontroller this position will support the agency fiscal operations through transactional processing, financial analysis, annual budget development and monitoring, cost allocation, monthly forecasts, program and annual audit support, and the implementation of financial and compliance controls. the senior accountant will serves as a key resource for the organization and provides daily financial oversight to ensure that the financial records are complete, accurate, and comply with generally accepted accounting principles, policies, and regulations to facilitate solid decision support. responsibilities: deliver monthly financial reporting, analytics and insight on performance metrics, benchmarking progress against targets, initiatives, and strategies conduct analytical reviews for departmental and programmatic activities to support complex financial and budgetary forecasting; evaluates alternatives and makes recommendations develop an understanding of organization wide departments and programs funding streams andor cost structure assist with analysis used for decision-making and recommendations to management and programs analyze financial & operational results to understand and report underlying causes for performance and variance assist with the agency budgeting and forecasts scenario planning based on changing assumptions in revenue, personnel, and other direct project costs perform budget to actual variance analysis to identify causes, adjustments needed, trends, personnel reclassifications, potential budget shortfalls or cost overruns, and opportunities for cost savings assist with weekly cashflow management reports and projections prepare monthly, quarterly, annual and ad-hoc financial statements with actual and projected financial positions ensure the integrity of key processes by understanding systems, flow of transactions, internal controls, and recommending efficiency and effectiveness improvements work with the finance & accounting team to identify areas or opportunities for improvement support organizational and management practices as applied to the analysis, evaluation, development, and implementation of programs, policies, and procedures perform variance analyses and account reconciliations as needed assist with month end closing, year-end closing and reconciliations and preparation for the external audit and prepare necessary audit schedules as needed ad hoc requests and one-off projects and other duties as assigned skillsexperienceabilities that are a must-have:bachelor's degree in accounting or finance is required minimum 8+ years accounting experience with progressive and relevant and analytical budgeting, analysis, and reporting experience minimum 5+ years in the nonprofit industry knowledge and understanding of cost methodologies, budgeting concepts, practices, and procedures, and accounting competencies, including an understanding of revenue recognition understanding of gaap compliance and uniform guidance and omb circulars excellent written and verbal communication and interpersonal skills strong analytical, organizational and time management skills work well in a team approach environment demonstrably strong judgement and decision-making skills ability to multi-task and prioritize workflow advanced in excel and proficient word and outlook skillsabilities wed like you to have: desire to work in a fun, friendly, collaborative, and professional environment passion for working in a non-profit, human services organization dedicated to helping individuals in need experience with financial edge not required but preferred important notice: incomplete submissions will not be considered. please, no phone calls. please, principals only. please, local candidates only (relocation is not provided). about jewish family service of san diegojewish family service of san diego is a client-centered, impact-driven organization working to build a stronger, more resilient community. for over 100 years, jewish family service has been a trusted resource for the entire community, offering an array of services that are always life-changing, and often life-saving. at jewish family service, we believe our employees are the backbone of our agency. we strive to ensure that each employee is treated with dignity and respect. our goal is your success. come work at jfs and be our partner in moving forward together. to learn more about jfs, please visit jfssd.org. *jewish family service is an equal opportunity employer. all applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status.

Resume:
<<summary7+ years of it industry experience in in designing and developing data mining/analytics solutions, data centric integration, developing and maintaining business analytics.adept in data query, data migration, data analysis, predictive modeling, machine learning, data mining, and data visualization implementations with extensive use of sql, python, r, java, and unix shell scripting with platform of toad, oracle developer, jupyter notebook, pycharm, r-studio, tableau, hadoop with spark.experience in predictive analytic procedures used in supervised learning (classification, regression, decision trees, random forest, svm, neural networks), unsupervised learning (clustering-k-means and pca), and reinforcement learning.solid theory background for machine learning, data mining, text mining, graph mining, statistics modeling, nlp and deep learning.expert in natural language processing like pos tagging, parsing, named entity recognition, relationship extraction, information retrieval, sentimental classification, machine translation, etc.solid knowledge of deep learning algorithms like cnn, rnn, lstm, gru, etc. for text mining and image processing. sql server, teradata and mysql using a lot of subqueries, joins, aggregate functions, analytical functions, and temporary tables, etc.worked on big data analytics, hadoop ecosystems (hadoop, sqoop, hive, pig, mapreduce) and spark for big data migration, cleaning, transformation, processing, query and analysisfamiliar with software lifecycle includes requirement collecting/documentation, development, and testing for unit, smoke , integration, system, non-functional testing regarding performance, scalability, usability, enduration, load, and volume testing, and regression testing, multivariate testing (a/b testing) and system maintenance.work with business domain experts and application developers to identify data relevant analysis / mining and, develop new predictive / analytical modeling methods and/or tools in financial (like loan and foreign exchange), product, customer, sales domains, etc.experience in data aggregation and reduction techniques of large data sets with high performance and parallel computing for high performance analytical projects.involved in diagnosing and resolving predictive / analytical model performance issues, monitoring analytical system performance · and implementing efficiency improvements.conversant with ms sql/ oracle plsql and rdbms. contributed in data definitions for new database file/table development and/or changes to existing ones as needed for analysis and mining purpose.experience d oracle pl/sql developer for designing, developing, debugging , maintaining and administrating database in oracle rdbms. solid experience in pl/sql and sql programming and performance tuning.familiarity with oracle data warehousing features such as star & snowflake data modeling schemas, materialized views, bitmap indexes, index organized tables, external tables etc. and oltp system using b-tree index, hash join, etc.experience d in front-end developing using java, javascript, c++ and back-end developing using c.professional in integrating and maintaining code using version control tools pvcs, svn, cvs.solid experience and knowledge in etl and data warehousing concepts.data processing experience in designing, implementing transformation processes using etl tool.involved in all aspects of etl- requirement gathering with standard interfaces to be used by operational sources, data cleaning, data loading strategies, etl mappings designing, documentation and etl jobs performance testing.using unix bash/corn shell scripting to do backend process operation, system resources checking, job scheduling, batch data loading, performance tuning and reporting.conversant with project management deliverables and sdlc phases – waterfall and agile.a self-starter, team player, excellent communicator, prolific researcher.expert technical documentation skills. strong interpersonal and communication skills (both written and oral); ability to communicate with people in a wide variety of areas and at various levels from technical specialists to senior management. skills roles: data scientist, data analyst, business system analyst, oracle plsql developerdata visualization: d3.js, tableau, r visualization packages, microsoft exceldata analytics tools/programming: python (numpy, scipy, pandas, scikit-learn, gensim, keras), r(caret, weka, ggplot ), matlab, microsoft sql server, oracle plsqlmachine learning algorithms: classification, regression, clustering, feature engineeringbig data tools: hadoop, mapreduce, sqoop, pig, hive, nosql, cassandra, sparkothers:deep learning, nlp, topic modeling, sklearn, graph mining, text mining, c++ , java, javascript, asp, shell scripting experience data scientist, 08/2011to 09/2016lockheed martin corporation– ,actively develop predictive models and strategies for effective fraud detection for credit and customer banking activities using kmeans clustering using python.assisted senior data scientist to do text mining on customer review/comment data, using topic modeling and sentimental classification, using deep learning algorithms like cnn, rnn, lstm, remediate according financial products using python.assisted senior quantitative analyst in assessing risk management of financial derivative products like foreign exchange products, bonds, funds, etc. using machine learning techniques for providing appropriate investment recommendations using collaborative filtering recommender system using python.mentored sophisticated organizations on large scale customer data and analytics using advanced machine learning and statistical models relying for issuing loan using random forest using r.performed k-means clustering in order to understand customer backgrounds and segment the customers based on the customer transaction behavior information for customized product offering, improve existing profitable relationships and to avoid customer churn, etc using r.worked on interactive dashboards for building story and presenting to business using tableau.implementing hadoop to provision big data analytics platforms for customer data. used mapreduce, sqoop, hive and spark to migrate and analyze large call-quality-data datasets from multiple data sources like integrated funds transfer system like fedwire, chips, swift for securities, treasury or derivatives, and web-based cash management systems egifts, giftsweb edd for fraud detection and risk management, for accounts based on positive pay, and automated cash handling, balance reporting, etc.installed and configured hadoop cluster in test and production environments; moving data from oracle 9i database to hdfs and vice-versa using sqoop; collecting and aggregating large amounts of log data using apache flume and staging data in hdfs for further analysis; developed multiple mapreduce jobs in java for data cleaning and preprocessing; writing pig scripts to transform raw data from several data sources into forming baseline data; solved performance issues in hive and pig scripts with understanding of joins, group and aggregation and how does it translate to mapreduce jobs; developed oozie workflow for scheduling and coordinating the etl process; using spark for further data analysis/mining.experience in using sequence files, rcfile, avro and har file formats.work with data analytics team to develop time series and optimization.involved in development and maintenance of oracle database using plsql and back-end development using c/c++ for intra-net management system for employee management system (ems) and agent pay-out system (aps).business system analyst, 04/2009to 08/2011accenture– ,project summary:this project is in application service group for mercury system in canon usa, inc. , which mainly in charge of the new item request, item disclosure between companies, item data import from other canon americas companies to canon usa. canon americas master inquiry, model tree maintenance, model configurations, and camera/video merchandise maintenance for canon americas systems includes- s21 for canon usa merchandise master, s98 for panama, cci21 for canada, s85 for mexico, chili, brazil, and argentina, ideal for latin americas countries.hardware/software:windows vista/nt/xp/7, linux, oracle 11g/10g/9i/8i, sql plus , oracle sql developer, toad, microsoft sql server management studio 2008,microsoft visual studio 6.0,odbc/jdbc , microsoft iis 5.1.1, putty, cygwin, winmerge, vpn, itg project management system, pqedit, iis, autosys-pc-xware 5.1.0, ms word, excel, access, project, visioresponsibilities:operational support for canon americas mercury system, includes data adjustment/research, batch data loading, system migration, technical and functional specification documentation, reports, business process alignment, workflow stuck, and reconciliation, etc.break/fix any issues or bugs collected from client and development regarding setup, performance, functionality, and workflow stuck, etc.system enhancement regarding functionality and performance, etc.reproduce and review existing oracle 9i schema objects includes tables, temporary tables, views, materialized views, indexes, triggers, procedures, functions, packages based on customer requirement and system upgrade using toad and oracle sql developer tools.review and analyze asp code for umc mercury application web development for data research and system feature fix and enhancement using visual interdev 6.0.query real-time data regarding canon americas new item request, item status inquiry, item data disclosure and import, model configuration and maintenance, warranty maintenance, and model configuration inquiry , etc. using complex sql queries on oracle 9i canon mercury database.using unix bash/corn shell scripting to do backend process operation, system resources checking, job scheduling, batch data loading, performance tuning and reporting.maintain scheduled day and night batch jobs for mercury system using autosys-pc-xware and unix box and check the mq series using pq edit.implement client, session, action, module, service, instance level end-to-end application tracing using sql trace with tkprof, and explain plan to check execution plans for high-load and top sql statement.using cygwin/ ftp- putty with unix bash shell to make a tunnel for oracle database connection.using tortoise svn for code check-out, update, and release–comparison, etc.tracking and documenting tickets for development and reproduction using itg ticket tracking system.assisted qa and build team to be involved in unit, smoke, integration, system, uat, non-functional testing regarding performance, scalability, usability, enduration, load, and volume testing, and regression testing and maintenance using soup ui and seapine qa wizard pro for product release.data loading using imp/exp, data pump, and external tables from americas mercury system to s21- ross-cusa retails system, and global mercury system.oracle plsql developer,2008to 04/2009cognizant technology solutions– ,project summary:nyu langone medical center, a world-class patient- one of the nation’s premier centers for excellence in healthcare, biomedical research, and medical education. the project is to develop new oracle database objects on online health information managment system on findwdev instance/server for 29 nyu medical school departments using in clinical, education, research, and foundational areas, etc. provide further data to be loaded into dwh for historical record, decision support and datamart for reports, and cube for ui display.hardware/software:unix, oracle 11g, oracle developer 11g, oracle ebs 11, erp r12, ibm datastage 8.0 (designer, director, manager, parallel extender), sql server management studio 2008, toad for oracle 9.0, tsql & pl/sql, xml, erwin, microsoft visio, autosys, ibm data stage 8, oracle reports 11g.responsibilities:independently develop oracle database objects includes tables, views, materialized views, indexes, triggers, functions, procedures, packages, etc.cooperated with ba, sme to collect and document database design requirements and do data modeling with db architect using erwin and microsoft visio.assisted dba for job scheduling, data loading, and performance tuning using oem, sql tuning/access advisor, hints, explain plan , sql trace and v$ performance views under unix.write complicated queries using a lot of aggregate functions, joins, analytical functions, subqueries , etc. to provide real-time data from oracle db for client and ui development supporting.checking execution plan using explain plan together with sql trace with tkprof using trcsess under unix to realized end-to-end application tracing.add optimization hints into high–load and top sql statements to change the optimization goal, access method, join method, join order, and parallelization, etc.designed and developed etl processes using datastage designer to load data from oracle to staging database and from staging to the target data warehouse.worked with datastage manager for importing metadata from repository, new job categories and creating new data elements.used datastage stages namely hash file, sequential file, transformer, aggregate, sort, datasets, join, lookup, change capture, funnel, peek, row generator stages in accomplishing the etl coding.job scheduling using autosys. coorporated with qa team for debugging, unit, system, , regression testing for new iso release production.working on linux system for batch data loading, job scheduling, and system resource checking, etc.assisted back-end developer for reviewing and debugging c program for health information management systems.involved in web development of online health information management systems using java.reviewed and reproduced online java reports of health information management system, checked db references in it for intelligent decision support system education master of science:computer science,expected in2016touniversity of california-los angeles,cagpa:gpa:3.78courses: -statistics programming -databases and knowledge bases -graphs and network flows -language and thought -current topics in computer theory(machine learning algorithm) -computer science classics(basic data science) -data mining and big data analytics -system securitymaster of science:electrical engineering,expected in2010touniversity of bridgeport-bridgeport,ctgpa:gpa:3.62courses: computer networks -database management systems -data and computer communications -data structuresbachelor of science:telecommunications engineering,expected in2007tojilin university-changchun,jilingpa:gpa: 3.50.