Sean Knight's Location
Omaha, Nebraska, United States, United States
Sean Knight's Contact Details
Sean Knight work email
- Valid
- Valid
- Valid
Sean Knight personal email
n/a
Sean Knight phone numbers
About Sean Knight
Sean Knight is a Senior Business Intelligence Engineer at Amazon. He possess expertise in business intelligence, data warehousing, databases, sql, etl and 18 more skills. Colleagues describe him as "As one of the primary resources assigned to the evaluation and selection of both the physical and human resources for our company's Enterprise Data Warehouse project, I can say hands-down that we would choose Brightlight again. Specifically, we would request Sean as our data modeler and development lead. His sheer attention to every single detail, depth of experience in data modeling, and development expertise on Netezza is exactly what we needed. He leaves no stones unturned and will turn them until they are literally perfect.", "I have been working closely on long-term analytical projects with Sean during my experience at CIDC and it has always proven efficient and instructive. Sean is very sharp, quickly grasps your needs and manages to instantly turn them into data requests. He is curious and always pushes analysis one step further. He also has a deep knowledge of the data making him the company reference for any data question. As the Director of BI, he has brought more structure to the department and made it a truly efficient and timely service provider for the Company, all this while keeping a smile on his face.", and "Sean has done a great job developing the BI department and giving it the central role it has. Always looking for the best solution, Sean's s excellent understanding of the business, technical skills and social interactions allowed the BI department to adapt to constantly changing environment and requirements while providing accurate pieces of advice and data analysis."
Sean Knight's Current Company Details
Amazon
View
Senior Business Intelligence Engineer
Omaha, NE, US
- Website:
- amazon.com
- Employees:
- 734811
Sean Knight Work Experience Details
-
Senior Business Intelligence EngineerAmazonOmaha, Ne, Us
-
Senior Data EngineerAmazon Apr 2018 - PresentSeattle, Wa, UsIn addition to engineering responsibilities, acted as “Bar Raiser” for Amazon from 2018 to present, conducting ~400 candidate interviews and facilitating ~200 post-interview debrief meetingsSenior Data Engineer for Bad Actor Disincentives organization (September 2022 to present):Managed day-to-day data warehouse operations for three Redshift clusters as the sole Data Engineer for the 400-person BAD organization; restored cluster viability within first two months by eliminating unnecessary overhead and working with management to increase cluster sizeMentored users across the organization by conducting weekly Office Hours sessions and training classes, and developing formal wikis in Redshift SQL best practicesPartnered with Data Science team to harden MLOps processes, including building a new ETL-based approach for maintaining key feature inputs to BAD Science modelsSenior Data Engineer for 3P Seller Pricing organization (April 2019 to September 2022):Worked with Atypical Pricing team and several external stakeholders to manage operational systems during COVID pandemicConsulted with technical team to design improved detail page logging capabilities, to drive improvements in reporting on reference prices displayed to customers; deployed improved data sources and integrated with existing data pipelines, and worked with business to cascade the improved metrics to weekly reportsCollaborated with external teams to implement a data pipeline capturing the real-time decisions made by internal systems when rendering featured offer details; eliminated a 15% overstatement of critical metrics caused by imprecisions in the previous version of the pipelineSenior Data Engineer for Subscribe and Save organization (April 2018 to April 2019):Became subject matter expert in source data produced by SnS team; developed and refined data warehouse tables for external consumption, and published to internal data lake system with exhaustive business definitions
-
Software Development ManagerAmazon Web Services Oct 2014 - Apr 2018Seattle, Wa, UsSoftware Development Manager for AWS Data Warehouse organization (April 2016 to April 2018):Managed team of eight Data Engineers responsible for maintaining the internal data warehouse used by all AWS services to report on service usage minutes, product revenue, and other key business indicatorsHired and onboarded five DE and BIE resources to team, and managed two team members through Performance Improvement PlansActed as primary liaison to the team’s Technical Project Manager for resource allocation and project planning, and acted as the team’s Product Owner in sprint management meetingsDeveloped three-year architecture plan and annual operational plans for teamData Engineer for AWS Data Warehouse organization (October 2014 to April 2016):Worked with AWS Marketplace team to resolve discrepancies in revenue reporting; uncovered a technical error that was causing the organization to understate key metrics by more than 20%Re-factored critical fact table to reduce daily run times by ~50%, and improving SLA compliance by ~95%Worked with production source data providers to deploy improvements in their daily extract processes to reduce upstream data latency by 2-4 hours -
Principal ConsultantBrightlight Consulting Sep 2012 - Oct 2014Redmond, Wa, UsLed architecture team for an ETL re-platforming initiative at a mail-order retailer in Omaha, NE:Analyzed detailed requirements documentation with representatives of the business to design physical data warehouse consolidation data model, optimized for Netezza;Supervised and mentored Brightlight team members in the development of ETL transforms using the nzDIF data integration tool;Defined implementation timeline and worked with client IT staff to ensure effective transition to productionLed Netezza Data Warehouse re-platforming project for a major hospital in Seattle, WA:Provided technical support and development assistance in implementing the Brightlight nzDIF data integration framework;Designed "sandbox" architecture enabling a large audience of users to perform data exploration and profiling activities in their own personalized Netezza databases;Worked in conjunction with DW team staff to integrate source control capabilities with nzDIF framework objects using Subversion (SVN);Deployed secondary Netezza environment and architected disaster recovery capabilities using native Netezza backup and restore capabilitiesProvided data architecture and ETL project management services for a large medical insurance company in San Francisco, CA:Adapted "flow-based architecture" principles into an architecture capable of using Informatica toolset to leverage parallel processing capabilities of Netezza, and collaborated with client data architects to develop Netezza Pilot data architecture in under one monthConducted Netezza optimization audit for a major insurance company in Los Angeles, CA:Reviewed Netezza configuration settings and query history to identify quick-hit optimizations;Audited data model and query history patterns to identify deeper architectural problems, and developed detailed recommendations for how to remediate model so that it performs better on the Netezza platform -
Director Of Business IntelligenceCidc Jul 2011 - Sep 2012Represented Business Intelligence interests with product development, software development and marketing directors to ensure that the company's analytical needs could be met;Managed the priorities and workload of Business Intelligence team members, acting as Agile Product Owner for the BI team;Collaborated with scrum masters and project managers to integrate the Business Intelligence team into the standard scrum processes of various development teams;Managed vendor account relationships, licensing requirements and budgeting for Business Intelligence product suite;Worked closely with executives, subject matter experts and designated data stewards to develop and maintain a comprehensive corporate glossary and a complete list of corporate Key Performance Indicators, along with the precise data definitions underlying each KPI -
Data ManagerCidc Apr 2008 - Jul 2011Designed architectural enhancements to stabilize and mature the existing technical infrastructure, and directed technical team in projects to deliver those enhancements;Developed complete star schemas for Gaming, Customer Service, Player Profiling, Marketing Promotions and Financial data marts;Wrote complex SQL processes to perform data transformation (ETL) from normalized data to denormalized data marts, and tuned ETL processes over time to optimize query performance;Performed frequent ad-hoc, SQL-driven analysis and data exploration for various business departments, including:Analyzing in-game player behaviors such as session duration, frequency of play, game selection and player skill;Assisting the fraud management team in detecting collusion among poker players and "bonus hunting" behavior among casino players by analyzing game play behavior sequentially and at a detailed level;Tracing key events in player lifecycle, from acquisition through registration and conversion to real money player status;Using player details to identify duplicate registrations and consolidate multiple registrations into a single "enterprise player" record;Profiling hardware and software configurations of players (such as browser version and CPU speed) to support technical architecture decision-makers in development team;Developed Business Objects reports and Microsoft Excel pivot reports and charts for user requests requiring complex or non-standard queries;Designed data quality verification scripts to perform daily validity checks of warehouse data, and production processes for handling discrepancies between the data marts and the production data;Became subject matter expert in the data structure and contents of the OLTP production system, and collaborated with the database team to coordinate production changes with the corresponding logic changes that needed to be implemented in warehouse load jobs
-
Circulation Systems ArchitectAdvanced Technical Solutions Feb 2003 - Mar 2008Maynard, Ma, UsWrote detailed functional and technical specification documents for contracted system modifications, through JAD sessions with high-level client resources in Circulation and Accounting departments;Used advanced SQL techniques to develop new procedures and optimize existing procedures, in the context of heavily SQL-dependent online and batch transaction processing environments;Built interface processes to feed daily transaction history into IWS data warehouse;Wrote original project plans for product installations, including task definitions, resource assignments and dependencies; maintained project actuals against original project plan;Managed personnel responsible for data conversion and interface and report development;Brought system live, and performed several weeks of on-site support after implementation;Managed project to upgrade to the current version of the application two years after the initial implementation -
ManagerE2I Inc. Aug 2000 - Aug 2001Conducted detailed informational sessions with senior medical staff, and researched industry web practices;Developed organizational and navigational structure for redesigned web site
-
Lead DeveloperArizona Republic Mar 1999 - Aug 2000Phoenix, Az, UsLed Circulation systems team during cross-departmental direct mail project in Phoenix, AZ:Coordinated application changes to accommodate address-level packaging and delivery functionality;Developed new SQL-based route sequencing module for the Circ2000 application to support tablet-based delivery route management for all metropolitan Phoenix delivery routes;Worked with co-lead developers in Advertising department, along with representatives of external production facility during testing and implementation cycles;Earned 2000 Arizona Republic “Silver Ingot” award as a member of the Circulation direct mail project team -
DeveloperEntercon Apr 1998 - Mar 1999Led Circulation systems team during cross-departmental direct mail project for the Arizona Republic newspaper (see listing above)
-
DeveloperBsg Consulting Jun 1994 - Apr 1998Acted as lead developer during development of a newspaper advertising system in Phoenix, AZ:Developed data model for core elements of the application;Built the SQL-based “rating engine” used to rate every ad that was entered into the system, and the fulfillment processes that would be used to verify compliance with contract terms and short-rate customers that did not meet their contractual obligations;Earned 1996 BSG Team “Outstanding Performer” award as a member of the advertising project teamAssisted in Cyborg HR/Payroll package implementation in Phoenix, AZ:Worked with client and vendor personnel to configure system setup parameters for benefits administration module of the Cyborg HR/Payroll package;Created specifications for and assisted in testing of customizations to 401(k) administration module;Created PowerBuilder sub-application for easier auditing of employee 401(k) history;Earned 1995 BSG Individual “Outstanding Performer” award for work on the Cyborg project
Sean Knight Skills
Business Intelligence
Data Warehousing
Databases
Sql
Etl
Data Modeling
Software Development
Integration
Business Objects
Data Integration
Enterprise Software
Testing
Netezza
Scrum
Database Design
Sdlc
Agile Methodologies
Agile Project Management
Software Project Management
Enterprise Architecture
Data Warehouse Architecture
Oracle
Business Objects Data Integrator
Sean Knight Education Details
-
Rice UniversityEconomics And Spanish
Frequently Asked Questions about Sean Knight
What company does Sean Knight work for?
Sean Knight works for Amazon
What is Sean Knight's role at the current company?
Sean Knight's current role is Senior Business Intelligence Engineer.
What is Sean Knight's email address?
Sean Knight's email address is se****@****ast.net
What is Sean Knight's direct phone number?
Sean Knight's direct phone number is +161787*****
What schools did Sean Knight attend?
Sean Knight attended Rice University.
What skills is Sean Knight known for?
Sean Knight has skills like Business Intelligence, Data Warehousing, Databases, Sql, Etl, Data Modeling, Software Development, Integration, Business Objects, Data Integration, Enterprise Software, Testing.
Who are Sean Knight's colleagues?
Sean Knight's colleagues are Juani L, Mubasher Khan, Vijay Marandi, Wassim Dannawi, Mr Danish Saifi Modi Nagar, Bala Krishna M, Shaik Saidha.
Free Chrome Extension
Find emails, phones & company data instantly
Find verified emails from LinkedIn profiles
Get direct phone numbers & mobile contacts
Access company data & employee information
Works directly on LinkedIn - no copy/paste needed
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial