Data Engineer
Job Description
Thomson Reuters Special Services (TRSS) supports Federal Law Enforcement customers, and this Data Engineer role is onsite in the Burlington, VT area. In this position, you will work with large-scale data to help enable complex investigations, while benefiting from a flexible, growth-focused culture and a comprehensive US benefits package.
Responsibilities
- Serve Federal Law Enforcement agencies by collecting, integrating, resolving, analyzing, modeling, and explaining large data in support of complex investigations.
- Support a full range of Federal Law Enforcement missions, including Immigration Enforcement, Emerging Threat Detection, Money Laundering, Fraud, Force Protection, Human Rights Crimes, Transnational Crime, and more.
- Outside of contract work, contribute to internal innovation through research and development, building and maintaining shared capabilities, strengthening technical skills, and supporting business development such as proof-of-concept projects and capabilities briefings.
- Interpret customer requests or problem statements into clear project plans, define project goals and methods, and deliver actionable results within required timeframes.
- Interface directly with customers at all levels and represent TRSS.
- Handle sensitive, confidential, or regulated data in accordance with applicable policies and requirements.
- Work independently and as part of a team.
Requirements
- United States Citizenship (essential to comply with government contract requirements).
- Ability to obtain and maintain a U.S. security clearance or agency work suitability determination, as required by assignment.
- Ability to work full time, on-site, embedded at US Government offices in the Burlington, VT area.
- Bachelor’s or Master’s Degree in a technical field.
- At least 3 years of relevant experience, including at least one programming language (Python, Java, R, etc.), creating programs for ETL, data pipelines, and entity resolution.
- Proficiency in multiple variants of SQL, including complex queries, table and view creation, and database performance tuning.
- Experience managing enterprise databases and warehouses, particularly Databricks, MS SQL Server, Snowflake.
- Data modeling across disparate data sources with varied formats and structures.
- Ability to handle sensitive, confidential, or regulated data in line with applicable policies and requirements.
- Ability to interface directly with customers at all levels and represent TRSS.
- Ability to work independently and collaboratively.
- Experience with cloud data platforms (Azure, AWS, Snowflake, etc.).
- Experience with formal SDLC (Software Development Life Cycle) procedures.
- Experience with version control software and methodology, preferably GitHub.
- Current/active government work suitability or security clearance.
- Experience working with law enforcement agencies.
- Programming skills in multiple languages other than Python (Python is a minimum requirement), including R, Java, or SQL.
- Experience with software development practices including managing collaborative codebases, version control, linting/testing, containerization, and interacting with REST APIs.
Technologies
Python, Java, R, SQL, ETL, data pipelines, entity resolution, Databricks, MS SQL Server, Snowflake, Azure, AWS, SDLC, Github, REST APIs
Benefits
- Hybrid Work Model
- Flexibility & Work-Life Balance (Flex My Way; work from anywhere for up to 8 weeks per year)
- Career Development and Growth (Grow My Way programming and skills-first approach)
- Comprehensive benefit plans including flexible vacation, two company-wide Mental Health Days off, access to the Headspace app, retirement savings, tuition reimbursement, employee incentive programs, and resources for mental, physical, and financial wellbeing
- Social Impact Institute (two paid volunteer days off annually; opportunities for pro-bono consulting projects and ESG initiatives)
- Comprehensive US benefits package including market-competitive health, dental, vision, disability, and life insurance programs
- Competitive 401k plan with company match
- Paid holidays (including two company mental health days off), parental leave, sabbatical leave
- Optional hospital, accident, and sickness insurance paid 100% by the employee
- Optional life and AD&D insurance paid 100% by the employee
- Flexible Spending and Health Savings Accounts
- Fitness reimbursement
- Access to Employee Assistance Program
- Group Legal Identity Theft Protection benefit paid 100% by employee
- Access to 529 Plan, commuter benefits, adoption & surrogacy assistance
- Access to Employee Stock Purchase Plan
What’s in it for you
- Hybrid Work Model: a flexible hybrid environment for office-based roles with a connected digital and physical experience.
- Flexibility & Work-Life Balance: Flex My Way policies designed to support personal and professional responsibilities.
- Career Development: Grow My Way and a skills-first approach in an AI-enabled future.
- Industry-competitive benefits and wellbeing-focused resources.
- Culture: globally recognized, award-winning reputation for inclusion and belonging, flexibility, and work-life balance.
- Social impact: Social Impact Institute support for community involvement.
- Making a real-world impact: helping customers pursue justice, truth, and transparency.
Pay range disclosure: For eligible US locations, the base compensation range for this role is $82,000 USD - $152,200 USD. Base pay is determined within the range based on factors including knowledge, skills, and experience, with consideration given to internal equity. This role may also be eligible for an Annual Bonus based on enterprise and individual performance.