Job Details

Lead Data Engineer

Fort Wayne, IN | Full time

Job ID:

0207-001LDE

Duration:

Long Term

Experience:

5-7 years

Career Level:

Managerial

Compensation:

DOE

Industry:

Logistics and Supply Chain

Job Description

  • Developing database solutions to store and retrieve information
  • Migrating data from legacy systems to new solutions
  • Designing conceptual, logical data models, and flowcharts
  • Improve system performance by conducting tests, troubleshooting, and integrating new elements
  • Completing product pricing updates and maintenance for Sales Team
  • Analyzing large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency
  • Capturing and analyze database activity to identify improvements in indexing, file structure, maintenance processes, and query performance
  • Conducting periodic assessments of security, backup/recovery, performance, load, and stress testing
  • Creating a product database and integrate live feeds from suppliers
  • Developing and maintaining system architecture and support documents
  • Understanding and querying disparate database sources, including relational structures, dimensional data marts/models and cubes
  • Reviewing and ensuring data security standards are implemented, including role-based security, encryption, tokenization, and obfuscation.

Requirements and Preferred Skills:

  • 5+ years of data engineering/data architecture experience
  • Comfort in a fast-paced startup environment
  • Analytical mind, critical thinker, problem-solver and experience working with large complex data sets
  • Excellent communication skills
  • In-depth understanding of database structure principles and experience with data modeling, large-scale batch, and real-time data processing, ETL design, implementation, and maintenance
  • Advanced PHP knowledge
  • Extreme preference for those with an understanding of large SKU-count e-commerce platforms with faceted search
  • SQL Server that runs on AWS
  • Project Samples: Must provide 3 samples of code upon applying
  • Need 200-300 lines of sample T-SQL code, procedures, functions, etc
  • AWS Certifications - AWS Certified Big Data Specialty desired
  • Experience with cloud platforms (AWS, Azure), including readiness, provisioning, security, and governance preferred (but not required)
  • Data Warehousing solutions and in-depth knowledge of database architecture
  • 5+ years min experience with AWS (S3, EC2, etc.)
  • Proficient in Excel, including VBAs and advanced functions