Senior Data Engineer

Lead end-to-end enterprise data engineering initiatives, from integration and warehousing to pipeline optimization and technical leadership.

Responsibilities

• Lead a team of developers, including internal and vendor resources, across the end-to-end design, development, implementation, and optimization of enterprise data integration and warehousing solutions
• Build and maintain robust ETL pipelines to connect source systems with target analytics platforms
• Create and maintain scalable data models supporting analytics and reporting needs
• Partner with external vendors and internal stakeholders to translate complex business requirements into high-performing technical solutions
• Collaborate with business teams to define priorities and serve as data/technology lead on cross-functional delivery efforts for data and reporting solutions
• Coordinate with vendor teams to support data operations
• Design, implement, and test complex data mappings and transformations using Informatica PowerCenter
• Optimize ingestion pipelines for scale, performance, reliability, and cost-efficiency
• Perform SQL performance tuning, including partitioning, Pushdown Optimization (PDO), and stored procedures in Oracle, SQL Server, and DB2
• Use Linux scripting and enterprise job scheduling tools to support operational workflows
• Support multiple integration methods and connectors, including APIs, files, SFTP/FTPS, Streaming Data, database connectors, SOAP, and REST
• Implement data governance and architecture practices, including data modeling, governance frameworks, and metadata management
• Enforce data quality and data security standards and adhere to strict industry compliance requirements
• Provide operations and troubleshooting support for large data sets, including debugging and continuous monitoring of active data pipelines
• Deliver team leadership through professional communication, mentoring, coaching, and guidance for junior developers
• Document data processes, workflows, and complete technical ETL solutions

Requirements

• Bachelor’s degree (or higher) in Computer Science, Information Systems, Business Information Technology, or an equivalent field
• 5+ years of professional, hands-on experience in data engineering, data architecture, or data integration
• Must be eligible to work in the United States without requiring sponsorship now or in the future (US Citizen or Green Card holder)

Technologies

• Informatica PowerCenter
• ETL (Extract, Transform, Load)
• SQL
• Oracle, SQL Server, DB2
• Data lake
• Linux scripting
• APIs, SFTP, FTPS, Streaming Data, SOAP, REST
• Git/GitHub
• CI/CD pipelines
• Power BI, OBIEE, Hyperion Essbase

Benefits

• Medical, dental, vision, life, and disability insurance
• 401K with a company match
• Tuition reimbursement
• PTO
• Company paid holidays
• Flexible work arrangements
• Cultural Awareness Day in support of IDE
• On-site medical/wellness center (Worcester only)

Bonus Points

• Experience working in Agile methodologies and modern DevOps environments
• Hands-on experience with Git/GitHub and CI/CD pipelines
• Familiarity with BI reporting tools such as Power BI, OBIEE, and Hyperion Essbase
• Master’s degree in Information Systems, Business Information Technology, or an equivalent field

Location and Pay

• Location: Remote (remote) with role basis in Worcester, MA
• Salary: USD 105,000 - 130,000 per yearly
• Pay type: Salary
• Job family: Data - Data Engineering
• Job function: Data and Analytics