Data Reporting & Analytics Consultant- SQL Server Admin

Job Summary

This individual contributor is primarily responsible for driving strategic data informed decisions, gathering data and information on targeted variables in an established systematic fashion, preparing data for analytic efforts, and interpreting data analyses. This position executes creative data analytic approaches leading to actionable outcomes, develops, implements, and automates business and reporting solutions, and develops analytical and/or statistical models enabling informed business decisions.

Essential Responsibilities

• Executes creative data analytic approaches leading to actionable outcomes by defining and calculating metrics to be analyzed; defining, calculating, and validating algorithms; and conducting analyses, including descriptive, correlational, inferential, and/or predictive statistics.
• Develops, implements, and automates business and reporting solutions by working with stakeholders in their design, planning, and implementation while ensuring consistency and coherency; evaluating and summarizing data and results; creating summary statistics; developing data reports, visualizations, and/or interactive Business Intelligence (BI) reports; reporting to stakeholders on key findings; identifying needs for the development and implementation of additional reporting solutions; and preparing documentation as appropriate.
• Interprets data analyses by applying findings to contextual settings; and developing insights, reports, and presentations telling a compelling story to stakeholders to enable and influence decision making; and providing context related to data interpretations and/or limitations as appropriate.
• Drives strategic data-informed decisions by consulting with clients to identify and clarify key business needs; developing outcomes and process measures; translating business requirements; determining data/information needs and data collection methods; developing analysis plans; measuring the impact of business decisions on clients, customers, and/or members; working with clients and staff to identify opportunities and methods to improve efficiencies with analysis; supporting and training end-users; and documenting processes and deliverables.
• Gathers data and information on targeted variables in an established systematic fashion by validating data sources; querying, merging, and extracting data across sources; completing routine data refresh and update; developing and/or delivering tools for electronic data collection; and providing user training, support, and documentation.
• Develops analytical and/or statistical models enabling informed business decisions by determining data and analytical requirements; creating models leading to actionable insights; and testing, refining, and validating models.
• Prepares data for analytic efforts by integrating and consolidating data; ensuring data quality and accuracy; profiling data inaccuracies and recommending process improvements or system changes to enhance overall quality of the data; and cleaning and creating final data set(s) for analysis.

Job Qualifications

Minimum Qualifications

• Bachelor’s degree in mathematics, Statistics, Engineering, Social/Physical/Life Science, Business, or related field and Minimum five (5) years’ experience in data analytics or a directly related field. Additional equivalent work experience of three (3) years for a total of eight (8) years in a directly related field may be substituted for the degree requirement.
• Minimum one (1) year experience in a lead role with or without direct reports.

Minimum two (2) years’ experience in the following areas:

• SQL
• Database administration experience (SQL Server)
• Python

Additional Requirements

Negotiation; Business Planning; Written Communication; Data Extraction; Data Mining; Data Visualization Tools; Statistical Programming Language; Relational Database Management; Vendor Management; Project Management; Client Engagement, familiarity with GitHub

Preferred Qualifications

• Databricks
• Power BI
• R & R Shiny
• Two (2) years Linux servers
• Two (2) years’ experience in process improvement.
• Three (3) years’ experience working with statistical analysis software.
• Three (3) years’ programming experience.
• Two (2) years’ experience working in a matrixed organization.
• Two (2) years’ experience delivering presentations to management.