Cloud Data Engineer at The Computer Merchant, LTD.

JOB TITLE: Cloud Data Engineer JOB LOCATION: Remote - Occasional travel to DC WAGE RANGE*: $56-60/hr. W2 JOB NUMBER: SAIJP00038367 REQUIRED EXPERIENCE:BS degree in Computer Science or related field and 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 follow 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 Syna Security Clearance: PUBLIC TRUST JOB DESCRIPTION ​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. Equal opportunity employer as to all protected groups, including protected veterans and individuals with disabilities * While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to: job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life/short term disability/whole life/term life/accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions. Benefits offered are in accordance with applicable federal, state, and local laws and subject to change at TCM's discretion.