What are the responsibilities and job description for the Fulltime Data Engineer - 100% remote position at Avesta Computer Services?
Customer - Our customer is Transitioning from a legacy stack (Cognos and SSIS) to a modern stack using Power BI and Snowflake. Cognos and SSIS experience are preferred. The modernization journey is critical and offers significant learning opportunities for the candidate. It is required for them to have Snowflake and Reporting expertise
Job Title Fulltime Data Engineer
Location Raleigh, North Carolina, United States - Open to remote (East Coast)
Type Fulltime Permanent
Visa Open to H1B Transfer candidates.
Reporting Structure: The engineer will work in a small, high-visibility BI product team responsible for sourcing, formatting, and ensuring the quality of data before providing insights to stakeholders across the company. 4 onshore, 3 offshore team members.
Key Projects:
- Modernization – Migrating from a legacy stack to a current technology stack.
- Cloud Migration – Strategic modernization effort focused on moving systems to the cloud.
Core Focus Areas:
- Snowflake is critical as we aim to become a Center of Excellence for data sourcing and management within the company.
- SQL is a key requirement.
- ETL (Any tool) – Strong preference for SSIS and ADF, but the ability to understand and quickly learn new ETL tools is highly valued.
Work Environment & Expectations:
- Fast-paced organization, where the treadmill is always at 6-10.
- Seeking independent contributors (ICs) who can drive work with minimal to no hand-holding.
- Looking for go-getters, not task-takers – candidates must take accountability, drive conversations, ask questions, and bring insights to their work.
- Must be able to own their work end-to-end.
- Hands-on experience with data extraction, quality checks, and publishing insights for stakeholders, including C-level executives. The candidate should also navigate challenges with street-smart problem-solving.
- Potential Growth: The role offers opportunities for promotion, including transitioning into a leadership position.
- Immediate Hiring: VERY HIGH VISIBILITY ROLE
- Team Visibility: Despite being a small team, it has high visibility and significant exposure to stakeholders, making the role impactful and potentially career-advancing
Required:
- Data Engineering experience
- Snowflake (data warehousing) still required at 3-5 YOE.
- ETL Experience (3-5 YOE)
- Must have strong Reporting expertise, either PBI (preferred) or Cognos
- 80% of role is Hands-on, so candidate must have recent hands on experience
Preferred:
- SQL Server
- SSIS experience (*SSIS being the current state moving to potentially a custom tool in 3 years)
Modeling skills (DVM, Kimball, etc)
- Bonus: Insurance background
