Data Warehouse Developer | SQL/ETL (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:

As part of the Reporting & Analytics (R&A) team, the Data Warehouse Developer will support development and maintenance of data management solutions using data warehouse technologies. This role will work under the technical guidance of the Senior Data Warehouse Architect to support business analysts and data analysts, to understand the company's data needs and develop plans to integrate and organize data in a secure and accessible way. This individual will write code and create frameworks for databases and will maintain systems for keeping raw data, metadata, and other data assets. The Data Warehouse Developer must have experience as a data/ETL engineer, understanding fully the methodologies behind delivering the right solutions on time, with quality and considering factors including a project’s ROI and financial metrics to determine best practices and deliver solutions. This role is expected to have the skills to back up the Senior Data Warehouse Architect on development and maintenance tasks.

What You’ll Do:

• Support development of database systems for corporate data warehousing and business intelligence
• Monitor database systems and address performance, accuracy, and security issues as they arise
• Develop and test ETL systems to consolidate data from heterogeneous business systems
• Support the development and release processes for database and ETL systems
• Ensure sufficient performance of data transfers and loads, and meet data latency requirements
• Write ad-hoc queries and perform data profiling
• Work with stakeholders and business analysts to understand reporting requirements, and support development of suitable data models
• Create and maintain documentation on standard operation procedures related to the areas of responbilities
• Recommend strategies to improve performance and capacity of tools
• Effectively manage and prioritize tasks
• Approach internal requests in a proactive and consultative manner, and effectively deliver appropriate solution proposals
• Partner with internal technical and business teams such as IT Enterprise Platforms, Application Development, Integration Management Office and Reporting & Analytics teams, and other experts to define optimal integration strategies within existing analytics ecosystems

Qualifications & Interests:.

• Bachelor’s degree in computer science, engineering, mathematics or related fields, or equivalent experience
• 3+ years of work experience with ETL/ELT, Data Modeling, and Data Arc