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 AreaCore Job ResponsibilitiesCollaborate with project teams and clients to understand data requirements, architecture, and objectivesWorking with business partners to understand the business requirements so that you can create a technical design to support those requirementsDesign, develop, and maintain data pipelines and ETL processes using technologies like Snowflake, Oracle, Fivetran, dbt, and IICSAssist in migrating Oracle data warehouse to Snowflake, ensuring data integrity, performance, and scalabilityDevelop and optimize SQL queries and scripts for data extraction, transformation, and loadingImplement best practices for data governance, security, and complianceTroubleshoot and resolve data-related issues in a timely mannerWork closely with cross-functional teams, including data analysts, business users, and IT teams, to deliver high-quality solutionsProvide technical leadership and mentorship to junior team membersStay updated on emerging technologies and industry trends related to data engineering and analyticsRequirements And SkillsB.S. or B.A. degree in business, MIS, or equivalent requiredFlexibility to travel (Monday – Thursday) during the work week, if requiredProficiency in SQL programming and database management systems such as Snowflake and Oracle.Hands-on experience with data integration tools like Fivetran, dbt, and IICSStrong understanding of data warehousing concepts, data modeling, and ETL processesExperience with Windows scripting and automation tools is a plusExcellent problem-solving and analytical skillsAbility to work effectively in a fast-paced, collaborative environmentStrong communication and interpersonal skillsComfortable in dynamic, constantly changing environmentsExcellent time management skills with the ability to multitaskProjects a composed professional imageExcellent written, oral, and interpersonal communication / relationship-building skillsEffective working with diverse personalitiesTeam playerCompensation & BenefitsCompetitive base salaryIndividual and company performance bonusesOngoing, formal technical and business skills trainingMedical/dental insuranceLTD/STD insuranceLife insurance401K planFlexible Spending Account (FSA)Paid vacations and holidaysJob Type: Full-timeBenefits401(k)401(k) matchingDental insuranceEmployee assistance programFlexible spending accountHealth insuranceLife insurancePaid time offParental leaveReferral programSupplemental Pay: Bonus opportunities*The posted salary range reflects our target range; however, we have flexibility for candidates with exceptional experience and qualifications.