Insight Global
Staff Data Engineer II - Azure Data Factory
Insight Global, Phoenix, Arizona, United States, 85003
Job Description
As the Staff Data Engineer II, you are critical engineer in a continuous delivery team dedicated to providing integrated data flows, data warehousing and analytic ecosystem across our Western Alliance Bank business lines. You are the technical expert in a high-performing centralized team of data engineers, data analysts and QA engineers. You champion data quality and discipline in the full data lifecycle. You must demonstrate strong technical mastery as well as an ability to collaborate and communicate with both technical team members and business stakeholders. You partner closely with enterprise architects to understand and implement solutions based on the recommended Azure Cloud data architecture and capabilities. You are required to know and/or learn modern automation and integration methods and tools, with Cloud-First design patterns, frameworks, critical thinking, and problem-solving skills. Being knowledgeable and up to date in the data integration and analytics trends in the industry is a differentiator in your role
Implement data engineering solutions that satisfy the full data lifecycle including efficient technical hygiene and the use of Azure DevOps for the implementation of the Western Alliance Bank Regulatory Reporting and Analytics strategy and roadmap.
Develop ETL and data pipeline capabilities considering how data is created, transformed, maintained, stored, archived, analyzed, and shared across Western Alliance Bank and our partners.
Implement Azure DevOps CI/CD pipelines in accordance with Western Alliance Bank technical standards.
Implement data governance and data quality controls in all data solutions in accordance with enterprise standards.
Apply Test Driven Development methodology to all data solution design and implementations.
Implement methods to include unstructured data and big data.
Lead the implementation of outcomes, recommendations, and designs from Data Governance and Enterprise Architecture.
Actively participate in making data architecture decisions..
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: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
Bachelors degree in engineering or related field or equivalent experience in data management and/or data analytics.
8+ years experience with data engineering specifically in Extract, Transform and Load (ETL) concepts and processes, enterprise data warehouse capabilities, database principles, and other related tools and technologies; preferably strong to expert in Azure Data Factory and/or Databricks.
5+ years Azure Data Lake, Azure Data Factory, Azure Data Services, Azure Synapse, Azure Logic Apps, and Azure DevOps experience
Expert level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL
Experience with design tools as it relates to creating conceptual architecture diagrams and data flow diagrams such as Visio, Archimate, Lucid Chart
Familiarity with data science and analytics tools such as SAS, Tableau, PowerBI.
Familiarity with multi-cloud data management and transformation platforms or tools such as Databricks, Snowflake, Matillion, etc. - Experience implementing Large Financial Institution (LFI) Regulatory Reporting data solutions is preferred
Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer null
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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.
As the Staff Data Engineer II, you are critical engineer in a continuous delivery team dedicated to providing integrated data flows, data warehousing and analytic ecosystem across our Western Alliance Bank business lines. You are the technical expert in a high-performing centralized team of data engineers, data analysts and QA engineers. You champion data quality and discipline in the full data lifecycle. You must demonstrate strong technical mastery as well as an ability to collaborate and communicate with both technical team members and business stakeholders. You partner closely with enterprise architects to understand and implement solutions based on the recommended Azure Cloud data architecture and capabilities. You are required to know and/or learn modern automation and integration methods and tools, with Cloud-First design patterns, frameworks, critical thinking, and problem-solving skills. Being knowledgeable and up to date in the data integration and analytics trends in the industry is a differentiator in your role
Implement data engineering solutions that satisfy the full data lifecycle including efficient technical hygiene and the use of Azure DevOps for the implementation of the Western Alliance Bank Regulatory Reporting and Analytics strategy and roadmap.
Develop ETL and data pipeline capabilities considering how data is created, transformed, maintained, stored, archived, analyzed, and shared across Western Alliance Bank and our partners.
Implement Azure DevOps CI/CD pipelines in accordance with Western Alliance Bank technical standards.
Implement data governance and data quality controls in all data solutions in accordance with enterprise standards.
Apply Test Driven Development methodology to all data solution design and implementations.
Implement methods to include unstructured data and big data.
Lead the implementation of outcomes, recommendations, and designs from Data Governance and Enterprise Architecture.
Actively participate in making data architecture decisions..
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: https://insightglobal.com/workforce-privacy-policy/ .
Skills and Requirements
Bachelors degree in engineering or related field or equivalent experience in data management and/or data analytics.
8+ years experience with data engineering specifically in Extract, Transform and Load (ETL) concepts and processes, enterprise data warehouse capabilities, database principles, and other related tools and technologies; preferably strong to expert in Azure Data Factory and/or Databricks.
5+ years Azure Data Lake, Azure Data Factory, Azure Data Services, Azure Synapse, Azure Logic Apps, and Azure DevOps experience
Expert level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL
Experience with design tools as it relates to creating conceptual architecture diagrams and data flow diagrams such as Visio, Archimate, Lucid Chart
Familiarity with data science and analytics tools such as SAS, Tableau, PowerBI.
Familiarity with multi-cloud data management and transformation platforms or tools such as Databricks, Snowflake, Matillion, etc. - Experience implementing Large Financial Institution (LFI) Regulatory Reporting data solutions is preferred
Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer null
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 employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to 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 oruniformed service member status, or any other status or characteristic protected by applicable laws, regulations, andordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.