Business Data Analyst 1.19

Be among the first applicants.
Focused HR Solutions
Halifax Regional Municipality
CAD 60,000 - 80,000
Be among the first applicants.
7 days ago
Job description

Will be worked onsite and remotely.

We have an opening for a Business Data Analyst rec 89611

This position is a 12-month contract to start in Phoenix, AZ. If you are interested, please submit the following:

  1. Your rate and resume.

Other details:

  • Corp to Corp must be direct with us and no employers are allowed.
  • Under limited supervision performs complex tasks to support the division by performing data analysis, data mining, design, development, testing activities, and execution of AdHoc, Standard, and Customized reports to achieve strategic objectives and goals.
  • Has working experience in writing and working with SQL (Standard Query Language), T-SQL, Visual Basic, and MS Access to develop queries to gather appropriate data from multiple systems and create reports in multiple technology applications (Excel, Tableau, etc.), write SSIS packages, and complete paperwork/documentation to move reports into Production.
  • Serves on projects and/or pilots to develop and/or provide input for requirements, provide technical guidance for design or enhancements to systems/reports, and develop Work Plans, schedule, monitor, etc. to ensure successful and timely completion.

Responsibilities include but are not limited to:

  • Designing reports requiring analysis, writing of SQL, data mining, and presentation to technical and non-technical audiences in a variety of technical platforms (Power BI, Tableau, Excel, etc).
  • Prioritize business and operational needs.
  • Extract, import, clean, transform and validate data.
  • Writing queries using SQL, T-SQL, and MS Access.
  • Experience with DB2.
  • Identify, analyze, and interpret trends or patterns in complex data sets.
  • Create standard and ad-hoc reports including detail, summary, history, snapshots, drill down, and other reports.
  • Develop report specifications, test plans, prepare test data, execute tests, supporting documentation, and coordinate production implementation.
  • Establish data connections with various data sources.
  • Setup report schedule, subscription, access process and procedures, and delivery method. Present data in lists, tables, charts, graphs, snapshots, crosstab, and other formats.
  • Tailor the analysis and reporting methods by the type of data as well as to the intended audience.
  • Review key indicators to locate and correct problems.
  • Follow up and track remediation of issues.
  • Write and present Desk-Aids and Work-Flows for both technical and non-technical audiences.

Knowledge, Skills & Abilities:

  • Knowledge of Service Level Agreement (SLA); laws, rules, security policies, privacy, data confidentiality management.
  • Knowledge of Engineering workflow, IT lifecycle and system design, performance tuning, and Business Intelligence tools and features.
  • Knowledge of Statistical and business analysis and research and analysis methodologies.
  • Knowledge of multiple business intelligence software applications (SQL, SSIS, MS Visual Studio, Tableau, Visual Basic, MS Access, etc.) and multidimensional and relational database design.
  • Knowledge of project management concepts, principles, and practices.
  • Skilled in dimensional and relational database design.
  • Skilled in analysis, design review, troubleshooting, implementation, and integration for applications.
  • Skilled in keyboarding and use of Microsoft Office programs such as Excel, Word, Access, and PowerPoint and Google for Gmail, calendar, chat, sheets, docs, slides, etc.
  • Problem and negotiation skills to research and resolve issues.
  • Good time management and organizational skills with attention to detail. Skilled in effective listening, oral, and written communications skills to communicate technical and non-technical concepts to a variety of audiences.
  • Ability to write business and functional requirements and diagram business processes, translate them into technical solutions and reports, query, and view objects, and present them in a meaningful format.
Get a free, confidential resume review.
Select file or drag and drop it
Avatar
Free online coaching
Improve your chances of getting that interview invitation!
Be the first to explore new Business Data Analyst 1.19 jobs in Halifax Regional Municipality