- 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

• Desenvolver, manter e aprimorar dashboards e relatórios em Power BI, assegurando alta qualidade visual, desempenho e confiabilidade das informações disponibilizadas. • Prestar suporte às áreas de negócio na interpretação de indicadores e na utilização das soluções analíticas, promovendo a tomada de decisão orientada por dados. • Elaborar, revisar e otimizar consultas SQL para extração, tratamento e transformação de dados em bancos relacionais e ambientes em nuvem. • Desenvolver scripts em Python para automação de processos, tratamento de dados e análises avançadas. • Apoiar a equipe de Engenharia de Dados nas atividades de ingestão, transformação e disponibilização de dados no Data Lake, atuando nas camadas Bronze, Silver e Gold. • Monitorar a qualidade, integridade e consistência dos dados nas camadas analíticas, identificando, investigando e reportando possíveis inconsistências e anomalias. • Documentar modelos de dados, pipelines de ingestão, processos de transformação e regras de negócio, garantindo rastreabilidade e padronização das informações. • Colaborar com equipes multidisciplinares na identificação de oportunidades de melhoria contínua dos processos de dados e analytics.

• 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.