Senior Azure Data Engineer

Empresa: SnapAV
Tipo de empleo: A tiempo completo

Established in 2005 and based in Charlotte, North Carolina, Snap One is a manufacturer and exclusive source of A/V, security, control, networking, and remote management products for professional integrators. An industry leader in the pro-install channel, Snap One helps integrators build their businesses by providing a wide range of high-quality products, easily accessible through an intuitive website and backed by award-winning service and support. With a vast catalogue of today’s most popular brands, Snap One is the premier choice for professional installers across the globe. With 28 pro stores in the US, Snap One blends the benefits of ecommerce with the convenience of local stores. Additional information about Snap One and its products can be found at .
The Senior Data Engineer will report to the Data Services Director and will be responsible for leading and contributing to SnapAV’s cloud-focused engineering teams to deliver end-to-end cloud transformation. This challenging role requires senior knowledge and experience across many facets of cloud technology: application development, hybrid environments / connectivity, and modern data services, while understanding the governance, security, monitoring and cost management aspects of the entire ecosystem.
The successful candidate will be responsible for the engineering and sustainment of the SQL Server based solutions, ensuring its operational readiness (security, health and performance), executing data extract, transformations, and loads, and performing data modeling in support of SnapAV’s various application development and data management teams.
Implement modern data solutions with Azure Data Factory, Data Lake, Data Bricks, SQL Server, and Azure Synapse
Support data migrations from SQL and open source repositories into modern Azure data services
Understand a broad spectrum of technology in order to provide detailed technical design
Provide technical leadership for on-premises to cloud solutioning, cost estimating and working with Director on modernization strategy
Design and development the Enterprise Data Warehouse ecosystem
Assist other team members and business insiders with complex query tuning and schema refinement
Perform occasional scheduled after-hours tasks related to maintenance or release deployments after-hours support for critical production systems
Refine and automate regular processes, tracks issues, and documents changes
Collaborate with Data Engineers on data collection, data quality, and ETL projects feeding into the Enterprise Data Warehouse
 Required Qualifications:
Bachelor’s Degree in Information Systems, Data Management, or Computer Science with 5+ years’ experience of IT solution delivery experience; OR  8+ years of relevant IT solution delivery experience
3+ years delivering and leading solutions on the Microsoft Azure platform with a focus on data solutions and services
Applicable knowledge of principles summarized in the Microsoft Cloud Adoption Framework
Experience developing software architectures and key software components
Experience with IaaS and PaaS capabilities on cloud platforms
Experience with on prem SQL Server stack (SSIS, SSAS)
Working knowledge of Azure Monitor, Application Insights, Cost Management or equivalent tooling
Preferred Qualifications:
Familiarity with SQL Server Reporting Services and/or Power BI
Experience managing and querying data in data lakes and/or cloud data repositories, such as, the following:ADLS
Google Big Query
Amazon Redshift
Experience with data replication tools, such as, HVR, Striim or Attunity
Familiarity with Azure Analysis Services and Azure Databricks
Azure certifications
Snap One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, or protected veteran status and will not be discriminated against on the basis of disability.