Senior Data Engineer

Summary

Join Emergent Software's dynamic team of data professionals as a Senior Data Engineer. This fully remote position offers the opportunity to lead data engineering teams, develop solution designs, and work on interesting projects for various clients. You will architect and maintain data platforms on Azure, collaborate with other data professionals, and contribute to best practices. The role requires strong technical skills, experience with Microsoft's data solutions, and the ability to manage multiple priorities. Emergent Software values work-life balance and offers excellent benefits, including flexible work schedules, professional development opportunities, and profit sharing.

Requirements

• 5-10 years experience working in data-specific roles
• Advanced understanding of data modeling design patterns such as 3NF and star-schema
• Data warehouse design experience using medallion architecture
• Experience with Microsoft Fabric, Synapse or Snowflake
• ETL tools such as Azure Data Factory
• Experience using a scripting language for data transformation
• Performance tuning databases and long running queries
• Stored procedure development
• Experience working with unstructured/structured large-scale data
• Advanced SQL syntax
• Advanced Python scripting
• Experience with real-time data processing

Responsibilities

• Architect end-to-end data platforms on Azure, ensuring scalability, resilience, and future-proof design
• Lead design reviews and architectural decisions for large or complex client data projects
• Contribute to defining data engineering best practices, coding standards, and reusable frameworks across the team
• Mentor and coach junior engineers on advanced Azure services, performance tuning, and cloud-native patterns
• Collaborate with Data Architects to define data models, schemas, and integration patterns
• Drive cloud cost optimization strategies, ensuring clients use the right services at the right scale
• Evaluate and recommend new Azure tools and technologies for inclusion in Emergent Software’s offerings
• Lead client advisory on data platform modernization, migration strategies (e.g., on-prem to Azure), and data engineering maturity
• Contribute to thought leadership, such as blog posts, webinars, or speaking engagements on Azure data topics
• Design, develop, and maintain data pipelines using Azure Data Factory, Synapse Pipelines, or Azure Batch
• Build and optimize data storage layers (Azure OneLake, Azure SQL, Synapse Analytics) for structured, semi-structured, and unstructured data
• Implement data transformation logic (ETL/ELT) using Spark, Python, SQL, or Azure Data Factory
• Ensure data quality, validation, and lineage using tools like Azure Purview and integrate with governance frameworks
• Collaborate with BI teams to prepare curated data models and tables for reporting in Power BI or downstream systems
• Manage data security, privacy, and compliance (RBAC, encryption, sensitive data masking) across Azure services
• Monitor and optimize pipeline performance and cost efficiency using Azure Monitor and cost management tools
• Develop and maintain CI/CD pipelines for data projects using Azure DevOps
• Document data engineering solutions and adhere to Emergent Software’s delivery standards and Agile practices

Preferred Qualifications

• Holding Microsoft certification(s) in the Data & AI solutions field are a plus
• Microsoft Certified: Fabric Analytics Engineer Associate (DP-600)
• Microsoft Certified: Fabric Data Engineer Associate (DP-700)
• Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Benefits

• Work from home or work remotely from anywhere
• Flexible work schedule meaning you can work regular hours or whenever you work best
• Work-life balance is essential and highly valued at Emergent Software. If you choose to work more than 40 hours, you’ll be compensated for the extra work!
• 100 hours per year to focus on your professional development . We invest in your growth!
• Grow your career without leaving the tech track. At Emergent Software, you can advance and be recognized as a technical expert without transitioning into people management. We value deep technical expertise as much as leadership and have established clear career paths for those who want to stay hands-on
• Profit sharing bonus means as we’re successful, you’re successful
• Variable compensation opportunities for being part of on-call team rotation and performing client focused work outside of normal business hours
• Excellent benefits package including medical insurance, dental, vision, 401(k) matching, FSA, disability, life insurance, and paid parental leave
• Medical Insurance: up to 80% of your monthly medical premium (HSA options available)
• HSA Contribution: up to $144/month
• Dental & Vision Insurance: up to 50% of your monthly dental and vision premium costs
• 401(k) plan: company match up to 4% of salary
• Profit sharing bonus: up to 15% of salary paid quarterly
• Extra compensation: get paid extra for work over 40 hours/week
• Employee referral & customer referral bonuses
• Flex Spending Account (FSA) for Dependent Care & Healthcare Costs
• Dependent Care FSA Contribution: $90/month
• Short Term Disability: $500/week for 12 weeks
• Long Term Disability: up to $6,000/month
• Group term life and AD&D insurance: $50k
• PTO, standard holidays, 2 floating holidays
• Paid parental leave: 2 weeks
• Staff development program: 100 hours/year plus training costs