Remote Data Engineer: Databricks, SQL & Analytics Pipelines

Anika Systems; United States; Remote; USD 95,000 - 130,000; Full time

Job summary

Anika Systems is seeking a Data Analyst to support OCDO and OPQ for a federal government contract. You will design and maintain robust data pipelines in Databricks using PySpark, SQL, and Python to transform agency data into analytics-ready assets.

The role requires a U.S. citizen with ability to obtain government clearance and will involve collaboration with data scientists, program analysts, and IT engineers to deliver actionable insights and governance-ready data products.

Qualifications

• Bachelor's degree or higher in a technical field.
• 3+ years of experience in data engineering, data analytics, or related discipline.
• Experience on federal government programs or supporting a federal agency data environment.
• Proficiency in SQL with complex joins, window functions, CTEs, and performance tuning.
• Hands-on experience with PySpark for distributed processing.
• Python scripting for data manipulation and automation.
• Direct experience with Databricks (notebooks, jobs, clusters, Unity Catalog).
• Knowledge of data lakehouse concepts (Delta Lake, bronze/silver/gold).
• Experience with Git-based version control and collaborative workflows.

Responsibilities

• Design, build, and maintain scalable data pipelines using PySpark and Python in Databricks.
• Develop and optimize SQL queries and data models for analytics and reporting.
• Automate data ingestion from APIs, files, relational DBs, and streaming feeds.
• Monitor pipelines, address data quality, and implement logging/alerting for reliability.
• Collaborate with data architects to enforce schemas, partitioning, and performance.
• Conduct exploratory data analysis to identify trends and opportunities.
• Create self-service analytics dashboards and reports using Databricks SQL, Tableau, or Power BI.
• Translate business questions into analytical tasks and present findings visually or in briefs.
• Work with data scientists, program analysts, IT engineers, and stakeholders to deliver solutions.

Skills

SQL

PySpark

Python

Databricks

ETL/ELT

Data Modeling

Data Analytics

Data Lakehouse

Git/GitHub/GitLab

Tableau/Power BI

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, or related field

Tools

Databricks Unity Catalog

Delta Lake

Tableau

Power BI

Job description

Anika Systems is seeking a Data Analyst to support OCDO and OPQ for a federal government contract. You will design and maintain robust data pipelines in Databricks using PySpark, SQL, and Python to transform agency data into analytics-ready assets.

The role requires a U.S. citizen with ability to obtain government clearance and will involve collaboration with data scientists, program analysts, and IT engineers to deliver actionable insights and governance-ready data products.