Job Summary Sr Developer role in a hybrid work model focusing on designing optimizing and maintaining high performance SQL and Redshift data solutions for complex enterprise billing and revenue scenarios. The position requires six to ten years of experience and involves close collaboration with cross functional teams to deliver reliable data capabilities for business reporting and analytics. Responsibilities Design and develop scalable SQL and Redshift data solutions that reliably support complex billing and revenue management processes and enable accurate downstream analytics for business stakeholders.
Optimize existing SQL queries and Redshift data models to improve performance reduce processing time and ensure timely availability of critical financial and operational data. Implement robust data pipelines and batch processing jobs across SQL and Redshift environments to ensure consistent ingestion transformation and delivery of business data. Collaborate with product owners and business analysts to translate billing and revenue reporting requirements into precise technical specifications and high quality data structures.
Perform detailed data profiling and validation in SQL and Redshift to ensure data quality integrity and alignment with source systems and financial reporting expectations. Create and maintain comprehensive technical documentation covering data models transformation logic and operational procedures to support knowledge sharing across the team. Investigate and resolve production issues related to SQL and Redshift workflows by applying structured root cause analysis and implementing durable corrective actions.
Coordinate with cross functional technology teams to ensure compatibility of SQL and Redshift solutions with upstream applications and downstream reporting platforms. Implement access control data segregation and configuration standards in SQL and Redshift to support compliance requirements and safeguard sensitive billing and revenue information. Support migration and modernization initiatives by refactoring legacy SQL code and data structures into optimized Redshift and modern data architecture patterns.
Participate in code reviews and quality assurance activities to uphold development standards and promote consistent best practices in SQL and Redshift work products. Contribute to continuous improvement efforts by evaluating new data engineering techniques that can enhance performance maintainability and reliability of the data ecosystem. Engage with stakeholders in a hybrid work model through structured communication routines to provide status updates and gather feedback on delivered data solutions.
Qualifications Demonstrate advanced proficiency in SQL scripting and query optimization with several years of experience delivering enterprise grade data solutions. Apply strong hands on expertise in Redshift data warehousing including table design distribution strategies and performance tuning for analytical workloads. Use practical understanding of billing and revenue management concepts to design data models that reflect invoicing rating payments adjustments and revenue recognition flows.
Bring six to ten years of progressive development experience in data intensive environments with a track record of building reliable and maintainable solutions. Exhibit effective communication and collaboration capabilities in hybrid work settings to partner with business teams and technology peers. Show familiarity with modern data engineering practices including structured data modeling version control workflows and standardized release processes.
Certifications Required Preferred certifications include AWS Certified Database Specialty or AWS Certified Data Analytics Specialty relevant to Redshift and SQL experience.
Job description provided by Cognizant Technology Solutions.
View the original posting
