> Markdown version of [/jobs/ext/550155-data-engineer](https://www.wearedevelopers.com/jobs/ext/550155-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Engineer - **Company:** Ivory Cloud LLC - **Location:** Huntsville, AL, United States - **Experience:** Experienced - **Salary:** $125,000.0 - $150,000.0 - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Agile Methodology, Business Analytics Applications, Data Analysis, Audit Trail, Capability Maturity Model Integration, Cyber Security, Information Systems, Data Architecture, Data Dictionary, Information Engineering, Data Governance, Data Integrity, Extract Transform Load (ETL), Data Migration, Data Profiling, Data Security, Data Structures, Electronic Data Interchange (EDI), Meta-Data Management, Microsoft SQL Server, Performance Tuning, Scrum Methodology, Query Optimization, Power BI, Application Data, Software Systems, SQL Stored Procedures, SQL Server Integration Services, Data Streaming, Technical Data Management Systems, Transact-SQL, Data Ingestion, Azure Data Factory, Indexer, Microsoft Fabric, Information Technology, Enterprise Integration, AWS Data Analytics, Tools for Reporting, Data Pipelines - **Published:** June 10, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=d08040887d2d5eac ## About the Role Do you have experience in T-SQL?, Do you have a Bachelor's degree?, * U.S. Citizen - required. * On-site work 5 days a week in Huntsville, Alabama is required. * Security Clearance Public Trust (T4) required. Required Qualifications * 4 years minimum experience * 8+ years of data engineering, database engineering, or ETL development experience, with at least 4 years supporting enterprise or federal mission systems * Deep expertise in Microsoft SQL Server, T-SQL, stored procedures, schema design, indexing, query tuning, and performance optimization * Hands-on experience designing and building ETL/ELT pipelines using SSIS or comparable enterprise data integration tooling * Demonstrable experience with data migration planning, data profiling, cleansing, transformation, reconciliation, and cutover support * Experience producing data architecture artifacts including logical and physical data models, data dictionaries, source-to-target mappings, and data flow diagrams * Experience implementing data quality controls, validation rules, and exception handling for operational and analytical data pipelines * Proven experience integrating application data with APIs, reporting platforms, and external systems while maintaining data integrity and auditability * Strong understanding of secure data handling practices, role-based access controls, and data governance expectations in regulated environments * Experience working in Agile SCRUM teams and collaborating directly with architects, developers, testers, and product stakeholders * Must possess excellent oral and written communication skills and the ability to explain technical data issues to both technical and non-technical stakeholders Education * BA or BS degree in Computer Science, Information Systems, Data Engineering, or similar IT related discipline * Bachelor's degree in the technical field from an accredited institution Certifications * At least one Microsoft or cloud data certification is highly desired, such as: Azure Data Engineer Associate, Microsoft Fabric Data Engineer Associate, AWS Data Analytics, or equivalent * At least one certification such as: Certified Scrum Master (CSM), PMI-ACP, SAFe Agilist, or equivalent Agile certification, is desired Highly Preferred Qualifications * Current or recent prior experience supporting Department of Justice/Law Enforcement-related software systems * Prior experience with incident reporting, case management, intelligence, investigative, or criminal justice information systems * Experience with federal data governance programs, metadata management, and records traceability requirements * Familiarity with federal data governance expectations, NIST 800-53 Rev 5, FISMA ATO processes, and Section 508 implications for data outputs and reporting * Experience enabling Power BI, embedded analytics, or dashboard-ready data structures in operational applications * Experience working with geospatial or location-based data structures, map layers, and downstream GIS-oriented reporting or exports * Experience operating in Agile software services and cross-functional teams within a Capability Maturity Model Integration (CMMI) Level 3 or higher accredited program, * SSIS: 4 years (Required) * ETL: 4 years (Required) * Data Architecture: 4 years (Required) ## Description IvoryCloud is seeking a Data Engineer to lead data migration, data architecture, and integration engineering activities for a Federal system modernization effort. The ideal candidate brings hands-on experience modernizing Microsoft SQL-based federal application data environments, designing ETL pipelines, and establishing trustworthy, high-quality data flows that support operational transactions, reporting, analytics, and secure inter-system exchange. This role is central to modernization because the modernized platform must preserve historical access, improve data completeness and standardization, and support interfaces to mission systems and downstream analytical outputs., * Lead the data engineering strategy for modernization of a legacy Microsoft SQL environment, including migration, normalization, and optimization activities * Design and maintain ETL pipelines supporting system modernization, data ingestion, historical data access, and operational reporting * Develop and maintain source-to-target mappings, data dictionaries, transformation logic, reconciliation rules, and migration runbooks * Profile legacy and MVP data to identify inconsistencies, duplicates, missing values, terminology issues, and other data quality risks that affect IOC and FOC delivery * Implement validation and quality controls that improve completeness, reliability, and traceability of incident and activity data * Partner with the Technical Solutions Architect Lead to design scalable data models optimized for transactional workloads, interfaces, and analytics * Support interfaces and data exchange requirements with other approved external systems * Prepare data structures and curated outputs that support dashboards, reporting, and future analytical capabilities without degrading operational performance * Coordinate with the Government's data governance, cybersecurity, and product stakeholders to ensure data engineering decisions align with policy and mission needs * Support sprint planning, backlog refinement, defect analysis, release readiness, and production issue triage for data-related features and integrations ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Optimizing Discovery: PostgreSQL's Role in Transforming GetYourGuide's Search](https://www.wearedevelopers.com/videos/1647-optimizing-discovery-postgresql-s-role-in-transforming-getyourguide-s-search) - [Resilient by Design: Building Robust Architectures in High-Stakes Financial Systems](https://www.wearedevelopers.com/videos/2106-resilient-by-design-building-robust-architectures-in-high-stakes-financial-systems) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Data Analytics with Microsoft Fabric: End-to-End Use Case with Data Agents](https://www.wearedevelopers.com/videos/1547-data-analytics-with-microsoft-fabric-end-to-end-use-case-with-data-agents) ## Related Articles - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Top-Paying Tech Jobs (with Salaries)](https://www.wearedevelopers.com/magazine/372-top-paying-tech-jobs-with-salaries) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [The 12 Best Jobs for Software Engineers](https://www.wearedevelopers.com/magazine/401-the-12-best-jobs-for-software-engineers)