Senior Financial Data Manager

Kearney & Company - Washington, DC

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.