Skip to main content

OpenArc

In-Demand IT Careers

Data Engineer

Pittsburgh, PA | Fully Remote

Posted: 06/13/2024 Job Category: Database Job Number: 6958

Job Description

OpenArc - Empowering Your Career. As a leading IT staffing firm, we are dedicated to connecting talented professionals with your ideal opportunities. We are currently seeking a qualified Data Engineer to join our client’s organization and contribute to their ongoing success. 

 

Job summary

Plans, designs, develops, and manages an organization's databases to ensure efficient data storage, access, and security. Collaborates with users to design, code, test, debug, and deploy databases that meet requirements and organizational needs. Writes queries, stored procedures and functions for database development. Monitors databases' performance, scalability, and security and modifies procedures to optimize database designs. Evaluates existing database design to determine necessary updates, performance tuning, and integration requirements. Possesses comprehensive knowledge of database technologies and solid coding and computer system skills. 

Responsibilities:

  • Assembling large, complex sets of data that meet non-functional and functional business requirements 
  • Identifying, designing and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes 
  • Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using AWS and SQL technologies 
  • Building analytical tools to utilize the data pipeline, providing actionable insight into key business performance metrics including operational efficiency and customer acquisition 
  • Working with stakeholders including data, design, product and executive teams and assisting them with data-related technical issues 
  • Working with stakeholders including the Executive, Product, Data and Design teams to support their data infrastructure needs while assisting with data-related technical issues
 

Requirements:

  • Proficiency in popular coding languages including Python, PHP and SQL. ? Proficiency in working with database systems like MySQL, PostgreSQL, or Microsoft SQL Server. 
  • Familiarity with databases like MongoDB, Cassandra, or Redis for handling unstructured or semi-structured data. 
  • Ability to design and implement ETL pipelines to move and transform data from source systems to data warehouses. 
  • Ability to identify and address data quality issues during ETL processes. ? Knowledge of tools and practices for documenting and organizing data assets. ? Skill in creating and optimizing database schemas for efficient querying and reporting. 
  • Proficiency in using cloud services for data storage, processing, and management (e.g., Amazon S3, Azure Data Lake, Google BigQuery). 
  • Understanding of real-time data streaming platforms for ingesting and processing continuous data flows. 
  • Skill in using version control systems to manage code and collaborate effectively.
  • Ability to learn quickly and work independently or as part of a team. 

At OpenArc, we prioritize your career success and strive to build exceptional technical teams for our clients. By understanding your experience and aspirations, we ensure to present you with rewarding and fulfilling opportunities. 

 

As an employee of OpenArc and our clients, you will be eligible to participate in a comprehensive benefits package.


OpenArc is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.

 

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.

About Pittsburgh, PA

Unlock your next career adventure in Pittsburgh, Pennsylvania! Nestled between the three rivers, this vibrant city boasts a rich history, thriving arts scene, world-class universities, and a robust job market. From catching a Steelers game at Heinz Field to exploring the Andy Warhol Museum or indulging in a Primanti Bros sandwich, Pittsburgh offers a unique blend of cultural experiences and professional opportunities. Embrace the charm of this dynamic city and discover your dream job among our diverse listings. Join us in the Steel City and elevate your career to new heights!

Take the Next Step