Kearney & Company is seeking a Senior Financial Data Manager to join our team! Specific responsibilities include, but are not limited to: Work on different initiatives (Finmart-Financial DataWarehouse, G-Invoicing) Upgrade/Maintenance of the Finmart (Financial DataMart) Assist with the training and testing scenarios for the G-Invoicing initiative Analyze and maintain logical and physical database designs using various tools (i.e. Erwin) Experience administering SQL Server 2016 or more recent versions. At least 5 years of experience Experience using MS Visual Studio and MS Access Automate processes by creating and customized reports for OFM (Ah-Hoc reports) Analyze, validate, and reconcile a large volume of financial transactions (i.e., Statement of Disbursement) Data retrieval and presentation skills to include ETL (Extract, Transform, and Load) Research and analyze complex financial data issues and deliver client recommendations IT Audit - SOC 1 Report review (Complementary User Entity Controls), Internal Control Review (Delegation and User Roles, System User Access) Qualifications Required Qualifications: 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) Preferred Qualifications: 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 KCO1701 #LI-MA1 Overview Exclusively focused on the Government, Kearney & Company provides financial services, including auditing, consulting, and technology services. Our commitment to our employees and clients as well as to dedication and trust, critical values to our Firm, have led to Kearney’s recognition as one of the leading accounting firms in the country. Based on our employees’ feedback, we are also consistently rated a Best Place to Work. Employment at Kearney means a flexible, collaborative, and open-minded work environment. We hope it is your “first easy decision.” Learn more at www.kearneyco.com/careers. The expected salary range for this position is between $93,000 and $180,000. This range is representative of base pay only and does not include straight time pay for hours worked over 40 per week, company contributions towards paid benefits, and/or bonuses. Actual compensation (meeting or exceeding the range) will be determined based on specific experience, education, work location, clearance level, and other factors permitted by law. This position is eligible for bonuses (when applicable). We also offer a competitive benefits package that includes: Medical, Dental, Vision, Life, AD&D, and Disability Insurance 401(k) Retirement Plan and 529 Education Savings Plan Flexible Spending & Health Savings Account Accident, Critical Illness, Hospital Indemnity Insurances Legal Insurance and Pet Insurance Employee Assistance Program, fitness and wellness benefits, and other firm benefits. Paid holidays, vacation, and sick time EEO Notice Applicants have rights under Federal Employment Laws EEO Notice Work location is subject to change based on client requirements. Kearney & Company is an Equal Opportunity Employer and will consider all qualified applicants without regard to race, color, ethnic or national origin, ethnicity, genetic information, religion, gender, gender identity, sexual orientation, pregnancy, childbirth, or related medical condition, age, disability or handicap, protected veteran status, relationship or association to a protected veteran, or any other characteristic protected by local, state, or federal laws, rules, or regulations. Click here to learn more. If you would like to request a reasonable accommodation, regarding accessibility of our website, a modification or adjustment of the job application or interview process due to a disability, please call 703-236-2391 or email accommodations@kearneyco.com. Please be advised that this contact information is for accommodation requests only and cannot be used to inquire about the status of an application. Family and Medical Leave Act (FMLA) FMLA is designed to help employees balance their work and family responsibilities by allowing them to take reasonable unpaid leave for certain family and medical reasons. Kearney & Company provides eligible employees with up to 12 weeks of unpaid, job-protected leave per year. Military family leave is available for up to 26 weeks under FMLA. Click here to learn more. Employee Polygraph Protection Act (EPPA) The EPPA prohibits most private employers from using lie detector tests either for pre-employment screening or during the course of employment. Kearney & Company adheres all provisions of the EPPA. Click here to learn more.