Data Engineer II

Data Engineer IIThe Data Engineer II delivers a range of modern technology solutions while implementing best practices for key stakeholders across the company. Main responsibilities of the Data Engineer II include the development, maintenance, and optimization of our data pipelines and infrastructure. You will collaborate with cross-functional teams to ensure data availability, reliability, and performance for analytics, reporting, and data science purposes. This role offers an exciting opportunity to work with cutting-edge technologies and contribute to data-driven decision-making within the organization.This role contributes to and may lead project data-related efforts, provides support to business partners, project managers, Scrum Masters, and vendor resources involved in project execution. They will lead development efforts on small to medium projects. They will coordinate and attend meetings as needed. Complete and track action items and deliverables. Attention to detail, organization, communication, and self-initiative are key skills for this role.Minimum RequirementsEducation: Bachelor's Degree or equivalent education and/or work experience preferred.Experience: 3+ years direct work experience in a data engineering, analyst, software development or project management capacity.An understanding of data warehousing and ETL processes.Awareness of common programming languages such as Python, Powershell, Java, or ScalaDemonstrated experience with SQL and relational databases (e.g., MS-SQL)Familiarity with NoSQL databases (e.g., MongoDB, CosmoDB)Awareness of big data technologies and tools (e.g., Hadoop, Spark, Kafka) is a plusTravel: 0-10%Work Schedule: This position works between the hours of 7 AM and 5 PM, Monday- Friday; However, work may be performed at any time on any day of the week to meet business needs.Key ResponsibilitiesDevelops integrations with specific SaaS applications such as; Workday, Salesforce, and ServiceNow.Designs, develops, and maintains data pipelines to efficiently and securely transfer data from various sources to a data mart or lakehouse.Transforms and cleanses raw data into usable formats for analytics, ensuring data accuracy and consistency.Integrates data from multiple sources and platforms, both structured and unstructured, to provide a unified view of data.Administers and optimizes databases to ensure data availability, performance, and security.Implements data quality checks and monitoring to identify and rectify data inconsistencies or anomalies.Works closely with developers, data scientists, analysts, and other stakeholders to understand data requirements and provide support for their data needs.Diagnoses and resolves data-related issues promptly to minimize downtime.Stays up-to-date with industry trends and emerging technologies to recommend and implement improvements in data engineering practices.Maintains comprehensive documentation of data pipelines, configurations, and processes.Coaches, mentors, and motivates project team members and contractors.Ensures that database, integration, and DevSecOps best practices are adhered to and ensure lessons learned are followed.Performs other related duties as required and assigned.The job description and responsibilities described are intended to provide guidelines for job expectations and the employee's ability to perform the position described. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.