Location: Agoura Hills,CA, USA
A large veterinary client of ours is in need of hiring multiple Azure Data Engineers. In this role, you will be responsible for creating data orchestration with Azure Data Factory/Synapse pipelines and Dataflows (this role requires someone to really understand the business requirements and implement the requirements using Azure Data Factory/Azure Synapse. You will be required to understand the underlying data and flow of data, build simple to complex data pipelines, preparing/analyzing data, and provide insight to the different LOBs this team supports so they know how to make better business decisions, maximize revenue opportunities, etc. You will support the Azure Synapse environment, support defects in production, optimization, etc. This is a 'fix it' type of role where you will also be technically responsible for migrating/moving data from a data lake to a data warehouse. This team needs someone who has fresh ideas and will be encouraged to make recommendations to improve the environment and provide insight to stakeholders. In addition, this team specifically supports data that is coming in from their General Practice LOB. Look at code and move pipelines around. We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal. com. To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: .
- 5+ years of overall Data Engineering/development experience - Expert-level knowledge on Azure Data Factory or Azure Synapse pipelines (*must know Synapse AND ADF data flow activities) - Advanced knowledge of Azure SQL DB & Synapse Analytics, SSIS, T-SQL, and Logic Apps - Proven ability to analyze and understand complex data - Knowledge of Azure data lake is required - Knowledge of Azure Services such as: Analysis Service, SQL Databases, and CI/CD is a must - Azure DevOps experience -- must know how to use DevOps (no configuration or administration experience is required) - Knowledge of Databricks - Experience with Python - Broad experience when it comes to ETL/ELT data pipelines - Knowledge of master data management, data warehousing and business intelligence architecture - Excellent knowledge of SQL Server best practices - Should have clear understanding of Data Warehouse lifecycle and contribute in preparing design documents, Unit Test plans, and code review reports - Excellent interpersonal/communication skills (both oral/written) with the ability to communicate at various levels with clarity and precision