Staff Enterprise Data Engineer

TriNet is a leading provider of comprehensive human resources solutions for small to midsize businesses (SMBs). We enhance business productivity by enabling our clients to outsource their HR function to one strategic partner and allowing them to focus on operating and growing their core businesses. Our full-service HR solutions include features such as payroll processing, human capital consulting, employment law compliance and employee benefits, including health insurance, retirement plans and workers’ compensation insurance. 

TriNet has a nationwide presence and an experienced executive team. Our stock is publicly traded on the NYSE under the ticker symbol TNET. If you’re passionate about innovation and making an impact on the large SMB market, come join us as we power our clients’ business success with extraordinary HR.

Don't meet every single requirement? Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single requirement. At TriNet, we are dedicated to building a diverse, inclusive and authentic workplace, so if you're excited about this role but your past experience doesn't align perfectly with every single qualification in the job description, we encourage you to apply anyways. You may just be the right candidate for this or other roles. 

JOB SUMMARY
The Data Engineer will build, manage and optimize data pipelines and move these data pipelines effectively into production for key data and analytics consumers like business/data analysts, data scientists or any business partner that needs curated data for data and analytics use cases across the enterprise.

This role will be the key interface in operationalizing data and analytics on behalf of the business unit(s) and organizational outcomes and will require both creative and collaborative working with IT and the wider business. It will involve evangelizing effective data management practices and promoting better understanding of data and analytics.

The data engineer will also be responsible for planning and implementing the best-in-class analytics and data science solutions utilizing a variety of technologies, including on-premises and leading cloud service providers, in collaboration with important business partners and IT specialists.

 Essential Duties/Responsibilities
•    Create, maintain, and optimize data pipelines from development to production for specific use cases.
•    Use innovative and modern tools, data services, techniques, and well architected frameworks to automate the most-common, repeatable, and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity.
•    Assist with optimizing the data management infrastructure to drive automation in data integration and management.
•    Implementing and using modern data preparation, integration and AI-enabled metadata management tools and techniques. Including MLOps framework and infrastructure automation.
•    Tracking data consumption patterns
•    Performing intelligent sampling and caching
•    Monitoring schema changes
•    Recommending and automating existing and future integration flows.
•    Collaborate in close relationship with data science teams and with business (data) analysts in refining their data requirements for various data and analytics initiatives and their data consumption requirements.
•    Build, model and curate data lake/warehouse and other data consumption methods.
•    Performs other duties as assigned
•    Complies with all policies and standards

QUALIFICATIONS

Education

• Bachelor's Degree in Computer Science/Engineering or equivalent experience, preferred    
   

Work Experience 

• Typically 8+ years of experience in implementation of Data & BI projects in a large-scale enterprise data lake/ warehouse environment required
• Typically 8+ years of experience in ETL/ELT Architecture and hands-on experience in developing the ETL/ELT jobs and tools like Informatica PowerCenter/ Informatica Cloud - IICS, AWS Glue required
• Must have working experience in SFDC and PeopleSoft in areas of Sales, Marketing, Finance, or Support domains    
• Knowledge or experience in working with Cloud data warehouses like Snowflake, AWS Redshift, Python and  ANSI SQL     
• Proven hands-on experience in using Informatica components such as Designer, Workflow Manager, Workflow Monitor, Repository Manager, Python etc     
• Hands on experience with database performance tuning like Oracle, Postgres and strong database languages like SQL, PL/SQL, ANSI SQL, Python, Unix Shell and Perl Scripting    
   

Licenses and Certifications

•     Informatica Powercenter/ Informatica Cloud - IICS preferred    

Knowledge, Skills and Abilities

• Knowledge of end-to-end SDLC process in EDW, Data Lake, BI & MLOps projects   
• Dimensional Modeling and Data warehouse, ODS concepts, such as star schemas, snowflakes and normalized data models 
• Ability to coordinate effectively with on-site and offshore resources through Managed Service Providers & IT Teams  
• Knowledge of Reporting tools like Tableau is desired  
• Excellent verbal and written communication skills   

Work Environment:
Currently remote.  Future:  Work in clean, pleasant, and comfortable office setting
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Travel Requirements
Minimal travel

The salary range for this role is $103,700 to $273,700. The candidate’s final salary offer will be based on the candidate’s skills, education, work location and experience.

A candidate’s compensation may also include bonuses consistent with TriNet’s corporate bonus plan.

Additionally, subject to applicable eligibility requirements, TriNet offers permanent full-time employees a variety of benefits including medical, dental, and vision plans, life and disability insurance, a 401(K) savings plan, an employee stock purchase plan, eleven (11) Company observed holidays, PTO and a comprehensive leave program.  Please click the following link for detailed information about our benefits offerings:  https://www.trinet.com/documents/blt5b61a1040aae1904  

Please Note: TriNet reserves the right to change or modify job duties and assignments at any time. The above job description is not all encompassing. Position functions and qualifications may vary depending on business necessity.

TriNet is an Equal Opportunity Employer and does not discriminate against applicants based on race, religion, color, disability, medical condition, legally protected genetic information, national origin, gender, sexual orientation, marital status, gender identity or expression, sex (including pregnancy, childbirth or related medical conditions), age, veteran status or other legally protected characteristics. Any applicant with a mental or physical disability who requires an accommodation during the application process should contact recruiting@trinet.com to request such an accommodation. 

TriNet is a leading provider of comprehensive human resources solutions for small to midsize businesses (SMBs). We enhance business productivity by enabling our clients to outsource their HR function to one strategic partner and allowing them to focus on operating and growing their core businesses. Our full-service HR solutions include features such as payroll processing, human capital consulting, employment law compliance and employee benefits, including health insurance, retirement plans and workers’ compensation insurance.
TriNet has a nationwide presence and an experienced executive team. Our stock is publicly traded on the NYSE under the ticker symbol TNET. If you’re passionate about innovation and making an impact on the large SMB market, come join us as we power our clients’ business success with extraordinary HR.
Please note that at this time, TriNet requires colleagues reporting to TriNet offices, engaging in in-person activities (including off-sites) or engaging in TriNet sponsored business travel, to be fully vaccinated (as defined by the CDC) against COVID-19 or provide proof of a negative PCR test each week.  TriNet will consider requests for reasonable accommodations for documented medical reasons and for sincerely held religious beliefs in accordance with applicable law.   TriNet is providing access to a mobile app for colleagues to submit proof of vaccination or negative test results.  Please do not include proof of vaccine status or any indication of a possible request for an accommodation when submitting your application materials. If applicable, TriNet will follow up with you directly to request proof of vaccination and to discuss any potential accommodations.