What are the responsibilities and job description for the Sr. Azure Data Engineer position at mozaic.io?
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 or US Remote
Hybrid Work Schedule:
For applicants residing in or near Nashville, this position will follow a hybrid work schedule. Employees will be required to work in the office 2 days one week and 3 days the following week.
Position Overview
We're on the hunt for an experienced and detail-oriented Senior Azure Data Engineer to join our awesome team and drive some exciting projects forward! 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.
Key Responsibilities:
Azure Data Architecture & Design:
Mozaic values our employees highly, and to best support them, we offer a wide array of benefits:
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 or US Remote
Hybrid Work Schedule:
For applicants residing in or near Nashville, this position will follow a hybrid work schedule. Employees will be required to work in the office 2 days one week and 3 days the following week.
Position Overview
We're on the hunt for an experienced and detail-oriented Senior Azure Data Engineer to join our awesome team and drive some exciting projects forward! 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.
Key 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
- 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
- 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
- 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
- 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 of 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, Function Apps 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
- 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.
- 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?