Automation & Systems Engineer - Microsoft Ecosystem + Python Apis

Ali Awad Law, P.C.; A distancia; MXN 1,079,000 - 1,439,000; Jornada completa

Descripción de la vacante

A growing law firm is seeking a Bilingual Automation & Systems Engineer to join their team remotely. The role involves designing Power BI dashboards, integrating data from multiple sources, and supporting strategic decisions through analysis. Candidates should possess a bachelor’s degree in a related field, have at least 3 years of experience in data analytics, particularly with Power BI, and exhibit strong communication skills in both English and Spanish. This position offers a full-time work schedule with a commitment to data integrity and collaboration.

Formación

• 3+ years of experience in data analytics with Power BI focus.
• Advanced skills in Excel and SQL for data management.
• Fluency in English and Spanish is preferred.

Responsabilidades

• Design and maintain Power BI dashboards for various departments.
• Integrate data from legal and CRM platforms for reporting.
• Automate reporting processes and ensure data quality.

Conocimientos

Power BI dashboard development

SQL

Microsoft Excel

Python

Data analysis

Communication skills

Educación

Bachelor's degree in Data Science or related field

Herramientas

Power BI

Azure

Descripción del empleo

We are looking for a Bilingual Automation & Systems Engineer - Microsoft Ecosystem + Python APIs.

Fully bilingual English - Spanish.

CEO Lawyer is a rapidly growing personal injury law firm based in downtown Atlanta and we are seeking a highly

Key Responsibilities

• Develop a deep understanding of the firm's operations, departments, and technology stack.
• Design, build, and maintain advanced Power BI dashboards and reports tailored to various departments (e.g., legal, marketing, HR, finance).
• Manage Power BI Service: publish reports, configure data gateways, manage workspace permissions, and schedule data refreshes.
• Integrate and transform data from multiple sources, including: Legal and CRM platforms: Filevine, LeadDocket, HubSpot; Microsoft 365 tools: Excel, SharePoint, Teams, OneDrive; HR and productivity tools: BambooHR, ActiveTrack.
• Conduct in-depth data analysis to support strategic decisions by attorneys, directors, and executive leadership.
• Automate reporting processes and build scalable, reusable data models.
• Monitor and analyze KPIs, providing monthly/quarterly executive summaries.
• Ensure data quality, consistency, and accuracy through regular audits and validation.
• Collaborate with stakeholders to gather requirements and translate them into actionable insights.
• Maintain comprehensive documentation of data sources, definitions, dashboards, and reporting standards.
• Provide ad hoc analysis and support for special projects and operational needs.

Required Qualifications

• Bachelor's degree in Data Science, Computer Science, Statistics, Business Analytics, or a related field.
• 3+ years of experience in data analytics with a strong focus on Power BI dashboard development.
• Advanced proficiency in: Power BI (DAX, Power Query, data modeling), SQL (data extraction, transformation, and optimization), Microsoft Excel (pivot tables, advanced formulas, Power Pivot), Python (API Creation and Integration).
• Experience working with Microsoft 365 ecosystem (Teams, SharePoint, OneDrive, Outlook).
• Strong understanding of marketing analytics (e.g., campaign attribution, funnel analysis) and financial reporting (e.g., cash flow, burn rate, revenue forecasting).
• Excellent communication skills with the ability to present complex data in a clear, actionable format.
• Detail-oriented with a strong commitment to data integrity, privacy, and confidentiality.
• Professional fluency in English (written and verbal); Spanish bilingual is a plus.
• Experience with cloud-based databases and data warehouses (Azure).

Preferred Qualifications

• Experience in a legal, professional services, or regulated industry environment.
• Familiarity with legal case management systems and CRMs (e.g., Filevine, LeadDocket, HubSpot).
• Understanding of personal injury legal processes and key performance metrics.
• Knowledge of data governance, compliance, and privacy best practices.
• Background in KPI development and performance tracking for legal or service-based teams.
• Experience with scripting or automation tools (e.g., Power Automate, Python, R) is a plus.

Job Type: Full-time

Expected Hours: 40 per week

Work Location: Remote