What are the responsibilities and job description for the Data Engineer II position at Allied OneSource?
Are you a data enthusiast with strong SQL skills looking for a new challenge? Join our century-old, where you'll be part of a collaborative team dedicated to innovation and excellence. As a Data Engineer II, you'll have the opportunity to work with a variety of cutting-edge technologies in a supportive, team-oriented environment. Ready to make an impact while working for a company with a proven track record of success? Apply today!
Requirements:
AW
Requirements:
- Bachelor's degree in Engineering, Computer Science, or a related field, or equivalent professional experience.
- Over 3 years of experience designing and implementing processes for data transformation, data structures, metadata management, and workload dependencies.
- Strong proficiency in SQL with at least 3 years of hands-on experience with relational databases, including query writing and working with various database systems.
- Proven experience in handling and processing large, disparate datasets.
- Familiarity with multiple database platforms such as SQL Server, MySQL, PostgreSQL, and AWS services (RedShift, ElasticSearch).
- Expertise in object-oriented and functional programming languages, such as Python, R, Java, C , or Scala, and experience with data modeling and schema documentation to ensure data integrity and accessibility
- Maintain and optimize existing SSIS packages, stored procedures, and ETL processes supporting SSRS.
- Fine-tune and optimize SQL queries for both SQL Server and PostgreSQL to ensure high performance.
- Provide ongoing support for various data integration and transformation tasks.
- Collaborate with cross-functional teams to ensure data accuracy, integrity, and accessibility.
- Opportunity to learn and work with Python, with exposure to MongoDB as part of the data infrastructure.
AW
Salary : $90,000 - $120,000