Comtech Global, Inc · 16 hours ago
Data Warehouse Specialist
Jackson County, MO
Contract
Onsite
Mid LevelComtech Global, Inc is seeking a Data Warehouse Specialist for their Enterprise Data Warehouse project. The role involves planning and implementing data architecture solutions using Azure Government ADLS Gen2, ensuring data security, and executing comprehensive testing protocols.
AnalyticsCloud Data ServicesCyber Security
Hiring Manager
Bhargav Cherukuri
Responsibilities
Conduct a project kickoff meeting onsite with MDCPS stakeholders and confirm working agreements, governance, and sprint cadence
Review and operationalize Agency-provided planning and architecture artifacts, confirm assumptions, and document any gaps requiring Agency decisions
Develop an Architecture Overview and implementation plan consistent with an Azure Government ADLS Gen2 landing zone and a curated reporting database using a star schema
Define and document the preferred secure pattern to move data from the on-premises SQL Server database to Azure Government ADLS Gen2 over VPN, including encryption in transit, secrets management, and network restrictions
Define and document a cross-tenant access approach for Pathways ingestion that enforces least privilege and network controls
Define the Bronze/Silver/Gold architecture approach for data landing, standardization, and curation
Produce a Security Design Summary addressing data classification and controls for sensitive information, including encryption at rest and in transit, Key Vault key/secret management, RBAC via Microsoft Entra ID, logging and auditing, secure networking, and vulnerability management
Create a prioritized product backlog and sprint plan aligned to the milestone schedule
Implement the Azure Government landing zone ingestion patterns required for both data sources, including folder/container conventions, data lineage considerations, and access controls
Implement ingestion pipelines/ELT processes from on-premises SQL Server into the landing zone over VPN using the selected secure pattern, including incremental loads and restorability
Daily ingestion from the Pathways Azure-hosted reporting database into the Agency landing zone, including incremental loads and secure credential handling via Key Vault
Implement transformation and curation processes to produce a reporting-ready star schema in an Azure database service suitable for enterprise reporting
Implement core conformed dimensions and facts required for initial reporting, based on Agency priorities and available source data
Conduct data quality and reconciliation checks sufficient to validate record counts, key relationships, and critical measures between source systems and curated outputs
Include Power BI connection to the curated Azure database, including configuration and validation as part of the implementation
Address the reverse-feed requirement by implementing a tested reverse-feed for selected curated tables or proposing it as a priced option with clear technical approach, scope boundaries, and test plan
Develop and execute a test plan that includes connectivity testing, security validation, performance testing, data reconciliation, and failure recovery testing
Validate and monitor VPN-based connectivity and throughput for on-premises ingestion and document results, bottlenecks, and recommended tuning
Validate and monitor cross-tenant connectivity and ingestion for the Pathways source and document least-privilege access verification, network restriction validation, and ingestion performance
Validate encryption in transit and at rest, RBAC/least privilege enforcement, Key Vault usage, logging/auditing configuration, and secure networking controls
Validate Power BI connectivity to the curated Azure database and representative query performance and refresh behavior
Include recovery testing outcomes to be documented, including restorable loads, transient failures, and restoration from backup for the curated database
Qualification
Required
Experience with Azure Government ADLS Gen2 and Azure SQL or equivalent in Azure Government
Knowledge of data ingestion patterns and secure data transfer methods, including VPN
Experience with data architecture and implementation of star schema for reporting
Ability to define and document security design summaries addressing data classification and controls
Experience with Power BI and its connection to Azure databases
Knowledge of data quality and reconciliation checks
Experience in developing and executing test plans for data solutions, including performance and security testing
Ability to document and validate connectivity, security, and performance metrics
Experience with Key Vault for secure credential handling
Knowledge of RBAC and least privilege enforcement in Azure environments
Company
Comtech Global, Inc
Comtech Global Inc is a provider of Information Technology services.
Founded in 2006
51-200 employees
H1B Sponsorship
Comtech Global, Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (1)
2024 (2)
2022 (1)
2021 (3)
2020 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase