Data Engineer

at DLL
Location Wayne, Pennsylvania
Date Posted July 31, 2022
Category Engineering
Job Type Not Specified

Description

Data Engineer

DLL is not your average financial services company. In fact, we are above average in almost every way. With an employee engagement score of 85% (compared to the 72% industry average), it sure seems like we are doing something right. And, while most companies survive fewer than 20 years, 2019 marked our 50th.

We collaborate with manufacturers, suppliers, and businesses in more than 30 countries to enable the acquisition of equipment, technology and software that companies need to contribute meaningfully to their communities. We believe in partnering with our customers to develop innovative and sustainable financial solutions that deliver meaningful value to the world.

At DLL, we are committed to making sure that all people, regardless of their race, ethnicity, gender, sexual orientation, age, religion, physical characteristics, or mental abilities, feel welcomed and encouraged to be their authentic selves. We strive to create an inclusive environment that is reflective of the communities in which we operate. Come see what all the excitement is about.

Day to day

Responsible for maintaining production applications within the Data Management Domain of DLL including the reporting and Datawarehouse environments, both cloud and on-premise. Responsible for Data DEVOPS including development and implementation to ensure production applications are available as defined by the SLA s. Responsible for project delivery work related to applications within the Business Intelligence Domain of DLL.

Duties and Responsibilities

  • Ensure Data DEVOPS is followed using Agile methodology, providing full system lifecycle for data components.
  • Create traceability from fix recommendation generation through to Test Case execution.
  • Ensure that analysis is compliant with IT standards and requirements
  • Testing activities validate quality and alignment to requirements
  • Identify opportunities for software improvement
  • Ensure delivery of deliverables are on time, on budget and on quality
  • Ensure that all deliverables comply with the boundaries set by enterprise architecture and by security and compliance.
  • Ensure applicable audit actions are managed and fulfilled in a timely manner
  • Support and when necessary, execute Link and SIT testing activities
  • Ensure the development and introduction of changes to existing systems, is in line with functional requirement.
  • Ensure the execution of changes, is in line with change requests or because of technical necessity.
  • Ensure the execution of the technical deployment activities is in line with defined process.

"We not only live up to the expectations of our customers for today, but also anticipate their market needs of tomorrow."

Essentials

  • Possess a broad range of knowledge in support of multiple applications within a production support environment including Azure, Azure Data Factory, SQLServer, Oracle SQL
  • Technical Skills including some of the following:
    • Azure Data Factory
    • SQL Server
    • Database script generation and formalization
    • Database design, modifications, and improvements for transactional systems
    • Data normalization/denormalization
    • Design and modification of Advanced queries, Triggers, Stored procedures (Oracle & SQLServer)
    • Performance Testing (Database Performance tuning for real-time service calls, tuning of Conversion process)
    • Experience working with cloud base data repositories
    • ETL Knowledge, mapping, troubleshooting. Azure Data Factory and Microsoft SQL Server Integration Services (SSIS) preferred.
    • Knowledge of other ORM Frameworks is acceptable
    • Knowledge of alternative SQL, general understanding and the ability to write queries
  • Experience in a role that supports complex production applications
  • Solid understanding of the SDLC and various development efforts such as debugging and unit testing
  • Knowledge in SQL tuning and performance monitoring
  • Knowledge of or experience with Star/Snowflake Schema and working with Data Warehouses/marts
  • Experience writing technical design documents, or documenting implementations
  • Strong Interpersonal skills in areas such as teamwork, facilitation, communication, and negotiation.
  • Excellent written and verbal communication skills, especially within the IT community
  • Excellent planning and organizational skills
    • Quality driven and results oriented and ready to go above and beyond to deliver results

Education and Other Credentials

    • Minimum proven bachelor s degree or equivalent work experience
    • Physical Requirements and Working Conditions
    • Substantial experience in the defined required technology area.
      • Excellent customer Service skills
      • Must have the ability to communicate, both orally and written, with other members of the team and with clients / prospective clients.
      • Able to work in a very fast-paced open environment
      • Must be able to demonstrate a high degree of attention and quality, details, correctness, and deadlines.
      • Must have the proven ability to handle and organize multiple projects and deadlines.
    • Fluent speaking and writing in English

      Skills - Nice to Have

      • Experience with Delta Lake, DataVault2.0 and other modern data architectures
      • Experience with Data Streaming technologies

Settling in

Drop files here browse files ...