Apex Systems
Cloud Data Engineer role at
Apex Systems . Remote position with occasional travel. Base pay range
$55.00/hr - $58.00/hr Job Description
Apex Systems is seeking a Cloud Data Engineer to work remotely. This role will require travel about 3-4 times per year to Washington, D.C., so the ideal candidate will be in the D.C. Metro area. Summary
The Cloud Data Engineer will work with a team of subject matter experts and developers to design and implement full lifecycle data pipeline services for Azure cloud based data lake, SQL, and NoSQL data stores. As a data engineer, you will translate business requirements to data engineering solutions to support an enterprise scale Microsoft Azure based data analytics and reporting platform. You will support continued maintenance of legacy SQL Server ETL operations and transition to modern cloud native solutions. Our ideal candidate is mission focused and delivery oriented, and applies critical thinking to create innovative functions and solve technical issues. Responsibilities
Maintain and operate legacy ETL processes utilizing Microsoft SSIS, Powershell, SQL procedures, SSAS, .NET code, and other technologies. Implement full lifecycle Azure cloud native data pipeline development and operation. Work closely with client personnel and team members to understand data requirements and develop appropriate data solutions. Support the design and implementation of data models and data pipelines for relational, dimensional, data lakehouse (medallion architecture), data warehouse, data mart, SQL and NoSQL data stores. Utilize Microsoft Azure services including Azure Data Factory, Synapse Pipelines, Apache Spark Notebooks, Python, SQL, stored procedures to develop high performing data pipelines. Redevelop existing SSIS extract, transform, load scripts to Azure Data Factory and Synapse Pipelines. Identify, create, prepare data required for advanced analytics, visualization, reporting, and AI/ML. Implement data migration, data integrity, data quality, metadata management, and data security functions to optimize data pipelines. Monitor and troubleshoot data related issues to maintain high availability and performance. Implement governance, build, deployment and monitoring to automate platform operation. Actively support Agile DevOps process, including Program Increment planning. Actively engage in continuous learning to increase relevant skills. Maintain strict versioning and configuration control to ensure integrity of data. Qualifications
BS degree in Computer Science or related field with 8+ years or Masters with 6+ years of experience 4+ years of experience developing and maintaining ETL processes using Microsoft SSIS, SQL, SQL Agent, and scripting languages including Powershell. 4+ years of experience with more than one of the following scripting languages: SQL, T-SQL, Python, PySpark Experience working with Microsoft database and business intelligence tools, including SQL Server, including stored procedures, SSIS, SSRS, SSAS (cubes), scripting languages including PowerShell Experience designing and building ETL/data engineering solutions utilizing various cloud services such as Azure Data Lake Services, Azure Synapse Strong understanding of data modeling, data governance, and data security practices Other Requirements
Must be a U.S. Citizen with ability to successfully obtain a government-issued Public Trust clearance. EEO and Benefits
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with applicable law. If you require an accommodation in using our website for a search or application, please contact our Employee Services Department. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. We offer a comprehensive benefits package and opportunities for career development. Apex is part of the Commercial Segment of ASGN Incorporated (NYSE: ASGN). Office address: 4400 Cox Road, Suite 200, Glen Allen, Virginia 23060.
#J-18808-Ljbffr
Apex Systems . Remote position with occasional travel. Base pay range
$55.00/hr - $58.00/hr Job Description
Apex Systems is seeking a Cloud Data Engineer to work remotely. This role will require travel about 3-4 times per year to Washington, D.C., so the ideal candidate will be in the D.C. Metro area. Summary
The Cloud Data Engineer will work with a team of subject matter experts and developers to design and implement full lifecycle data pipeline services for Azure cloud based data lake, SQL, and NoSQL data stores. As a data engineer, you will translate business requirements to data engineering solutions to support an enterprise scale Microsoft Azure based data analytics and reporting platform. You will support continued maintenance of legacy SQL Server ETL operations and transition to modern cloud native solutions. Our ideal candidate is mission focused and delivery oriented, and applies critical thinking to create innovative functions and solve technical issues. Responsibilities
Maintain and operate legacy ETL processes utilizing Microsoft SSIS, Powershell, SQL procedures, SSAS, .NET code, and other technologies. Implement full lifecycle Azure cloud native data pipeline development and operation. Work closely with client personnel and team members to understand data requirements and develop appropriate data solutions. Support the design and implementation of data models and data pipelines for relational, dimensional, data lakehouse (medallion architecture), data warehouse, data mart, SQL and NoSQL data stores. Utilize Microsoft Azure services including Azure Data Factory, Synapse Pipelines, Apache Spark Notebooks, Python, SQL, stored procedures to develop high performing data pipelines. Redevelop existing SSIS extract, transform, load scripts to Azure Data Factory and Synapse Pipelines. Identify, create, prepare data required for advanced analytics, visualization, reporting, and AI/ML. Implement data migration, data integrity, data quality, metadata management, and data security functions to optimize data pipelines. Monitor and troubleshoot data related issues to maintain high availability and performance. Implement governance, build, deployment and monitoring to automate platform operation. Actively support Agile DevOps process, including Program Increment planning. Actively engage in continuous learning to increase relevant skills. Maintain strict versioning and configuration control to ensure integrity of data. Qualifications
BS degree in Computer Science or related field with 8+ years or Masters with 6+ years of experience 4+ years of experience developing and maintaining ETL processes using Microsoft SSIS, SQL, SQL Agent, and scripting languages including Powershell. 4+ years of experience with more than one of the following scripting languages: SQL, T-SQL, Python, PySpark Experience working with Microsoft database and business intelligence tools, including SQL Server, including stored procedures, SSIS, SSRS, SSAS (cubes), scripting languages including PowerShell Experience designing and building ETL/data engineering solutions utilizing various cloud services such as Azure Data Lake Services, Azure Synapse Strong understanding of data modeling, data governance, and data security practices Other Requirements
Must be a U.S. Citizen with ability to successfully obtain a government-issued Public Trust clearance. EEO and Benefits
Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, marital status, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with applicable law. If you require an accommodation in using our website for a search or application, please contact our Employee Services Department. Apex Systems is a world-class IT services company that serves thousands of clients across the globe. We offer a comprehensive benefits package and opportunities for career development. Apex is part of the Commercial Segment of ASGN Incorporated (NYSE: ASGN). Office address: 4400 Cox Road, Suite 200, Glen Allen, Virginia 23060.
#J-18808-Ljbffr