Job Type
Full-time
Description
Department: IT Development
Reports to: Director of Technical Programs
Location: Hybrid - Dublin, Ohio (3 days) Remote (2 days)
Full-time, Non-Exempt
Why T-CETRA?
We're constantly developing new and creative ways to solve the industry's most complex problems. Our enterprise software solutions run the gamut of Information Technology Services-from payment processing, to prepaid wireless activations, to mobile and web app development. For the past 10+ years our originality attracts the most outstanding and innovative thinkers- allowing us to develop new and creative approaches while growing as the industry leader. Are you a passionate professional, ready to make changes in the tech world? Join our team today.
About the Job As a Lead Data Engineer at T-CETRA, you'll play a pivotal role in designing and developing data warehousing and integration projects. Collaborate with cross-functional teams to maintain data integrity and drive innovation.
What You'll Do: - Apply advanced technical concepts to develop data warehousing and integration projects.
- Write high-quality, performant code that adheres to company guidelines and industry best practices.
- Apply business and domain knowledge to develop a deeper understanding of the system and contribute to effective solutions.
- Ensure applications meet functional and non-functional requirements by actively participating in testing efforts and enforcing quality standards
- Design and maintain accurate data models to meet business requirements.
- Develop extensible integration workflows connecting internal applications.
- Collaborate with application development teams to ensure data integrity.
- Participate in refining project requirements with stakeholders.
- Participate in team processes for planning, tracking work, and continuous improvement.
- Oversee deployments and support projects post-release.
- Recommend practices to enhance quality and productivity.
- Review and approve changes to models and code.
- Stay updated with emerging technologies and industry trends.
- Evaluate frameworks, technology, platforms, and tooling solutions.
Requirements
Must Have: - 7+ years experience supporting highly available, scalable data systems.
- 5+ years experience in relational database design and optimization (MS SQL, PostgreSQL, MySQL, etc).
- 5+ years experience with OLAP and OLTP Data Platforms.
- 2+ years of experience with DBT
- 5+ years of experience with AWS ETL and OLAP technologies (Redshift, Glue, Step Functions, Lambda, DMS, MSK, etc)
- Experience integrating with various systems and platforms.
- Proficiency with Data Warehousing solutions.
- Proficiency in at least one major programming language.
- Strong problem-solving and organizational skills.
Great To Have: - Detail-oriented and highly organized with the ability to work collaboratively in a flat, inter-disciplinary organization structure.
- Self-starter, ownership attitudes and ability to work with little supervision with a bias for action.
- Solid experience with the suite of products
Blow Us Away: - Experience writing data pipelines using Python or similar language.
- Experience with Apache Airflow.
- Experience with iPaaS Solutions (Dell Boomi, Adeptia, etc.).
- Experience integrating with ERP Systems, Salesforce, or Tableau.
- Experience with Docker, Redis, and CI/CD Pipelines.
Why Should You Apply: - Paid Time Off
- Comprehensive Medical, Vision and Dental
- Matching 401k up to 4%
- FMLA and Life Insurance
- Tuition Reimbursement
- Wellness Program
- Employee Growth and Development Reimbursement Program
- Discounted Rates for Multiple Handsets and Prepaid Wireless Rates
- Beautiful nearby walking paths and park
- Fun, value centered work atmosphere
- Flexible work environment
T-CETRA provides employment and opportunities for advancement, compensation, training, and growth according to individual merit, without regard to race, color, religion, sex (including pregnancy), national origin, sexual orientation, gender identity, marital status, age, genetic information, disability, veteran-status, or any other characteristic protected under applicable Federal, state, or local law. Our goal is for each staff member to have the opportunity to grow to the limits of their abilities and to achieve personal and organizational objectives. We will support positive programs for equal treatment of all staff and full utilization of all qualified employees at all levels within T-CETRA. To create a safe and positive environment for employees, all applicants must perform a pre-employment drug screen and background check.?
Salary Description
125,000 - 145,000