Assistantly logo
Assistantly

Work on Your Business, We'll Handle the Rest.

Yardi Database Analyst

AnalystAnalystFull TimeRemoteMid LevelTeam 51-200Since 2021H1B No SponsorCompany SiteLinkedIn

Location

Philippines

Posted

7 days ago

Salary

0

Seniority

Mid Level

No structured requirement data.

Job Description

Yardi Database Analyst

Assistantly

Role Description As a Yardi Database Analyst, you will play a pivotal role in supporting growth-stage businesses and leadership teams by delivering actionable insights and robust reporting solutions. You will work closely with a Database Administrator and be embedded within operational and leadership teams to drive data integrity and reporting excellence. - 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 Qualifications - Bachelor’s degree in Information Systems, Accounting, Finance, Computer Science, or a related field (or equivalent professional experience) - 3+ years of relevant experience in Yardi, SQL, BI, or reporting-focused roles - Hands-on experience with Yardi Voyager across GL, AP, AR, and lease administration modules - Intermediate-to-advanced proficiency in SQL, including joins, subqueries, aggregations, window functions, and stored procedures - Experience building dashboards in Power BI, including data modeling and DAX - Advanced proficiency with Microsoft Excel, including pivot tables and Power Query - Working knowledge of accounting fundamentals, including GL structure, debits/credits, accruals, P&L, and balance sheet - Full professional fluency in English (written and spoken) - Authorized to work in the Philippines - Availability to work and overlap standard business hours in GMT Benefits - Permanent work-from-home opportunities - Paid Holidays and PTO - Part-time or Full-time positions tailored to your availability - Performance, Tenure, and Health & Wellness bonuses - Opportunities for professional development within the Assistantly community - Be part of a vibrant and supportive community of Unicorns

Related Categories

Related Job Pages

More Analyst Jobs

Channel Quoting Analyst

Micron Technology

Micron Technology specializes in memory and semiconductor technology, such as computer memory and image sensors. Since opening, Micron Technology has had a successful history and i

Analyst7 days ago
Full TimeRemoteTeam 45,000Since 1978

Our vision is to transform how the world uses information to enrich life for all . Micron Technology is a world leader in innovating memory and storage solutions that accelerate the transformation of information into intelligence, inspiring the world to learn, communicate and advance faster than ever. - Process daily quote requests in Model N with high accuracy and within defined turnaround times. - Review and validate quote inputs, including MPN, quantity, distributor target cost, and competitive information. - Ensure quotes are aligned with pricing guidelines, floor pricing, and business strategies. - Maintain quote lifecycle (approval, expiry, updates) and ensure data integrity in the system. - Work closely with Business Unit (BU) Pricing teams to obtain approvals for quotes and resolve exceptions. - Analyze market trends, competitor pricing, and customer demand to support pricing decisions. - Provide insights to support margin optimization and quote-to-debit conversion performance. - Act as a key point of contact for quoting-related queries from internal and external stakeholders. - Ensure compliance with internal policies, audit requirements, and pricing governance. - Support SOX controls and documentation where applicable. - Maintain accurate documentation of quote decisions and approvals. - Support reporting and dashboard development for quoting performance metrics. Track key KPIs such as quote turnaround time, conversion rates, and backlog. - Prepare reports, presentations, and operational summaries as required. - Leverage Artificial Intelligence (AI) technologies to enhance business processes, including developing and implementing AI-driven solutions to improve efficiency, accuracy, and operating as a culture vanguard towards infusing AI into everyday work. Requirement: - Bachelor's degree in Business, Economics, Finance or Supply Chain with related pricing or quotation experience! - 2+ years of experience in Sales Operations or operations management, facing internal and external customers! - Sales based mentality, proactive problem solver, skilled at customer negotiations - Customer focused attitude with good communication and interpersonal skills - Strong data and analytical skills - Energetic teammate with a focus on high performance and follow-through skills - Flexible with ability to adapt to change in a highly dynamic work environment - Ability to manage own time and multi-task combined with strong organizational skills - Ability to represent the company in a highly professional manner both over the phone and face-to-face - Be able to independently make decisions - Knowledge of channel business models a plus - Intermediate/Advanced computer skills in Microsoft Office (Outlook, Excel, Teams), ERP/CRM system or similar (Model N, SAP), Reporting tools (Tableau, Power BI), SharePoint About Micron Technology, Inc. We are an industry leader in innovative memory and storage solutions transforming how the world uses information to enrich life for all . With a relentless focus on our customers, technology leadership, and manufacturing and operational excellence, Micron delivers a rich portfolio of high-performance DRAM, NAND, and NOR memory and storage products through our Micron® and Crucial® brands. Every day, the innovations that our people create fuel the data economy, enabling advances in artificial intelligence and 5G applications that unleash opportunities - from the data center to the intelligent edge and across the client and mobile user experience. To learn more, please visit micron.com/careers All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, veteran or disability status. To request assistance with the application process and/or for reasonable accommodations, please contact hrsupport_my@micron.com Micron Prohibits the use of child labor and complies with all applicable laws, rules, regulations, and other international and industry labor standards. Micron does not charge candidates any recruitment fees or unlawfully collect any other payment from candidates as consideration for their employment with Micron. AI alert: Candidates are encouraged to use AI tools to enhance their resume and/or application materials. However, all information provided must be accurate and reflect the candidate's true skills and experiences. Misuse of AI to fabricate or misrepresent qualifications will result in immediate disqualification. Fraud alert: Micron advises job seekers to be cautious of unsolicited job offers and to verify the authenticity of any communication claiming to be from Micron by checking the official Micron careers website in the About Micron Technology, Inc.

Malaysia

• Perform end-to-end reconciliation of third party pharmacy claims across Medicare Part B and D, Medicaid, commercial insurers, and PBMs • Analyze claim denials and rejections by payer, denial code, and drug category • Monitor actual reimbursement against expected contract rates for each payer • Manage outstanding AR aging by payer, prioritizing high-dollar claims • Serve as a point of contact for payer portals, provider relations representatives, and clearinghouse inquiries • Ensure all reconciliation activities adhere to CMS guidelines, HIPAA requirements, and internal audit protocols • Work closely with pharmacy operations, finance, and technology teams to surface workflow inefficiencies

United States
$80K - $100K / year
Valsoft Corporation logo

M&A Analyst - Academic Work Placement/ Internship

Valsoft Corporation

Valsoft Corporation acquires and builds market software solutions. The company invests in stable businesses and aims to foster an entrepreneurial environment post-acquisition to gr

Analyst7 days ago

Role Description This mandatory internship will start on September 1st and will last for 3 months. Valsoft is offering a structured internship within our European M&A team, with the role based in France, Germany, or another European country. This placement offers supervised, hands-on experience across the M&A lifecycle in a fast-paced investment environment. Key Responsibilities - Conduct industry and market research - Identify and evaluate acquisition targets - Support preparation of internal investment materials - Assist with financial analysis and valuation - Contribute to due diligence activities - Maintain acquisition pipeline tracking - Participate in internal transaction discussions Eligibility (Mandatory) - Be enrolled in an undergraduate or postgraduate degree programme at a university in France, Germany, or another European country - Require a placement as a mandatory and assessed part of their course - Provide written confirmation from their university - Have the legal right to undertake an internship or work placement in France or Germany Profile - Degree in Finance, Business, Economics, or related field - Strong analytical skills and attention to detail - Proficiency in Excel and familiarity with financial modelling - Excellent communication skills; proficiency in English is required, German and French is a strong advantage - Entrepreneurial mindset and strong interest in M&A - Prior experience in finance, consulting, corporate development, or investment analysis is advantageous but not required What You Will Gain - Exposure to live M&A transactions - Experience in valuation and financial analysis - Mentorship from experienced investment professionals - Insight into acquisition strategy and portfolio growth - Development within an entrepreneurial, acquisition-driven organisation Important Information This is an internship aligned with academic programme requirements and is not a standard employment position. The internship will be structured in accordance with applicable French, German or another European internship regulations. Any future employment would be subject to a separate recruitment process. Application Please submit your CV and academic transcript in one PDF document. A short cover letter (in English, French, or German) is welcome but not required.

Europe
Computer Task Group, Inc logo

Epic HB Analyst

Computer Task Group, Inc

CTG, a Cegeka company, is at the forefront of digital transformation, providing IT and business solutions that accelerate project momentum and deliver desired value. Over nearly 60 years, we have earned a reputation as a faster and more reliable, results-driven partner. Our vision is to be an indispensable partner to our clients and the preferred career destination for digital and technology experts. CTG leverages the expertise of over 9,000 team members in 19 countries to provide innovative solutions. Together, we operate across the Americas, Europe, and India, working in close cooperation with over 3,000 clients in many of today's highest-growth industries. For more information, visit www.ctg.com . Our culture is a direct result of the people who work at CTG, the values we hold, and the actions we take. In other words, our people define our culture. It's a living, breathing thing that is renewed every day through the ways we engage with each other, our clients, and our communities. Part of our mission is to cultivate a workplace that attracts and develops the best people. CTG will consider for employment all qualified applicants including those with criminal histories in a manner consistent with the requirements of all applicable local, state, and federal laws. CTG is an Equal Opportunity Employer. CTG will assure equal opportunity and consideration to all applicants and employees in recruitment, selection, placement, training, benefits, compensation, promotion, transfer, and release of individuals without regard to race, creed, religion, color, national origin, sex, sexual orientation, gender identity and gender expression, age, disability, marital or veteran status, citizenship status, or any other discriminatory factors as required by law. CTG is fully committed to promoting employment opportunities for members of protected classes.

Analyst7 days ago
ContractRemoteTeam 5,001-10,000

Role Description CTG is seeking a certified Epic Hospital Billing (HB) Build Analyst with 3+ years of hands-on build experience to support the design, configuration, and optimization of Epic HB applications. This individual will play a key role in supporting revenue cycle operations, ensuring accurate billing, reimbursement, and compliance across hospital billing workflows. The ideal candidate will have strong knowledge of hospital revenue cycle processes and the ability to translate operational needs into scalable and effective Epic solutions. - Design, build, configure, and maintain Epic HB application components in alignment with organizational and regulatory requirements - Collaborate with revenue cycle stakeholders to gather requirements and translate them into system build and workflow improvements - Support hospital billing processes, including charge capture, claims creation, reimbursement workflows, and denial management - Participate in system implementations, upgrades, and optimization initiatives - Perform unit testing, integrated testing, and user acceptance testing (UAT) to ensure system reliability and accuracy - Troubleshoot complex system and billing issues, performing root cause analysis and implementing sustainable solutions - Maintain comprehensive documentation of system build, workflows, and change management activities - Support go-live and post-go-live stabilization efforts, including on-call support as needed - Ensure compliance with payer requirements, regulatory standards, and Epic best practices - Collaborate with cross-functional teams (PB, Charge Router, HIM, interfaces, reporting) to ensure seamless revenue cycle integration Qualifications - Epic Hospital Billing (HB) Certification (required) - 3+ years of Epic HB build experience, including hands-on configuration and support - Strong understanding of hospital revenue cycle operations, including billing, reimbursement, and denial management - Experience with system upgrades, enhancements, and full testing cycles - Proven ability to troubleshoot complex billing and system issues - Strong communication and stakeholder engagement skills across both technical and operational teams - Excellent verbal and written English communication skills and the ability to interact professionally with a diverse group are required. Requirements - CTG does not accept unsolicited resumes from headhunters, recruitment agencies, or fee based recruitment services for this role. Benefits - The expected base salary for this position ranges from $75.00 to $85.00/hour. - Salary offers are based on a wide range of factors including relevant skills, training, experience, education, market factors, and where applicable, licensure or certifications obtained. - In addition to salary, a competitive benefit package is also offered.

United States
$75 - $85 / hour