Senior, Data Engineer

**About Zone & Co**

Zone & Co is a leading SaaS company committed to freeing finance teams from the limitations of clunky, disparate systems and manual processes. Our rapidly growing portfolio of solutions is built on the oracle NetSuite platform (the leading cloud-based ERP software platform) and offers advanced automation and integration solutions to a wide spectrum of business-critical functions, including complex billing & revenue recognition, to off-the-shelf advanced reporting, Payroll, AP automation, payments, reconciliations, approvals and more.

Zone helps over 3,000 companies worldwide work smarter, faster and more securely, whilst maximizing platform value. We do this with a growing innovation-minded team of over two hundred folks, based across North America, Europe and Asia Pacific.

Our journey has only just begun and we are excited to welcome talented individuals looking to grow alongside us. If this sounds interesting to you, we'd love to hear from you

**About the Job**:
We are seeking a highly skilled Senior Data Engineer to design, build, and optimize our mission-critical data platform, which is fundamentally built on SQL Azure for ZoneReporting. You will be instrumental in developing and maintaining high-performance ELT pipelines and ensuring the speed and reliability of our systems. A core responsibility is owning the orchestration, monitoring, and optimization of these pipelines using Azure Data Factory (ADF). This role requires deep expertise in database development, specifically in writing and tuning complex Stored Procedures for business logic, and managing secure, repeatable schema deployments using DACPAC methodology. Your work will directly enable our customers to unlock the power of their data and drive real business decisions. This position is for an expert in the Microsoft data ecosystem and data architecture who is passionate about building scalable, production-ready solutions.

**Responsibilities**:

- Maintain and Optimize ELT Processes: Provide ongoing support for our existing bespoke ELT (Extract, Load, Transform) pipelines. This includes optimizing data ingestion and transformation jobs to improve performance, reliability, and cost-efficiency.
- Manage Data Warehouse and Analytics Environment: Administer and maintain the current data warehouse, which leverages Azure Data Factory, SQL Azure Databases, and other services. Ensure data quality, consistency, and integrity for reporting and analysis.
- Support Data Visualizations: Collaborate with business intelligence developers and data analysts to support BI dashboards and reports. This includes troubleshooting data-related issues and optimizing data models to ensure data freshness and performance.
- Collaborate with Stakeholders: Work closely with data scientists, data analysts, and business teams to understand their data requirements and translate them into effective, scalable data solutions.

**Qualifications**:

- A Bachelor's degree in Computer Science, Data Science, Information Technology, or a related quantitative field
- At least 3 years of professional experience in a data-centric role, specifically in data engineering and performance optimization.
- SQL Mastery: Expert-level SQL proficiency within the Azure SQL environment, including writing complex Stored Procedures and proven expertise in query performance tuning, execution plan analysis, and indexing strategies on large datasets.
- Azure Tooling: Proven experience designing and deploying ELT solutions using Azure Data Factory (ADF).
- Data Architecture: Deep understanding and hands-on experience with data warehouse design principles, including dimensional modeling (star schemas) and implementing multi-stage architectures (e.g., Bronze, Silver, Gold layers).
- Database Lifecycle: Strong familiarity with database lifecycle management, including schema deployment using DACPAC.
- Troubleshooting: Demonstrated ability to troubleshoot and resolve end-to-end system performance bottlenecks, from the data source to the reporting layer.
- Version Control: Expert knowledge of Git, including advanced branching strategies, pull request workflows, and merge conflict resolution.

**Not Required, but nice to have**:

- Knowledge of NetSuite is a plus, but not required.
- Knowledge of Power BI is a plus, but not required.

**Benefits**: