For the given 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.>> the resume: <<Summary7+ years of experience as a BI developer with a proven track record in Business Intelligence (BI), Data Warehouse (DWH) and Data Analytics related consulting projects.Proven ability to identify business needs and develop valuable solutions to drive accuracy and process efficiency.Experienced in developing, implementing, documenting, monitoring and maintaining the data warehouse extracts, transformations and ETL process in various industries like Financial, Health Care and Retail Industry withSales, Marketing, Inventory Management, Supply Chain and Financedomains.Delivered BI reporting solutions in Power BI, Reporting Services (SSRS).Expertise inData Warehousing ArchitecturesincludingETLdesign,Staging,Transformations,Delta/change Datacapture,Star-Schemas, Cubes andHistoryloadingSkilled in writingT-SQL Queries, Dynamic-queries, sub-queries and joins for generatingStored Procedures, Triggers, User-defined Functions, Views and Cursors.Experience with all phases of software development life cycle (SDLC) and Agile methodologies.Have delivered as a team member, team lead and as an independent consultant on medium to large scale projects.
SkillsData/Business/SystemsTools: MS SQL Server Integration(SSIS), Analysis Services(SSAS), MetlDatabases: SQL Server 2012/2016,Netezza 7.2, Oracle 11g, AzureDevelopment Skills: T-SQL, DAX, MDX, C#BI Reporting Tools: Power BI, Reporting Services Services (SSRS).Data Quality and StandardsAgile MethodologyProgramming Languages:T-SQL, C#, VB Scripting.
EducationExpected in05/2013totoBachelor of Science|Information TechnologyGMR Institute of Technology,Rajam, India,GPA:
Experience05/2020toCurrentSr. Data Analyst/Support EngineerHoneywell|Gladstone,MO,Client:Citi Bank, Irving, TxWorking as Level2 Support Engineer for Data Pipelines the Retail Customer Applications and Azure Data Staging.Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.Developing and supporting DevOps Repos and code pipelines for all ETLs Tasks and JobsDevelopedStandardETLintegrationsto extract Community-Loan-Location data from Mainframes system and implemented Business Rules to confirm the data.Experience in creating and managing SSAS tabular models, creating dimension and fact tables.Responsible for data administration tasksmaintenance plans,performance tuning,backup, and securityfor MS SQL Server systems.Primarily involved in data migration using SQL, SQL Azure, Azure storage, and azure data factory, SSIS, Powershell.Integrated Custom Visuals based on business requirements using Power BI desktop.Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.Developed complex calculated measures using Data Analysis Expression language (DAX).Embedded Power BI reports on the Salesforce portal page and also managed access of reports and data for individual users using Roles.Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.08/2018to05/2020Sr. BI Data DeveloperButler Technical Group|Opa Locka,FL,Led the development of Data Mart for supply chain,marketing departments along with analysis of existing data warehouse for performance improvements.Worked on all phases of data warehouse development life cycle, from gathering requirements, implementation, testing, training and support.Interviewed Business Users of the Data Warehouse and the Business Analysts to understand and troubleshoot the existing bottlenecks and problem areas.Developed applications and designed processes for transformation and data management from company-wide databases.Developed automated data dictionary for Enterprise Data Warehouse using SSRS and SQL.Completed a thorough analysis of the issues with the cube processing and query processing to identify bottleneck for the existing facts and dimensions.Designed and developed ETL packages to facilitate incremental load process.Created aggregates, partitions, attribute relationships and user defined hierarchies with the goal to reduce the cube processing time and query processing time.Created stored procedures and performed index analysis for slow performing SSRS reports to bring down the report rendering time.Developed Enterprise wide cascading reports in SSRS that were used throughout the agency to monitor the performance of the cube, logging of the nightly ETL loads and also to monitor most active users of the cube.Created robust and high-performing ETL mappings usingSSISandMetl.Migrated existing self-service reports and adhoc reports to Power BI.Developed custom calculated measures using DAX in Power BI to satisfy business needs.Assisted users in accessing databases, troubleshooting malfunctions and removing system-based barriers to task completion.11/2016to07/2018Sr. ETL DeveloperKairos Technologies Inc|City,STATE,Client:Cvs Caremark, Irving, TxWorked on ambitious project to develop an Enterprise Wide Drug plan Record system data warehouse connecting Insurance companies and Drug Manufacturers for CVS Caremark.Worked with Business Intelligence Manager to plan BI strategies, create BI road map and budget plans to deliver on organizations Business Intelligence needs.Assessed the impact of current business processes on users and stakeholders.Developed multiple dashboards, analytical reports, KPIs and Interactive reports based on business requirements using SSRS to support executive business needs.Transferred data from various data sources/business systems including MS Excel, MS Access, Flat files,COSMOS etc. to SQL Server using SSIS.Implemented Query Optimization and performance tuning for slow performing SQL queries.Involved in writing complex T-SQL queries and stored procedures to perform data transformations and to support SSRS Reports.Involved in creating User Security and Roles in reporting services at both parent level and report level.Supported maintenance of Data Quality Service's (DQS) knowledge base and development of Master Data Service's database.07/2013to04/2016Business Data AnalystTata Consultancy Services|City,STATE,Client:Sun Trust Bank, USDesigned, Implemented, and aided End-to-End data migration project using Microsoft SSIS.Assisted in creation of internal applications for marketing and customer relations departments, including financial reporting tools and reports.Designed SSIS Packages to extract data from various data sources such as Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.Performed rigorous business case analyses and proposed various process improvements.Used Excel and Access applications for visualizing the data functionality.Led an initiative to convert all excel files which were used in in-house time/expense reporting wherein I automated the process to find discrepancies in timesheets by creating tables, views using stored procedures.Client :Marks and Spencer,UKImproved business direction by prioritizing customers and implementing changes based on collected feedback.Analyzed open orders, backlog, and sales data to provide sales team with insights.Created tables and define their relations by using foreign key and primary key relationship.Involved in creating database objects using stored procedures, Triggers, Functions, Views and T-SQL Joins using T-SQL.Performed normalization of database to reduce redundancy and achieve maximum system performance.Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionalityWorked as ETL Developer for an End-to-End implementation of Operation Data Warehousing Project.Responsible for data integration and transformation using SSIS.Formulated and documented the physical ETL process design based on business requirements and system specifications with strong ETL design skills.Created source to target mappings, transformations, lookups, aggregations, expressionsInvolved in scheduling reports, creating snapshot reports and subscription for the reports Using SSRS.>>. The result is, No Fit

Fit assessment: No Fit