World Wide Technology
Position Overview
The Consulting Data Engineer role requires experience in both traditional warehousing technologies (e.g. Teradata, Oracle, SQL Server) and modern database/data warehouse technologies (e.g., AWS Redshift, Azure Synapse, Google Big Query, Snowflake), as well as expertise in ETL tools and frameworks (e.g. SSIS, Azure Data Factory, AWS Glue, Matillion, Talend). This person should have experience with both on-premise and cloud deployments of these technologies and in transforming data to adhere to logical and physical data models, data architectures, and engineering a dataflow to meet business needs. This role will support engagements such as data lake design, data management, migrations of data warehouses to the cloud, and database security models, and ideally should have experience in a large enterprise in these areas. Key Responsibilities
Develops high performance distributed data warehouses, distributed analytic systems and cloud architectures Participates in developing relational and non-relational data models designed for optimal storage and retrieval Develops, tests, and debugs batch and streaming data pipelines (ETL/ELT) to populate databases and object stores from multiple data sources using a variety of scripting languages; provide recommendations to improve data reliability, efficiency and quality Works alongside data scientists, supporting the development of high-performance algorithms, models and prototypes Implements data quality metrics, standards, guidelines; automates data quality checks / routines as part of data processing frameworks; validates flow of information Ensures that Data Warehousing and Big Data systems meet business requirements and industry practices including but not limited to automation of system builds, security requirements, performance requirements and logging/monitoring requirements Qualifications
Bachelor’s Degree in Arts/Sciences (BA/BS) or related field A combination of education, training and experience may be considered in lieu of a degree A minimum of 3-5 years progressive experience in a related field Experience with at least one traditional data warehousing technology (e.g., Teradata, Oracle, SQL Server) and/or modern platforms (e.g., AWS, GCP, Azure) Experience in one scripting language (e.g., Python, Java or Scala) Experience in SQL scripting, tuning, indexing, partitioning, data access patterns, and scaling strategies Experience with data integrations and data processing for business intelligence and analytics workloads Experience as a key player in developing an enterprise data warehouse Knowledge, Skills, and Abilities
Ability to translate a logical data model into a relational or non-relational solution Expert in one or more of the following ETL tools: SSIS, Azure Data Factory, AWS Glue, Matillion, Talend, Informatica, Fivetran Hands on experience in setting up End to End cloud based data lakes Hands-on experience in database development using views, SQL scripts and transformations Ability to translate complex business problems into data-driven solutions Working knowledge of reporting tools like Power BI, Tableau etc Ability to identify data quality issues that could affect business outcomes Flexibility in working across different database technologies and propensity to learn new platforms on-the-fly Strong interpersonal skills Team player prepared to lead or support depending on situation Travel Requirements
Up to 25% of the time Domestic and International Travel Security Clearance
Security clearance is required – currently have security clearance or able to achieve security clearance Why WWT?
At World Wide Technology, we work together to make a new world happen. Our important work benefits our clients and partners as much as it does our people and communities across the globe. WWT is dedicated to achieving its mission of creating a profitable growth company that is also a Great Place to Work for All. We achieve this through our world-class culture, generous benefits and by delivering cutting-edge technology solutions for our clients. Founded in 1990, World Wide Technology (WWT) is a global technology solutions provider leading the AI and Digital Revolution. With more than $20 billion in annual revenue, WWT combines the power of strategy, execution and partnership to accelerate digital transformational outcomes for large public and private organizations. Through its Advanced Technology Center, a collaborative ecosystem of the world\'s most advanced hardware and software solutions, WWT helps clients and partners conceptualize, test and validate innovative technology solutions for the best business outcomes and then deploys them at scale through its global warehousing, distribution and integration capabilities. With over 10,000 employees and more than 55 locations around the world, WWT\'s culture, built on a set of core values and established leadership philosophies, has been recognized 14 years in a row by Fortune and Great Place to Work for its unique blend of determination, innovation and creating a great place to work for all. With this culture at its foundation, WWT bridges the gap between business and technology to make a new world happen for its customers, partners and communities. Want to work with highly motivated individuals on high-performance teams? Join WWT today! Note: This description reflects the role within the Solutions Consulting & Engineering (SC&E) Team and is intended for recruitment purposes. It is not an offer of employment and is subject to change.
#J-18808-Ljbffr
The Consulting Data Engineer role requires experience in both traditional warehousing technologies (e.g. Teradata, Oracle, SQL Server) and modern database/data warehouse technologies (e.g., AWS Redshift, Azure Synapse, Google Big Query, Snowflake), as well as expertise in ETL tools and frameworks (e.g. SSIS, Azure Data Factory, AWS Glue, Matillion, Talend). This person should have experience with both on-premise and cloud deployments of these technologies and in transforming data to adhere to logical and physical data models, data architectures, and engineering a dataflow to meet business needs. This role will support engagements such as data lake design, data management, migrations of data warehouses to the cloud, and database security models, and ideally should have experience in a large enterprise in these areas. Key Responsibilities
Develops high performance distributed data warehouses, distributed analytic systems and cloud architectures Participates in developing relational and non-relational data models designed for optimal storage and retrieval Develops, tests, and debugs batch and streaming data pipelines (ETL/ELT) to populate databases and object stores from multiple data sources using a variety of scripting languages; provide recommendations to improve data reliability, efficiency and quality Works alongside data scientists, supporting the development of high-performance algorithms, models and prototypes Implements data quality metrics, standards, guidelines; automates data quality checks / routines as part of data processing frameworks; validates flow of information Ensures that Data Warehousing and Big Data systems meet business requirements and industry practices including but not limited to automation of system builds, security requirements, performance requirements and logging/monitoring requirements Qualifications
Bachelor’s Degree in Arts/Sciences (BA/BS) or related field A combination of education, training and experience may be considered in lieu of a degree A minimum of 3-5 years progressive experience in a related field Experience with at least one traditional data warehousing technology (e.g., Teradata, Oracle, SQL Server) and/or modern platforms (e.g., AWS, GCP, Azure) Experience in one scripting language (e.g., Python, Java or Scala) Experience in SQL scripting, tuning, indexing, partitioning, data access patterns, and scaling strategies Experience with data integrations and data processing for business intelligence and analytics workloads Experience as a key player in developing an enterprise data warehouse Knowledge, Skills, and Abilities
Ability to translate a logical data model into a relational or non-relational solution Expert in one or more of the following ETL tools: SSIS, Azure Data Factory, AWS Glue, Matillion, Talend, Informatica, Fivetran Hands on experience in setting up End to End cloud based data lakes Hands-on experience in database development using views, SQL scripts and transformations Ability to translate complex business problems into data-driven solutions Working knowledge of reporting tools like Power BI, Tableau etc Ability to identify data quality issues that could affect business outcomes Flexibility in working across different database technologies and propensity to learn new platforms on-the-fly Strong interpersonal skills Team player prepared to lead or support depending on situation Travel Requirements
Up to 25% of the time Domestic and International Travel Security Clearance
Security clearance is required – currently have security clearance or able to achieve security clearance Why WWT?
At World Wide Technology, we work together to make a new world happen. Our important work benefits our clients and partners as much as it does our people and communities across the globe. WWT is dedicated to achieving its mission of creating a profitable growth company that is also a Great Place to Work for All. We achieve this through our world-class culture, generous benefits and by delivering cutting-edge technology solutions for our clients. Founded in 1990, World Wide Technology (WWT) is a global technology solutions provider leading the AI and Digital Revolution. With more than $20 billion in annual revenue, WWT combines the power of strategy, execution and partnership to accelerate digital transformational outcomes for large public and private organizations. Through its Advanced Technology Center, a collaborative ecosystem of the world\'s most advanced hardware and software solutions, WWT helps clients and partners conceptualize, test and validate innovative technology solutions for the best business outcomes and then deploys them at scale through its global warehousing, distribution and integration capabilities. With over 10,000 employees and more than 55 locations around the world, WWT\'s culture, built on a set of core values and established leadership philosophies, has been recognized 14 years in a row by Fortune and Great Place to Work for its unique blend of determination, innovation and creating a great place to work for all. With this culture at its foundation, WWT bridges the gap between business and technology to make a new world happen for its customers, partners and communities. Want to work with highly motivated individuals on high-performance teams? Join WWT today! Note: This description reflects the role within the Solutions Consulting & Engineering (SC&E) Team and is intended for recruitment purposes. It is not an offer of employment and is subject to change.
#J-18808-Ljbffr