Overview:
This Developer Analyst position is part of RealPage Delivery Planning & Insights group, responsible for preparing, maintaining, and enhancing varieties of reports/dashboards to provide meaningful insights/foresights to different businesses in RealPage. The position will be delivering reports and analyzing the results for the businesses to help them make data-driven decisions and eventually help satisfy/retain/attract customers.
Responsibilities:
Collaboration, Communication & Requirements
-
Partner with team members and senior colleagues to deliver high-quality outputs within agreed timelines.
-
Elicit, analyze, and validate reporting and insights requirements with leads, teams, and customers.
-
Produce clear documentation and communicate status, risks, and decisions effectively to stakeholders.
-
Collaborate with stakeholders to design and tailor reports and dashboards to business needs.
-
Demonstrate flexibility to support cross-time-zone collaboration, including early/late meetings as needed.
Data Sourcing, Transformation & Tools
-
Work with diverse data sources, including on-prem (SQL/Oracle/file-based) and cloud platforms (e.g., Salesforce, SharePoint, Azure).
-
Acquire, cleanse, and transform data using fit-for-purpose approaches aligned to performance and reliability needs.
-
Select and apply appropriate tools, technologies, and development practices for each deliverable.
-
Develop and maintain data models by integrating relevant sources and defining consistent business logic.
-
Design, develop, schedule, and monitor ETL/ELT pipelines, including incremental and full-load patterns.
-
Implement operational controls for ETL jobs (parameterization, idempotency, error handling, retries, logging, alerting, and SLA adherence).
-
Perform data validation and reconciliation checks; investigate and resolve ETL failures and data-quality issues in a timely manner.
Analysis, Insights & Reporting
-
Communicate insights and recommendations through appropriate visuals, narratives, and supporting analysis.
-
Analyze datasets to identify variances, anomalies, trends, and root causes.
-
Recommend appropriate data volumes, refresh strategies, and caching/storage approaches to balance performance and cost.
-
Support business reviews by summarizing outcomes and packaging reports into clear presentations.
-
Own recurring reporting deliverables, including scheduled refreshes, access management, and ongoing enhancements.
Quality, Process & Issue Management
-
Drive continuous improvement in solution quality, delivery efficiency, and stakeholder experience.
-
Adhere to organizational standards and processes, leveraging guidance from experienced team members.
-
Identify, document, and triage defects, bugs, and data issues; support resolution through to closure.
-
Log, track, and communicate project risks and issues, ensuring timely escalation when required.
Knowledge Management & Transition
-
Plan and execute knowledge-transfer activities, ensuring smooth transition and operational readiness.
-
Maintain and leverage knowledge repositories to accelerate delivery and improve supportability.
Qualifications:
- Bachelor’s or Master’s degree in computer science or a related technical field
-
5+ years of experience with MS SQL for business intelligence and analytics
-
5+ years utilizing Power BI or similar data transformation and reporting tools
-
Proficient in developing and supporting scheduled ETL/ELT jobs, including monitoring and troubleshooting
-
Knowledge of data quality controls, auditability, and documentation for production pipelines
-
Experience with MS Excel for data visualization and reporting
-
Familiarity with Microsoft tools such as Word and PowerPoint
-
Strong analytical, conceptual, and problem-solving abilities
-
Effective process documentation skills
-
Excellent verbal and written communication and presentation skills
-
Ability to manage multiple projects and meet deadlines
-
Proven independent work and initiative
-
Willingness to work overtime as needed
-
Consistent follow-through on commitments
-
Excellent planning, organizational, and time management skills
PREFERRED KNOWLEDGE/SKILLS/ABILITIES
-
Knowledge/experience in data insight/foresight with modern technologies o
-
E.g., Machine learning using any standard platform/tool (e.g, Python/R) •
-
Advanced knowledge/experience (3+ Years) using MS SQL & SQL Reporting Services. o
-
E.g., Performance Tuning or Query Optimization techniques as per situation
-
Advanced knowledge/experience (3+ Years) with Power BI is preferred.
-
E.g., Modelling with variety of data sources & types with custom DAX functions, RLS etc.
-
Experience with ETL orchestration and scheduling tools (e.g., Azure Data Factory or similar) and implementing pipeline observability (alerts/metrics).
-
Advanced knowledge in Excel and its functions in real world.
-
Excellent process-documentation skills, following ISO standards.
-
Experience (3+ Years) in managing multiple projects simultaneously, while meeting regular deadlines
-
Experience in verbal and written communication with global teams.
