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.