Kearney & Company - Washington, DC

posted 7 days ago

Full-time - Senior
Washington, DC
Securities, Commodity Contracts, and Other Financial Investments and Related Activities

About the position

The Senior Financial Data Manager at Kearney & Company is responsible for overseeing various financial data initiatives, including the Finmart Financial Data Warehouse and G-Invoicing. This role involves maintaining and upgrading financial data systems, training staff, analyzing complex financial data, and ensuring the integrity of financial transactions. The position requires a strong background in information technology, particularly in database management and financial data analysis, to deliver effective client recommendations and support internal controls.

Responsibilities

  • Work on different initiatives such as Finmart-Financial Data Warehouse and G-Invoicing.
  • Upgrade and maintain the Finmart (Financial DataMart).
  • Assist with training and testing scenarios for the G-Invoicing initiative.
  • Analyze and maintain logical and physical database designs using various tools (i.e. Erwin).
  • Administer SQL Server 2016 or more recent versions.
  • Automate processes by creating and customizing reports for OFM (Ad-Hoc reports).
  • Analyze, validate, and reconcile a large volume of financial transactions (i.e., Statement of Disbursement).
  • Conduct data retrieval and presentation skills including ETL (Extract, Transform, and Load).
  • Research and analyze complex financial data issues and deliver client recommendations.
  • Review IT Audit - SOC 1 Report (Complementary User Entity Controls) and Internal Control Review.

Requirements

  • Bachelor or Master of Science Degree in Information Technology, Information Systems, Computer Science, Software Engineering, or related field.
  • Minimum of 6 years of experience in Information Technology with at least 4 years of federal finance and/or accounting experience.
  • Understanding of the ETL paradigm.
  • Extensive experience with writing complex and efficient SQL queries.
  • Extensive experience with performance tuning of database architectures.
  • Experience with SQL Server Integration Services (SSIS), MS Access, and Visual Studio.
  • Experience with architectural design for Entity Relationships and Star Schemas.
  • Experience creating and customizing ad-hoc reports.
  • Experience performing root-cause analysis identifying issues and alternative solutions.
  • Ability to analyze large financial data sets.
  • Proficient in Microsoft Office 365 (Excel, Word, PowerPoint).
  • Demonstrates strong oral and written communication and interpersonal skills.
  • Ability to obtain and maintain a U.S. security clearance (requires US Citizenship).

Nice-to-haves

  • Minimum of 5 years experience writing complex and efficient SQL queries.
  • Experience with the Momentum Financials ERP system.
  • Familiarity with implementing G-Invoicing.
  • Experience supporting software development lifecycles such as waterfall, spiral, and evolutionary prototypes.
  • Experience with metadata designs in OLAP systems such as MicroStrategy, Tableau, or Cognos.
  • Understanding of Oracle drivers and how to install and reference them in ODBC connections.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service