$70K - 90K a year
Build and optimize scalable data pipelines and Power BI dashboards using Databricks and related technologies, migrate legacy reports, and mentor team members.
5+ years analytics engineering experience including 3+ years with Databricks, advanced SQL and PySpark skills, Power BI expertise including DAX and paginated reports, SSRS migration experience, and cloud platform knowledge.
Sr. Data Analytics Engineer – Databricks - Power BI Company: Ajmera Infotech Private Limited (AIPL) Experience: 5 – 9 years Preferred Location: Austin, Texas (We kindly request that candidates seeking remote work outside of Texas refrain from applying) Ajmera Infotech builds planet-scale software for NYSE-listed clients, driving decisions that can’t afford to fail. Our 120-engineer team specializes in highly regulated domains—HIPAA, FDA, SOC 2—and delivers production-grade systems that turn data into strategic advantage. Why You’ll Love It • End-to-end impact — Build full-stack analytics from lake house pipelines to real-time dashboards. • Fail-safe engineering — TDD, CI/CD, DAX optimization, Unity Catalog, cluster tuning. • Modern stack — Databricks, PySpark, Delta Lake, Power BI, Airflow. • Mentorship culture — Lead code reviews, share best practices, grow as a domain expert. • Mission-critical context — Help enterprises migrate legacy analytics into cloud-native, governed platforms. • Compliance-first mindset — Work in HIPAA-aligned environments where precision matters. 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. Application: Interested candidates are invited to submit their resumes to jobs@ajmerainfotech.com Job Types: Full-time, Contract Pay: $70,000.00 - $90,000.00 per year Benefits: • Flexible schedule • Health insurance • Paid time off Application Question(s): • What is your current location (City)? • What is your expected base pay? • How many years of Power BI experience do you have? • How many years of Total experience do you have? Experience: • Databricks: 3 years (Required) Work Location: Remote
This job posting was last updated on 9/9/2025