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!
Learn more at www.zoneandco.com or follow us on LinkedIn: linkedin.com/company/zoneandco.
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.
- Troubleshoot and Resolve Issues: Act as a subject matter expert for the existing data infrastructure. Troubleshoot and resolve complex technical issues related to Azure Data Factory, SQL Azure, and data pipelines.
- 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.
- All resumes and applications must be submitted in English
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
At Zone, our benefits are designed to enrich your life beyond the workplace. Recognizing that work is just a fraction of your overall life experience, we are dedicated to providing robust support. As a fully remote company, we prioritize flexibility and balance. Explore our comprehensive list of benefits at Zoneandco.com.
Zone and Co is an Equal Opportunity Employer committed to diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, age, national origin, disability, protected veteran status, gender identity, or any other factor protected by applicable federal, state, or local laws.We strongly encourage candidates of all different backgrounds and identities to apply. This is an opportunity for us to bring in a different perspective and we’re eager to further diversify our company. Zone & Co is committed to building an equitable, inclusive, and supportive place for you to do some of the greatest work of your career.
Create a Job Alert
Interested in building your career at Zone & Co? Get future opportunities sent straight to your email.
Apply for this job
*
indicates a required field