Business Intelligence Analyst - Grapevine

Employer
  • Paycom Payroll Llc

Job Description

The role will be responsible for basic and routine level projects assisting with the development and deployment of internal reports to aide with new and established IMS initiatives. The goal is to help internal departments use this information to gauge success or derive insight into these business practices through developing reports and data visualizations.

 

Responsibilities

  • Process and develop general reports of for departments to help understand key business metrics.
  • Involved in requirement discussions to establish reporting and analytics for business units around processes to provide clarity and insight.
  • Assist with the design, building, and deployment of dashboards and reports.
  • Participate in project brainstorming sessions.
  • Assist with the development of processes, projects, and reports for continuous improvement.
  • Work and communicate timely with internal customers to assist, problem solve, and complete projects.
  • Research issues to find resolutions essential to completing tasks.
  • Maintain a continuous integration development workflow. Coordinate implementation & deployments to testing and production environments.
  • Develop custom queries by examining databases in Microsoft SQL Server Management Studio (SSMS) to extract data using Structured Query Language that fulfills the needs of customer requirements and follows established business rules

Education/Certification:

  • Bachelors Degree, preferably in MIS or CS, or 5 years of experience in data analytics or business intelligence solutions development.

 

Skills/Abilities:

  • SQL knowledge and experience writing SQL queries and stored procedures.
  • Familiarity with Microsoft Report Builder and Microsoft SQL Server Reporting Services (SSRS), Microsoft SQL Server Management Studio (SSMS) or equivalent tool is preferred.
  • Experience with SSAS and Microsoft DAX Language a plus
  • Familiarity with SSMS, Crystal Reports, Business Objects, Spotfire, Qlik, SAS, Tableau, R, Splunk or Microsoft Power BI experience a plus.
  • Familiarity with star-schema data models a plus.
  • Basic knowledge of dashboard design and visualization.
  • Ability to research data source viability and quality for use in projects.
  • Self-Starter willing to take initiative to fulfill requested requirements.
  • Ability to work in conjunction with team in fast paced work environment.
  • General ability to both learn and teach in a team environment.
  • General ability to solve problems while working toward optimum solutions.

Paycom is an equal opportunity employer and prohibits discrimination and harassment of any kind. Paycom makes employment decisions on the basis of business needs, job requirements, individual qualifications and merit. Paycom wants to have the best available people in every job. Therefore, Paycom does not permit its employees to harass, discriminate or retaliate against other employees or applicants because of race, color, religion, sex, sexual orientation, gender identity, pregnancy, national origin, military and veteran status, age, physical or mental disability, genetic characteristic, reproductive health decisions, family or parental status or any other consideration made unlawful by applicable laws. Equal employment opportunity will be extended to all persons in all aspects of the employer-employee relationship. This policy applies to all terms and conditions of employment, including, but not limited to, hiring, training, promotion, discipline, compensation benefits, and separation of employment. The Human Resources Department has overall responsibility for this policy and maintains reporting and monitoring procedures. Any questions or concerns should be referred to the Human Resources Department. ****To learn more about Paycom's affirmative action policy, equal employment opportunity, or to request an accommodation - Click on the link to find more information:

more