Senior Data Engineer

Senior Data Engineer 4.8 4.8 out of 5 stars Chicago, IL Remote $115,000

• $150,000 a year
• Full-time Emergent Software 20 reviews $115,000
• $150,000 a year
• Full-time
• This is an opportunity to join our dynamic team of data professionals working together managing environments and implementing interesting projects for our clients. This position is fully remote (indefinitely).
• Emergent Software is seeking a Senior Data Engineer who is intelligent, passionate, detail-oriented, and enjoys working in Data Engineering using the Microsoft suite of data solutions.

A qualified candidate possesses experience in leading data engineering teams and developing solution designs. This 100% remote position is for self-starters with good communication skills, strong work ethic, and the ability to manage work across numerous clients and priorities. This role requires a technical professional who thrives in dynamic environments, can wear multiple hats, and is passionate about designing, maintaining, and optimizing modern data platforms. Highlights & Benefits of working at Emergent Software Work closely with other talented data professionals & software engineers . Our vetting process means you can count on your team members to know what they are talking about. 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! Work on interesting projects solving complex business problems with custom software. 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 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 Required Experience 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 Nice to Have Experience 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) Our Vetting Process At Emergent Software, we work hard to find the best data engineering professionals capable of providing robust consulting and high-quality services to our clients. If you think you're one of those, please understand that the effort put into this by people like yourself helps us be successful in surrounding you with other top-notch engineers. Here are the steps of our vetting process for this position: Application (5 minutes) Online Assessment (40-50 minutes) Initial Phone Interview (30-45 minutes) At-Home Data Engineering Challenge (3-4 hours) Technical Interview (60-90 minutes) Job Offer!

Benefits Package Details 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 About Emergent Software Emergent Software is a fast-growing software development, cloud consulting, and data engineering company serving clients across the country. We are regularly adding to our team of talented software engineers, cloud architects, data engineers, UX designers, technical product owners and more who can help us deliver high quality services for our clients. We are a remote-first company Since our inception, we've embraced a remote-friendly culture, promoting work flexibility beyond the norm. When the pandemic struck in 2020, our transition to fully remote work was seamless—just a matter of cleaning out the fridge. Recognizing an opportunity, we adopted a remote-first approach and began hiring talent from anywhere. We continue to offer our signature Minnesota-nice, Midwest-friendly attitude, ensuring everyone feels valued, whether or not they're familiar with the skyway system. Your career grows with us Working with talented engineers on interesting projects creates an engaging environment for software development enthusiasts. By working directly with our experienced team, participating in our staff development program, and solving complex problems across a variety of projects, you'll find numerous opportunities for long-term career growth. At Emergent Software, your ideas will be heard, you will grow exponentially as a master of your craft, and you will enjoy working other dedicated team members to deliver software solutions for our clients. Check out what others say Visit our Glassdoor page to discover how employees enjoy our remote working structure, flexible hours, profit sharing program, and more! #EmergentSoftware #IND1