About the Role
Baker Botts is establishing its Enterprise Data Services team and seeks an Analytics Engineer to transform enterprise data into reliable, analytics-ready assets for reporting, business intelligence, and AI initiatives. This role focuses on designing and maintaining data transformations, implementing business logic, ensuring data quality, and creating curated datasets within Azure Databricks and Entegrata to drive insights and decision-making.
Responsibilities
- Partner with business stakeholders and the EAI team to understand enterprise reporting and analytical requirements, translating them into scalable technical and data solutions.
- Define, document, and implement business rules, transformation logic, calculations, enrichment processes, data lineage, and data quality checks.
- Develop pipelines and transformations using Bronze-layer data to create trusted Silver and Gold datasets for reporting, analytics, and AI use cases.
- Maintain curated datasets, reusable metrics, and analytical data products supporting firmwide reporting and self-service analytics.
- Build, maintain, and optimize PySpark-based workflows, Delta Lake assets, and Databricks jobs.
- Perform data profiling, reconciliation, validation, and testing to ensure confidence in downstream reporting and decision-making.
- Support the development of dashboards, reports, and analytical solutions by providing clean, trusted, and well-documented datasets.
- Work with source system owners and technical teams to resolve data quality, completeness, and usability issues.
- Participate in code reviews, CI/CD processes, and adhere to established development standards.
- Identify opportunities to leverage advanced analytics, statistical methods, and AI-enabled solutions to improve business outcomes.
Requirements
- 5-7 years of experience in analytics engineering, data engineering, data analytics, business intelligence, or a related field.
- Strong Python skills, including experience building data transformation, automation, and validation processes.
- Hands-on experience with Azure Databricks, including notebooks, workflows, Unity Catalog, Delta Lake, job orchestration, and performance optimization.
- Experience using PySpark to prepare, transform, and optimize large-scale datasets.
- Experience developing semantic models, analytical data marts, or subject area datasets.
- Experience designing, building, and maintaining analytics-ready datasets and business-facing data models.
- Experience with Power BI, Tableau, or other business intelligence and visualization platforms.
- Strong understanding of data quality, validation, testing, and governance practices.
- Experience working with cloud-based data platforms and modern lakehouse architectures.
- Ability to translate business requirements into scalable data solutions and meaningful analytical outputs.
- Strong written and verbal communication skills, including the ability to explain technical concepts to both technical and non-technical audiences.
- Proven ability to work independently while collaborating effectively across technical and business teams.
- Experience with Azure Data Lake Storage (ADLS Gen2).
- Familiarity with medallion architecture and modern lakehouse design patterns.
- Experience with machine learning, predictive analytics, or AI-enabled solutions.
- Exposure to dimensional modeling and analytical data modeling techniques.
- Basic SQL proficiency for data validation, troubleshooting, and exploratory analysis.
- Databricks, Azure, analytics, or business intelligence certifications.
Skills
- Python
- Azure Databricks
- PySpark
- Delta Lake
- Power BI
- Tableau
- Data Quality
- Data Validation
- Data Governance
- Cloud-based data platforms
- Lakehouse architectures
- Azure Data Lake Storage (ADLS Gen2)
- Medallion architecture
- Machine learning
- Predictive analytics
- AI-enabled solutions
- Dimensional modeling
- Analytical data modeling
- SQL
Location
- Hybrid
Work Type
- Full-time
- Hybrid
Experience Level
- 5-7 years
About the Company
- Baker Botts is a leading international law firm recognized for its deep understanding of the industries it serves.
- With offices across major global markets, the firm delivers sophisticated legal services while cultivating a collaborative, inclusive culture where both attorneys and professional staff contribute to client success and organizational excellence.
Equal Opportunity
- Baker Botts L.L.P. is an equal opportunity employer and considers all qualified applicants for employment without regard to race, color, gender, sex, age, religion, creed, national origin, citizenship, marital status, sexual orientation, disability, medical condition, military and veteran status, gender identity or expression, genetic information, or any other basis protected by federal, state, or local law.
