Senior Data Engineer

Summary

Join Emergent Software's dynamic team of data professionals as a fully remote Senior Data Engineer. You will design, maintain, and optimize modern data systems using Microsoft technologies, supporting multiple clients. The ideal candidate possesses expertise in data modeling, data warehouse design, and Microsoft's data solutions. This role requires strong communication, a solid work ethic, and the ability to manage multiple priorities. Emergent Software offers a comprehensive benefits package, including flexible work arrangements, profit sharing, and professional development opportunities. The company values work-life balance and invests in employee growth.

Requirements

• 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
• Experience with Reporting tools such as Power BI
• Experience with ETL tools such as Azure Data Factory
• Experience with Performance tuning databases and long running queries
• Experience with Stored procedure development
• Experience with Database migrations and/or database server consolidations, including Azure SQL solutions
• Experience with configuring Azure SQL databases, elastic pools, and Managed Instances
• Experience with performing health checks, assessments, and security audits for client databases
• Experience with implementing replication and/or log shipping for disaster recovery or reporting scenarios
• Experience with evaluating disk I/O and network throughput for SQL performance

Responsibilities

• Develop and maintain data processing software
• Perform Database Engineer responsibilities
• Perform Database Administrator responsibilities
• Manage work across numerous clients and priorities
• Design, maintain, and optimize modern data systems
• Work closely with other talented database professionals & software engineers
• Work on interesting projects solving complex business problems with custom software

Preferred Qualifications

• 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
• 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)

Benefits

• Work from home or work remotely from anywhere
• Flexible work schedule
• Work-life balance
• Extra compensation for work over 40 hours/week
• 100 hours per year to focus on your professional development
• Profit sharing bonus
• 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
• 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