VivSoft logo
VivSoft

Solving complex Public Sector Use cases using emerging technologies - SBIR Phase III Awardee

Senior Data Warehouse Specialist, ETL Developer

Analytics EngineerAnalytics EngineerFull TimeRemoteSeniorTeam 51-200Since 2011H1B SponsorCompany SiteLinkedIn

Location

United States

Posted

16 hours ago

Salary

0

Seniority

Senior

Job Description

Senior Data Warehouse Specialist, ETL Developer

VivSoft

• Design, develop, and maintain ETL/ELT pipelines for data integration from multiple source systems • Build and enhance data warehouses, data marts, and analytics platforms • Perform data extraction, transformation, cleansing, and loading to ensure data quality and accuracy • Optimize SQL queries, ETL jobs, and data processing performance • Support data modeling (conceptual, logical, physical) and metadata management • Develop and maintain data integration workflows and automation processes • Conduct data profiling, validation, and testing (unit, integration, performance, data quality) • Collaborate with data architects, BI developers, business analysts, and QA teams • Provide production support, troubleshoot issues, and implement fixes/enhancements • Ensure compliance with data governance, security, and federal regulations (FISMA, NIST, FedRAMP) • Contribute to documentation, SOPs, and knowledge transfer activities • Provide technical leadership and enforce best practices

Job Requirements

  • Strong expertise in ETL/ELT tools (Databricks, DataStage, SSIS, AWS Glue, etc.)
  • Advanced proficiency in SQL and database development
  • Experience with data warehouse architecture and data modeling
  • Hands-on experience with cloud platforms (AWS, Databricks, Redshift, S3)
  • Knowledge of database platforms (Oracle, SQL Server, PostgreSQL, etc.)
  • Familiarity with job scheduling tools (Control-M or equivalent)
  • Experience in data quality, governance, and metadata management
  • Understanding of SDLC, Agile methodologies, and DevOps practices
  • Strong troubleshooting, performance tuning, and analytical skills
  • Knowledge of federal security and compliance standards (NIST, FISMA, FedRAMP)
  • Excellent communication and collaboration skills

Benefits

  • Comprehensive Medical, Dental, and Vision Plans (Healthcare benefits are 100% employer-paid for employees only)
  • Life Insurance
  • Paid Time Off (Flexible/Combined PTO, Bereavement Leave, 11 Company Paid Holidays)
  • 401K Retirement Plan with employer match
  • Professional Development Training Reimbursement

Related Categories

Related Job Pages

More Analytics Engineer Jobs

Nest Health logo

Senior Analytics Engineer

Nest Health

Making healthcare radically accessible to families on Medicaid. Generational change for families begins at home.

Analytics Engineer17 hours ago
Full TimeRemoteTeam 11-50Since 2021H1B No Sponsor

• You'll own the dbt project end to end • You'll own the semantic layer • You'll own data observability • You'll own the orchestration layer • Collaborate with clinical, operations, and finance stakeholders on metric definitions and data quality

United States
Dadosfera logo

Analytics Engineer – Engenheiro de Analytics Pleno

Dadosfera

O caminho mais rápido entre Dados e Valor

Analytics Engineer19 hours ago
Full TimeRemoteTeam 51-200Since 2018H1B No Sponsor

• Desenvolver e manter camadas analíticas focadas no consumo de negócios • Traduzir necessidades de negócios em modelos de dados escaláveis e reutilizáveis • Garantir qualidade, documentação e governança de ativos analíticos • Colaborar com Engenheiros de Dados para evoluir pipelines e conjuntos de dados • Construir métricas corporativas e camadas semânticas para consumo em Power BI e Metabase • Apoiar iniciativas de Self-Service Analytics • Participar da definição e adoção de catálogos de dados e documentação técnica • Atuar como um elo entre equipes técnicas e partes interessadas de negócios

Brazil
Nscale logo

Senior Analytics Engineer

Nscale

Nscale is the Hyperscaler engineered for AI.

Analytics Engineer21 hours ago
Full TimeRemoteTeam 201-500Since 2024H1B No Sponsor

Role Description We're hiring a Senior Analytics Engineer to own the analytics layer that powers data-driven decisions across Nscale's GPU procurement and hardware supply chain. In this role, you'll sit within the Supply Chain Analytics & Automation team and build in Palantir Foundry, creating the output datasets, data models, and reporting products that teams use directly. You'll work closely with Supply Chain, Finance, Capacity stakeholders, the C-suite, and data engineering, serving as the link between business decision-making and the underlying data required to support it. This is a senior individual contributor role and the first analytics hire on the team, giving you the opportunity to set standards for quality, documentation, and architectural decision-making from the ground up. Your work will shape how critical supply chain decisions are understood, trusted, and acted on as Nscale continues to scale. What you'll be doing - Own the analytics layer - Build output datasets, data models, and reporting products in Palantir Foundry - Design analytical outputs that business stakeholders can use directly - Maintain the reporting layer that supports decision-making across the organization - Partner across technical and business teams - Serve as the primary interface between the analytics team and data engineering - Assess what data exists, what shape it is in, and what needs to be built or changed to answer business questions - Partner with Supply Chain, Finance, and Capacity stakeholders to translate decisions into analytical requirements - Communicate effectively with both technical and non-technical audiences, including senior stakeholders - Set quality and operating standards - Define engineering standards for analytical outputs - Establish documentation standards, including assumption documentation and version control - Implement reconciliation checks to ensure analytical outputs are accurate and trusted - Raise the quality bar for how analytics work is produced and maintained - Shape the future of the function - Make architectural decisions that shape the analytics layer as the team grows - Set expectations for what strong analytical work looks like in a fast-moving environment - Hire and onboard analysts over time, helping define the foundation for future team members KPIs - Quality and reconciliation accuracy of analytical outputs - Delivery of trusted Foundry datasets, models, and reporting products - Stakeholder adoption across Supply Chain, Finance, Capacity, and leadership - Analytics documentation and standards maturity Qualifications - 5+ years of experience in an analytics engineering or senior analytics role, including work in at least one production environment at meaningful scale - Strong experience with SQL, data modelling, and data transformation - Palantir Foundry experience strongly preferred, with comparable platform experience also considered - Demonstrated ability to build analytical outputs, datasets, models, and reporting layers used by business stakeholders - Strong instinct for data quality and a high bar for reconciliation and accuracy - Experience working across technical and non-technical stakeholders - Ability to write a clear data spec for engineers and a concise summary for C-suite audiences - Track record of making strong architectural decisions in fast-moving environments with incomplete requirements - Background in supply chain, procurement, hardware, or AI/cloud infrastructure is a meaningful bonus Benefits - Highly competitive US compensation package (base + bonus + equity), with performance reviews every 12 months - Join one of the fastest-growing AI infrastructure companies — your chance to directly shape how global AI capacity is planned and deployed - Expect a dynamic progression plan tailored to your ambitions - Human-First Flexibility: We treat you as humans first. Our flexible workplace trusts Nscalers to deliver, giving you the autonomy to shape your day around life's moments

United States
$100K - $150K / year
Empower AI logo

Performance Management Analytics Engineer

Empower AI

Empower AI (formerly NCI) elevates public sector teams with the power of AI, to ensure America’s missions are met.

Analytics Engineer22 hours ago
Full TimeRemoteTeam 501-1,000Since 1989H1B No Sponsor

• Proactively monitors adherence to service level agreements (SLAs) using ServiceNow dashboards and performance reports, escalating deviations to program leadership. • Drives continuous service improvement by conducting in-depth analysis of service desk performance metrics and delivering data-driven corrective action recommendations. • Performs high-level systems analysis, evaluation, design, integration, documentation, and implementation of very complex applications requiring thorough knowledge of administrative and technical skills. • Participates in all phases of system development with emphasis on planning, analysis, evaluation, integration, testing, and acceptance phases (IV&V and DT&E). • Applies higher-level business or technical principles and methods to very difficult technical problems to arrive at automated engineering solutions. • Designs, analyzes, and maintains highly complex enterprise infrastructure environments to support J6 service delivery operations. • Develops performance measurements including goals, metrics, and reports utilizing the current service desk platform; facilitates a feedback system to team members on customer service, communication, and technical skills to enhance the quality of support delivered. • Develops and provides regular Service Desk metrics reports to program leadership and Government stakeholders. • Manages the implementation of an enterprise knowledge base and knowledge management best practices to ensure consistent, high-quality service delivery. • Collaborates with IT support teams and section leads to design and implement continuous service improvement initiatives aligned with J6 mission objectives. • Ensures J6 customer requirements for Service Desk performance are met consistently and in alignment with contractual obligations. • Analyzes tickets, calls, emails, and web chat interactions to provide Interaction and Ticket Trend Reports, characterizing the nature and volume of change in call and ticket volume and handling time. • Generates ad hoc and repeatable Interaction and Ticket Forecast Reports using supporting tools including Active Directory accounts, Asset Reports, and Mobile Device Usage Reports. • Provides business and data visualization dashboards in graphical format to inform Government leadership regarding patterns, trends, and correlations, enabling data-driven decision-making. • Forecasts future interaction volumes, handle times, staffing requirements, and schedules to ensure adequate J6 Service Desk coverage and performance.

United States