• Grow as the subject matter expert for analytics, data environment, and report design, offering quick insights and suggestions on the potential needs and problems that need to be solved.
• Manage a variety of requests coming from various feature teams and stakeholders.
• Maintain, support, and document reports, reporting tools and report definitions.
• Work closely with Product, Stakeholder and feature teams to support analysis needs.
• Be a data advocate working across the company to understand how data outputs affect different groups and identify areas where we can provide additional value.
• Define the Intake process for reports and inquiries including process, intake requirements, acceptance criteria.
• Use available data from external tools like Google Analytics, SendGrid to provide data to provide analytics required to measure impacts of marketing, communications.
• Analyze data needs and determine any needs that may be resolved through automated, repeatable processes.
• Work with technology teams to develop and deliver dashboards, reports, and scorecards to inform business performance
• Assist with data modelling / analysis with a variety of data types
• Promote best practices to access and use the information available in the Data Warehouse
• Build the BI reporting presence through delivery of high value reporting solutions to the business with emphasis on self-service reporting capability
• Manage data and enhance current processes through system developments that improve process efficiency
• Identify potential areas of efficiency and performance improvements / automation of existing reporting functionality

Skills: Analytics Expertise, Stakeholder Management, Reporting Tool Maintenance, Cross-Departmental Collaboration, Data Analysis and Advocacy, Process Definition and Management, Advanced Data Tool Utilization, Business Intelligence Development

• Learn and understand nuanced regulatory requirements and technical functionality across multiple data management systems.
• Collaborate with cross-functional team members to understand, review, and solve outstanding data needs.
• Actively listen to internal and external customer needs, prioritize tasks, efficiently troubleshoot problems, and recommend solutions in a timely manner.
• Support Brands and Sales Operations with frequent, ad hoc customer requests, including compliance data gathering.
• Actively engage with Brands+ product suppliers to gather data that cannot be found in established systems.
• Establish a technical point of contact regarding Brands+ customer data on-boarding needs. 
• Thoroughly analyze and identify incomplete or inaccurate information to ensure data integrity is maintained.
• Responsible for accurate and efficient data entry into internal and external data systems.
• Effectively manage priorities to ensure on-time delivery of accountabilities.
• Provide key technical internal support for any relevant data management activity.
• Participate in systems improvement initiatives to influence process efficiencies.
• Run detailed queries and reports and translate data into Excel or other functional formats.
• Develop report queries, views and SSRS reports to provide analytics and data to feature team stakeholders, Product Managers, and business decision makers.
• Provide data support and reporting to stakeholders ranging from one-time ad-hoc data investigations to building automated reports used daily.
• Utilize SQL Server, SSRS and Excel to provide data analysis and support to clients and internal stakeholders.

Skills: Regulatory Compliance Understanding, Cross-functional Collaboration, Customer Service Excellence, Data Integrity Analysis, Data Entry Proficiency, Priority Management, Advanced SQL and SSRS Usage, Report Development and Automation

• Develop and plan required analytic projects in response to business needs.
• In conjunction with data owners and department managers, contribute to the development of data models and protocols for mining production databases.
• Handling structured and unstructured Data with multi-dimensional supervise and Unsupervised Machine Learning Algorithms (Regression, Classification, Clustering, Forecasting) for meaningful insights.
• Visualize the data in order to portray correct solution against the given business problem.
• Develop new analytical methods and/or tools
• Contribute to data mining architectures, modeling standards, reporting & data analysis methodologies.
• Work with application developers to extract data relevant for analysis.
• Write advanced SQL queries for data extracts and schedule metric jobs as needed by the business
• Construct traditional reporting solutions by designing Excel-based templates and publish those as PDFs, to be included in WBR decks
• Create new Tableau dashboards and revise existing dashboards 
• Partner with AMXL Business Analytics team on joint initiatives and reports
• Build a strong understanding of the backend data sources for AMXL such as AWS Redshift clusters and global performance reporting tables, etc.
• Create and analyze sales and retention campaign performance reports, develop target lists for acquisition and retention campaigns, analyze sales results to discover and interpret trends, patterns, and relationships. 
• Monitor and evaluate overall sales and retention performance and identify opportunities. 
• Working with the team, help ensure achieve campaign goals and present data in a way that makes it easy to communicate at the highest levels of the company. 

Skills: Analytic Project Development, Data Modeling, Machine Learning Application, Data Visualization, Advanced SQL Proficiency, Tableau Dashboard Creation, Sales Campaign Analysis, Strategic Business Partnership

• Participation across the CPR Programme lifecycle including analysis and design workshops, data migration, integration, testing, training, implementation and transition to business as usual.
• Supporting the CPR Data Migration Lead, with the financial reconciliation process, reviewing and reconciling Financial data throughout the planned 9 ETL’s, and Historic Data in the Data Platform
• Supporting the definition and development of all Financial reporting: liaising with the CPR Domain Leads, BE and Group finance team and other SMEs to agree, document and support the development of effective & robust financial reporting
• Working with the CPR delivery team to support development of the UMAX data structure for management reporting, agreeing appropriate changes to the Chart of Accounts and the Oracle GL system integration, supporting acceptance testing for all financial reporting and the Oracle integration.
• Working with the CPR delivery team, Data Platform team, CPR Domain leads, BE Finance and Group Tax team on the historic data reporting requirements for data from CS and other associated applications that will not be migrated to UMAX.
• Identify implications of project design on finance reporting, available information, and ensure risks are highlighted in a timely manner so that informed decisions can be made
• Support the Finance team and areas of the business that link to Finance pre-implementation, including UAT and business readiness checks on the Chart of Accounts and reporting throughout dual running and transition to business as usual.
• Work within various time constraints to meet critical business needs, deep dive large datasets to uncover trends and identify root causes for performance misses, while ensuring service requirements are met

Skills: Program Lifecycle Management, Financial Data Reconciliation, Financial Reporting Development, Data Structure Optimization, Historical Data Analysis, Financial Impact Analysis, User Acceptance Testing Support, Trend Identification and Analysis

• Develop efficient dashboards and provide clear visual reporting of digital media ROAS
• Leverage statistical & predictive analysis and let data guide campaign decisions
• Analyze raw data and campaign results to generate actionable insights
• Ongoing digital campaign report creation, and optimization, heavy data analysis, and A/B testing
• Analyze performance from campaigns within vendor platforms to improve efficiency
• Develop reports for various stakeholders to drive decision-making process for campaigns
• Leverage data in the correct manner to ensure reporting is accurate
• Collaborate with teams to improve digital campaigns
• Competitive research, analysis and reporting
• Support ad-hoc marketing insight requests
• Monitors, analyzes, and reports marketing metrics and outcomes of marketing performance and programs
• Utilize internal databases and reporting tools to generate daily/weekly/monthly reporting
• Build, validate, query, and analyze reports/models from large datasets using tools like Tableau, Access or Excel
• Proactively, independently and thoughtfully develop reporting tools
• Manage multiple activities under tight deadlines to ensure timely and accurate completion of responsibilities

Skills: Dashboard Development, Statistical & Predictive Analysis, Data-Driven Decision Making, Campaign Performance Analysis, Stakeholder Reporting, Data Accuracy Assurance, Cross-Functional Collaboration, Advanced Reporting Tools Mastery

• Reviewing entry level data analysts’ performance of established processes that monitor the integrity and reasonability of data using Excel, Access and other programs.
• Performing quality control checks to monitor the reasonability and consistency of databases, relying on analysis performed by entry level data analysts and database reports from third-party administrators.
• Ensure weekly processes are consistently run correctly and in a timely manner
• Updating processes and programs
• Making recommendations to management for changes in processes to improve efficiency and accuracy.
• Performing UAT testing of new or changed processes and report issues to management and internal developer.
• Communication with employers, if necessary, to ask questions regarding accuracy of data.
• Reviewing analysis of employee contribution collection to identify potentially incorrect contribution amounts, missing contributions and late contributions and communicate findings with employers to remedy issues.
• Conducting reviews of independent data provided by employers to internal records to ensure accuracy of data and compliance with plan rules, including follow-up interactions via phone and email to resolve issues.

Skills: Data Integrity Monitoring, Quality Control, Process Management, Process Improvement, UAT Testing, Stakeholder Communication, Data Analysis Review, Compliance Review

• Developing records management processes and policies
• Identifying areas to increase efficiency and automation of processes
• Setting up and maintaining automated data processes
• Producing and tracking key performance indicators
• Developing and supporting reporting processes
• Designing and carrying out surveys and analysing survey data
• Preparing reports for internal and external audiences using business analytics reporting tools
• Creating dashboards, graphs and visualisations
• Mining and analysing large datasets, drawing valid inferences and presenting them successfully to management

Skills: Records Management, Process Automation, Data Automation, Performance Tracking, Reporting Support, Survey Analysis, Data Reporting, Data Mining

• Generate a variety of regular and ad hoc reports/queries from PeopleSoft. 
• Reports include, but are not limited to: headcount, compensation reports, turnover reports, attrition reports, annual budget reports, and employee data reports.
• Writing, maintaining and supporting PeopleSoft reports and queries.
• Act as a gatekeeper for creation of new reports and Queries in PeopleSoft.
• Assist in the compilation and analysis of data for Affirmative Action reporting.
• Compile and submit annual EEO-1 and VETS-100 reports, and other governmental reports
• Assist with automation of reports to further streamline processes.
• Assist in building and monitoring interfaces from PeopleSoft to other systems.
• Perform PeopleSoft system maintenance by updating various HR tables as needed, including job codes, locations, cost centers, performance evaluations, schools, security, etc.
• Assist with test scripts and maintenance validation testing after each maintenance pack/upgrade is applied or during system testing for new systems and modules. 
• Oversee and coordinate validation testing with other teams such as Benefits and Payroll.

Skills: PeopleSoft Reporting, Report Management, Data Analysis, Government Reporting, Report Automation, System Integration, System Maintenance, Validation Testing

• Complete a variety of external salary & benchmarking surveys using data from PeopleSoft, Firm Directory, and other relevant systems.
• Conduct various data audits within PeopleSoft to ensure accuracy (e.g., compensation figures/frequency, hire data, termination data, prior/next employer, years of experience, etc.)
• Assist in regular and ad hoc audits of data, including but not limited to PeopleSoft, Firm Directory, and miscellaneous databases and spreadsheets.
• Work with IT on annual HR data uploads.
• Oversee and ensure that procedures exist for all HRIS-related functions. 
• Drafting and/or reviewing procedures for completeness and accuracy and updating
• Maintain awareness of current trends in HRIS and examine trends to improve current processes.
• Assist with improvement of HR procedures and practices to ensure efficient operations.
• Act as back-up to the HR Managers, HR Supervisor and HR Specialists 
• Assist with HRIS projects and processes 

Skills: Salary Benchmarking, Data Auditing, Data Management, IT Collaboration, HRIS Procedures, Procedure Drafting, Process Improvement, HRIS Support

• Establish and develop productive relationships with clients in order to understand their particular objectives, environment and challenges.
• Conduct requirements gathering and scoping around client reporting / dashboarding needs
• Develop custom SQL queries and data tables in line with client reporting requirements to inform dashboard development
• Develop custom PowerBI queries and dashboards
• Maintain daily refresh of SQL data pipelines to ensure data accuracy
• Effectively and quickly troubleshoot issues with reporting pipelines to ensure overall data integrity and accuracy of reports.
• Maintaining effective rapport and relationships with employers on behalf of clients to include liaising as needed with outside vendors.
• Assisting with annual data projects such as actuarial valuation, employee benefit statements and employer census verification.
• Reviewing employee benefit calculations.
• Assisting with updating plan administrative forms, documents and literature 
• Assisting with updating and maintaining relevant plan material on the website.
• Preparing weekly reports.

Skills: Client Relationship Management, Requirements Gathering, SQL Development, PowerBI Development, Data Pipeline Management, Issue Troubleshooting, Stakeholder Liaison, Data Project Assistance.

• Advanced skills in T-SQL
• Progressive experience using reporting tools such as SSRS and Excel. 
• PowerBI, Tableau, or other visualization tool
• Experience in analyzing large data sets
• A track record of success in effectively communicating requirements, criteria, and results - both internally and with the client
• Previous demonstrated experience in utilizing Excel in a professional environment including creating and running Pivot Tables and Macros, experience with conditional formatting, templates and formulas.
• Experience in project management and Lean Six Sigma
• Self-starter, exercises high degree of initiative, judgement, discretion and decision making to achieve objectives
• Strong attention to detail.
• Analytical and creative thinker with problem-solving skills.

Qualifications: BA in Business Analytics with 4 Years of Experience

• Previous experience in a data reporting position, preferably working as a reporting Analyst in a fast-paced results-driven business setting.
• Experience managing or owning a process involving multiple divisions and individuals.
• Previous experience in using various programming languages, with experience in R and/or Python 
• Proficient in MS Word, Excel, PowerPoint as well as SQL, or other equivalent tools, Power BI, Tableau or other visualization tools
• A strong background in reporting and analytics in advanced Excel
• Proven experience in SAP reporting suites and analytical platforms such as BOBJ, BI, Analysis for Office, and Analytics Cloud
• Be able to quickly establish yourself in the role, build internal relationships and become an indispensable part of the business
• Experienced with developing models that achieve objectives with minimum required complexity
• General problem-solving abilities

Qualifications: BS in Statistics with 4 Years of Experience

• Coursework or related certifications in data science, statistics or machine learning 
• Experience in the health and benefits ecosystem at a data warehouse, consulting firm, health insurance carrier, or health analytics team
• Experience working with large health claims datasets
• Strong working knowledge writing SQL queries and scripting languages (e.g. R, Python, ggplot2)
• Strong presentation and communication skills and ability to convey technical analyses and information in a clear and concise manner to a wide variety of stakeholders
• Experience building and designing creative and scalable solutions and dashboards in data visualization tools (e.g. Tableau, Power BI, and vendor-specific data warehouse reporting systems)
• Experience in data cleansing, exploratory analysis and predictive analytics
• Good applied statistics skills such as distributions, statistical testing, regression, etc.
• Understand the importance of performance and able to implement best practices in ensuring performance and maintainability for data-centric projects
• Knowledge of Agile Scrum and Continuous Delivery practices is desirable

Qualifications: BA in Computer Science with 6 Years of Experience

• Data analysis and reporting or related experience 
• Expert level knowledge of SQL
• Ability to analyze and interpret data
• Ability to quickly identify business problemsopportunities
• Ability to communicate orally and in writing in a clear and straightforward manner
• Ability to communicate with all levels of management and company personnel
• Ability to manage multiple projects at one time
• Ability to document, prepare and present data-driven presentations
• SQL Experience
• Knowledge of Databases and Visualisation Tools like Tableau/PowerBI
• Desire to learn and grow technical and non-technical skills
• Experience with other programming languages like Python/R/SAS is also desirable

Qualifications: BA in Information Systems with 8 Years of Experience

• Experience in SQL, Excel, Splunk and data analysis/management.
• Experience with Patching and Vulnerability Management.
• Experience in ITIL and IT Service Management.
• Experience in SharePoint.
• Experience working with large datasets and relational databases.
• Experience in Patching and/or vulnerability management related field.
• Certification in Data Analytics and information Security topics.
• Knowledge and understanding of large IT organizations.
• Knowledge and thorough understanding of IT service level management including formulas for calculating metrics and KPI's.
• Have strong analytical, statistical, mathematical and/or predictive modeling skills.
• Knowledge of Understanding of Qualys, SQL, Excel and Data Management/Analytics.
• Knowledge of and practical experience with IS topics.

Qualifications: BS in Data Science with 5 Years of Experience

• Python programming skills
• Experience performing unit testing
• Developing automation and code that is scalable
• Good communication skills and Agile project experience
• Motivation to take ownership of tasks and the determination to drive them to completion
• Experience with SQL Server, Tableau and writing queries 
• Experience working in a team-oriented, collaborative environment
• Ability to work independently 
• Experience within the staffing industry and Power BI 
• Experience with Microsoft Access, Tableau and SQL 

Qualifications: BA in Economics with 2 years of Experience

• Strong knowledge of manual and automated business systems design and programming techniques
• Strong planning and organizational skills and strong interpersonal skills
• Strong oral and written communication skills
• Proven analytical ability and experience in insurance industry 
• Demonstrated ability to work independently to meet project deadlines
• Demonstrated knowledge of Microsoft Windows applications
• Demonstrated knowledge of programming languages Sequel, SQL, SAS, COBOL and RPG.
• Related data analysis and reporting experience.
• Background in the mortgage industry 
• Analytical and detailed with strong critical thinking skills.
• Excellent multi-tasking and time management skills with the ability to meet competing deadlines.

Qualifications: BA in Business Administration with 5 years of Experience

• Strong leadership and organizational abilities, demonstrated through related work experience.
• Outstanding decision making, active listening and consultation skills.
• Ability to work both cooperatively with all levels of management, persons of differing skill sets and as an individual contributor.
• Strong process orientation with the ability to understand the strategic and tactical link between business processes and the financial success of the business.
• Flexible to work on multiple projects/assignments at once when there is no ability to handle a single ask from start to finish.
• Proficient in data mining via SQL through various data sets and relational databases.
• Mastery of developing ETL workflows to aggregate data from multiple sources with tools like Alteryx or Python.
• Experience creating compelling visualizations in the form of operational dashboards in Tableau or Power BI.
• Ability to automate ETL workflows and publishing of data to dashboards as well as error logging to alert the team when automation fails.
• Solid analytical and reasoning abilities, including high level of strategic thinking and ability to articulate strategy through the analysis of data and presentation to all levels of the business.
• Expert in translating metrics and reporting concepts to all levels of the organization.
• Excellent project management skills with proven track record of effectively managing large, complex projects on time and to completion.

Qualifications: BA in Marketing Analytics with 6 years of Experience

• Excellent critical thinking skills to help solve business problems and make decisions
• Able to notice small details that could impact results
• Must be able to effectively relate data to coworkers using verbal and written communication skills
• Skilled in time management and prioritization to meet project deadlines
• Experience as a financial or business analyst
• Demonstrated ability to create pivot tables, graphs, and charts from data tools
• Strong analytical skills that allow for the development of data-driven reports
• Familiarity with object-oriented programming and other data analysis programs
• Familiarity with business operations, objectives, strategies, process and information flow

Qualifications: BA in Accounting with 3 years of Experience

• Experience working with BI Tools such as Sisense, Power BI, Tableau, etc.
• Experience working with cloud based solutions such as AWS.
• Comfortable with SQL and have the ability to customize reports
• Proficient with Microsoft Office 365
• Experience in a similar role working with data entry, analysis, and reporting. 
• Experience with Learning/Education data sets.
• Technology Must have basic Excel/Gsheets/Gslides proficiency.
• Knowledge of advanced Excel functions 
• Strong written, verbal, and interpersonal communication skills

Qualifications: BA in Business Analytics with 5 years of Experience