Developer Analyst II

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.

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. 

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