Jobs and Careers

Senior Data Engineer

Remote jobRemotefull_timeVerifiedPosted 11 Apr 2025

💰 $150,000/yr($115,000/yr – $150,000/yr)

About the role

** 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: