Senior Data Engineer (Snowflake)
Performance Architects · Boston, MA · 1 mo ago
RemoteRemoteInformation TechnologyFull-time
Core Job Responsibilities
- Collaborate with project teams and clients to understand data requirements, architecture, and objectives
- Working with business partners to understand the business requirements so that you can create a technical design to support those requirements
- Design, develop, and maintain data pipelines and ETL processes using technologies like Snowflake, Oracle, Fivetran, dbt, and IICS
- Aid in migrating Oracle data warehouse to Snowflake, ensuring data integrity, performance, and scalability
- Develop and optimize SQL queries and scripts for data extraction, transformation, and loading
- Implement best practices for data governance, security, and compliance
- Resolve data-related issues in a timely manner
- Work closely with cross-functional teams, including data analysts, business users, and IT teams, to deliver high-quality solutions
- Provide technical leadership and mentorship to junior team members
- Stay updated on emerging technologies and industry trends related to data engineering and analytics
Requirements and Skills
- B.S. or B.A. degree in business, MIS, or equivalent required
- Proficiency in SQL programming and database management systems such as Snowflake and Oracle
- Hands-on experience with data integration tools like Fivetran, dbt, and IICSS
- Strong understanding of data warehousing concepts, data modeling, and ETL processes
- Experience with Windows scripting and automation tools is a plus
- Excellent problem-solving and analytical skills
- Ability to work effectively in a fast-paced, collaborative environment
- Strong communication and interpersonal skills
- Comfortable in dynamic, constantly changing environments
- Excellent time management skills with the ability to multitask
- Projects a composed professional image
- Excellent written, oral, and interpersonal communication / relationship-building skills
- Effective working with diverse personalities
- Team player
Compensation & Benefits
- Competitive base salary
- Individual and company performance bonuses
- Ongoing, formal technical and business skills training
- Medical/dental insurance
- LTD/STD insurance
- Life insurance
- 401K plan
- Flexible Spending Account (FSA)
- Paid vacations and holidays
- 401(k) matching
- Dental insurance
- Employee assistance program
- Flexible spending account
- Health insurance
- Life insurance
- Paid time off
- Parental leave
- Supplemental Pay: Bonus opportunities