Business Immigration Data & Reporting Specialist

• Analyze, identify, and interpret trends or patterns in complex data sets.
• Create PowerBI dashboards and paginated reports.
• Create SLA reports to ensure client deadlines are met.
• Develop performance metrics (KPI’s).
• Develop and maintain SharePoint collaboration tools.
• Generate ad-hoc reports for clients from multiple data sets with tight deadlines.
• Write queries in SQL database language to pull information directly from database to supplement Visatrax reporting capability.
• Ability to use Excel/SQL to parse information from datasets too large for manual work (>100,000 rows).
• Perform quality control checks on case and document information and design reports to locate and solve data management issues.
• Perform internal case manager audits regularly to ensure data is being entered into the system accurately and efficiently.
• Track regular data integrity reporting, follow up with case managers and correct information.
• Conduct continuous data validation, cleansing and maintenance processes.
• Provide assistance with database login credentials and security settings to clients and staff.
• Train new staff on VisaTrax and RMS file management system.
• Work with cross-functional teams to determine data governance requirements.
• Interact with client contacts on a consistent basis and train on reporting capabilities.

• To support the health and safety of our teams and work spaces, we require employees to be fully vaccinated against COVID-19 or to have received an approved accommodation based on medical condition, personal conscience, or sincerely held religious belief or practice, or as otherwise required by applicable law. Please let us know if you’d like to discuss the policy or available accommodations before proceeding with our recruitment process.
• Bachelor’s degree and 2+ years of data analytics experience required.
• Excel competency and ability to write SQL required.
• Experience with immigration practice and business reporting, analytics, or metrics highly preferred.
• Strong attention to detail and maintaining consistent accuracy
• Willingness to seek out systemic problems in processes, data entry, and data maintenance, and to address these without direction or guidance.
• Ability to work under pressure with shifting priorities based on urgent requests.
• Excellent organizational skills with the ability to organize, manage, prioritize, and handle numerous projects/tasks simultaneously.
• Strong orientation toward maintenance and upkeep of existing systems.
• Flexibility to work additional hours when necessary to reach Firm objectives.
• Expert in Microsoft Office Suite (Excel, Word, PowerPoint, Outlook).
• Data visualization tools experience is highly preferred, specifically PowerBI.
• Strong analytical and problem-solving abilities.
• Experience in writing basic SQL queries.
• Experience with SharePoint is preferred.

 We are not working with outside recruiters for this position.

Ogletree Deakins offers a robust suite of benefits for our Staff including: Paid Time Off, Sick Time, a 401(k) matching program, Profit Sharing, Paid Holidays, Paid Parental Leave, affordable Health and Life Insurance including Dental & Vision coverage, Health Savings Account /Flexible Spending Accounts to help offset the cost of dependent care and/or health care expenses, Teladoc (24/7 access to a doctor by phone or online video), Tuition Reimbursement and an Employee Assistance Program.