Share this Job
Apply now »



Lead Data Engineer (SQL/ Big Data)

Req id:  22660

Boston, MA, US Alpharetta, GA, US Tinton Falls, NJ, US San Mateo, CA, US San Antonio, TX, US San Diego, CA, US Virtual, US Austin, TX, US Pasadena, CA, US


As the Information Company, our mission at OpenText is to create software solutions and deliver services that redefine the future of digital. Be part of a winning team that leads the way in Enterprise Information Management. 



The Opportunity: #LI-Remote


OpenText is looking for a innovative and curious person to join a team of data & feature engineers. The successful candidate will work on unlocking massive value from volumes of existing data. The Senior Data Engineer will work closely with data scientists and business owners to define and build real time data pipelines to support AI and analytics efforts. Candidates should have extensive experience productionalizing / wrangling unstructured data and creating features suitable for analytics and modelling. The team is global and very collaborative.  We are a fast-paced organization and there are numerous projects in progress at any one time.


You Are Great At:


  • Participating in requirements gathering / analysis, and solution documentation of large scale data transformation / feature engineering and loading routines
  • Construction of robust data transformation / feature engineering and loading routines
  • Working collaboratively with the data science team to engineer and integrate features from foundational data that are suitable for solving modelling problems
  • Coming up with and conducting unit and integration test cases for data transformation and loading pipelines
  • Assessing correlations and suitability for modelling of transformed data
  • Curiosity with global regulatory regimes and anonymization frameworks and how they effect analytics and modeling outcomes
  • Investigating and implementing ways to improve data reliability, efficiency, and quality
  • Working creatively to understand, wrangle, and integrate diverse / unstructured data sources
  • Collaborating with stakeholders including the product owners, data science, and design teams to assist with data-related technical issues and support their data infrastructure needs


What It Takes: 


  • Bachelor’s degree in computer science, engineering, business, finance or a related area of study
  • 7+ years experience in a similar role
  • Excellent analytical and problem-solving skills
  • Extreme attention to detail
  • Familiarity with the modelling / analytics process, assessing the usefulness of data within that process
  • Deep knowledge of SQL, “Big data” data pipelines, and architectures
  • Experience with enterprise data modelling and architecture
  • Experience working with big data tools like Apache Spark
  • Experience working with large data sets, data pipeline and workflow management tools, and stream-processing systems
  • Experience with data lineage concepts & related tools
  • Experience with data cleansing, data masking for PII
  • Experience implementing automated data quality validations within ETL pipelines 
  • Strong knowledge of Cloud environments (Unix/Windows, Virtualization, Containers, Data Management, CI/CD Management)
  • Background in programming in Python, C, C++, or Java
  • Experience with waterfall and agile methodologies
  • Experience with, or willingness to develop and exercise skills in the areas of enterprise content management, web-based software applications, and application integration
  • Ability to work cross-functionally with IT infrastructure and database administrator teams on project implementations
  • Knowledge of Jira and Confluence
  • Experience with OpenText Magellan
  • Good written and verbal communication skills
  • Able to build a sense of trust and rapport with the team and partners
  • A self-starter attitude, a strong desire to learn as you go, and the belief that you can make a meaningful contribution to your immediate team, the business users that you serve, and to the organization


For Colorado residents, this job is expected to pay in the range of 98K-147K in addition to a comprehensive and competitive group benefit and healthcare plan. Individual compensation will be determined based on skills and experience comparable to the job requirements.


While OpenText is an Equal Opportunity Employer, our efforts to build an inclusive work environment go beyond simply complying with applicable laws. Our Employment Equity and Diversity Policy provides direction on maintaining a working environment that is inclusive of everyone, regardless of culture, national origin, race, color, gender, gender identification, sexual orientation, family status, age, veteran status, disability, religion, or other basis protected by applicable laws. Should you require accommodations during the selection process, please contact accomodationrequests@opentext.com.


Additionally, OpenText, as a proud US Federal Government contractor, is subject to Executive Order 14042 requiring all US employees (in office or virtual) be fully vaccinated by January 4, 2022. New employees joining OpenText will be required to provide proof of vaccination prior to joining or be approved for a medical or religious exemptions. If you believe you qualify for an exemption you can request the exemption form at accommodationrequests@opentext.com


Our growing team is mapping the future of Information Management, and we continue to make new discoveries that expand its boundaries. Join us and be part of a winning team, where the opportunities for your career are limitless. 

From its innovative start as a research project by University of Waterloo professors in 1991, OpenText has grown into a global company with offices in more than 35 countries. Our high- performance culture has forged our growth and is an excellent fit for people looking to push themselves to learn and do more.

It’s our time to lead, and as part of our team, it will be your time too. Our continued growth will provide you the opportunity to explore, learn and chart an exciting career path while enjoying a good work-life balance. 

If you thrive in a dynamic work environment, there is always a new horizon to explore. We are proud to offer excellent benefits, challenging work and competitive financial rewards. 

Our employee programs prioritize employees’ well-being and that of their families. We offer a comprehensive benefit plan, education assistance, a wellness/fitness reimbursement and time off to volunteer. 

Social events 
With offices around the world and flexible work arrangements, OpenText strives to make sure all our employees feel connected. Teamwork extends to our social lives too from local social events to company-wide activities, we want our employees to take time to relax and have fun.  

Corporate Citizenship  
Corporate Citizenship is more than a program for us, it is engrained in our purpose, impact, and approach to doing business. Through numerous volunteer initiatives, we support education and innovation for global change.

Join OpenText today.

Nearest Major Market: Boston

Apply now »