Developer ii – data warehouse & etl
Summary:
The developer ii – data warehouse & etl will be responsible for supporting the architecture, design and implementation of quaker houghton’s data warehouse/business intelligence/etl ecosystemThis 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 usersThe 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 businessThis 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 needsThis 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 neededMaintain 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 policiesReport 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 motivationNormally 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 lawHoughton international will also provide reasonable accommodations for qualified individuals with disabilitiesThis employer participates in the federal e-verify program to confirm the identity and employment authorization of all newly hired employeesFor 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 classificationThey are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees assigned to this position.
