Senior Data Analyst position at Cadent Technology

Senior Data Analyst, Business Intelligence

Cadent Technology

POSITION SUMMARY

The primary duty of the Senior Data Analyst is to provide analytical support to all business users across Cross MediaWorks. This position will act as a team lead in the department that manages initiatives to enhance and maintain Cross MediaWorks analytical environment.  Also, the Senior Data Analyst will review internal processes, suggest enhancements and take action to implement approved solutions.  A successful team member in this position will implements advanced analytical thinking to tasks.  This position will also act as a mentor to coworkers, transferring knowledge to enhance the skill sets of peers.

PROJECT DUTIES / RESPONSIBILITIES

·        Document new learnings of end user terms, data, metric and processes and translate business needs into well formulated business questions.

·        Develop wireframes, visual designs, and prototypes based on requirements from the end user.

·        Generate work flow diagrams that provide clear visibility into business processes.

·        Maintain documentation on all processes and procedures.

·        Track tasks and task hours in Team Foundation Server (TFS).

·        Identify and alert BI management of any discovered data inaccuracies.

·        Meet with BI management to update on project milestones.

·        Review reports for accuracy and data integrity.

·        Document use cases and data verification steps for QA.

·        Train SMEs on reporting and research tools.

·        Provide end user support during User Acceptance Testing (UAT).

·        Create and submit Business Requirement Documents (BRD), Request for Change (RFC) and Method of Procedure (MOP) as required.

·        Create detailed technical documents detailing BI projects and user guides with clear step by step instructions.

·        Migrate projects from development into production.

·        Create sites and logins when required.

ADDITIONAL DUTIES / RESPONSIBILITIES

·        Track and report against key corporate and departmental KPIs.

·        Comply with policies associated with the use and access of data.

·        Audit databases for inaccuracies.

·        Complete ad hoc research requests from management.

·        Document ad hoc workflows and provide support for automation.

·        Contribute to a team environment and complete required training to improve skills.

·        Guide junior staff in maintaining end user reports and dashboards.

·        Review and provide feedback on work completed by Junior Data Analysts as assigned.

·        Research new trends in data visualization.  Attend seminars and conferences.  Document learnings and transfer knowledge to the BI team.

·        Research vendor products that can create greater departmental workflow efficiencies or innovative solutions to business needs.

·        Provide direction and analytical support to IT on projects and initiatives.

·        Examine how specific functions of the company are performing and advise management through meetings and reports of suggested enhancements.

·        Identify, analyze and interpret trends/patterns in large datasets.

·        Produce presentations for internal and external corporate meetings.

·        Perform other tasks as assigned by management.

ACCOUNTABILITIES & KEY MEASURES OF SUCCESS

·        Financial metric(s): Focus and specialize in automation techniques and programmatic thinking to mitigate resource waste and increase project throughput.

·        Operating metric(s): Strict adherence to the timelines established for the project.  Quick resolution of any conflicts that might affect on-time completion of tasks.

·        Qualitative metric(s): Work as a team with other BI personnel and coordinate any efforts with other departments involved in the same projects.  Contributes to a positive team environment.

·        Technology metric(s): Expand knowledge of current tools and discover new ways to provide greater analytical impact to end users.

·        Implementation metric(s): Successful deployment of BI solutions to end users meeting all documented requirements.

REQUIREMENTS

Technical/Functional Competencies  

·        Ability to work independently and with a team to achieve department objectives.

·        Detailed oriented with advanced analytical abilities.

·        Strong communication and presentation skills.

·        Interest in learning new tools through cross-training and independent study.  Takes action to integrate new skills into daily activities.

·        Ability to prioritize multiple tasks and meet deadlines assigned by management.

·        Ability to collaborate across the organization to meet the needs of internal and external customers.

Key Experiences/Achievements 

·        5+ years work experience in an analytical position.

·        Bachelor’s Degree in Business, Economics, Mathematics, Statistics, Finance, Accounting or related field experience (advanced degree preferred)

·        Advanced knowledge of Microsoft Excel (Pivot Tables, Lookups, Formulas, Graphs).

·        Proficient in all Microsoft products.

·        3+ years experience in SQL.  SSIS and SSRS experience preferred.

·        1+ years experience in Tableau, Pentaho, Qlik or other data visualization tools.

·        Understanding of the SDLC (Software Development Life Cycle).

·        Strong Knowledge of Relational Database design (OLAP & OLTP). Data Warehouse design or Big Data technologies (SPARK, HDFS) preferred.

·        1+ years C#, JavaScript, Python or R experience preferred.

·        Understanding of the media business model, media buys, media math and media metrics preferred.

·        Experience in the media industry preferred.

SALARY: $55,000 - $75,000

DESIRED MAJORS: Finance, Accounting, Business Administration, Mathematics, Computer Science

TO APPLY: Email resume to ehartman@cadent.tv