Greater Pittsburgh Area, PA 15222
We are looking for a data engineer to help us build our data pipeline, data warehouse and technical data structures across the data landscape.
Partner with the product and engineering teams to develop scalable, extensible data solutions for data transformation, movement, and manipulation
Normalize transactional data, disparate systems, and transfer of data in a way that creates flexible and scalable data solutions
Build applications and scripts for specialized data processes to acquire, manipulate, and supply data to systems for various purposes
Understand master data elements to be used when joining datasets and creating data maps
Creates processes and data management systems including manual and automated processes, such as cleansing and maintaining master data sets
Build automated fault-tolerant processes to acquire and cleanse data routinely
Develop new dimensional data models where highly complex data relationships and data flows exist
Design and maintain data pipelines to simplify end user reporting and analytics
Maintain the security, data integrity, and availability of data in the data warehouses and data hubs
Build and maintain data pipelines between 1st- and 3rd-party products and the data warehouse used for company-wide analytics
Collaborate with all teams across the company to ingest data and apply appropriate business logic
Uses existing data assets to build new datasets for the purpose of gaining new insights
Bachelor’s degree in Computer Science or related field
Experience with writing SQL scripts and Python or Ruby apps for purposes of data manipulation
Experience and background in building data platforms
Knowledge of EasyMorph or Alteryx preferred
Experience with data architecture/design
Software development with deep experience in Object-Oriented, Functional, Object-Functional Language and one of the major SQL relational datastores
To learn about benefits and perks apply online!
"Whether you are looking to fill or looking to advance your career, I would strongly suggest speaking to Scott and his team at OpenArc. Scott and his team provided a consultative and hands on approach throughout the entire process in my recent transition. Their unique approach was unlike anything I've experienced either as a candidate or a hiring manager,"-Mark Quinn, Service Sales Executive at Siemens Medical Solutions, USA, Inc.
"Working with OpenArc was a great experience. The position I accepted was accurately described and my questions on benefits, paid time-off, and holidays and more were promptly answered. The entire OpenArc team was a very professional and to the point. I highly recommended OpenArc to all of my peers."- Lisa McLaughlin, Executive Director, ACAPT