What are the responsibilities and job description for the LOCAL to ST. LOUIS ONLY - Sr Data & Reporting Analyst (x2) SQL, dashboards - Must be GC, Citizen, H4 or TN Visa position at neteffects?
Sr Data & Reporting Analyst - 2 openings
Location: Maryland Heights, MO – Onsite 4 days a week
Sr level
#1 skills is SQL and building reports and dashboards - Using SQL (basic queries, joins, some stored procedures) to troubleshoot reporting issues, billing reports, and data analysis
Build star schemas in SAP Hana DB (this is a plus) to bill reports
They use Business Objects for reports but will consider any tool - Tableau, PowerBI, etc.
This role will interact with the business. Able to talk to user and figure out requirements.
Someone that can manage their own priorities, self-managed, and proactive personality - personality is everything!
This person must be detail-oriented so the manager pays close attention to both your LI account and resume since it’s a representation of the candidate.
They are currently working on a requirement gathering data for an RPA tool so any RPA experience is a plus
Summary
Responsible for managing complex data and reporting to better assist management in maximizing resources in various departments or lines of business. Responsible for creating and producing forecasts, reports, ad hoc requests, dashboards, etc. in order to provide insights to determine operational impact, trends, and opportunities. This role requires thorough understanding of business analysis and data methodology.
Duties
Conduct complex data analysis in support of a variety of analytic solutions
Capture, develop, and document data definitions, business rules, and data quality requirements
Integrate data from multiple sources to produce requested or required data elements
Create and produce forecasts, reports, ad hoc requests, dashboards, etc.
Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunities
Develop reports and deliverables for management and communicate with all levels of stakeholders
Identify and define data quality improvements
Create and maintain report forms and formats, information dashboards, data generators, canned reports and other end-user information portals or resources
Ensure compliance with deliverable reporting requirements by performing quality data audits and analysis
Create specifications for reports based on business requests
Identify opportunities to use data to develop new strategies and improve business performance and utilize knowledge of mathematical modeling and other optimization methods to perform quantitative and qualitative data analysis
Skills
Data analysis and reporting or related experience - 5 years of experience
Ability to prioritize and organize effectively
Ability to work independently, as well as in a collaborative and dynamic team environment
Ability to handle multiple projects and priorities
Ability to analyze and interpret data
Ability to quickly identify business problems/opportunities
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
Knowledge of software applications such as Word, Excel, etc.
Demonstrated knowledge of SQL
Salary : $95,000 - $105,000
