Senior Data Engineer in Boston, Massachusetts at Performance Architects Inc

Performance Architects, Inc. (www.performancearchitects.com) is a fast-growing, leading business and technology consulting company that partners with our clients to initiate and sustain significant improvements in enterprise performance.

Performance Architects is seeking a highly skilled and experienced Senior Data Engineer to join our dynamic team. The Senior Data Engineer will play a key role in assisting with various projects involving data migration, transformation, and reporting. The ideal candidate will have strong expertise in utilizing technologies such as Snowflake, Oracle, Fivetran, dbt, Windows scripting, and Informatica Integration Cloud Services (IICS). Experience in migrating Oracle data warehouses to Snowflake and establishing reporting capabilities during the transition phase are desired but not required. You will be instrumental in supporting our clients' needs, leading business requirements gathering and creating (and executing on) a technical design to support those requirements.

**Use of Artificial Intelligence (AI) During the Interview Process**

Performance Architects embraces the responsible use of AI and recognizes its value as a productivity and innovation tool in the workplace. However, during our interview and assessment process, we are evaluating each candidate's individual knowledge, experience, problem-solving abilities, and communication skills.

Candidates are prohibited from using AI-powered interview assistants, real-time answer generators, coaching tools, or any other technology designed to provide responses during interviews, technical assessments, or hiring evaluations unless explicitly authorized by the hiring team.

The use of such tools during any stage of the interview process will result in immediate disqualification from consideration for employment.

Locations: Remote (anywhere in the US); Boston, MA Area

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
Assist 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
Troubleshoot and 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 IICS
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
Job Type: Full-time
Benefits:
401(k)
401(k) matching
Dental insurance
Employee assistance program
Flexible spending account
Health insurance
Life insurance
Paid time off
Parental leave
Referral program
Supplemental Pay: Bonus opportunities*
*The posted salary range reflects our target range; however, we have flexibility for candidates with exceptional experience and qualifications.