Own and enhance Sigma dashboards and business intelligence reporting for the Records Retrieval business. Partner with stakeholders to translate business needs into scalable data solutions, analyze complex datasets, improve data quality and governance, define reporting standards, and support Snowflake data warehouse and modeling initiatives. Deliver actionable insights, automate reporting processes, evaluate analytics tools, and independently drive analytics projects from requirements through delivery.
Magna Legal Services is a trusted nationwide partner to law firms, corporations, insurance carriers, and government agencies, delivering comprehensive legal support at every stage of a case. From court reporting and record retrieval to jury consulting, investigations, litigation graphics, and language services, we help our clients navigate complex legal challenges with confidence. Our reputation is built on the expertise, dedication, and professionalism of our team, and we’re proud to foster a culture where talented people can do meaningful work and grow their careers.
Magna Legal Services is seeking a Senior Data Analyst, Business Intelligence, to help lead and evolve the analytics practice supporting our Records Retrieval line of business. This role will partner closely with business stakeholders to understand operational needs, translate those needs into scalable data solutions, and deliver reporting and insights that drive better decision-making.
The Senior Data Analyst will own the development and ongoing improvement of dashboards and reporting in Sigma, while also helping establish reporting standards, improve data quality, and strengthen the underlying analytics infrastructure. The ideal candidate combines strong technical and analytical skills with business acumen and the ability to communicate effectively with both technical and non-technical stakeholders.
Experience with Snowflake is strongly preferred.
Primary Responsibilities
- Partner with business stakeholders to understand objectives, identify reporting and analytics needs, translate requirements into effective data solutions, and help turn insights into action.
- Design, develop, maintain, and enhance dashboards and reports in Sigma, delivering clear and actionable insights to business leaders and operational teams.
- Use SQL to query, transform, validate, and analyze data from multiple sources, including Snowflake.
- Analyze large and complex datasets to identify trends, performance drivers, opportunities, and potential areas of concern.
- Establish and promote best practices for reporting, data governance, metric definitions, documentation, and data integrity.
- Improve and scale existing BI assets and reporting processes through simplification, standardization, and automation.
- Partner with data and technology teams on data modeling, warehouse development, and improvements to the Snowflake environment.
- Evaluate analytics tools, processes, and capabilities and recommend improvements that increase the effectiveness and efficiency of the BI function.
Desired Background
- Bachelor’s degree in Data Science, Computer Science, Information Systems, Business Analytics, or a related field.
- 5+ years of experience in business intelligence, data analytics, reporting, or a related role.
- Strong proficiency with SQL, including experience querying and analyzing large datasets.
- Experience developing sophisticated dashboards and reporting solutions using Sigma or a comparable modern BI platform.
- Experience working with cloud data warehouses; Snowflake strongly preferred.
- Strong analytical and problem-solving skills, with the ability to translate business questions into meaningful analysis and actionable insights.
- Excellent written and verbal communication skills, including the ability to explain technical concepts and data findings to non-technical audiences.
- Demonstrated ability to gather requirements, manage competing priorities, and independently drive analytics initiatives from concept through delivery.
- Experience with data modeling, ETL/ELT processes, data governance, and visualization best practices is preferred.
- Collaborative, proactive, and comfortable working in a fast-paced environment with a high degree of ownership.
Magna Legal Services provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.
Similar Jobs
Healthtech
Supports value-based healthcare programs through complex SQL analysis, reporting, data reconciliation, payment support, and evaluation of new program opportunities. Develops monthly and ad hoc reports using Excel and Azure Synapse Analytics, interprets complex healthcare and insurance data, and communicates findings to senior leadership. The role also supports program implementation, maintenance, process improvement, and provider relationships.
Top Skills:
Azure Synapse AnalyticsDatabricksExcelPysparkPythonSQL
Fashion
Designs and maintains BI solutions, writes optimized SQL and stored procedures, and builds AI-assisted reports and dashboards using Power BI, Tableau, and Excel. Translates business questions into actionable insights for Sales and cross-functional teams, develops data models, supports reporting migrations, and ensures data quality, governance, documentation, and consistency across platforms.
Top Skills:
Ai-Assisted AnalyticsData ModelingData WarehousingETLExcelMicrosoft Power BiMicrosoft Power PlatformSQLSQL ServerSsisSsrsTableau
Fintech • Financial Services
Design and administer enterprise dashboards and reporting solutions (Tableau, Power BI, Microsoft Fabric). Translate complex business questions into compelling data stories, partner with stakeholders and BI engineers, champion visualization standards and governance, mentor analysts, and improve reporting usability and trust across the organization.
Top Skills:
AlteryxMicrosoft FabricPower BIPythonSQLTableau
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
