Azure Data Warehouse Developer Jobs in Reston, VA

Job Summary:
Nightwing Intelligence Solutions is a company that provides advanced cyber and data operations services. They are seeking a Data Engineer to work on engineering, installing, operating, and sustaining databases and repositories, ensuring data collections are processed efficiently and supporting mission partners with their analytics and dissemination needs.
Responsibilities:
• Develop and maintain data and metadata policies and procedures for structural design and development to build, maintain and leverage the unified data storage, data lake, and lake house. ensuring integration with SYSTEM data standards.
• Engineer the design, development, deployment, implementation and support of major databases and metadata structures to include the review and evaluation of database performance and optimization.
• Develop plans for, and tools to enhance, the transition of legacy data to the SYSTEM during install as well as transition of development and/or production environment to new technology
• Recommend and plan server/ cloud compute/storage resource recapitalization for Sponsor consideration
• Provide comprehensive assessments of the technical characteristics of proposed installations and alternatives considered to optimize database performance
• Develop methods of ensuring data incompatibilities among systems are systematically eliminated
• Diagnose, isolate and expediently resolve complex problems pertaining to data infrastructure
• Baseline and forecast server performance data; refine server hardware and software configurations
• Manage, monitor and administer database system performance/schedule activities; oversee daily performance; perform backups/restores; archive data; provide technical assistance and support
• Monitor industry trends and directions in database technology and tools; develop and present substantive technical recommendations to the Sponsor.
• Compose technical documents including Design, Deployment, System specifications and Mission Partner baselines, updates, user's manuals, training materials, installation guides, proposals, and reports.
Qualifications:
Required:
• SQL: Proficiency in writing and executing SQL queries for data manipulation and analysis.
• Data Modeling: Understanding of data modeling principles and ability to design data structures that meet business requirements.
• ETL/ELT Processes: Experience with Extract, Transform, and Load (ETL) or Extract, Load, and Transform (ELT) processes and tools.
• Cloud Platforms: Familiarity with cloud computing platforms such as AWS, Azure, or Google Cloud Platform.
• Programming Languages: Proficiency in Python or Java for data manipulation and scripting.
• Data Warehousing: Understanding of data warehousing concepts and experience with data warehouse technologies.
• Data Governance and Security: Knowledge of data governance principles and best practices for data security and privacy.
Preferred:
• Big Data Technologies: Experience with technologies like Apache Hadoop, Spark, or Kafka.
• Data Visualization: Ability to create data visualizations using tools like Tableau or Power BI.
• Data Pipeline Orchestration: Experience with data pipeline orchestration tools like Airflow or Luigi.
• Data Quality Tools: Familiarity with data quality tools and techniques for identifying and resolving data quality issues.
• Data Wrangling: Experience with data wrangling techniques for cleaning, transforming, and preparing data for analysis.
• AWS Certified Data Analytics Specialty
• Microsoft Certified: Azure Data Engineer Associate
• Google Cloud Certified Professional Cloud Data Engineer
• IBM Data Engineering Professional Certificate
• IBM Data Warehouse Engineer Professional Certificate
• Meta Database Engineer Professional Certificate
Company:
Nightwing provides cyber, data operations, systems integration, and intelligence services for government and commercial customers. Founded in 2024, the company is headquartered in Sterling, USA, with a team of 1001-5000 employees. The company is currently Late Stage.