- Writing, optimizing, and troubleshooting SQL queries and stored procedures against the Yardi database for reporting, data validation, and ad-hoc analysis - Designing, building, and maintaining Power BI dashboards and reports for operational, leasing, and financial KPIs - Developing advanced Excel models, pivot tables, and reconciliations to support month-end close, audits, and recurring reporting - Partnering with the Database Administrator on data integrity checks, performance tuning, and routine database maintenance - Translating accounting, operations, and leadership requirements into technical specifications and deliverables - Investigating and documenting data discrepancies across Yardi modules (GL, AP, AR, lease administration) and proposing corrections - Documenting queries, reports, data sources, and processes to ensure repeatability and auditability - Supporting user training and responding to internal reporting requests

• Develop, implement and maintain interactive dashboards and analytical reports in Power BI, delivering relevant strategic insights. • Write Python scripts for data collection, processing and analysis from multiple sources. • Create and optimize SQL queries for extracting, transforming and integrating data with relational and non-relational databases. • Execute data integration and processing workflows from multiple sources. • Conduct detailed analyses and continuous monitoring of data quality and governance. • Support administration and management of workspaces and datasets in the Power BI Service. • Build Power Apps applications and design flows in Power Automate. • Deliver regular training sessions and provide specialized technical support to end users. • Identify, analyze and quickly resolve issues in reports and dashboards, ensuring high availability of analytical solutions. • Lead continuous improvement initiatives in internal processes through the strategic use of data.

• Collect data from multiple sources, whether from databases or via data collection tools; • Data cleaning and preparation: process raw data to ensure it is clean, consistent, and ready for analysis. At this stage, remove any duplicate, corrupted, or blank records that could distort analysis; • Exploratory Data Analysis (EDA): perform exploratory analyses to understand data distributions and identify patterns and/or outliers that may indicate initial trends; • Report and dashboard development: create visual reports and dashboards using Certsys tools and/or client-provided tools that highlight key insights identified during collection, cleaning, and EDA; • Data modeling: actively participate in designing data models and database structures that support the organization’s analytical needs; • Statistical analysis: apply basic statistical techniques to understand relationships between variables, perform hypothesis testing, and conduct comparative analyses based on business rules; • Team collaboration: work with business teams, data scientists, and other professionals to gather analytical requirements and translate them into solutions; • Understanding business objectives: maintain a solid understanding of the organization’s business goals to ensure data analysis is aligned with company objectives; • Technical skill development: continuously improve technical skills, including programming languages such as SQL, Python, or R, and the latest data analysis tools; • Communication of results: effectively communicate data analysis results to technical and non-technical stakeholders, ensuring insights are actionable and can influence business decisions; • Identify opportunities to improve business processes based on data analysis findings.

• Oversee day-to-day administration and analysis of employee benefit plans, including health, dental, vision, life, disability, FSA/HSA/HRA, and retirement plans. • Ensure compliance with federal and state regulations such as ERISA, COBRA, ACA, and HIPAA privacy and security, and FMLA. • Analyze benefits utilization data to identify trends, recommend plan enhancements, cost-saving strategies, and ensure external competitiveness. • Maintain relationships with insurance carriers, consultants, brokers, and third-party administrators, ensuring service quality and adherence to contracts. • Serve as a secondary point of contact for complex benefits inquiries, provide guidance, and develop communication/education programs to enhance employee understanding and use of benefits. • Lead and participate in projects related to benefit programs, such as open enrollment, ERISA compliant benefit transitions of mergers and acquisitions, and plan implementations, and contribute to process documentation and improvement initiatives. • Prepare reports for compliance filings (e.g., 5500s, ACA reports), conduct regular audits of benefit plans and documentation, and reconcile departmental billing.