What are the responsibilities and job description for the Senior Data Engineer position at Performance Architects?
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
Flexibility to travel (Monday – Thursday) during the work week, if 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*
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
Flexibility to travel (Monday – Thursday) during the work week, if 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.
Salary : $100,000 - $150,000