Overview Title: Data Analyst II Location: Remote Salary: starting at 90K D.O.E. + Full Time Benefits *Actual compensation may vary from posting based on geographic location, work experience, education, and/or skill level. Position Summary: Are you excited to analyze large datasets and help business owners make data driven decisions? Are you excited to design and develop automated reports using industry leading tools like Power BI? At New American Funding we know the importance of utilizing quantitate insights and actionable reports to drive our business; and we are looking for a highly talented Business Data Analyst to join our BI and Analytics team and help us become a more data driven company. Identity Verification checks are in place throughout the Candidate journey to prevent candidate fraud Responsibilities • Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards, etc. to drive stakeholder engagement.• Extensive experience in building Power BI Dashboards using Complex DAX Functions / merging multiple data sets/data sources.• Strong SQL skills in analyzing, implementing/writing complex SQL scripts for designing critical data sets, trace data quality issues and should be proficient in data cleansing.• Strong analytical and problem-solving skills, and attention to details• Possess the ability to identify, analyze, and resolve problems logically and systematically.• Strong verbal and written communication skills; ability to present complex information in an easy-to-understand manner with clear recommendations based on data insight.• Can function collaboratively as part of a fast-paced, customer-oriented team, perform effectively, and demonstrate willingness to support the team on all levels to get the job done.• Ability to deal with ambiguity and competing objectives in a fast-paced environment.• Other duties may be assigned. Qualifications • Experience independently designing and implementing solutions to complex problems.• Have attention to detail to ensure the highest level of quality/rigor in solutions.• Proficiency with MS Office Suite.• Must be a team player.• Must have clear and effective communication.• Strong SQL experience.• Strong experience in Visualization tools like Power BI to create clean, visually compelling charts that will help understand discoveries and empower others to use data to make key decisions.• Working knowledge in Power Automate.• Own the design, development, and maintenance of ongoing metrics, reports, analysis, dashboards, etc. to drive stakeholder engagement.• Attention to details that involve reading/accessing intricate coding or technical structure.• Understanding of the mortgage industry including the life cycle of a loan. Desired Education/Experience: • Bachelor’s degree in business, Statistics, Computer Science, Mathematics, or a related field preferred.• Experience working with Power BI.• 3+ years of experience as a Business Data Analyst, Data Engineer or equivalent.• Relevant experience as a business analyst, data analyst or related role is a plus.• Working knowledge of SQL and creating complex queries.• Experience with Snowflake.• Retail Mortgage Analytics experience highly desired. Other Duties: This job may require frequent sitting or standing for long periods of time. This job profile is not intended to be an all-inclusive list of job duties and responsibilities, as one may perform additional related duties as assigned to meet the needs of the organization. Work Authorization: Must be able to verify identity and employment eligibility to work in the U.S. [EOE/M/F/D/V. Drug-free workplace.] Physical Demands: The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions. Must be able to lift to ten pounds. Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight; to operate office equipment requiring repetitive hand movement and fine coordination including use of a keyboard; and to verbally communicate to exchange information. VISION: See in the normal visual range with or without correction. HEARING: Hear in the normal audio range with or without correction. Pay Transparency Disclosure: If based in New American Funding’s offices, this role has the annual base salary range stated below. Job level and actual compensation will be decided based on factors including, but not limited to, individual qualifications objectively assessed during the interview process (including skills and prior relevant experience, potential impact, and scope of role), market demands, and specific work location. The listed range is a guideline, and the range for this role may be modified. For roles that are available to be filled remotely, the pay range is localized according to employee work location by a factor of between 80% and 100% of range. Please discuss your specific work location with your recruiter for more information. New American Funding offers competitive package of additional benefits, including health, dental & vision, retirement with company contribution, parental leave , mental health & wellness benefits, and generous PTO. New American Funding also offers sales incentive pay for most sales roles and an annual bonus plan for eligible non-sales roles. New American Funding’s compensation and benefits are subject to change and may be modified in the future. #LI-JS3 #LI-REMOTE

Arcadia is dedicated to happier, healthier days for all. We believe that there is a better healthcare world – one powered by data. Our platform transforms complex, diverse data into a unified foundation for health, helping organizations deliver better care, boost revenue, and lower costs. We’re a team of fiercely driven individuals committed to making healthcare more sustainable—and we’re looking for passionate people to help us get there. For more information, visit arcadia.io Why This Role is Important to Arcadia Love data and want to make a difference? Arcadia is transforming healthcare data into actionable insights that improve outcomes for millions of patients. As a leader in Population Health and Analytics, we empower our customers to advance care delivery, research, and financial performance through a unified data fabric. If you’re passionate about healthcare and love turning data into impact, join our growing Data team to help modernize how healthcare organizations use data. The Analyst will join the Customer Insights team of a high-growth Population Health and Analytics software company. This role reports to the Director of Customer Insights and will involve the creation of high value analytics and reporting for Arcadia customers. The ideal candidate loves data and wants to make a difference. We are seeking individuals who rely on data analysis, metrics, and visualizations to make decisions and are passionate about improving the way healthcare is delivered to millions of patients across the country. You should be eager to share healthcare and business intelligence expertise to help Arcadia’s customers unlock more from the data. What Success Looks Like In 3 months - Learn Arcadia’s data model, core use cases, and start conducting quality analyses for customer datasets - Learn reporting tools used by the team (Redshift, Athena, S3, Quick Sight, etc) - Lead the intake process and execution of complex analytics requests - Creating custom tables and stored procedures in AWS Redshift - Supporting BI developers by creating robust data models - Presenting data and findings to stakeholders - Supporting ad hoc data requests - Serve as a value-based care SME on internal and external calls - Deliver analytics and insights that demonstrate customer value - Collaborating with talented colleagues – Product Managers, Analysts, and Data Scientists – across Arcadia’s Customer Insights, Analytics, Data Science, and Product teams In 6 months - Lead data validation efforts and advise customers on how ingestion and configuration decisions affect their analytics - Development and Delivery of Dashboards utilizing Amazon’s BI Development Tool Quick Sight - Establish yourself as a subject matter expert on Arcadia’s analytics platform and methodologies - Lead cross-functional initiatives to refine analytics processes and enhance data usability In 12 months - Serve as an internal subject matter expert on Arcadia’s data pipelines, championing best practices and guiding health systems and payers to maximize their use of Arcadia’s platform - Proficiently manage multiple customer projects with on time deliverables of across a diverse range of subject areas - Identify opportunities to enhance Arcadia’s product and drive improvements that elevate the experience for both internal and external stakeholders What You'll Be Doing - Collaborate with healthcare clients to understand their data challenges and translate complex insights into clear, actionable solutions - Develop subject matter expertise across Arcadia’s products and data model to influence new analytics capabilities and product improvements - Contribute to Arcadia’s growing body of intellectual property and best practices for data-driven healthcare transformation What You'll Bring - 5+ years of experience working with healthcare data with deep expertise in claims and or clinical data - 2+ years of experience in value based care - Advanced SQL skills and robust data modeling capabilities - Strong analytical and problem solving skills - Familiarity with medical economics, risk algorithms, and quality data - Ability to comfortably engage with clients on their value-based goals and objectives, translating them into actionable deliverables - Eagerness to learn, a detail-oriented mindset, and a creative approach to problem solving Would Love For You To Have - Experience with modern data tools (e.g., dbt, Redshift, Snowflake, Looker) - Experience with business intelligence dashboarding tools such as Quick Sight, Tableau, or Power BI - Experience integrating AI-powered coding tools into development and QA work - Familiarity with FHIR or healthcare interoperability standards - Experience supporting analytics or data governance in a high-growth SaaS environment - Experience working at a data vendor, ACO/CIN Organization or health insurance company - Experience with the AWS ecosystem - Experience using collaboration tools such as Jira and Confluence - Familiarity with GitHub, DBT, and Jenkins - Ability to write and troubleshoot python code What You'll Get - Become a member of the talented, energized, diverse and purpose-driven Arcadian Community with decades of collective experience in population health, product development, and data science - Employee driven programs and initiatives for personal and professional development - A supportive and remote-work friendly company that provides frequent opportunities for fun and connection, as well as personal and professional development - Competitive compensation, amazing benefits including unlimited FTO The opportunity to: - Analyze large and diverse data sets on Arcadia’s custom data model built by analysts for analysts - Create value add IP and quickly distribute it to wide array of Arcadia customers - Ideate with the best minds in healthcare through our advisory network - Support a wide variety of customers in the healthcare space – all focused on pulling healthcare tech into modernity About Arcadia Arcadia.io helps innovative providers and payers across the country transform healthcare to reduce cost while improving patient health. We do this by aggregating large amounts of disparate data, applying algorithms to identify opportunities to provide better patient care, and making those opportunities actionable by physicians at the point of care in near-real time. We are passionate about helping our customers drive meaningful outcomes. We are growing fast and have emerged as a market leader in the highly competitive population health management software market and have been recognized by industry analysts KLAS, IDC, Forrester, and Chilmark for our leadership. For a better sense of our brand and products, please explore our website. Protect Yourself If you have concerns about the authenticity of a job offer or recruitment-related communication claiming to be from Arcadia, we encourage you to verify by contacting us directly at (781) 202-3600 and select option 3. For more information, visit our website. This position is responsible for following all Security policies and procedures in order to protect all PHI under Arcadia's custodianship as well as Arcadia Intellectual Properties. For any security-specific roles, the responsibilities would be further defined by the hiring manager.

• Provide analytical oversight for the Company’s related products • Work directly with large volumes of data, creating meaningful analysis • Interpret data, analyze results using statistical techniques and provide ongoing reports • Identify, analyze, and interpret trends or patterns in complex data sets • Locate and define new process improvement opportunities • Provide ad-hoc reports and perform investigative steps regarding specific transaction screening flow through compliance system(s) • Partner with all groups within the Compliance department to drive technology needs in collaboration with the IT organization • Maintain an attention to detail while coordinating efforts cross-functionally

• Analyzing, mining, and modeling large volumes of business data to build a comprehensive algorithmic system that extracts valuable information regardless of rules or machine learning algorithms. • Leading through example: Overseeing high performing, multidisciplinary members of the Data Analyst team, you will design and build complex visualizations and analytical models to help us to meet compliance or regulatory requirements, build several data analytical systems to help business teams improve work efficiency. • You will work closely with the compliance areas to identify, prioritize and deliver on their most pressing and impactful analytical use case; turning complex findings into simple visualizations and recommendations for execution. • Analyze and interpret large (PB-scale) volumes of transactional, operational and customer data using proprietary and open source data tools, platforms and analytical tool kits. • Support and manage data requests from business stakeholders – can understand business change needs and assess the impact of those changes. • Responsible for working closely with the compliance areas to identify, prioritize and deliver on their most pressing and impactful analytical use cases.