Senior Data Analytics Engineer - Databricks - Power BI

Ajmera Infotech

5+ Years | Austin, TX, United States (On Site) | Full Time | 3 months ago

Apply Now

Job Summary

The role involves building scalable data pipelines using SQL, PySpark, and Delta Live Tables on Databricks. Responsibilities include orchestrating workflows with Databricks Workflows or Airflow, implementing SLA-backed retries and alerting, and designing dimensional models with Unity Catalog and Great Expectations validation. The engineer will deliver Power BI solutions, including dashboards, semantic layers, and paginated reports, and migrate legacy SSRS reports to Power BI. Optimization of compute and cost through cache tuning, partitioning, and capacity monitoring is also required. Additionally, documenting pipeline logic and RLS rules in Git-controlled formats, collaborating cross-functionally, and mentoring team members are key aspects of the position.

Must Have

5+ years in analytics engineering
3+ years in production Databricks/Spark contexts
Advanced SQL and PySpark
Delta Lake and Unity Catalog expertise
Power BI mastery (DAX, security, paginated reports)
SSRS to Power BI migration experience
Git, CI/CD, and cloud platform familiarity
Strong communication skills

Perks & Benefits

Competitive salary
Comprehensive health insurance
401(k) plan
Flexible work hours
Professional development opportunities

Job Description

Requirements

Key Responsibilities

Build scalable pipelines using SQL, PySpark, Delta Live Tables on Databricks.

Orchestrate workflows with Databricks Workflows or Airflow; implement SLA-backed retries and alerting.

Design dimensional models (star/snowflake) with Unity Catalog and Great Expectations validation.

Deliver robust Power BI solutions—dashboards, semantic layers, paginated reports, DAX.

Migrate legacy SSRS reports to Power BI with zero loss of logic or governance.

Optimize compute and cost through cache tuning, partitioning, and capacity monitoring.

Document everything—from pipeline logic to RLS rules—in Git-controlled formats.

Collaborate cross-functionally to convert product analytics needs into resilient BI assets.

Champion mentorship by reviewing notebooks, dashboards, and sharing platform standards.

Must-Have Skills

5+ years in analytics engineering, with 3+ in production Databricks/Spark contexts.

Advanced SQL (incl. windowing), expert PySpark, Delta Lake, Unity Catalog.

Power BI mastery—DAX optimization, security rules, paginated reports.

SSRS-to-Power BI migration experience (RDL logic replication)

Strong Git, CI/CD familiarity, and cloud platform know-how (Azure/AWS).

Communication skills to bridge technical and business audiences.

Nice-to-Have Skills

Benefits

Competitive salary
Comprehensive health insurance
401(k) plan
Flexible work hours
Professional development opportunities

You should know about the position:

This is a permanent, full-time position, working from an office in Austin, Texas, and we are not considering C2C (Corp-to-Corp), W4, or any type of contract engagement for this role.
Potential new employees must complete a drug screen and background check which includes criminal search, education certification, and employment verification before hire.
Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa currently.
The position will be posted until a final candidate is selected for the requisition or the requisition has enough applications.
Legal Compliance: Ensure compliance with all federal, state, and local regulations, including but not limited to E-Verify requirements for employment eligibility verification.

Application: Interested candidates are invited to submit their resumes to jobs@ajmerainfotech.com

12 Skills Required For This Role

Legal Compliance Communication Data Analytics Github Unity Aws Azure Power Bi Spark Ci Cd Git Sql

Similar Jobs

Data Analysis

Intern - Data Science (Studying Bachelor Degree)

Western Digital • Bang Pa-in District, Phra Nakhon Si Ayutthaya, Thailand (On Site)