Job Description
We are looking for a Data Engineer with a focus in Relational Databases. The candidate is expected to be operating under the guidance e of The ech Lead. However, he is expected to be self-starter and operate with an ownership mentality, and interface with other teams. Candidate must be familiar with Agile Software Delivery Practice. This role is in Pittsburgh, PA, HYBRID.
Skills and Qualifications
- Good knowledge of Relational Model, Dimensional Data Modeling, and Data Warehouse
- Advanced working SQL knowledge and performance tuning
- Experience working with relational databases, forex, ample Oracle, and Vertica; familiar with Database objects like Indexes, Views, Synonyms
- Hands-on experience in database programming and design using PL/SQL, Stored Procedures, Functions, Triggers, and Views, using Oracle 12c or better
- Knowledge of ETL, experience in related programming, Java, Python, etc
- Unix/Linux and Scripting, Bash, Python, etc
- Experience using version control and DevOps tools like Git, Jenkins, etc.
- Comfortable working with large, complex datasets, performs data analysis required to troubleshoot data data-related uses
- Experience in Reference/Master Data is a plus
- Knowledge of data security is a plus
- A logical thinker with demonstrably strong analytical skills
- Good written and verbal communication skills contribute to engineering wiki and documents work
- Establishes good working relationships with peers and teams
- 5+ years of experience in architecture in a data engineer role. Master's or Bachelor's degree in Computer Science