Software Engineer- Data Warehouse

Lead Software Engineer
In this role, you will be responsible for creating and maintaining optimal data pipeline architectures for data extraction, transformation, loading (ETL) processes and creating the data models.


In This Role You Will

• Design and implement database solutions, including conceptual and logical data models, to support business requirements. Integrate new data sources and third-party APIs into existing systems and databases.
• Data Modelling: Efficiently design data pipelines by understanding the project needs and creating Source to Target Mappings, Technical Specs with a scalable & performant architecture in AWS redshift.
• Monitor and optimize database performance, ensuring high availability and scalability.
• Work closely with business stakeholders and analysts to understand data requirements and translate them into technical solutions.
• Document data architecture design, processes, and standards.
• Implement data security and privacy measures to protect sensitive information.
  
  
  

We are looking for someone who has:

• An expert-level understanding of complex data warehousing and data modelling is required.
• Must have 8+ years’ experience working as DWH modeler, with a strong understanding of conceptual, logical, and physical data modelling concepts.
• Strong understanding of database management systems, ETL processes, and data modelling.
• 10+ Years of working experience with T-SQL and SSIS.
• Strong understanding of database concepts, including indexing, partitioning, and query execution plans. Experience with data warehousing solutions and cloud platforms.
• Data modelling and architecting skills including strong foundation in data warehousing concepts, data normalisation, and dimensional data modelling such as AWS Redshift, OLAP, or data vault.
• Experience with real-time, batch, and ETL for complex data conversions.
• Prior work experience on AWS services, particularly S3, Glue, AWS DMS, pyspark and Redshift / Redshift Spectrum, to build scalable and efficient data solutions.
• Strong verbal and written communication skills.
• **Experience integrating with call centre applications via APIs, specifically Ivanti (ITSM), Avaya CMS, Genesys Customer Interaction Center (CIC), InContact and/or Altitude would be a bonus.
• **Experience with AWS Cloud would be a bonus.
• **Experience in BPO Operations would be a huge bonus.
  
  
  

About ResultsCX:
ResultsCX is a premier customer experience partner to Fortune 100 and 500 companies. We design, build, and deliver digitally influenced customer journeys that achieve the satisfaction and loyalty brands need to thrive and grow, while improving efficiency and reducing costs. ResultsCX’s 30+-year track record for reimagining the customer experience to meet consumers’ evolving expectations has driven growth to more than 20 geographic hubs and approximately 20,000 colleagues worldwide. Our core expertise extends to actionable analytics, contact center as a service (CCaaS), and our own SupportPredict AI-powered digital experience platform. Our strength lies in exceptional individuals working together in a high-performing, fun culture to deliver next-generation customer experiences on behalf of our clients.

ResultsCX is an equal opportunity and affirmative action employer and will consider all qualified applicants without regard to race, color, religion, national origin, sex, sexual orientation, gender identity, age, disability, veteran status, or any other protected factors under federal, state, or local law.