
Senior Data Engineer
Emergent Software
full-time
Posted on:
Location Type: Remote
Location: United States
Visit company websiteExplore more
Salary
💰 $115,000 - $150,000 per year
Job Level
About the role
- 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
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
- 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
- Medical Insurance: up to 84% of your monthly medical premium (HSA options available)
- HSA Contribution: up to $200/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
- 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
- Staff development program: 100 hours/year plus training costs
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data platform architecturedata modeling design patternsETLdata transformationperformance tuningSQLPythonAzure Data FactoryAzure Synapsedata warehousing
Soft Skills
mentoringcollaborationleadershipcommunicationthought leadershipcoachingadvisorydocumentationorganizational skillsproblem-solving
Certifications
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)