Senior Data Engineer I

Job Title: Data Engineer II

Job Location: Boston Massachusetts 02041-(Remote)

Onsite Requirements: Remote

• 4+ yrs experience writing production level Java code


• 4+ yrs experience with complex SQL (e.g., production experience, table design and creation, functions, queries, optimization) Oracle SQL deal


• Some Cloud Native/Cloud API experience


• Experience working directly with the business to build solutions

Job Description:

• You will drive the transformation of our data systems by designing and deploying architectures to drive greater analytical and business value from a wide range of data sources.


• The individual will work with Team Members to design and develop highly performant, resilient, automated data pipelines and data transformation applications, adapting technologies for ingesting, transforming, classifying, cleansing, and exposing data using creative schema design to meet objectives.

Responsibilities:

• Develop, enhance, and maintain Client Safeguarding infrastructure to support analytics, reporting, and operational needs.


• Design, build, and optimize ETL/ELT pipelines to ensure efficient, reliable data ingestion and integration from diverse sources.


• Analyze, organize, and transform raw and structured data to support data modeling efforts, reporting, and business insights.


• Explore, implement, and refine methods to improve data quality, reliability, and overall system performance.


• Monitor and troubleshoot data discrepancies, quality issues, and pipeline failures to ensure accuracy and timely delivery.


• Identify architectural bottlenecks, optimize system performance, and contribute to long-term platform scalability.


• Work with Product Managers and Business Analysts to understand functional requirements and interact with other cross-functional teams to architect, design, develop, test, and release features.


• Build and prototype algorithms and analytical tools to support complex data analysis and automation.


• Design and support cloud-native data workflows, including logging, monitoring, and working with storage buckets and other cloud services.


• Collaborate closely with BI Engineers, Finance teams, and cross-functional partners across global offices to deliver efficient, robust, and scalable data solutions.


• Create and maintain technical documentation (e.g., JIRA), ensuring accuracy and clarity across development activities.


• Participate in agile ceremonies, contribute to continuous improvement efforts, and help advance engineering best practices.


• Support on-call responsibilities as needed to address urgent system issues and maintain platform availability.


• Create and maintain existing documentation (configuration, test scripts, functional specs for reporting, and integration).


• Contribute to continuous improvement and development of business processes.


• Demonstrate an open-minded and collaborative approach to creating innovative technical solutions.


• Provide leadership and mentorship to other team members and early adopters of the platform.

Qualifications:

• Bachelor's degree in computer science or equivalent technical discipline.


• 4+ years of experience with advanced SQL Knowledge (Oracle, PostgreSQL, etc.).


• 4+ years of experience with Java or Groovy languages.


• 3+ years of experience interacting with web service APIs (SOAP, REST).


• 2+ years of experience with DBT.


• 2+ years data modeling experience.


• Knowledge of modern data platforms including how to design, scale and optimize data systems. Must understand distributed processing, storage strategies and performance considerations.


• Knowledge of Snowflake Analytics Platform is a plus.


• Experience in working within an Agile environment.


• Knowledge of GIT, Jenkins (CI).


• Experience with Automation, including Unit and Integration Testing.


• Knowledge of Cloud Concepts.
  
  

• **3rd party and subcontract staffing agencies are not eligible for partnership on this position. 3rd party subcontractors need not apply.


• This position requires candidates to be eligible to work in the United States, directly for an employer, without sponsorship now or anytime in the future**