BI Developer
Columbus Ohio
Hybrid Job
Video Interview
State of Ohio Dept of Transportation
Job# 751464
Job Description
** Will be required to be onsite at 1980 West Broad St Columbus minimum of 3 days a week.
Requirement Description: This role will fulfill reporting and dashboard requirements for various business units across the organization providing them with timely information that enables them to make various quality financial program and policy related decisions. In conjunction with IT Management data owners and business units develop models procedures and protocols in concert with company goals. Use knowledge of SSRS PowerBI and other specialized reporting tools to develop reports. Meet with decision makers systems owners business analysts and end users to define requirements and goals. Work with IT technical staff to coordinate the creation and management of dashboard scorecard reporting and analysis presentation structures and data. Work with process owners and the data team to prioritize requests. Design data visualizations and determine the best way to present data to end users using drilldowns tables gauges graphs charts and other intuitive graphical addons Prepare and deliver reports analytics and interactive intelligence in systems across the organization. Develop expertise in specifically assigned subject areas of the warehouse. Develop and maintain ETL and data warehousing processes and measures in assigned areas of subject expertise. Advise managers and stakeholders regarding appropriate effective and efficient use of organizational data capabilities and functions.
In conjunction with IT Management data owners and business units develop models procedures and protocols in concert with company goals.
Use knowledge of SSRS PowerBI and other specialized reporting tools to develop reports.
Meet with decision makers systems owners business analysts and end users to define requirements and goals.
Work with other IT staff to coordinate the creation and management of dashboard scorecard reporting and analysis presentation structures and data.
Work with process owners and the data team to prioritize requests.
Design data visualizations and determine the best way to present data to end users using drilldowns tables gauges graphs charts and other intuitive graphical addons
Prepare and deliver reports analytics and interactive intelligence in systems across the organization.
Develop expertise in specifically assigned subject areas of the warehouse.
Advise managers and stakeholders regarding appropriate effective and efficient use of organizational data capabilities and functions.
Liaise with various business groups in the organization to facilitate implementation of improved business intelligence and reporting processes.
Coordinate postimplementation support including enduser reviews for modified and new data visualizations
Requirements:
Bachelor s degree in the field of computer science information management systems or a related field (or equivalent work experience) is required
Minimum 8 years related work experience / Maximum 10 years of experience.
Proven experience with report writing dashboard development data visualization techniques supported by technical requirements analysis business process modeling/mapping and data modeling.
Proven experience with reporting tools dashboards scorecards and related software and other applications.
Exposure to the operation and analysis of Microsoft SQL Server relational and OLAP database software and standards as well as data retrieval methodologies.
Experience writing complicated yet efficient SQL for a relational database such as Microsoft SQL Server is essential.
Working knowledge of SSRS and PowerBI is desirable.
Experience with OpenText BI and/or Tableau is beneficial
Extensive practical knowledge in importing data for use in report software spreadsheets graphs and flowcharts.
Able to exercise independent judgment and take action on it.
Excellent analytical mathematical and creative problemsolving skills.
Excellent listening interpersonal written and oral communication skills.
Demonstrated ability to be logical and efficient with keen attention to detail.
Experience working in a teamoriented collaborative environment.
Skill
Required / Desired
Actual Years
Last Year Used
Bachelor s degree in the field of computer science information management systems or a related field
Required
Proven experience with report writing dashboard development data visualization techniques
8
Proven experience with reporting tools dashboards scorecards and related software and other applications.
8
Exposure to the operation and analysis of Microsoft SQL Server relational and OLAP database software and standards as well as data retrieval methods
Required
Experience writing complicated yet efficient SQL for a relational database such as Microsoft SQL Server
Required
Extensive practical knowledge in importing data for use in report software spreadsheets graphs and flowcharts
Required
Excellent analytical mathematical and creative problemsolving skills.
Required
Working knowledge of SSRS and PowerBI
Highly desired
Experience with OpenText BI and/or Tableau
Highly desired
Will you be required to be onsite at 1980 West Broad St Columbus minimum of 3 days a week.
(Yes/No)
etl processes,opentext bi,ssrs,dashboard development,data warehousing,data visualization,reporting,sql server,power bi,sql,tableau,report writing,data
Power BI Developer
