Sr. Azure Data Engineer

We are looking for an experienced and detail-oriented Senior Data/SQL Engineer to join our dynamic team. As a Senior Azure Data Engineer, you will play a crucial role in designing, implementing, and optimizing data storage solutions, ensuring efficient data retrieval, and supporting data-driven applications. The ideal candidate should have a strong background in SQL, database architecture, and data engineering.

Azure Data Architecture & Design:

• Design and implement scalable data architectures on Microsoft Azure, leveraging services like Azure Data Factory, and Azure Synapse Analytics.
• Select and configure appropriate Azure data storage solutions (e.g., Azure Blob Storage, Azure Data Lake Storage) based on specific data needs.
• Ensure data security, compliance, and governance are implemented throughout the data lifecycle.

Data Ingestion & Processing:

• Develop and manage efficient data pipelines using Azure Data Factory to automate data ingestion from various sources (internal applications, external APIs, streaming data).
• Utilize Azure Services or other big data processing tools for complex data transformations and ETL (Extract, Transform, Load) processes.
• Optimize data pipelines for performance and scalability to handle large data volumes.

Data Modeling & Warehousing:

• Design and implement dimensional data models (e.g., star schema) within Azure Synapse Analytics or other data warehousing solutions.
• Ensure data quality and consistency through data cleansing, transformation, and validation processes.
• Optimize data storage and querying performance for efficient data analysis and reporting.

Collaboration & Communication:

• Collaborate closely with cross-functional teams (product, engineering, analytics) to understand data requirements and translate them into actionable technical solutions.
• Effectively communicate complex data architecture concepts and findings to both technical and non-technical audiences.
• Document data pipelines, models, and procedures for knowledge sharing and future maintenance.

Cloud Expertise & Innovation:

• Stay up-to-date on the latest advancements in Azure data services and best practices.
• Proactively identify opportunities to leverage new Azure features to improve data management and analytics capabilities.
• Be a champion for innovation, seeking ways to optimize data pipelines and infrastructure for efficiency and cost-effectiveness.

Requirements

• Minimum 5+ years of experience as a Data Engineer or similar role with a focus on cloud data platforms.
• Proven experience in designing, developing, and managing data pipelines on Microsoft Azure using Azure Data Factory and related services.
• Proficiency in SQL programming and relational database management systems (e.g., SQL Server).
• Strong understanding of data warehousing concepts (e.g., star schema, snowflake schema) and data modeling principles.
• Experience with big data processing tools and technologies.
• Experience in database performance tuning and optimization.
• Familiarity with data security, compliance, and governance best practices in the cloud.
• Excellent documentation skills with the ability to create and maintain comprehensive technical documentation.

Ideal Candidate will possess:

• Experience with data visualization tools (e.g. Power BI) to create dashboards and reports.
• Experience with DevOps principles and practices for data pipelines.
• Experience with infrastructure as code (IaC) tools.
• Experience with cloud cost optimization strategies.
• Previous experience in a music tech, media tech, or fintech company is a strong advantage.

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or a related field.

Benefits

Mozaic values our employees highly, and to best support them, we offer a wide array of benefits to support everyone with whatever they may need.

• Medical, Dental, and Vision coverage 🩺
• Premiums 100% covered by Mozaic
• EAP Access through Spring Health
• Weekly pay 💲
• 401K 🏦
• Mozaic matches up to 6%
• Immediate vesting of company contributions
• Paid Time Off 🏝️
• Unlimited PTO
• Sick time
• Holiday schedule - and your birthday is a Holiday!
• Continual learning and development opportunities 📓
• Professional organization memberships
• Certificati