Sr. Azure Data Engineer

About Mozaic:

Mozaic.io is a fast-growing payments startup focused on facilitating payouts to creators and their collaborators all over the world. Our dynamic and collaborative team is dedicated to revolutionizing the way creators get paid. The company has offices in Chicago and Nashville, and aims to make compensation as equally distributed as talent is in the Creator Economy.

Location: Nashville, TN

Job Description

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.

Responsibilities

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.

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.

Mozaic values our employees highly, and to best support them, we offer a wide array of benefits:

• 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
• Certifications and / or degree programs
• Learning management systems access
• Conference attendance
• Company-provided technology 💻
• You pick: Mac or Windows?