Senior Data Architect

OneMagnify is a global performance marketing organization working at the intersection of brand marketing, technology, and analytics. The Company's core offerings accelerate business, amplify real-time results, and help set their clients apart from their competitors. OneMagnify partners with clients to design, implement and manage marketing and brand strategies using analytical and predictive data models that provide valuable customer insights to drive higher levels of sales conversion.

OneMagnify's commitment to employee growth and development extends far beyond typical approaches. We take great pride in fostering an environment where each of our 700+ colleagues can thrive and achieve their personal best. OneMagnify has been recognized as a Top Workplace, Best Workplace and Cool Workplace in the United States for 10 consecutive years and recently was recognized as a Top Workplace in India.

OneMagnify needs a Senior Snowflake Data Engineer to join our team. We blend brand marketing, technology, and analytics to boost business and client competitiveness.

At OneMagnify, we are dedicated to encouraging an environment where every individual can thrive and achieve their personal best. We have been consistently recognized as a Top Workplace, Best Workplace, and Cool Workplace in the United States for the past 10 years. Join our team and be a part of our outstanding culture

Join OneMagnify and be part of a world-class team that competes at the highest level. Apply now and take your career to new heights

About the Role

We are looking for a Senior Data Architect with the ability to independently design and implement the components of scalable data solutions while also collaborating within their team. The successful candidate will have deep expertise in database engineering across SQL Server (on-premises) and Azure Data Services/Databricks. This role requires a demonstrated understanding of OLTP and dimensional data modelling, large-scale data processing and performance tuning.

The ideal candidate is someone who has spent several years passionate about building core data engineering expertise, has exhibited leadership in end-to-end data solution implementations, and can clearly articulate the architecture, technical decisions, and challenges they solved.

Key Responsibilities

• Design and develop scalable and efficient data solutions across both on-premises SQL Server and Azure Data Services/Databricks.
• Provide experience based technical leadership in migrating legacy on-premises data processes to Azure cloud technology stacks.
• Ensure process performance, data security, and integrity across hybrid solutions built in SQL Server (on-premises), Azure Data Services (Databricks, Data Factory, Azure SQL, and Synapse Analytics).
• Optimize large data loads, complex SQL workloads, and storage/compute performance across environments.
• Build and maintain ETL pipelines using Azure Data Factory, SSIS, Synapse Pipelines, and Databricks.
• Collaborate closely with analytics and BI teams to deliver solutions aligned with governance and Azure best practices.
• Provide technical mentorship to junior engineers in both on-premises and cloud data engineering.
• Demonstrate ownership and initiative by engaging with leaders and colleagues to fully understand requirements, contribute to solution designs, participate in reviews, and drive overall excellence.

Required Experience & Skills

• Bachelor's degree in Information Technology, Computer Science, or a related field, or equivalent experience.
• 6 to 8+ years of hands-on experience in a Data Engineer or similar role with expertise in both on-premises SQL Server and Azure cloud technologies.
• Expert-level skills in SQL Server (T-SQL, indexing, partitioning, performance tuning, query optimization).
• Strong proficiency in Azure Data Services:
  • Azure Databricks
  • Azure SQL Database
  • Azure Data Lake Storage
  • Azure Data Factory
  • Azure Synapse Analytics
• Hands-on experience building large-scale ETL/ELT pipelines using ADF, SSIS, Synapse, or Databricks.
• Proven experience migrating on-premises SQL Server databases to Azure cloud environments.
• Clear understanding of dimensional modelling theory and practices.
• Strong problem-solving attitude with the ability to articulate sophisticated technical scenarios.
• Solid understanding of data governance, security, and compliance in cloud environments.
• Ability to work in fast-paced, collaborative environments with good communication skills.

Preferred Skills

• Experience with distributed compute paradigms (Spark/Databricks).
• Exposure to workload management & cost optimization across Azure services.
• Experience guiding or mentoring peers.