Principal Data Engineer (Remote)

Who is Trace3?

Trace3 is a leading Transformative IT Authority, providing unique technology solutions and consulting services to our clients. Equipped with elite engineering and dynamic innovation, we empower IT executives and their organizations to achieve competitive advantage through a process of Integrate, Automate, Innovate.

Our culture at Trace3 embodies the spirit of a startup with the advantage of a scalable business. Employees can grow their career and have fun while doing it!

Trace3 is headquartered in Irvine, California. We employ more than 1,000 people all over the United States. Our major field office locations include Atlanta, Denver, Detroit, Indianapolis, Grand Rapids, Lexington, Los Angeles, Louisville, Texas, San Diego, San Francisco, and Scottsdale.  

Ready to discover the possibilities that live in technology?

Come Join Us!

Street-Smart - Thriving in Dynamic Times

We are flexible and resilient in a fast-changing environment. We continuously innovate and drive constructive change while keeping a focus on the “big picture.” We exercise sound business judgment in making high-quality decisions in a timely and cost-effective manner. We are highly creative and can dig deep within ourselves to find positive solutions to different problems.

Juice - The “Stuff” it takes to be a Needle Mover

We get things done and drive results. We lead without a title, empowering others through a can-do attitude. We look forward to the goal, mentally mapping out every checkpoint on the pathway to success, and visualizing what the final destination looks and feels like.

Teamwork - Humble, Hungry and Smart

We are humble individuals who understand how our job impacts the company's mission. We treat others with respect, admit mistakes, give credit where it’s due and demonstrate transparency. We “bring the weather” by exhibiting positive leadership and solution-focused thinking. We hug people in their trials, struggles, and failures – not just their success. We appreciate the individuality of the people around us.

About the Role:

What You’ll Do:

• Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence, and deployment infrastructure diagrams.
• Take ownership of technical solutions from design and architecture to hands-on delivery work for projects. 
• Work closely with sales teams and clients to understand their business, capture requirements, identify pain areas, and propose ideal solutions to win business.
• Experience with gathering end user requirements and writing technical documentation.
• Suggest innovative solutions based on new technologies and latest trends.
• Review the architectural/technological solutions for ongoing projects and ensure right choice of solution.
• Other duties as requested by supervisor.

Qualifications & Interests:.

• Must have prior experience with end-to-end implementation of Snowflake cloud data warehouse and end-to-end data warehouse integrations on-premise.
• Expertise in Snowflake - data modelling, ELT using SQL, implementing complex stored procedures and standard DWH and ETL concepts.
• Knowledge in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel, and understand how to use these features.
• Experience with multi-tenant Snowflake architectures and related Snowflake functionality including Organizations and Database Replication.
• Expertise in deploying Snowflake features such as data sharing.
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python.
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling).
• Experience with data security and data access controls and design.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshooting.
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface.
• Troubleshoot problems across infrastructure, platform, and application domains.
• Effectively communicate complex technical concepts, plans, operations, and requirements with executives and management.
• Strong interpersonal skills and ability to communicate clearly and concisely present to all levels within the organization.
• Accustomed to multi-tasking, working under pressure with multiple deadlines.
• Experience working with multiple stakeholders to identify data driven solutions to business problems.
• Ability to approach customer requests with a proactive and consultative manner; listen and understand user requests and needs and effectively deliver.
• Highly motivated, adaptable, innovative, fun and enjoyable to work with!

The Perks:

• Comprehensive medical, dental and vision plans for you and your dependents
• 401(k) Retirement Plan with Employer Match, 529 College Savings Plan, Health Savings Account, Life Insurance, and Long-Term Disability
• Competitive Compensation
• Training and development programs
• Stocked kitchen with snacks and beverages
• Collaborative and cool office culture
• Work-life balance and generous paid time off

***To all recruitment agencies: Trace3 does not accept unsolicited agency resumes/CVs. Please do not forward resumes/CVs to our careers email addresses, Trace3 employees or any other company location. Trace3 is not responsible for any fees related to unsolicited resumes/CVs.