Data Engineer

The Data Engineer role is responsible for developing and scaling end-to-end data and analytics solutions that enable self-service and analytics efforts. This role will work with key business partners across the organization to understand business problems and translate them into automated processes and functional data resources., * Create and maintain optimal data pipeline architecture.

• Assemble large, complex data sets that meet functional requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL.
• Create Power Platform objects for data insert and data consumption.
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Keep our data separated and secure across boundaries through multiple databases, servers, data centers, and Azure regions.
• Create data tools for analytics and support the data architect.
• Build processes supporting data transformation, data structures, metadata, dependency, and workload management.

• 5+ years in Data Engineer or similar role
• A Bachelor’s Degree in CS, Information Systems, a related field or equivalent work experience
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
• Strong analytic skills related to working with unstructured datasets.
• Strong project management and organizational skills.
• Experience supporting and working with cross-functional teams in a dynamic environment.
• Experience with Power BI, Power Automate and Power Platform tools.

Physical Demands and Working Environment:

The conditions herein are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential job functions.

Environment: Work is performed primarily in a standard office environment with extensive public contact and frequent interruptions.

Physical: Primary functions require sufficient physical ability and mobility to work in an office setting; to stand or sit for prolonged periods of time; to occasionally stoop, bend, kneel, crouch, reach, and twist; to lift, carry, push, and/or pull light to moderate amounts of weight 50 lbs; to operate office equipment requiring repetitive hand movement and fine coordination including use of a computer keyboard; to travel to other locations using various modes of private and commercial transportation; and to verbally communicate to exchange information.