The Data Engineer assists in developing and maintaining the database architecture and data processing systems. Works in partnership with finance and operations to communicate results that help make business decisions. Team is remote out of Wilmington DE and King of Prussia PA areas. Occasional in-person meetings required.
Job Duties
This position is responsible for performing the following duties:
Identifying, designing, and implementing internal process improvements including re-designing infrastructure for greater scalability, optimizing data delivery, and automating manual processes
Building required infrastructure for optimal extraction, transformation and loading of data from various data sources using SQL and SQL Server Integration Services Packages
Searching through and organizing large data sets to provide viable data structures for reporting and analysis
Working with stakeholders including accounting, operations, and executive teams and assisting them with data-related technical issues
Requirements
Position Requirements
Bachelor's from four-year college or university in a related field.
2+ years of relevant experience. A combination of education and relevant experience will be considered.
Strong command of T-SQL and SQL Server
Familiarity with a wide variety of data sources, including databases and big data platforms, as well as public or private APIs and standard data formats, like JSON and XML
Proficiency in Excel and Visual Studio are a must
Power BI a plus
Knowledge of C# a plus
Comfortable working with accounting and financial data