Data Automation Engineer

Job Title: Data Automation Engineer Location: Washington, DC Type: Contract Compensation: $46.11 per hour Contractor Work Model: Remote – offsite Hours: 40.0 hours/week Security Clearance: DOJ Public Trust Preferred  ResponsibilitiesDesign and implement innovative data automation solutions for Azure cloud-based data lake, SQL, and NoSQL platforms.Translate business requirements into data engineering and AI-based solutions to support enterprise analytics and reporting.Develop high-performing data pipelines using Microsoft Azure services including Data Factory, Synapse Pipelines, Apache Spark Notebooks, Python, SQL, and stored procedures.Research and incorporate cutting-edge AI/ML and GenAI tools to automate data processes and eliminate workflow bottlenecks.Collaborate with implementation specialists, engineering teams, and clients to develop data solutions addressing operational needs.Identify, prepare, and manage data required for analytics, visualization, reporting, and AI/ML applications.Implement data migration, data integrity, quality functions, and metadata management to optimize data pipelines.Monitor, troubleshoot, and optimize data pipelines to ensure high availability and performance.Support performance testing, validation, and tuning of Azure-based data pipelines.Document test results, issues, and observations clearly for team review.Participate in Agile DevOps activities including planning and continuous learning efforts.Maintain strict versioning and configuration controls to ensure data integrity.RequirementsBS degree in Computer Science or related fieldMinimum of 2+ years of relevant experience in data automation, data engineering, or related rolesExperience with scripting languages such as SQL, T-SQL, Python, or PySparkProficient in designing and building ETL/data engineering solutions utilizing Azure Data Lake, Synapse Analytics, and Data FactoryExperience working with Microsoft SQL Server, SSIS, SSRS, SSAS, and Power BIKnowledge of data automation using Azure/AWS CLI tools with Bash or PowerShellFamiliarity with Azure DevOps or GitHub for version control and pipeline managementSupport of production, testing, and development environmentsStrong problem-solving skills and ability to adapt to new technologies quicklyExcellent communication skills and ability to support multiple projectsUS Citizenship and ability to obtain a Public Trust clearanceSystem One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.#M-M2 Ref: #851-Rockville-S1