KentRecruiter Since 2001
the smart solution for Kent jobs

Reporting Specialist

Company: MV Transportation
Location: Kent
Posted on: June 20, 2022

Job Description:

The Reporting Specialist will prepare all day, weekly and monthly reports as required. They will use various systems (including Trapeze, ViewPoint, Transit Miner and the phone system used by the control center) to collect and compile service data in to comprehensive and detailed reports. He/She will analyze the data and make recommendations regarding staffing needs, changes to non-dedicated assignments, and adjustments to Trapeze parameters, with the overall goal of service efficiency and performance.Job Responsibilities:

  • Build appropriate Data Pipelines, Data Exploration, Reports and Quality Controls to enable self-service
  • Business Intelligence using analytical tools and programming languages like Python, SQL, Power BI, advanced Excel.
  • Build automated weekly reports and provide Business Intelligence on organization's performance by focusing on On Time Performance, Late Appointments, Key Performance Index, Liquidated Damages etc. Streamline performance metrics for the company to comply with the King County's contract terms for the County Wide Paratransit System.
  • Collaborate across multiple teams to research, architect, engineer and configure complex data warehouse solutions to specified requirements in support of business-critical systems with permanent Business Intelligence systems.
  • Provide in-depth analysis and develop processes, tools, and templates to enable efficient, accurate, and standardized data analyses and related deliverables; leverages automation to greatest extent possible. Develop and implement data collection systems and other strategies that optimize statistical efficiency and data quality in complex datasets.
  • Ensure consistency and accuracy of information and reporting by identifying issues and fluctuations with core metrics/KPIs, facilitates changes, research questions, participate and/or lead process and data improvement efforts.
  • Maintain effective communication with internal organizations, external vendors/partners and internal staff. Structure and present complex subjects in a meaningful and comprehensible manner.
  • Provide all aspects of Data Management, Data Governance, Data Intelligence, Knowledge Graphs
  • Evaluation of multiple reports and make recommendations for report consolidations and standardization.
  • Write technical documentation in support of the BI solutions being developed or enhanced.
  • Review completed code, documentation, and other deliverables to ensure that they meet specifications and requirements based on defined expectations. Ensure best practices are being followed in developing all layers of a business solution.
  • Designing logical and physical database structure to facilitate analysis of data from both operational and client perspectives.
  • Translate and communicate complex subject matters to technical and non-technical audiences with demonstrated ability to maintain and improve the quality and integrity of data collected for management decision-making.
  • Work closely with Company's Senior Management to accommodate their data needs and analysis with a goal of improving the organizations performance & to help others easily interpret and understand the data being presented (via SSRS, Power BI and ViewPoint). Talent Requirements:
    • Experience working with complex reporting systems like SSRS, PowerBI, ViewPoint and transit miner are required
    • Ability to independently design, implement and create executive level reports
    • A clear understanding of contract requirements relating both to reporting deliverable and KPIs
    • Strong consultative, problem-solving and analytical skills required
    • Details Oriented, strong organizational skills, absnippility to multitask; results oriented
    • Strong interpersonal and written/oral communication skills
    • Degree in Computer Science, or Information Technology or equivalent experienceAdditional Requirements:
      • Must have strong experience utilizing tools and systems on the MS SQL Server BI Stack, SSRS, SSIS, SSAS, T-SQL, Power Pivot, Power BI, Power Query.
      • Deep understanding of database fundamentals, including relational database design, multidimensional database design, OLTP, and OLAP
      • Minimum of one (1) to three (3) years of related business experience.
      • Expertise using data visualization tools such as Power BI, SQL Service Reporting Service, ViewPoint etc.
      • Exceptional technical knowledge of SQL, relational database structures, data warehousing tools, datamining, and proficiency in Business Intelligence tools required
      • Ability to develop and use structured approaches to identify root causes and recommend resolutions.
      • Work with company leadership to define, launch, and drive critical strategic, organizational, and operational initiatives.
      • Ability to self-start and self-direct work in an unstructured and fast-paced environment, ability to deal with ambiguity.
      • Research and analyze key performance index.
      • Must demonstrate attention to detail, data integrity and accuracy; be results oriented and demonstrate the ability to multitask.
      • Solid work ethics and ability to use experience, judgment and skills to work effectively as both a member of a team and independently.
      • Excellent organizational skills
      • Strong communication skills: verbal and written.
      • Experience drafting/developing requirements (technical, business specific language/technical documentation)
      • Strong Business Acumen, ability to learn business areas quickly.During the course of employment, employees may receive and have access to confidential information. All employees are expected to respect and maintain the confidentiality of non-public customer and business records and any other information that MV classifies as confidential.MV Transportation is committed to as policy of Equal Employment Opportunity and will not discriminate against an applicant or employee on the basis of race, color, religion, creed, national origin or ancestry, sex, physical or mental disability, veteran or military status, genetic information or any other legally recognized protected basis under federal, state or local laws, regulations or ordinances. The information collected by this application is solely to determine suitability for employment, verify identity and maintain employment statistics on applicants. Where permissible under applicable state and local law, applicants may be subject to a pre-employment drug test and background check after receiving a conditional offer of employment.

Keywords: MV Transportation, Kent , Reporting Specialist, Advertising , Kent, Washington

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Washington jobs by following @recnetWA on Twitter!

Kent RSS job feeds