Senior Data Engineer

** 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 Senior Data Engineer who is a smart, passionate, and detail oriented and enjoys Data Engineering work using the Microsoft suite of data solutions. A qualified candidate has knowledge for developing and maintaining data processing software and can perform both Database Engineer and, to a lesser extent Database Administrator responsibilities. 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 systems.

Highlights & Benefits of working at Emergent Software

• Work closely with other talented database 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!
• 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

Required Experience

• Basic understanding of data modeling design patterns such as 3NF and star-schema
• Data warehouse design experience using medallion architecture and/or snowflake methodologies
• Experience with Microsoft Fabric, Synapse or Snowflake
• Reporting tools such as Power BI
• ETL tools such as Azure Data Factory
• Performance tuning databases and long running queries
• Stored procedure development
• Database migrations and/or database server consolidations, including Azure SQL solutions
• Configure Azure SQL databases, elastic pools, and Managed Instances
• Perform health checks, assessments, and security audits for client databases
• Implement replication and/or log shipping for disaster recovery or reporting scenarios
• Evaluate disk I/O and network throughput for SQL performance

Nice to Have Experience

• Advanced SQL syntax
• SQL Server installation & configuration in production environments using best practices
• Availability Group & failover cluster configuration
• Exposure to MySQL and/or PostgreSQL environments
• Familiarity with Red Gate SQL Monitor or similar tools
• Right-sizing VM for SQL Server
• Develop and maintain robust backup, recovery, and maintenance plans
• 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)
• Microsoft Certified: Administering Microsoft Azure SQL Solutions (DP-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 & Short Coding Test  (50-70 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 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

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