Senior Data Engineer

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.

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.

About Performance Architects Inc

Performance Architects is a professional services firm that provides solutions for our clients that help them plan, monitor, and measure their performance. We do this through the implementation of market-leading Enterprise Performance Management, Analytics, and Data solutions. Since our founding in 2006, we’ve focused on building long term relationships with our clients and partners in order to achieve mutual successes.