AZURE DATA ENGINEER - 100% REMOTE - FED GOV END CLIENT, W-2 Job at ALTA IT Services, Arlington, VA

Ry8wOWZiTzdTMzd5eFZMc3JjdFVXczhjWHc9PQ==
  • ALTA IT Services
  • Arlington, VA

Job Description

Job Description

Job Description

Job Title: Cloud Data Engineer
Location: Remote, perhaps 4 trips to DC a year
Type: Contract, 12 months
Compensation: $55/HR W-2 
Contractor Work Model: Remote - Potential travel to Washington, DC for special occasions. 
Security Clearance: Must obtain a Public Trust, DOJ ATF is the end client

ALTA IT Services is seeking a seeking a customer experience focused Cloud Data Engineer to 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. 
  • 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.

You must possess:

  • 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 
  • Federal Government end client, DOJ ATF, requires citizenship

Job Tags

Remote job, Contract work, For contractors,

Similar Jobs

Tomo Credit

Social Media Manager (Onsite - San Francisco) Job at Tomo Credit

 ...headquarters. About the Role The Paid Social Media Specialist is an entry-level member of...  ...in digital marketing to gain hands-on experience while collaborating with an experienced...  ...Vacation Policy We trust you to manage your time wisely. Career Growth Learn... 

Museum of Fine Arts, Houston

Assistant Conservation Scientist Job at Museum of Fine Arts, Houston

Join to apply for the Assistant Conservation Scientist role at Museum of Fine Arts, Houston5 days ago Be among the first 25 applicantsJoin to apply for the Assistant Conservation Scientist role at Museum of Fine Arts, HoustonGet AI-powered advice on this job and more... 

EVELAB INSIGHT

Customer Success Manager Job at EVELAB INSIGHT

 ...AI-driven solutions that transform their operations. As a Customer Success Manager , youll work closely with Account Manager to be the trusted...  ...the beauty industry. Work Environment Location: Remote, US West Coast Travel: Up to 30% of travelling. About... 

Effy Jewelry

Logistics Coordinator Job at Effy Jewelry

 ...Job Description Logistics Coordinator Salary: $50,000 - $60,000 Location: Miami, Florida (Onsite) About Us Effy Jewelry...  ...& Quality Control Identify and resolve shipment or supply chain issues promptly. Review ship supply checklists and flag discrepancies... 

Inland Empire Health Plan

Special Investigations Unit - Investigator II Job at Inland Empire Health Plan

*What you can expect! * The Special Investigations Unit Investigator II investigates and analyzes incidents of suspected fraud, waste, and...  ...internal partners on FWA intelligence and initiatives and assist with tracking and trending to identify potential fraud, waste,...