Lead Financial Data Analyst Detroit Area Agency on Aging
7 Detroit, MI Job Details Full-time 18 hours ago Benefits Health insurance Dental insurance Paid time off Vision insurance 403(b) Opportunities for advancement Prescription drug insurance Pet insurance Qualifications Customer communication Driver's License Financial accounting Query management Full Job Description Who Are We and What We Do? The Detroit Area Agency on Aging (DAAA) Region 1-A is a private, non-profit organization responsible for planning, coordinating, developing, and funding services for older adults in the cities of Detroit, the five Grosse Pointes, Hamtramck, Harper Woods, and Highland Park. The DAAA Lead Financial Analyst role requires a high level of commitment, adaptability, and accountability. This individual must possess a strong work ethic, the capacity to manage complexity, and the depth of professional judgment necessary to serve a vulnerable population with excellence. The expectations are significant, and success in this role demands resilience, initiative, and a dedication to delivering high-quality, patient-centered care. If you're passionate about serving the aging population and thrive in a collaborative environment, we want to hear from you. We invite you to apply and be part of a team that truly values your contribution. We offer competitive wages and are committed to fostering a workplace where growth, teamwork, and serving the aging population are at the forefront. The DAAA Lead Financial Data Analyst reports to the Chief Financial Officer and has director oversight of the DAAA Finance Billing Department. The DAAA Lead Financial Data Analyst plays a pivotal role in shaping the Agency's financial strategy and operational efficiency. The incumbent will be responsible for overseeing financial operations, including budgeting, forecasting, and financial reporting. This role demands a strategic thinker with a strong understanding of financial markets, corporate finance, and accounting principles. The successful candidate will drive financial planning, analyze performance against key metrics, and provide actionable insights to senior leadership to support informed decision-making. Furthermore, this position is instrumental in ensuring fiscal responsibility, compliance with regulatory requirements, and the optimization of financial resources to achieve organizational objectives and foster sustainable growth. Responsibilities Research incorrect billing requests from Vendor Agencies and tracks occurrences Prepare and submit claims data sets for processing / payment by MSA. Review rejection / pending reports and follow-up for correction / resubmission of claims Liaison to Care Management Department to address ineligible participants. Liaison to MDCH to address ineligible participants and claims processing issues Liaison to CIM for claims processing issues. Oversight of Adjustment of rejected claims for resubmission / reclassification Investigate errors, omissions and makes necessary adjustments/ reclassifications in the System. Interpret data, analyze results to support and/or drive decision making. Identify issues and trends through data analysis. Locate and define new process improvement opportunities. Work with Finance Department leadership and team members to understand, set-up and run standard reports to support their individual functions. Work closely with management to prioritize business and information needs. Prepare presentations for leadership. Builds new reports per requirements. Modifies, maintains, and enhances existing and scheduled reports. Responds to and provides fixes for report defects/deficiencies. Responds to requests for ad hoc data sets. Writes queries in support of ad hoc data requests, and to validate report data to requirements. Develops appropriate graphical reports, including spreadsheets, charts, graphs and pixel-perfect reports to support internal and external customers. Supports internal and external customers providing appropriate communication about deliverables through all phases of report development and deployment. Other duties as needed to support the Business Intelligence and Reporting Architect or other Data Operations activities. Conducts thorough follow-up and effective resolution and communication in response to other departmental inquiries and requests. Works closely and collaboratively with other departments as needed. Effective understanding of the organization's goals and objectives Extract data from various systems to create electronic billings to Insurance Companies Performs other duties, assignments and responsibilities as assigned or required. Oher duties as assigned The Benefits of Joining Our Team
We Offer:
Comprehensive Health Coverage- including medical, dental and vision Generous Paid Time Off Pet insurance Prescription drug insurance 403(b) Flexible work week schedule Supportive Culture
- A collaborative and inclusive environment where your ideas are valued Career Development and Opportunities for Advancement Employee Recognition Other attractive benefits BA degree in computer science, mathematics, analytics or related field, master's degree preferred.
Minimum of two (2) years of professional experience in performing significant data analysis and report development and in designing and developing SQL queries which obtain data from various sources (e.g. Oracle, SQL Server, and MS Access) One (1) + years of Managed health care experience preferred. Must have a valid driver's license. Access to personal vehicle. Possible holidays, evening, and weekend work. Include any relevant physical or working-condition requirements. Must be comfortable with remote work, hybrid, and/or four-day work schedule. Knowledge, Skills, and Abilities (KSA's) Ability to interact with individuals at all levels with effective written and oral communications skills. Knowledge of Claims Adjudication and Information Technology. Knowledge of non for-profit processes and procedures. Ability to handle multiple projects and deadlines. Ability to interview (gather specifications), document, present, and test reporting requirements. Knowledge of relational databases. Intermediate to Advanced skills with MS Office (Excel, Access, Word, etc) including experience creating pivot tables, data table development, and data inquires. Project management, analytic skills. Ability to work within time frames and handle multiple duties. Knowledge of database administration & management. Proficiency in Power Point and preparing presentations. Analytical skills with the ability to analyze, troubleshoot and organize significant amounts of information with attention to detail and accuracy. Ability to problem solve with a desire and ability to enhance and automate systems and reports. Ability to communicate effectively both orally and in writing. Ability to communicate ideas in both technical and user-friendly language with great attention to detail. Ability to provide customer service.
Servant leadership:
The successful candidate should have exceptional listening skills, a high level of energy and integrity; compassion for the elderly and the community as well as the staff; is centered and mature; exercises durability, adaptability, and a sense of humor. Values fun in the workplace as an integral instrument of staff motivation and operates with a spirit of excellence.
