Sr. Data Engineer

At Echo, we foster a culture that promotes continuous learning, innovation, and personal development. Apply today and grow with Echo!
Echo Global Logistics is a leading provider of technology-enabled transportation management services. As a third-party logistics provider, we simplify transportation management for our clients and carriers, handling crucial tasks so they can focus on what they do best. From coast to coast, dock to dock, and across all major transportation modes, Echo connects businesses that need to ship their products with carriers who transport goods quickly, securely, and cost-effectively.
Position Purpose:
The Senior Data Engineer contributes and leads the design, development, integrations, and management of Echo's large scale data solutions while supporting the strategic architectural vision of quality, scalability, performance, and function.
Duties and Responsibilities

• Lead and owns data design, coding, testing, and development of on-premise and off-premise extensible, sustainable, quality value driven data solutions based on an understanding of business and customer requirements and needs.
• Collaborate with teams on product design, data modelling, technical diagrams, updates to the data dictionary, creation of standards, code reviews for efficient and optimal running queries and work directly with stakeholders to support and solve complex challenges.
• Exhibits comprehensive, methodical engineering judgment, and effectively manages trade-offs among data volumes, number of users logical and physical distribution, response times, retention rules, security, and domain controls.
• Lead in the research, evaluation and building Atomicity, Consistency, Isolation, Durability (ACID) data solutions.
• Automate, simplify, implement, and continuously improve the data environments and processes.
• Commands a broad awareness of technologies and industry trends related to data and Cloud technologies.

• Hands-on contributor that teaches by example and mentors others on best practices and technical acumen.

• Open to new ideas and encourages innovative practices.
• Acts in the interest of the overall team.
• Balances best practice decisions with delivering high business value (right vs right now).
• Able to multi-task in a fast paced, fluid work environment.
• Customer focus and value driven.

.
Position Requirements:

• Bachelor's Degree in computer science or equivalent years of experience.
• 5- 8 years working with commercial-grade database systems and technical experience leveraging the following:
  o Microsoft SQL Server 2012 - 2019.
  o Solid T-SQL, SSIS, SSRS, ETL/ELT, data structures and data flows, logical and physical data modeling, stored procedures, schema design, security, backup/recovery, and data integrity skills.
  o Working knowledge of serverlesslambdas in PythonC#Node.js and .Net frameworks.
  o Experience with AuroraRedshift, S3, API Gateway and good understanding of IAMSecurity, VPC, peering in a context of building near real time data driven applications.
• Proficient in performance tuning, troubleshooting and resolution knowledge including root cause analysis (RCA).
• Object Oriented programming - Inheritance, Encapsulation, Polymorphism, and Data abstraction.
• Proficient in implementing and supporting High-Availability and Disaster Recovery for data solutions
• Aware of ScrumAgile methodologies and Continuous Delivery and Integrations CD/CI.
• Solid experience with Cloud data technologies specific to AWS (DynamoDB, Aurora, Redshift, RDS) and NoSQL.
• Solid understanding of event stream processing (Kafka, RabbitMQ, Kinesis).
• Experience and ability to work with multiple database platforms besides SQL Server.
• Experience with Visual Studio development tools.
• Strong planning and organizational skills; excellent verbal and written communication skills; able to present clean, organized, and thorough information and data appropriate for intended audience.
• Cloud Certification - Preference is AWS Certified Cloud Practitioner or other Cloud focus.
• 24/7 Support on-call rotation.
• Informatica and Master Data Management (MDM) is a plus.
• Google Looker platform is a plus.

What's in it for you?

• Help career growth by joining industry leader and established teams with newly integrated and focused User Experience process
• Working with an organization with defined market goals, products, customers, revenue, and collaborative teams
• Experienced mentors to learn and adopt new practices
• Ability to introduce your own views and takes on the products

Work environment/physical demands summary:
This job operates in an office environment and uses a computer, telephone and other office equipment as needed to perform duties. The noise level in the work environment is typical of
that of an office with an open seating floor plan. The employee may encounter frequent interruptions throughout the work day. The employee is regularly required to sit, talk, or hear.
All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, status as a qualified individual with a disability, or Vietnam era or other protected veteran.