Previous Job
Sr. Data Analyst
Ref No.: 18-00163
Location: Holmdel, New Jersey
Position Type:Contract
Start Date: 11/05/2018
Job Summary:
The Portfolio Delivery Metrics team is seeking an experienced and resourceful Senior Data Analyst to work in a fast-past highly visible role. The candidate will work closely with the Agile Managers, Business PMOs, Technical Teams and Analysts to analyze and validate data requirements, assist in data discovery, build test datasets, document data flows and transformations and help in quality assurance activities such as writing test cases, test scripts and conducting system entry assessments. Must be analytical, detail oriented, and possess desire to advance and grow personally and professionally.
  • 5+ years of industry experience in a Data Analyst role
  • Expertise in using MS SQL and other data access / browsing tools
  • Proficient in using MS Excel (i.e. Pivot Tables)
  • Ability to write complex queries using multiple data sources
  • Experience developing reports and/or dashboards preferred
  • High level of competency in data manipulation and analysis: accessing raw data in varied formats with different methods and analyzing and processing data
  • Knowledge of at least one statistical analysis tool I.e. Python, SAS or R
  • Experience in data profiling methods and methodologies
  • Data modeling experience and normalization
  • Experience working with Entity Relationship Diagramming for Data Modeling
  • Experience in developing Key Performance Indicators (KPI's)
  • Accustomed to looking through data tables and SQL logic, documenting data flows and discerning data patterns and identify anomalies
  • Must have strong consultative, analytical and problem-solving skills
  • Willingness and ability to suggest areas of improvement
  • A solid understanding of metrics and analysis to deliver on business objectives
  • Must be detail-oriented with ability to multi-task and effectively handle changing requirements
  • Effective oral and written communication skills
  • Experience using Tableau or other Data Visualization tools preferred
  • Experience with the Scaled Agile Framework a plus
  • Proficient in using JIRA and supporting data tables a plus
  • Proficient in using CA Clarity and supporting data tables a plus
  • Bachelor's and/or Master's degree in computer science, engineering, Mathematics or other related discipline
Job Responsibilities:
  • Work along aside the Portfolio Delivery Metrics Manager in providing KPIs and insightful and informative metrics via dashboards to enhance operational efficiency, transparency and communication over the Scaled Agile Transformation rollout
  • Solicit metrics requirements from the Product Managers and Owners, Portfolio Delivery leadership and Technical Teams to identify key metrics supporting Portfolio Oversight, Technical Health, Demand Management, Capacity Management, Governance, Behavioral and other key metrics
  • Help to identify and translate data patterns and trends
  • Perform data profiling and data analysis activities
  • Develop operational, analytical and financial reports and make recommendations to management
  • Model data using MS Excel, MS Access and/or other analytical data tools
  • Develop workflows and queries to obtain data required for dashboard development
  • Analyze data and document transactional and reporting data elements from internal data sources (JIRA, Clarity, Confluence, etc.)
  • Participate in visioning sessions and design reviews to develop wireframes for Tableau development
  • Evaluate existing reporting to identify opportunities to automate
  • Design and develop reconciliation or control jobs to assist in data testing
  • Ensure JIRA / Clarity compliance by performing data quality and analysis assessments
  • Create and maintain QA artifacts, follow QA process and document data anomalies
  • Perform other related duties as required by management
Job Type: Contract
  • Tableau: 3 years (Required)
  • Data Analysis: 5 years (Required)
  • MS SQL: 5 years (Required)
  • JIRA: 1 year (Preferred)
  • MS EXCEL (pivot tables): 5 years (Required)
  • Clarity: 1 year (Preferred)
  • Bachelor's (Required)