Remote ETL Data Engineer

Summary

Join us at Skyward, a people-centered business that values integrity, compassion, and innovation. We're seeking an ETL Data Engineer to support the Centers for Medicare and Medicaid Services (CMS) by disseminating data to researchers. As a team member, you'll be part of a future-looking and growth-oriented team that's passionate about modernizing government services with cutting-edge technology.

Requirements

• Bachelor’s degree
• At least 2 years of experience in data engineering
• Experience with one or more ETL tools like Informatica PowerCenter, Microsoft SSIS (SQL Server Integration Services), Talend, Pentaho, or Apache NiFi
• Strong understanding of relational databases (such as MySQL, Oracle, and SQL Server) and knowledge of SQL
• Experience with NoSQL databases like MongoDB or Cassandra
• Familiarity with data warehousing architectures (such as Kimball and Inmon) and technologies like Amazon Redshift, Google BigQuery, and Snowflake
• Excellent knowledge of scripting and programming languages for data manipulation and transformation
• Strong oral and written communication skills for collaborating with team members and stakeholders, documenting ETL processes, and explaining technical details clearly

Responsibilities

• Be part of a team that is supporting the Centers for Medicare and Medicaid Services (CMS) by disseminating data to researchers who are studying ways to improve the quality and reduce the cost of care provided to chronically ill Medicare beneficiaries
• Support data warehouse architecture development across one or more data warehouse solutions (such as Snowflake)
• Provide rotation-based production support for ETL batch loads including off-hours and weekends
• Analyze and resolve complex hardware/software compatibility and interface design considerations
• Conduct investigations and tests of considerable complexity
• Maintain data documentation on processes and procedures
• Track multiple data feeds, business rules, and statuses to ensure management receives accurate data and information

Benefits

• Medical, dental, vision insurance (fully paid for employees)
• 15 days of paid leave
• 7 days of sick leave
• 2 days bereavement leave
• 11 paid Federal holidays
• Up to 40 hours for jury duty
• 401K with 4% employer contribution (and no vesting period)
• Up to 4 weeks of paid paternity and maternity leave
• Company provided laptop
• $5,000 per year for professional development
• $600 per year for technical supplies and equipment
• $2,000 referral bonus
• Life and disability insurance
• HSA and FSA
• Legal Shield and ID Shield Voluntary Benefits