analyst, sports

financial analyst

senior data analyst

accounting operations analyst Jobs in Chicago

accounting operations analyst

analyst 1

data analyst

Wilson Elser

<div><div>Wilson Elser is a leading defense litigation law firm with more than 1400 attorneys in 46 offices throughout the United States. Founded in 1978, we rank among the top 100 law firms identified by The American Lawyer and 36 in the National Law Journal's survey of the nation's largest law firms.</div>
Our firm is committed to attracting and retaining professionals who value each other and the service we provide by embracing Teamwork, Collaboration, Client Service, and Innovation. If you are a motivated professional looking for a long-term fit where you can grow in a role, and will be valued and empowered, then we invite you to apply to our Data Analyst position in our Chicago, IL Office.

This position offers a flexible, hybrid working arrangement.

The Position

This hands-on Data Analyst position will reside within the Firm's Business Solutions &amp; Innovations department, where 20+ years of legacy technology and business processes are undergoing a complex and strategic overhaul, focused on efficiency, sustainability and providing a competitive industry advantage.

Key Responsibilities:
<ul>
<li>Create and maintain reporting processes to support firm stakeholders</li>
<li>Develop an understanding and knowledge of databases supporting firm operation</li>
<li>Utilize Power BI Analysis Services for data visualization and reporting</li>
<li>Leverage Aderant Database &amp; Software for financial systems reporting</li>
<li>Perform initial analysis and refinement of data</li>
<li>Effectively communicate with internal/external resources</li>
<li>Respond to ad hoc data requests</li>
<li>Effectively analyze, reverse engineer, and document legacy scripting routines</li>
</ul>
Qualifications
<ul>
<li>1-3 years of Experience in Financial Systems Administration</li>
<li>1-3 years of recent Experience with Aderant Financial System</li>
<li>Demonstrated Ability to Managing Data &amp; Performing Data Analysis</li>
<li>Working Knowledge Power BI Analysis Services</li>
<li>MS SQL/SSRS/SQL Query skills required</li>
<li>Exceptional MS Excel understanding, ability to debug, and develop a must</li>
<li>VBA/Macro understanding and ability to debug are preferred skills</li>
<li>Familiar with using JIRA software or comparable software for project and task management</li>
<li>Excellent analytical and problem-solving skills</li>
<li>Multi-tasker with ability to successfully manage numerous projects and tasks concurrently</li>
<li>Strong oral communication skills</li>
<li>Ability to draft succinct, informative, and accurate reports and recommendations</li>
<li>Organizational skills to manage toward deadlines and deliverables</li>
<li>Experience leading the transition, integration, and implementation of legal e-billing platforms a plus</li>
<li>Knowledge of Sequel Viewpoint Systems a plus</li>
<li>Prior industry experience with mid to large sized Law Firm(s) a plus</li>
<li>Bachelor's degree (preferably in a Computer Science or related field), or substantial industry experience/expertise</li>
</ul><div>
Why Should You Apply?
<ul>
<li>Benefits: Outstanding benefits package, including 401k match and generous PTO plan</li>
<li>Career Growth: Ample opportunities for professional development and advancement</li>
<li>Employee Perks: Access to corporate discount plans and other benefits</li>
</ul><h5 class="jobSectionHeader">Wilson Elser welcomes submissions of candidates for our open positions exclusively from recruitment agencies with an active, signed fee agreement who have been granted access to a position through our dedicated Recruitment Agency Portal. We are unable to consider submissions from recruitment agencies without a current (dated as of 7/1/2024) agreement in place. We appreciate your understanding. For collaboration inquiries or to establish an agreement, please contact us at talentacquisition@wilsonelser.com.</h5>
<h5 class="jobSectionHeader">Wilson Elser is committed to a collegial work environment in which all individuals are treated with respect and dignity. It is the Firm's policy that employment will be based on merit, qualifications, and competence. Further, employment decisions will be made without regard to an applicants race, color, age, sex, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation or preference, gender identity, physical or mental disability, status as a victim of domestic violence, sex offenses, or stalking, past or present service in the uniformed services or application or obligation to serve in the uniformed services, or any other characteristic protected by law.</h5>
<h5 class="jobSectionHeader">Wilson Elser endeavors to make the Wilson Elser website accessible to any and all users. You may review our Accessibility Policy here.</h5>
<h5 class="jobSectionHeader">California Residents may review our CCPA notice for applicants and employees here.</h5>
<h5 class="jobSectionHeader">#ZR</h5></div></div>

Data Analyst

<div>
 
 
 Wilson Elser
 
 is a leading defense litigation law firm with more than 1400 attorneys in 46 offices throughout the United States. Founded in 1978, we rank among the top 100 law firms identified by The American Lawyer and 36 in the National Law Journal&rsquo;s survey of the nation&rsquo;s largest law firms.&nbsp;
 
 
 Our firm is committed to attracting and retaining professionals who value each other and the service we provide by embracing Teamwork, Collaboration, Client Service, and Innovation.&nbsp; If you are a motivated professional looking for a long-term fit where you can grow in a role, and will be valued and empowered, then we invite you to apply to our
 
 Data Analyst
 
 position in our
 
 Chicago, IL
 
 Office.
 
 
 
 
 This position offers a flexible, hybrid working arrangement.
 
 
 
 
 
 The Position
 
 
 
 This hands-on Data Analyst position will reside within the Firm&rsquo;s Business Solutions &amp; Innovations department, where 20+ years of legacy technology and business processes are undergoing a complex and strategic overhaul, focused on efficiency, sustainability and providing a competitive industry advantage.
 
 
 
 Key Responsibilities:
 
 
 <ul>
 <li>
 Create and maintain reporting processes to support firm stakeholders
 </li>
 <li>
 Develop an understanding and knowledge of databases supporting firm operation
 </li>
 <li>
 Utilize Power BI Analysis Services for data visualization and reporting
 </li>
 <li>
 Leverage Aderant Database &amp; Software for financial systems reporting
 </li>
 <li>
 Perform initial analysis and refinement of data
 </li>
 <li>
 Effectively communicate with internal/external resources
 </li>
 <li>
 Respond to ad hoc data requests
 </li>
 <li>
 Effectively analyze, reverse engineer, and document legacy scripting routines
 </li>
 </ul>
 
 
 Qualifications
 
 
 <ul>
 <li>
 1-3 years of Experience in Financial Systems Administration
 </li>
 <li>
 1-3 years of recent Experience with Aderant Financial System
 </li>
 <li>
 Demonstrated Ability to Managing Data &amp; Performing Data Analysis
 </li>
 <li>
 Working Knowledge Power BI Analysis Services
 </li>
 <li>
 MS SQL/SSRS/SQL Query skills required
 </li>
 <li>
 Exceptional MS Excel understanding, ability to debug, and develop a must
 </li>
 <li>
 VBA/Macro understanding and ability to debug are preferred skills&nbsp;
 </li>
 <li>
 Familiar with using JIRA software or comparable software for project and task management
 </li>
 <li>
 Excellent analytical and problem-solving skills
 </li>
 <li>
 Multi-tasker with ability to successfully manage numerous projects and tasks concurrently
 </li>
 <li>
 Strong oral communication skills
 </li>
 <li>
 Ability to draft succinct, informative, and accurate reports and recommendations
 </li>
 <li>
 Organizational skills to manage toward deadlines and deliverables
 </li>
 <li>
 Experience leading the transition, integration, and implementation of legal e-billing platforms a plus
 </li>
 <li>
 Knowledge of Sequel Viewpoint Systems a plus
 </li>
 <li>
 Prior industry experience with mid to large sized Law Firm(s) a plus
 </li>
 <li>
 Bachelor&rsquo;s degree (preferably in a Computer Science or related field), or substantial industry experience/expertise&nbsp;
 </li>
 </ul>
 
 A variety of factors are considered in making compensation decisions, including but not limited to experience, education, licensure and/or certifications, geographic location, market demands, other business and organizational needs, and other factors permitted by law. Final salary wages offered may be outside of this range based on other reasons and individual circumstances.&nbsp; This position is considered full-time and therefore qualifies for benefits including 401(k) retirement savings plan, medical, dental, vision, disability, and life insurance. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.&nbsp;
 
 
 Salary Range: : $80,000 USD - $90,000 USD
 
 
 
 Why Should You Apply?&nbsp;
 
 
 <ul>
 <li>
 
 
 Benefits:
 
 &nbsp;Outstanding benefits package, including 401k match and generous PTO plan
 
 </li>
 <li>
 
 
 Career Growth:
 
 &nbsp;Ample opportunities for professional development and advancement
 
 </li>
 <li>
 
 
 Employee Perks:
 
 &nbsp;Access to corporate discount plans and other benefits
 
 </li>
 </ul>
 
 Wilson Elser welcomes submissions of candidates for our open positions exclusively from recruitment agencies with an active, signed fee agreement who have been granted access to a position through our dedicated Recruitment Agency Portal. We are unable to consider submissions from recruitment agencies without a current (dated as of 7/1/2024) agreement in place. We appreciate your understanding. For collaboration inquiries or to establish an agreement, please contact us at talentacquisition@wilsonelser.com.
 
 
 Wilson Elser is committed to a collegial work environment in which all individuals are treated with respect and dignity.&nbsp; It is the Firm's policy that employment will be based on merit, qualifications, and competence. Further, employment decisions will be made without regard to an applicants race, color, age, sex, religion, creed, national origin, ancestry, citizenship, marital status, sexual orientation or preference, gender identity, physical or mental disability, status as a victim of domestic violence, sex offenses, or stalking, past or present service in the uniformed services or application or obligation to serve in the uniformed services, or any other characteristic protected by law.&nbsp;
 
 
 Wilson Elser endeavors to make the Wilson Elser website accessible to any and all users.&nbsp; You may review our Accessibility Policy here.
 
 
 California Residents may review our CCPA notice for applicants and employees here.
 
 #ZR
</div>

Cboe Global Markets

<div>
 
 Job Description:
 
 
 
 
 Building trusted markets &mdash; powered by our people
 
 
 
 At Cboe Global Markets, we inspire our people to solve complex challenges together because what we do matters. We provide the financial infrastructure that powers the global economy. As a leading provider of market infrastructure and tradable products, Cboe delivers cutting-edge trading, clearing and investment solutions to market participants around the world.
 
 
 We&rsquo;re building meaningful ways to support professional and personal development while strengthening the trust we&rsquo;ve earned as a global market leader. Our teams are empowered to share ideas, actively pursue them and bring on a challenge. As champions of internal mobility and access to opportunity, we encourage our people to &ldquo;go for it&rdquo; and equip our managers with the training to coach their teams to the next level. We strive to provide employees a safe space to network, share ideas and create opportunities.
 
 
 
 Location Overview
 
 
 
 Cboe HQ is located in the historic Old Post Office district, it&rsquo;s a landmark that blends classic architecture with modern amenities. The building features expansive spaces with high ceilings and large windows, offering an abundance of natural light and panoramic views of the city skyline and the Chicago River.
 
 
 With its prime location in the heart of downtown, the OPO Building provides easy access to major transportation hubs, including Union Station and multiple CTA lines, making it convenient for commuters. The building is home to a variety of amenities, including restaurants, a fitness center, and collaborative workspaces, creating a vibrant and dynamic work environment in one of Chicago's most iconic areas.
 
 
 
 Role Overview
 
 
 
 This Data Analyst reports to the Client Engagement Platform Manager and is responsible for overseeing the development and maintenance of our Salesforce instance and integrated toolsets, including advanced data visualization tools like Sigma Computing. This role is focused on advanced data management, reporting, integration, and actionable insights to support strategic decision-making.
 
 
 This role is pivotal in advancing our data and analytics capabilities, ensuring the seamless integration of complex data sources, and delivering high-impact insights that drive our strategic initiatives.
 
 
 
 Your responsibilities will be:
 
 
 
 <ul>
 <li>
 Oversee operational administration, configuration, and support of the Salesforce platform, including user setup, profiles, roles, groups, security and permissions, workflows and validation rules, and custom objects and fields.
 </li>
 <li>
 Maintain and advance current workflows and data structures to align with evolving business objectives.
 </li>
 <li>
 Advise on and execute system enhancements, collaborating with business line leaders to meet new requirements.
 </li>
 <li>
 Monitor and analyze site metrics, system performance, and user activity to ensure optimal functionality.
 </li>
 <li>
 Perform regular data audits to identify integrity issues and opportunities for process improvements.
 </li>
 <li>
 Develop and implement advanced SQL queries to address complex data discrepancies and streamline marketing and Salesforce data integration.
 </li>
 <li>
 Create and manage data models in Sigma Computing, facilitating the combination of Salesforce data for sustainable future use.
 </li>
 <li>
 Use Python scripting to generate weekly summaries, providing stakeholders with easy access to client data.
 </li>
 <li>
 Develop complex dashboards and actionable insights in Sigma Computing to support strategic decision-making.
 </li>
 <li>
 Build advanced flows and automations in Salesforce to drive operational efficiency.
 </li>
 <li>
 Perform integrations between Salesforce and third-party applications, ensuring seamless data flow and system compatibility.
 </li>
 <li>
 Maintain and schedule advanced Python jobs, utilizing VIM language for navigating the analytics layer and updating scheduled jobs as needed.
 </li>
 <li>
 Create and manage data mapping structures to ensure alignment and synchronization between Pardot and Salesforce, enhancing marketing operations and facilitating future analysis.
 </li>
 <li>
 Collaborate on continuous improvement initiatives to enhance user experiences and increase efficiencies.
 </li>
 <li>
 Train users on Salesforce functionality, new features, and workflow enhancements.
 </li>
 <li>
 Consult with business stakeholders to gather and confirm business requirements, producing functional, technical, and system design documentation.
 </li>
 <li>
 Develop and create reports and dashboards in Sigma and Salesforce to support the delivery of key business metrics.
 
 
 </li>
 </ul>
 
 The ideal candidate has
 
 
 
 <ul>
 <li>
 Bachelor's degree in Computer Science, Information Systems, Data Analytics, or a related field.
 </li>
 <li>
 2+ years of experience in data analysis, with a strong focus on Salesforce administration and advanced SQL.
 </li>
 <li>
 Proficiency in data visualization tools like Tableau and Sigma Computing.
 </li>
 <li>
 Strong experience with Python scripting and VIM language.
 </li>
 <li>
 Excellent analytical, problem-solving, and project management skills.
 </li>
 <li>
 Ability to work collaboratively with cross-functional teams and communicate effectively with stakeholders.
 
 
 </li>
 </ul>
 
 Benefits And Perks Of Working For Cboe Global Markets
 
 
 
 We value the total wellbeing of our people &ndash; including health, financial, personal and social wellness. We believe standard benefits like health insurance and fair pay are a given at any organization. Still, you should know we offer:
 
 
 <ul>
 <li>
 Fair and competitive salary and incentive compensation packages with an upside for overachievement
 </li>
 <li>
 Generous paid time off, including vacation, personal days, sick days and annual community service days
 </li>
 <li>
 Health, dental and vision benefits, including access to telemedicine and mental health services
 </li>
 <li>
 2:1 401(k) match, up to 8% match immediately upon hire
 </li>
 <li>
 Discounted Employee Stock Purchase Plan
 </li>
 <li>
 Tax Savings Accounts for health, dependent and transportation
 </li>
 <li>
 Employee referral bonus program
 </li>
 <li>
 Volunteer opportunities to help you give back to your communities
 
 
 </li>
 </ul>
 Some of our associates&rsquo; favorite benefits and perks include:
 
 
 <ul>
 <li>
 Complimentary lunch, snacks and coffee in any Cboe office
 </li>
 <li>
 Paid Tuition assistance and education opportunities
 </li>
 <li>
 Generous charitable giving company match
 </li>
 <li>
 Paid parental leave and fertility benefits
 </li>
 <li>
 On-site gyms and discounts to other fitness centers
 </li>
 <li>
 Paid Time Off
 
 
 </li>
 </ul>
 
 More About Cboe Global Markets
 
 
 
 We&rsquo;re reimagining the future of the workplace by focusing on what matters most, our people. Our journey is an inclusive one. We&rsquo;re investing deeply in leadership programs and career development initiatives that ensure everyone has an equal chance to succeed.
 
 
 We work with purpose, solving problems with ingenuity, collaboration, and a lot of passion. We&rsquo;re an engaged and excited team connecting markets across borders and embracing growth in all its forms to achieve incredible outcomes.
 
 
 Learn more about life at Cboe on our website and LinkedIn.
 
 
 
 Equal Employment Opportunity
 
 
 
 We're proud to be an equal opportunity employer do not discriminate against any employee or applicant for employment based on any legally protected characteristic, including race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, or veteran status. We are committed to fostering a workplace where all individuals are valued and respected.
 
 
 #Hybrid
 
 
 
 This position is not eligible for visa sponsorship. Candidates must be legally authorized to work in the United States without the need for employer sponsorship now or in the future.
 
 
 
 At Cboe, we are committed to providing a competitive, transparent, and market‑informed total rewards program. The anticipated base salary range for this role is $81,345-$105,270, with actual compensation determined by job‑related factors such as skills, relevant experience, education, internal alignment, and location.
 
 
 This role may also be eligible for annual incentive compensation and, where applicable, participation in Cboe's long-term equity programs.
 
 
 Additional information about Cboe's total rewards program, including benefits and other compensation components, can be found here: Total Rewards at CBOE.
 
 
 
 Any communication from Cboe regarding this position will only come from a Cboe recruiter who has a @cboe.com email or via LinkedIn Recruiter. Cboe does not use any other third party communication tools for recruiting purposes.
 
</div>

Stellar Solutions

<div>TITLE: Senior Data Analyst
Location: Chicago, IL (some travel to McLean, VA maybe required) 
Duration: 7+ months
Role Overview
We are seeking experienced Senior Data Analysts to support advanced data engineering and analytics initiatives. This role requires strong technical expertise, hands‑on problem solving, and the ability to work independently in a fast‑paced environment.
Core Technical Skills
<ul><li>Python / PySpark: Skilled in data processing using Databricks or Jupyter Notebooks.</li>
<li>SQL: Proficient in complex data manipulation and retrieval.</li>
<li>AWS (S3): Experience consuming and managing data in cloud storage.</li>
<li>Snowflake: Hands‑on background in cloud data warehousing.</li>
<li>Linux / Unix: Comfortable with shell scripting for navigation and automation.</li>
<li>Dashboarding / Visualization: Strong experience with tools such as Tableau, Power BI, or QuickSight.</li>
</ul>Preferred Qualifications
<ul><li>Capital One Experience: Familiarity with internal tools and ecosystem is highly valued for faster onboarding.</li>
<li>Proactive Learner: Ability to quickly adapt to new tools and processes without extensive documentation.</li>
<li>Self‑Starter: Demonstrated capability to take ownership of problems and drive solutions independently.</li></ul></div>

Senior Data Analyst

KellyMitchell Group

<div>
 
 
 Job Summary
 
 &nbsp;
 
 
 Our Financial Services client is seeking a&nbsp;Senior Data Analyst to join their team!
 
 
 &nbsp;&nbsp;
 
 
 Core Responsibilities&nbsp;
 
 
 <ul>
 <li>
 Act as key data lead to leverage versatile technical capabilities to drive the development, evolution, and implementation of data products, which enable self-service by data consumers
 </li>
 <li>
 Re-engineer data processes and migrate the processes from on-premises to Amazon Web Services
 </li>
 <li>
 Explore industry trends, tools, and techniques in Open Source/Big Data/Digital domain Business Intelligence
 </li>
 <li>
 Execute and monitor data processes that deliver critical data to partners and regulators
 </li>
 <li>
 Develop prototypes and implement new business intelligence tools, solutions, and techniques
 </li>
 <li>
 Assist in development of standards and policies for business intelligence frameworks Data Management
 </li>
 <li>
 Evaluate data management, data quality and data access processes for gaps, inefficiencies and opportunities; provide recommendations for improvement
 </li>
 <li>
 Implement solutions and processes for management and governance across data quality metrics, metadata, lineage, data access rights, and business definitions
 </li>
 <li>
 Develop data mapping to enable data end users to more easily transition to using new systems
 </li>
 </ul>
 
 
 Required Skills/Experience (Must-Haves)&nbsp;
 
 
 <ul>
 <li>
 Python/PySpark: Experience using Databricks or Jupyter Notebooks
 </li>
 <li>
 SQL: Experienced in data manipulation and data retrieval
 </li>
 <li>
 AWS: Experience with S3 for data consumption
 </li>
 <li>
 Snowflake: Hands-on experience with cloud data warehousing
 </li>
 <li>
 Linux/Unix: Comfort with the basics of shell scripting to navigate and automate
 </li>
 <li>
 Dashboarding: Experience with any visual reporting tool (Tableau, Power BI, QuickSight, etc.)
 </li>
 </ul>
 
 
 Preferred Skills/Experience (Nice-to-Haves)&nbsp;
 
 
 <ul>
 <li>
 Proactive Learner:&nbsp;can pick up new tools/processes on the fly
 </li>
 <li>
 Ability to take a problem and run with it without constant hand-holding
 </li>
 </ul>
 
 
 Key Competencies &amp; Behaviors&nbsp;
 
 
 <ul>
 <li>
 Proactive ownership
 </li>
 <li>
 Continuous learning mindset
 </li>
 <li>
 Collaborative communication
 </li>
 </ul>
 
 
 Work Environment&nbsp;
 
 
 <ul>
 <li>
 Location: Chicago, IL
 </li>
 </ul>
 
 
 Compensation &amp; Benefits&nbsp;
 
 
 <ul>
 <li>
 Pay Range: The approximate pay range for this position is between
 
 $32.00&nbsp;
 
 and
 
 $45.00
 
 . Please note that the pay range provided is a good faith estimate. Final compensation may vary based on factors including but not limited to background, knowledge, skills, and location. We comply with local wage minimums.&nbsp;
 </li>
 <li>
 Medical, Dental, &amp; Vision Insurance Plans&nbsp;
 </li>
 <li>
 Employee-Owned Profit Sharing (ESOP)&nbsp;
 </li>
 <li>
 401K offered&nbsp;
 </li>
 </ul>
 
 
 This position is W-2 only. We do not work with third-party firms or C2C arrangements for this role.
 
 
 
 About KellyMitchell&nbsp;
 
 
 
 At KellyMitchell, our culture is world class. We&rsquo;re movers and shakers! We don&rsquo;t mind a bit of friendly competition, and we reward hard work with unlimited potential for growth. This is an exciting opportunity to join a company known for innovative solutions and unsurpassed customer service. We're passionate about helping companies solve their biggest IT staffing &amp; project solutions challenges. As an employee-owned, women-led organization serving Fortune 500 companies nationwide, we deliver expert service at a moment's notice.&nbsp;
 
 
 &nbsp;&nbsp;
 
 
 Marketing Disclosure&nbsp;
 
 
 
 By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from KellyMitchell and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at https://www.careers.kellymitchell.com/privacy-policy
 
</div>

AllSTEM Connections

<div>
 
 
 Candidates will be disqualified if the following criteria are not met:
 
 
 <ul>
 <li>
 
 Employment Type: No C2C (Corp-to-Corp) or C2H (Contract-to-Hire) arrangements. W2 contract only. No referral fees will be entertained.
 
 </li>
 <li>
 
 Work Authorization: US CITIZEN and GREENCARD ONLY!!!
 
 </li>
 <li>
 
 Hybrid- Chicago, IL or an hour travel to Chicago, IL
 
 </li>
 <li>
 
 Experience in Power BI, SQL and Databricks.
 
 </li>
 <li>
 
 Build and manage Databricks notebooks, Delta tables, and data pipelines for transforming large datasets into curated analytical datasets.
 
 </li>
 <li>
 
 Design, optimize, and maintain complex SQL queries, views, and stored procedures to support analytics, self-service reporting, and data quality controls.
 
 </li>
 </ul>
 
 
 
 
 
 
 Requirements:
 
 
 
 
 Job Requirements:
 
 
 Required expertise: Power BI, SQL and Databricks.
 
 
 Design, optimize, and maintain complex SQL queries, views, and stored procedures to support analytics, self-service reporting, and data quality controls.
 
 
 Build and manage Databricks notebooks, Delta tables, and data pipelines for transforming large datasets into curated analytical datasets.
 
 
 Lead development, enhancement, and maintenance of Power BI dashboards, reports, and semantic models for executive and operational stakeholders.
 
 
 Collaborate with business SMEs to translate requirements into scalable data models, KPIs, and documentation across finance and operations use cases.
 
 
 Perform advanced data profiling, validation, and reconciliation across source systems, ensuring accuracy, performance, and adherence to governance standards.
 
 
 Provide SME-level guidance, code review, and best practices coaching in Power BI, SQL, and Databricks to internal analytics teams.
 
</div>

Allied Benefit Systems

<div>POSITION SUMMARY
The Senior IT Data Analyst is responsible for performing quantitative analysis of complex business situations, such as strategies, performance, and solutions involving sales and customer performance. They may apply SQL skills and database tools to conduct the analysts. The Senior IT Data Analyst will be responsible for various aspects of data analytics, such as programming, mining, generation, and visualization. As a technical lead, the data analyst will be responsible for resolving issues and ensuring the success of projects assigned to their team.
ESSENTIAL FUNCTIONS
<ul><li>Respond to data and product related inquiries in real-time to support business and technical teams.
</li><li>Provide expertise and translate the business needs to design; and develop tools, techniques, and metrics, and dashboards for insights and data visualization.
</li><li>Responsible for developing and executing tools to monitor and report on data quality.
</li><li>Responsible for establishing appreciation and adherence to the principles of data quality management, including metadata, lineage, and business definitions.
</li><li>Provide support to Tech teams in managing security mechanisms and data access governance.
</li><li>Develop an understanding of the health insurance world in different areas of the business such as claims, eligibility, customer service, and stop loss.
</li><li>Perform analyses of varied healthcare data to evaluate programs and product solutions using medical, dental, flex, pharmacy, lab, provider, and utilization data.
</li><li>Maintain high standards of data quality and integrity.
</li><li>Work closely with stakeholders to create dashboards and reports.
</li><li>Design and code efficiently using SQL and other data reporting languages.
</li><li>Help create and test SQL statements for data presentation and further automation.
</li><li>Set up and monitor routine maintenance of SQL jobs and developing / maintaining an alert strategy(s) for failed jobs and database problems and/or failures.
</li><li>Data modeling, including an understanding of all normalized forms, design and development of stored procedures, views, and triggers.
</li><li>Manage daily / monthly data and reporting processes automated through SQL Server agent.
</li><li>Create reports using a variety of tools and formats such as Excel, Power BI, PDFs, .txt files, etc.
</li><li>Document methods, specifications, and findings clearly; contribute to the writing and presentation of results, findings, and conclusions.
</li><li>Excellent attention to detail, ability to detect and correct problems within SQL script.
</li><li>Meet Allied&rsquo;s expectations for productivity, quality, and goal accomplishment.
</li><li>Work closely with the manager to complete assigned tasks.
</li><li>Adhere to, and apply all applicable privacy and security laws, including but not limited to HIPAA, HITECH and any regulations promulgated thereto.
</li></ul><ul><li>Attend continuing education classes as required, including but not limited to HIPAA training.
</li><li>Other duties as assigned.</li></ul>
EDUCATION<ul><li>
Bachelor&rsquo;s degree required with a focus in Computer Science, Math, Statistics, or equivalent work experience required.
</li></ul>EXPERIENCE AND SKILLS
<ul><li>4-5 years of data analyst experience required. Health care experience preferred.
</li><li>4 to 5 years&rsquo; experience with MS SQL Server required.
</li><li>Experience with SQL Server Development &ndash; creating and modifying complex stored procedures.
</li><li>Proficient with reporting and business intelligence tools like Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Integration Services (SSIS), and Power BI.
</li><li>Ability to collaborate well with team members.
</li><li>Experience working in a data warehouse environment as well as the ability to work with large data sets from multiple data sources.
</li><li>Proficient computer skills, including Microsoft Office Suite (Word, Excel, Access and Power Point).
</li><li>Demonstrated analytical and problem-solving skills.
</li><li>Strong written, verbal communication, and analytical skills are required.
</li><li>Usage of SQL Profiler.</li></ul><ul><li>
Experience with Power Automate.
</li><li>Knowledge of integrating SQL Server solutions in .NET environments, with working knowledge of C#, ASP.NET and SOA with web services.
</li></ul>POSITION COMPETENCIES<ul><li>
Accountability</li><li>
Analytical Problem Solving</li><li>
Collaboration</li><li>
Quality and Risk Management</li><li>
Systems Thinking</li><li>
Technical/Functional Expertise</li></ul>
PHYSICAL DEMANDS<ul><li>
This is a standard desk role requiring extended sitting and computer work</li></ul>
WORK ENVIRONMENT
<ul><li>Remote</li></ul>
Here at Allied, we believe that great talent can thrive from anywhere. Our remote friendly culture offers flexibility and the comfort of working from home, while also ensuring you are set up for success. To support a smooth and efficient remote work experience, the internet connection must be obtained through a cable broadband or fiber optic internet service provider with speeds of at least 100Mbps download/25Mbps upload. Reliable internet service is essential for staying connected and productive.
The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills, and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.
Compensation is not limited to base salary. Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life and Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.
Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time. All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process. It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.</div>

Senior IT Data Analyst

Explore 433+ Data analyst in Chicago this May. Find roles across top companies and apply now to boost your career.

433 data analyst jobs In Chicago

Data Analyst

Data Analyst

Data Analyst

Senior Data Analyst

Senior Data Analyst

Data Analyst

Senior IT Data Analyst