Data Reporting Analyst

Greenberg Traurig; A distancia; MXN 200,000 - 400,000; Jornada completa

Descripción de la vacante

A global law firm is seeking a Reporting and Data Analyst for a remote full-time position. This role involves leading data activities in the Immigration Department, developing data systems, and creating dashboards for clients. Candidates should have significant experience with data management, advanced Excel, SQL, and data visualization tools. An underlying knowledge of immigration processes is beneficial. The firm offers competitive compensation and a comprehensive benefits package.

Servicios

Competitive compensation

Excellent benefits package

Formación

• Fluent in English speaking and writing.
• Minimum of 7 to 10 years' experience in advanced Excel.
• Minimum of 5 years' experience with SQL scripting and data management.

Responsabilidades

• Lead data activities for the immigration practice group.
• Design and maintain data systems and databases.
• Develop dashboards and reporting systems for internal and external use.
• Conduct ad hoc reporting and data analysis.

Conocimientos

Analytical skills

Communication skills

Organizational skills

Problem-solving skills

Independence

Educación

Bachelor's Degree or equivalent

Herramientas

Microsoft Excel

Power BI

SQL

Python

R

Descripción del empleo

Greenberg Traurig, a global law firm, currently has an excellent remote full-time employment opportunity in the Immigration Department of our Mexico City office.

We offer competitive compensation and an excellent benefits package.

Position Summary

The Reporting and Data Analyst will be responsible for leading data activities for the Firm's immigration practice group, including establishing protocols for data integrity, performing data analytics, and executing reporting functions for the highly specialized Immigration Department.

This position will take the lead on various ad hoc data projects, including the migration of data from a legacy case management system to a new system, including field analysis, data extraction, data cleansing and transformation, data mapping, and data transferring.

Additionally, the Reporting and Data Analyst will also assist with the development of complex dashboards for clients and sales pitches.

Please submit resume in English.

Duties & Responsibilities

• Designs and maintains data systems and databases, including developing Data Models to mine data from primary and secondary sources.
• Develops descriptive, predictive, and prescriptive data models.
• Prepares viewable summaries (dashboards) of data for consumption by non-technical stakeholders for both internal staff and external end-clients, using tools such as Excel and data visualization software (e.g., Microsoft Power BI).
• Develops and improves the team's reporting system and overall capability.
• Assist with the evaluation and implementation of data systems, tools, and processes to enable data management and analytics capabilities.
• Simplifies and automates new and existing data and reporting processes, transitioning daily reporting activities into low effort, reusable reports.
• Gathers, analyzes, documents, and translates reporting requirements into functional specifications to meet business objectives.
• Completes ad hoc reporting requests from clients and internal teams, developing and implementing data reports and visualizations to effectively communicate insights.
• Generates internal reports, including monthly reports on status document expirations, max-out dates, green card eligibility, and conditional green card expirations.
• Plans, develops, and delivers operational reports for internal staff and external end-clients.
• Contributes to the internal audit function through auditing client records, conducting data cleansing and ensuring data quality by utilizing reports to guide data cleanup efforts.
• Acts as the lead for new client data migrations and other data requests, under the direction of the Practice Group Manager, including migrating data and documents for new clients to firm systems and corresponding with clients for necessary documentation.
• Serves as point of contact for other data personnel on technical matters.
• Stays current with the latest data analysis tools and techniques.
• Works overtime as needed.

Skills & Competencies

• Strong analytical and problem-solving skills.
• Ability to communicate professionally and interact effectively with all levels of personnel, including management staff and support staff.
• Ability to work on multiple matters simultaneously.
• Outstanding case management and organizational skills.
• Excellent interpersonal and communication skills (oral and written), professional demeanor and presentation.
• High attention to detail, outstanding organizational and analytical skills and the ability to manage time effectively.
• Be able to work independently toward team goals.
• Ability to respond quickly and positively to shifting demands.

Qualifications & Prior Experience

• Fluent in English speaking and writing.
• Bachelor's Degree or equivalent experience in a related field preferred.
• Minimum of 7 to 10 years' experience in advanced Excel formula writing.
• Minimum of 5 years' experience with coding, SQL scripting, R, Python, SSRS, SSIS and ETL.
• Minimum of 3 years' experience with writing basic visual queries such as in Power BI.
• Must have advanced level of programming knowledge (reporting code) and of relational databases, database structures and design, systems design, data management, and data warehousing.
• Familiarity with immigration processes or the legal sector preferred.
• Greenberg Traurig is an Equal Opportunity Employer and committed to diversity and inclusion in the workplace.

Individuals seeking employment at Greenberg Traurig are considered without regards to race, color, religion, sex, sexual orientation, gender identification, national origin, age, marital status, ancestry, disability, veteran status, or genetic information, among other protected bases.