Title: Data Engineer III  

Location: Remote in these states: AZ, CA, CO, FL, GA, KS, KY, IA, ID, IL, IN, MA, ME, MI, MN, MO, NC, NH, NJ, NV, NY, OH, OR, PA, RI, SC, SD, TN, TX, UT, VA, VT, WA, WI 

Role Description: 

The role of a Data Engineer III in Finance and Accounting at ShipBob involves a multifaceted set of responsibilities aimed at enhancing and maintaining the integrity, accuracy, and accessibility of financial data within the company.  

As a senior member of the team, you will: 

• Data Warehouse Management: You'll play a crucial role in managing and optimizing the data warehouse system. This includes ensuring its performance, reliability, and scalability to meet the needs of the accounting and finance teams. You'll be responsible for the integration of various data sources into the warehouse, maintaining the data pipeline, and ensuring that the data is up-to-date and accurate. 
• Supporting Financial Operations: You will assist the accounting and finance teams in their daily operations by providing them with the data they need to perform tasks such as financial analysis, budgeting, and forecasting. Your role will be critical in closing the books at various intervals, including monthly, quarterly, and annually, ensuring that financial reporting deadlines are met with accuracy and efficiency. 
• Data Quality and Improvement: A significant part of your job will involve identifying and implementing improvements in the data collection, storage, and retrieval processes. You'll work to enhance the quality of the data in the warehouse, making it more accessible and useful for the finance and accounting teams. This may involve developing new reports or improving existing ones, optimizing data models, and ensuring data consistency across the organization. 
• Collaboration and Communication: You'll collaborate closely with team members within the finance and accounting departments to understand their data requirements and challenges. This will involve translating complex financial concepts and needs into technical solutions, as well as explaining data-related issues in a way that non-technical staff can understand. 
• Innovation and Automation: You will identify opportunities for automating manual processes within the finance and accounting workflows, leveraging your technical skills to create solutions that streamline operations, reduce errors, and improve efficiency. 
• Regulatory Compliance and Security: Ensuring compliance with financial regulations and maintaining the security of financial data will be an essential aspect of your role. You'll implement and maintain data governance practices to protect sensitive information and comply with relevant laws and standards. 
• Staying Current: As a senior data engineer, you'll need to keep up with the ever evolving productions system.  Learn what changes necessitate updates to the Data Warehouse and the ETL process that moves data there.   

What you’ll do: 

• Focus on growing as an data engineer in an Azure SQL environment. 
• Performing SQL programming and performance tuning. 
• Capable of taking well-defined sub-tasks and completing these tasks. 
• Creating Power BI visualizations and paginated reports. 
• Modeling and implementing databases and warehouses.  
• Effective in communicating status to the team. 
• Exhibits ShipBob’s core values, focuses on understanding and living these values. 
• Accepts feedback graciously and learns from everything they do. 
• Other duties/responsibilities as necessary. 

What you’ll bring to the table: 

• 6-9 years of experience. 
• Excellent problem-solving skills. 
• Excellent SQL skills. 
• Excellent communication skills. 
• Performance oriented mindset. 
• Ability to work quickly and collaboratively in a fast-paced, entrepreneurial environment. 
• Experience in the following: 

• • SQL 
  • Performance Tuning and Optimization 
  • Data Modeling 
  • Azure SQL Administration, including Security 
  • Powershell 
  • Azure Data Factory 

• Nice to have: 
  • Power BI 
  • Ability to own small well scoped projects and implement them 
  • Experience in Azure Synapse and Cosmos 
  • A passion for databases and an understanding that solutions you implement will affect our entire suite of applications 
  • Experience with big data 
  • Experience with Azure DevOps 
  • Experience with Git 
  • Experience with Agile 
  • Experience with Azure DevOps 
  • Experience with Azure Functions 
  • Mongo Atlas experience 
  • Spark 

Classification: Exempt 

Reports to:  Manager, Database Administration 

Perks & Benefits: 

• Medical, Dental, Vision & Basic Life Insurance 
• Paid Maternity/Parental Leave Program 
• Flexible Time Off Program 
• Paid Sick Leave and Paid Emergency Leave 
• Floating Holidays (2 days/year) 
• Wellness Days (1 day/quarter) 
• 401K Match  
• Competitive Salary, Performance Bonus & Equity 
• Variety of voluntary benefits, such as, short term disability 
• Referral Bonus Program 
• Fun Culture >>> Check us out on Instagram (@lifeatshipbob) 

ShipBob believes in transparency while providing a competitive total compensation package with a pay for performance approach. The expected base pay range for this position is $119,060 - $198,433. 

Classification: Exempt 

Reports to:  Manager, Database Administration