Sorry, this job is no longer available.

(Loading More Opportunities)

Data Warehouse and ETL Developer II

Developer II Data Warehouse & ETL

Summary:

The Developer II Data Warehouse & ETL will be responsible for supporting the architecture, design and implementation of Quaker Houghtons Data Warehouse/Business Intelligence/ETL ecosystem. This position presents the opportunity to work in a strategically important and fast paced team that supports the data and business intelligence needs of both corporate and field users. The Developer II will be responsible for supporting the data infrastructure and administration of several data warehouse systems that deliver data-driven and actionable insights to the business. This includes design, development, and implementation of new data models, as well as the associated ETL/ELT, along with operational and troubleshooting support.

Specifically, the Developer II will be responsible for designing, developing, implementing and maintaining scaled, automated, user-friendly systems that support data warehousing, business intelligence, and reporting and analytic needs. This role will help shape the direction of business reporting and ensure DW/ETL/DevOps best practices and resources are effectively used throughout the organization.

Responsibilities:

  • Build and debug complex SQL queries and optimize performance of queries using database tools
  • Build ETL (Extracting, Transforming and Load) solutions to support key business data and data warehouse requirements using data integration tools
  • Configures and tunes ETL infrastructure to optimize the data warehousing architecture
  • Develop subject-specific data marts using star schema design to optimize end user BI performance.
  • Create technical documents with source to target mapping including detailed transformational logics
  • Schedule ETL jobs based on the completion of the source systems, and establish controls and reconciliation process to check the data load between source and targets
  • Provide consulting support on all organization data-related solutions (program design, report design, data feed design, data aggregation, etc)
  • Participate in the development and implementation of evolving data warehouse practices, tools and processes including JSON and non-relational data, text data analysis and NLP, real time data integration, geospatial information, IOT data traffic
  • Create database objects, normalize tables as needed. Maintain the database referential integrity.
  • Enforce industry/company naming conventions & standards for database objects, reports, file names, etc.
  • Monitor production jobs, report and processes, and make sure they are completed on-time
  • Design and build relational and analytical database schemas and architectures based on best practices and customer requirements/needs
  • Create indexes, keys, joins appropriately to ensure best performance
  • Perform and document audits regularly according to company policies. Report findings to management.
  • Correct the audit findings in a timely manner and complete necessary documentations
  • Attend to user issues on-time and resolve issues as per the established SLA
  • Participates in requirements definition, solution development and the implementation phases of data warehouse and reporting projects
  • Proactive ability to process large amounts of data into meaningful results to meet reporting needs and ad hoc requests
  • Other duties as assigned or as business needs require.

Requirements:

  • 3+ years experience in designing, developing, testing and implementation of data warehouse solutions
  • 3+ years solid hands-on experience in database development & SQL programming experience (stored procedures, views, triggers) using MS SQL Server and/or Azure cloud-based databases
  • 3+ years experience in ETL development (Extract Transformation & Load) using one or more ETL tools like Informatica, MS SQL Server SSIS, Azure Data Factory, Matillion, Boomi, etc.
  • 2+ years experience in data warehouse architecture, dimensional modeling, design principles and best practices
  • Experience with Azure Services including Azure Data Factory, Azure Key Vault, Logic Functions, and Application Insights a plus
  • JSON, R, Python - exposure to competent a plus
  • Must be self-motivated, team oriented and able to operate with minimal supervision
  • High level of intellectual curiosity with strong desire to deepen knowledge
  • Have a clear project orientation with experience in delivering solutions under very tight timelines, on time and to specification
  • Accountable for service commitments for in scope applications and requests
  • Demonstrates good judgment in selecting methods and techniques for obtaining solutions.
  • Networks with senior internal and external personnel in own area of expertise.
  • Excellent communication and interpersonal skills
  • Self-initiative and results-oriented motivation. Normally receives little instruction on day-to-day work, general instructions on new assignments.

 

EEO STATEMENT: It is Quaker Houghton's policy to provide equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. Houghton International will also provide reasonable accommodations for qualified individuals with disabilities. This employer participates in the federal E-Verify program to confirm the identity and employment authorization of all newly hired employees. For further information about the E-Verify program, please click here:http://www.uscis.gov/e-verify/employees

DISCLAIMER: The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position.

 

Company
Quaker Houghton
Posted
09/16/2021
Salary Range
$68,000.00 - 97,000.00
per Year
Salary range estimated by
Location
Conshohocken, PA 19428, US