Data Engineer
LOCATION: Remote/NYC | FULL-TIME | BENEFITS: 401k match, Dental, Vision, Unlimited PTO
Description
We are looking for a Data Engineer who will work simultaneously with our business intelligence teams who will be responsible for database activities centered around delivering/building impactful solutions and improving our database systems. This is a multi-faceted role that includes technical analysis, design, development, testing and maintenance as well as user interaction including requirements gathering, training, etc. This role will work on on-premise SQL data warehouse platform and helping to build out the data platform of the future in Azure.
Description:
Build out and migrate to cloud data technologies, which may include Azure Data Lake, Azure SQL Pools, Apache Spark, Synapse
SQL Server Database development work including tables, views, stored procedures and functions. SSIS development for ETL processes
Performance tuning and testing of BI structures
Participation in the design of data models
Collaborate with BI Team members
Collaborate on requirements definition, design and build out of key data warehousing and integration deliverables for Supply Chain, Brand Insights, Digital, Sales and other areas
SQL scripting to perform essential data maintenance functions including reclassifications, some master data setup and more
Data preparation and modeling using the Power BI platform as well as Analysis Services-Tabular
Maintenance and extension of our SQL server jobs and Azure PowerShell runbooks for update of our SQL and Azure environments
Requirements
• Three to five years of hands-on experience with database management.
• Microsoft SQL Server, Azure data technologies, Power BI training Required
• Hands-on experience with data visualization tools (DataRobot, SnowFlake & Domo)
• 3+ years hands-on development experience with SQL Server, SSIS
• Powershell experience a must
• Python scripting a plus
• Analytical thinker with excellent problem-solving skills
• Ability to meet deadlines.
