The DC Office of the Chief Technology Officer (OCTO) Enterprise Data team needs an ETL Data Engineer for its Cloud Data Exchange, using native Azure tools for ETL, loading, and transformation: building end-to-end pipelines from multiple sources, establishing cloud and on-premise connectivity, and contributing to enterprise data governance. 100% onsite in Washington, DC.
Job Responsibilities
Build and support end-to-end ETL pipelines for the Cloud Data Exchange, loading and transforming data from multiple sources
Design, develop, implement, replicate, and support complex enterprise data projects using cloud solutions
Establish cloud and on-premise connectivity across systems (data lake storage, data factory, Synapse, Databricks)
Develop, standardize, and optimize data workflows and pipelines to best practices; automate, monitor, and alert on them
Contribute to enterprise data governance: accuracy, consistency, security, and reliability of data
Gather and document requirements with stakeholders; analyze existing code and perform enhancements or new development
Numbers & Facts
Location
Washington, DC
Job Type
Full-time, Employee
Salary
$60–$70 Per Hour
Qualifications
What you need
Bachelor’s degree in Information Technology or a related field, or equivalent experience
Extensive ETL development experience, including end-to-end pipelines loading from multiple sources (15 years)
Requirements gathering and documentation for extraction, transformation, and load processes (15 years)
Data warehousing, data lake, business intelligence, and information management concepts and standards (15 years)
SQL for relational databases (11 years) and varied data formats (Oracle, SQL, Postgres, DB2; CSV, XML; Parquet, AVRO) (11 years)
Microsoft Azure tools: Azure Data Factory, Synapse, SQL Database, Data Lake Storage Gen2, Blob Storage (5 years)
Required skills
ETL development: end-to-end pipeline design, data loading, and transformation from multiple sources
Microsoft Azure data engineering (Data Factory, Synapse, Azure SQL, Data
Lake Storage Gen2, Blob Storage)
SQL development for relational databases and complex queries and reports
Data integration and pipeline orchestration (Informatica PowerCenter, Apache NiFi, Apache Airflow, FME)
Data warehousing, data lake, and business-intelligence design and standards
Enterprise data governance: accuracy, consistency, security, and reliability
Requirements gathering, stakeholder advising, and cross-platform integration
Benefits
Medical, Dental, Vision
About Company
About Tecknomic Tecknomic is a technical staffing firm partnering with government and Fortune 500 clients across manufacturing, engineering, and technology. We are an Equal Opportunity Employer and consider all qualified applicants without regard to race, color, religion, sex, national origin, disability, protected-veteran status, or any other protected characteristic.
Skills
ETL Data Engineer
Microsoft Windows Azure
SQL
Data Engineer
Azure Data Factory
PYTHON
MicroStrategy
Tableau
Skills
Cloud Computingunmatched
Database Extract Transform and Load (ETL)unmatched
Microsoft Exchange Serverunmatched
Microsoft Windows Azureunmatched
Software Engineeringunmatched
🎯
Be found by employers
5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.
Level up your application
Professional resume templates
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.