Patrick Schilling Email & Phone Number

Raleigh, Nc, Us

Raleigh, Nc, Us

Las Vegas, Nv, Us

- Proactively generate insights based on regular evaluations of the lottery marketplace- Independently maintain and refine key analytic products related to retail facing products (B2B) that are substantially relied upon internally- Answer complex ad-hoc questions that arise from internal/external stakeholders- Work to develop new KPI’s that can be used by the organization and our customers- Provide regular reporting of industry trends and happenings to key stakeholders- Use Business Intelligence tools such as Tableau and SQL to create and distribute content for our many stakeholders- Support the onsite team with validation and operations reporting as well as development/realization of the Analytics roadmap.

Philadelphia, Pa, Us

- Create custom and scalable SQL scripts to transform data for use in Power BI templates and analyses.- Create custom Power BI templates and DAX functions to improve the efficiency of analyzing dashboards.- Manage existing Power BI templates, data sources, SQL scripts and data connections for team use.- Liaison between teams for new analysis ideas, technology implementation impacts and changes.

Philadelphia, Pa, Us

- Ability to clean, transform and bridge raw data sources into data visuals to answer client business questions.- Utilize Authority Labs, Google Ad, Google Analytics, SEMRush, Ahrefs, and Google Keyword Planner to connect to data warehouses for use inside of Power BI, Tableau and Looker.- Advanced use of Power BI to connect to data warehouses and create relationships inside of dashboards.- Writing unique SQL scripts and DAX functions to transform and analyze data specific for client's own data and strategy.- Present insights to clients based on analyzing dashboards to further their business strategy and break down the data into usable business actions.- Drafted project briefs detailing client needs, business and research questions to answer, applicable internal analyses to answer their questions and their data needs.

Philadelphia, Pa, Us

- Independently utilize standard BigQuery tables for core deliverables & run standard SQL scripts.- Utilizing client project briefs developed by account managers to turn into a dashboard.- Pulling data from Authority Labs, Google Ads, Google Analytics, SEMRush, Ahrefs and Keyword Planner and connecting it with the internal data warehouse.- Connecting, building and analyzing Power BI dashboards to answer business questions and support research.- Assists in client presentations on analysis findings, collecting feedback and managing deliverable timelines.

Durham, Nc, Us

- Determining, document, and track requirements and user stories for changes to business processes, policies, information, and information systems.- Support communication and validation of requirements with stakeholders and identified SMEs.- Assist in the creation of and adherence to requirements approach and management plan in alignment with an overall project plan- Collaborate with project teams to adhere to solution scope and maintain requirements traceability.- Assist in managing requirements change requires process and documentation throughout the project life cycle- Support business relationships by documenting business issues, determining project needs, and supporting training as need.

Durham, Nc, Us

Durham, Nc, Us

- Business Analysis: Analyze business needs for strategic initiatives that drive quality, affordability and exceptional experience- Requirements Development: Collaborate with cross-functional stakeholders to define, develop and communicate scope and requirements to technical development partners- Project Implementation Support: Partner with project teams to prioritize requirements, develop solution approach and alternatives and manage requirements changes to ensure developed solutions meet business needs

Cullowhee, Nc, Us

-Help set up and run home athletic events for Western Carolina University-Work scoreboard, shot clock and other operational needs for home sporting events-Track basketball (men's and women's) stats using CBS STATCREW & NCAA Live Stats-Track baseball and softball stats using DOS scoring program

-Independently compose weekly articles researching trends in both athlete performance and sports business-Take data and research and turn it into meaningful thoughts so that it is able to be understood quickly and effectively

-Compose and publish independently researched topics based on assigned sports teams-Develop coherent thoughts and ideas about teams, players and the organization as a whole