Skip to main content

Workforce Intelligence Data Engineer Specialist (Farmington, CT or Remote)

Apply Now
Businesses Raytheon Technologies Corporate Job ID 01470546 Most Recent Date Posted 09/12/2021 City Farmington State Connecticut Country United States

Date Posted:



United States of America


UT6: 4 Farm Springs 4 Farm Springs Road, Farmington, CT, 06032 USA

Workforce Intelligence Data Solutions has an opening for a Data Engineer Specialist to provide direct Data Engineering support to the RTX Workforce Intelligence workstreams of Advanced Analytics, Automation, and Business Unit Consultants. With Advanced Analytics as the primary customer, the Data Solutions Data Engineer Specialist will also engage with the other workstreams when advanced data engineering is needed beyond what is available from the existing data infrastructure. The Data Engineer Specialist will investigate and identify opportunities for new data pipelines and data structures to advance the Workforce Intelligence mission, develop new and innovative solutions, and where appropriate work with the Workforce Intelligence Infrastructure group to productionize.

The Data Solutions Data Engineer Specialist supports RTX Workforce Intelligence Advanced Analytics, Automation, and Business Unit Consultants data needs, and will

  • Collaborate with analytics and business consultant teams to improve data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization
  • Work with Advanced Analytics, Automation, and Business Consultant stakeholders to assist with data-related technical issues and support their data infrastructure needs. Effectively partner with the data scientists on the Advanced Analytics team on a regular basis.
  • Create data solutions for analytics team members that assist them in building and optimizing RTX Workforce Intelligence innovations
  • Design database queries to conduct benchmarking, testing, and validations for datasets used in machine learning and predictive models. Maintain the data quality and help support overall data governance of the datasets used in such models
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL, Matillion, and Snowflake technologies
  • Assemble large, complex data sets that meet business requirements
  • Combine raw information from different sources
  • Identify opportunities for data acquisition
  • Develop and design scalable data pipelines supporting analytics models and tools to provide actionable insights into key business performance metrics
  • Build algorithms and prototypes
  • Explore ways to enhance data quality and reliability
  • Keep our data secure, and compliant with data privacy and data protection commitments
  • Work with data and analytics experts to strive for greater functionality in our HR data systems.


  • Technical expertise with data models and data mining
  • Knowledge of programming languages such as Python (Matillion preferred)
  • Great numerical and analytical skills
  • Previous experience as a data engineer or in a similar role
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL), SQL database design as well as working familiarity with a variety of databases
  • Experience building and optimizing data pipelines, architectures, and data sets
  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
  • Strong analytic skills related to working with unstructured datasets
  • Experience building processes supporting data transformation, data structures, metadata, dependency, and workload management
  • A successful history of manipulating, processing, and extracting value from large disconnected datasets
  • Familiarity with the machine learning and predictive modeling lifecycle will be a plus
  • Strong project management and organizational skills
  • Excellent problem solving and troubleshooting skills
  • Process oriented with great documentation skills
  • Experience supporting and working with cross-functional teams in a dynamic environment
  • Excellent oral and written communication skills with a keen sense of customer service
  • Data engineering certification is a plus
  • Knowledge of HR data and HR data structure (Workday, ADP EV5) a plus
  • Ability to develop solutions to problems with minimal guidance
  • Nimble, ability to respond to ad hoc requests of differing urgencies and reprioritize on the fly
  • We are looking for a candidate with 5+ years of experience in a Data Engineer role, who has attained a Bachelor's degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field
  • Ideal candidate will have experience using the following software/tools:
    • Snowflake
    • Matillion
    • Dataiku
    • Alteryx
    • Oracle
    • SQL Server
    • Advanced SQL/SQL database skills
    • Python development experience
    • R
  • Seasoned professional contributor
  • May manage small projects or processes
  • Has advanced knowledge of work area
  • Problems faced are difficult and sometimes complex
  • Works autonomously with limited oversight from manager


Remote, Hybrid or on-site UT6 (4 Farm Springs Road, Farmington, CT) preferred, with most key customers, stakeholders, and the Data Solutions team either hybrid or onsite at location UT6 (4 Farm Springs Farmington CT).

Raytheon Technologies is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Privacy Policy and Terms:

Click on this link to read the Policy and Terms

Raytheon Technologies is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Apply Now

Your Saved Jobs

You have not saved any jobs.

Recently Viewed Jobs

You have no recently viewed jobs.

Sign Up for Job Alerts

Get the latest career opportunities as soon as they become available.

Interested InSearch for a category and select one from the list of suggestions. Search for a location and select one from the list of suggestions. Finally, click “Add” to create your job alert.

  • Human Resources, Farmington, Connecticut, United StatesRemove
  • All, Farmington, Connecticut, United StatesRemove
  • New England Engineering, Farmington, Connecticut, United StatesRemove