Sr. Analyst, Reporting & Analytics

U.S. Cellular Chicago , IL 60602

Posted 3 weeks ago

Sr. Analyst, Reporting & Analytics - MAR001113

The SANDS team is responsible for delivering data solutions, analytical tools, campaign execution, and business insights to our stakeholders in Marketing, Finance, Customer Service, and Sales Operations. The Sr. Analyst, Reporting and Analytics is responsible for Ad-hoc analytics and reporting as well as delivering critical data projects, and end-user computing application development. The individual will work on complex assortment of analytical and systems development initiatives which require highly complex data investigation and programmatic manipulation to respond to business questions or operational challenges posed by key stakeholders across the organization.


Section 2

  • Collaborate with stakeholders and team members to support both enterprise and departmental projects that involve ad-hoc reporting, analysis, ETL, end-user-computing application development, and/or data visualization.

  • Complete needs analysis and requirements gathering process with stakeholders, and then code, test, deliver, and support technical processes to extract new data and complete ad-hoc analyses.

  • Present ad-hoc analysis results or end-user computing applications directly to stakeholders.

  • Leverage advanced knowledge of SQL, SAS, Tableau and other tools to develop business metrics, KPI's (e.g. Gross Adds, Churn, ARPU/ARPA, cost to serve).

  • Complete geographic and customer analysis, life-time value, behavioral profiling and segmentation analysis across Sales, Marketing, Roaming, and Finance .

  • Develop, test, and execute programing methods and procedures to support requests for product and price plan auditing, analysis, and ad-hoc reporting.

  • Development of SQL, MS Visual Studio, and SharePoint applications for the Finance Organization (300+ associates).

  • Works independently to analyze and interpret project needs, determines scope and report / analysis content; maintain regular communication and coordinate with team members and stakeholders throughout project.



  • Bachelor's degree in a relevant field (computer science, operations research, statistics, economics, computational finance, etc.) required; or equivalent analytical, programing, or business experience.

  • Minimum of 5+ years of hands-on technical experience, including complex analysis, and development of end-user. computing application projects; ability to manipulate large, complex data structures to meet business reporting and auditing requirements; ability to convert functional requirements into technical design; experience in ETL process development.

  • Ability to transform raw data into actionable insights that translate directly to improved business results

  • Advance knowledge of RDMS, Billing, and ERP systems with 5+ years' experience in data extraction and manipulation from these systems using tools such as SQL, SAS.

  • 5+ years hands-on experience with ad-hoc analytic, reporting, and data visualization tools, as well as experience developing EUC applications with the MSDN application development environment.

  • Strong written and verbal communication skills.

  • Ability to think analytically and technically about a qualitative or quantitative business problem and apply mathematical, business, technical, and industry acumen to develop solutions and EUC applications.

  • Exceptional time and project management experience

  • Ability to break down complex problems into. milestones, prioritize work, maintain progress, and communicate status as well as results across stakeholder teams.


Section 4

  • Cognos or Tableau preferred

  • Knowledge of Hadoop and Big Data technologies preferred (Hive, Map Reduce, Impala, etc.)

  • Knowledge of applied financial techniques to measure business impact preferred (e.g. ROI, NPV)

  • Prior experience in wireless industry or similar service provider preferred

Job : Marketing

Location(s) : Illinois-CHICAGO_IL

U.S. Cellular is an EEO employer and gives consideration to qualified applicants without regard to race/color/age/religion/sex/sexual orientation/gender identity/national origin/disability/veteran status, pregnancy or genetic information.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Sr Analyst Reporting & Analytics


Posted 2 weeks ago

VIEW JOBS 4/3/2019 12:00:00 AM 2019-07-02T00:00 Passionate about making a difference in the world of cancer genomics? With the advent of genomic sequencing, we can finally decode and process our genetic makeup. We now have more data than ever before but providers don't have the infrastructure or expertise to make sense of this data. We're on a mission to connect an entire ecosystem to redefine how genomic data is used in clinical settings. What You'll Do: * Provide timely ad hoc analyses via SQL for our Next Generation Sequencing Lab * Perform robust root cause analyses for laboratory and operational investigations * Define KPI's and develop tools to monitor business metrics * Own the design of advanced analytics dashboards and KPI reports in our BI tool starting from requirements gathering across cross-functional teams to the delivery of final, polished reports in production * Design SQL scripts that can be easily manipulated to efficiently address similar future analyses * Work closely with technical and product teams to drive changes to our systems to support future analyses * Serve as the laboratory's subject matter expert for advanced analytics and report design, offering insights and suggestions on what potential problems the team should be solving * Develop initiatives to assure data integrity * Train end users on new reports and dashboards Qualifications: * Bachelor's degree in Finance, Mathematics, Computer Science, Statistics, Economics, Engineering or similar * 3-5 years of experience in an analytical role with a heavy focus on querying data, analyzing and clearly presenting analyses to stakeholders across the organization * Minimum 3 years report-development and data visualization experience, leveraging the most current BI tools (Tableau minimum, others applicable) * Demonstrated advanced technical skill, knowledge of data systems and query languages * High SQL aptitude, experience working with at least one scripting language * Ability and interest to quickly ramp up on laboratory processes in the field of next generation sequencing * Ability to deliver both high-level explanations of complex problems while also able to deep dive into complex problems * Must work well in a team environment and be able to partner with both business and technical team members and translate technical language to the non-technical need * Creative problem solver, ability to handle multiple projects, and strong work ethic needed * Excellent written and verbal communication skills * Highly organized and systematic, superb attention to detail * Able to complete tasks with a high degree of accuracy and an eye towards process improvement * Persistent and resilient person who thrives in a fast-paced, highly iterative environment Tempus Chicago IL

Sr. Analyst, Reporting & Analytics

U.S. Cellular