Data Warehouse Analyst/ETL Developer
S. Reynolds & Associates, Inc. is under contract with a major Financial Services company - who with their affiliated companies, can quickly customize, creatively market and efficiently mange innovative financial protection programs, from credit insurance and payment protection to service contracts and warranties – a Data Warehouse Analyst/ETL Developer for their Corporate offices located in Jacksonville, FL.
Essential Duties and Responsibilities:
•Work with multiple departments to design, develop, and maintain reporting environment using ETL and Oracle BI tools
•Interact with the user community to gather and document business requirements, conduct process analysis, and draft conceptual design
•Design and maintain the infrastructure including ETL processing, metadata maintenance, and data validation
•Work with users and other executive members on a routine basis to troubleshoot reported problems pertaining to the reports and the reporting database environment
•Identify the cause, design or develop an approach for resolution
•Upon approval, implement the correction to meet user specific needs
•Assist with training users on tools, and in the use of the tools
•Design, code, test and install complex reports/queries based on technical specifications
•Provide user assistance and direction for ad hoc data reporting. Plan, design (data mapping), and create reports and cubes for business users
Education/Experience Requirements:
•Bachelor's degree
•3+ years of systems design, analysis, and programming experience in a combination of: 2+ years experience with relational databases AND 2+ years experience with BI tools (Oracle OBIEE) and OLAP development
•Equivalent combination of relevant education and experience may be substituted as appropriate
Specialized Knowledge/Beneficial Skills and Experience:
•Experience with Oracle EPM product
•Rodan ETL experience
•Working Knowledge of Star, Snowflake, and ERD modeling
•Erwin, Java, iSeries DB2 all a plus
Please submit your resume to: sjoakman@gmail.com
Senior Accountant – External Reporting
S. Reynolds & Associates, Inc. is under contract with a major Financial Services company - who with their affiliated companies, can quickly customize, creatively market and efficiently mange innovative financial protection programs, from credit insurance and payment protection to service contracts and warranties – seeking a Sr. Accountant for their Corporate offices located in Jacksonville, FL.
Essential Duties and Responsibilities:
•Document management of the SEC filings (10-K, 10-Q, and 8-K) during the quarterly drafting phase. This includes processing of management, auditor and legal comments, maintaining blackline versions and distribution to reviewers as well as the coordination of the Edgarization process.
•Coordination of support documentation for SEC filings. This includes maintenance of the support matrix, advance communication of requirements to source individuals, and ensuring support is received timely and is accurate. Also included is the responsibility to provide final support to the auditors and to reference the document to the underlying support through the revision process.
•Ensure the controls surrounding the process which have been identified for SOX purposes are followed and documented for each cycle
•Research SEC regulatory guidance such as Regs S-X, S-K, G, FD and the 1933 and 1934 Securities Acts as new disclosures are required
•GAAP research related to financial statement disclosures
•Maintenance of SOX procedures throughout the year
•Setup and maintenance of white paper library
Education/Experience Requirements:
•Bachelor's degree required (Accounting or Finance Preferred) • CPA or CPA Candidate with 5+ years of experience with SEC exposure
•Industry experience performing SEC reporting is a plus
•Apply knowledge of financial statements and generally accepted accounting principles to prepare, reconcile, and analyze financial statements (e.g., earnings statements, balance sheets, statements of cash flows, supporting footnotes, etc.)
•Ability to provide guidance regarding the information contained in financial statements and supporting accounting ledgers and journals
•Apply knowledge of applicable regulatory rules (e.g., Security and Exchange Commission, Financial Accounting Standards Board, American Institute of Certified Public Accountants, Bureau of Census, etc.) for external reporting
•Maintains company book of accounts by preparing, collecting, and analyzing accounting data to communicate financial information to company organizations and external customers
•Ensure compliance with government laws and regulations, policies, and professional standards
•Identify and resolve complex financial issues
Please submit your resume to: sjoakman@gmail.com
