For the given job description <<NATIONAL HOT ROD ASSOCIATION
Senior Staff Accountant
Who we are:At the National Hot Rod Association, we crave speed. We race the fastest vehicles in motorsports at speeds of more than 300 mph, with power exceeding 11,000 hpNHRA is the most extreme sport on the planet! At NHRA, we believe in Speed for All, which provides competition opportunities for all drivers, from street-car owners to professional racers. NHRA also offers career-driven opportunities off-track and behind the scenes. We serve content to our highly engaged audiences on-site at events, on the Fox broadcast and Fox Sports networks, at NHRA.com, through our live streaming service NHRA.TV, and within the pages of our publication, National DRAGSTER. Our team supports the infrastructure of local grassroots-level racing all the way up to the professional touring series all across the country, as well as our corporate offices and remote functions.
If you are looking to join a dynamic and high-speed organization in the sports and entertainment space, have the drive to innovate and the satisfaction of seeing your work in action, read on
The Job: The Senior Staff Accountant responsibilities include, but are not limited to, general ledger accountability, financial reporting, as well as financial profitability analysis and other special projects as assigned.
Primary Responsibilities:Prepares asset, liability, and capital account entries by compiling and analyzing account information.Summarizes current financial status by collecting information, preparing balance sheet, profit and loss statement, and other reports.Reviews and reconciles breakdown of expenditures.File state sales and use tax across multiple jurisdictions, also including property taxes.Assist with annual external audit by preparing assigned schedules for the annual and interim audit.Regularly maintain detailed reconciliations of all balance sheet accountsAssist with special projects assigned by management.May direct other clerical accounting employees in the support functions of finance and accounting.Performs similar job-related duties as assigned.
Minimum SkillsExperienceEducation Requirements:Bachelors degree in business administration or accounting required.Must have a minimum of 3 years of staff accountant experience.CPA preferred.Must have strong analytical skills coupled with excellent knowledge of basic accounting principles.Must be able to communicate effectively in writing and verbally to all levels of management.Must be able to effectively handle multiple projects simultaneously in a deadline driven environment.Must be comfortable working independently and reporting to all functional leaders of the Company.
Physical Requirements:Able to work at a computer all day.Ability to talk on the phone as needed.No heavy lifting required.>> the resume: <<ProfileHas a Master’s of Science Degree in Management Information Systems with Business Intelligence Concentration.Has  5+  years of experience working as a SQL server Developer, SQL DBA, and Data Analyst with excellent analytical and problem-solving skills to work with minimal supervision.Strong knowledge and experience of RDBMS like MS SQL Server 2008 R2/2012, MS Access, MySQL and T-SQL (queries, stored procedures).Strong knowledge and experience in Business Intelligence –SSIS, SSRS, SSAS, Power BI ( Power Pivot, Power Query, Power View, Power Map and Pivot Table,).Experience in Windows server 2008/2012 Active Directory Administration(Users and Computers, DNS, DHCP)Experience with data analysis and visualization tools like Excel and Tableau
Core QualificationsBusiness Intelligence /Data AnalyticsDatabase Development /AdministrationWindows Server AdministrationWindows AzureData warehouse/Data MiningMicrosoft OfficeWeb DesignAmazon Web Services
Technical SkillsSQL Server, MS Access, MS Excel, MYSQLSSIS, SSAS,
SSRS, Power BIT-SQL, VBA (MS Access), Excel MacrosTableauRapidMiner, XLMiner (Data Mining)HTML, CSS, WordPress, Dreamweaver, Photoshop, JavaScript
Professional ExperienceSQL Devloper/DBA/Data Analyst,09/2012-03/2015Market Footwear, Fred Lurie Associate Inc.–City,STATE,Responsibilities:Created ETL packages involving various data sources (SQL Server, Flat Files, Excel source files,  etc)  using MS SSISDeveloped data quality solution using SQL Server data services (DQS) as part of ETLAnalyzed data using using SSAS, Excel, Tableau and Power BI tools for decision making processBuilt Self Service Business Intelligence  dashboards using Power BI tools in Excel.Wrote T-SQL queries  for data Analysis and ReportingDeveloped reports using MS SQL Server Reporting Services (SSRS) and ExcelHelped decision makers to understand data on reports and dashboards and gain insights.Installed, administered and maintained MS SQL Server 2008/2012, including upgrades, security, configuration and service packsDesigned, implemented, and maintained SQL Server databases.Designed and implemented tables, views, functions, stored procedures and triggers in SQL Server.Planned and implemented SQL Server Security and database permissionsPerformed  Database Performance Analysis and Tuning using Database Engine Tuning Advisor, SQL Server Profiler and SQL Server Extended EventsSetup High-Availability as part Disaster Recovery Strategy for the SQL server 2012 databases (Failover Clustering, Database Mirroring, Log Shipping and Replication).SQL Server developer/DBA,07/2009-08/2012Cifra Systems–City,STATE,Responsibilities:As a mid-level DBA, Installed, configured, administered and secured SQL servers 2008/2008 R2.Created and optimize database objects, e.g. Tables, Views, indexes, cursors, stored procedures, functions and Triggers.Scheduled and automated maintenance plans using SQL Server Job Agent.Scheduled and automated full/differential/transactional backups and implemented recovery strategies.Configured and monitored database Mirroring, Replication and Log Shipping as HADR strategy.Planned and implemented SQL Server Security and database permissionsExtensively used Joins and sub-queries for complex queries involving multiple tables.Created indexes (clustered and non-clustered)  to speed up query performance.Designed Excel dashboard  for tabular and chart reports with drill down  functionality.Web Designer/SQL DBA/Developer/Media Specialist,02/2005-04/2009Miami Christians Fellowship–City,STATE,Designed desktop database application in MS Access using VBADeveloped financial report using MS Access and ExcelCreated website for the organization utilizing HTML, WORDPRESS, CSS, PHP, MSSSQL and MYSQLPerformed regular website maintenance and update while also designing graphics for banners, flyers, and postersRecorded and edited videos to be distributed in DVD , CD format and upload them to organization’s websiteTrained staff members how to utilize computers, use software to maintain website and other media support servicesWeb Developer and Database Support,07/2003-2005Hotsilhouette, Inc.–City,STATE,Responsibilities:Developed and maintained  company's websites using Dreamweaver, HTML, CSS, ASP.NET, JavaScript.Designed and managed back-end SQL Server databases for web applications.Wrote complex T-SQL queries to manipulate  dataDesigned and edited graphics and photos for websites using Photoshop.Installed, Configured and managed SQL Server and Access databases.Analyzed sales data from different sources and created dashboards using MS Excel.Provided technical computer support to end users.
EducationMaster of Science:Management Information Systems,Expected in2015-Nova Southeastern University-Fort Lauderdale,FLGPA:Status-Concentration: Business IntelligenceAssociate of Science:Computer Programming and Analysis,Expected in2003-Miami Dade College-Miami,FLGPA:Status-Bachelor of Science:Agriculture (Plant Science),Expected in1988-Haremaya University Of Agriculture-Haremaya,HarerGPA:Status->>. The result is, No Fit

Fit assessment: No Fit