Data Engineer

Analytica
United States
Workplace: RemoteFull timeFunction: Data Analytics & Business IntelligenceExperience: 5+ yearsEducation: bachelorsSkills: ["Communication","Presentation","Interpersonal skills"]

Support a long-term federal government program by designing and implementing star-schema dimensional models in SQL Server, including fact/dimension tables and slowly changing dimensions. Build and optimize ETL and data operations (indexing, keys, scripting) and develop application systems aligned to standard development methodology. Deploy analytical models and application code using CI/CD, provide support post-deployment, and apply domain expertise to specifications and data process plans.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Analytica
Analytica
4 days ago

Data Engineer

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 5 hours agoStatus: Live
Reposted: similar role first listed 6 months ago

Job Summary

Support a long-term federal government program by designing and implementing star-schema dimensional models in SQL Server, including fact/dimension tables and slowly changing dimensions. Build and optimize ETL and data operations (indexing, keys, scripting) and develop application systems aligned to standard development methodology. Deploy analytical models and application code using CI/CD, provide support post-deployment, and apply domain expertise to specifications and data process plans.
Location: United States
Workplace: Remote
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Design and implement star schema dimensional models (fact and dimensions tables) in SQL Server to support BI and analytics requirements.
  • •Write and optimize ETL and data operations, including table creation, indexing strategies, keys, and slowly changing dimensions.
  • •Provide business analysis and develop ETL code to meet technical specifications and business requirements.
  • •Develop application systems following standard system development methodology, including design, programming, and backup/recovery for strong performance and integrity.
  • •Deploy application code and analytical models using CI/CD tooling and provide support for deployed data applications and analytical models.

Pay and Benefits

Perks:Health InsuranceLearning Budget401k

Key Requirements

  • •Bachelor’s degree in Computer Science, Engineering, IT, or another scientific/quantitative field.
  • •5+ years designing conceptual, physical, and logical data models using enterprise data modeling tools.
  • •5+ years in strategic data planning, governance, and standards.
  • •5+ years using enterprise data warehouse modeling constructs and star schema best practices to build scalable, high-performing databases.
  • •Hands-on experience integrating systems with big data/data lake repositories using ETL tools, including expertise with SQL Server.
Experience:5+ yearsFederal governmentHealthcareData warehousingETLBig dataData lakes
Education:Bachelor's
Skills:CommunicationPresentationInterpersonal skills
Certifications:SQL Server certificationData management (CDMP)Data management (MCSA)
Tech Stack:SQL ServerAmazon RedshiftDbeaverVisual StudioETLCI/CDAWS GlueAWS LambdaGitGitHubData miningData warehousingStar schemaDimensional modelingSlowly changing dimensions

Eligibility

Security Clearance:Secret

Company Brief

Analytica
Analytica is a federal-focused consulting and technology services firm delivering data, analytics, AI, and IT modernization solutions to health, civilian, and national security agencies in the U.S.
Industry: Consulting
Company Size: Medium (51 to 250 employees)
Revenue: USD 25M to 50M
Growth: Established Company
Headquarters: Washington, United States
Founded: 2009
Glassdoor
Glassdoor: 3.4
WebsiteLinkedInGlassdoor