Business Intelligence Engineer, Sales Marketing Global Services (SMGS) Security

Key Skills

AWS, Business Intelligence, Data science techniques, Data Visualization, Java Programming, KPI, Leadership, Looker, Mathematics, MicroStrategy, PowerBI, Python Programming, QuickSight, SQL, Statistics, Tableau

Job Description

The Amazon Web Services (AWS)‘s Sales, Marketing, and Global Services (SMGS) mission is to enable the AWS field organization to be the most efficient and effective in the world. We are building a security team to protect AWS customers and the SMGS computing environment that enables the AWS Sales and AWS Marketing teams.

SMGS makes broad use of AWS platforms and technologies including cloud services, identity and access management, big data and analytics, all operating at massive scale with consistent growth. SMGS Security helps internal teams with each step of deployment and leads inspection of SMGS’s security posture. In this expanding environment, our highly collaborative team is committed to each team member’s growth as our business and team grows.

SMGS Security is looking for a Business Intelligence Engineer to build a security platform and actionable dashboards. These tools provide a data-driven experience for SMGS teams and ensure that senior leaders can assess and prioritize security work to safeguard Amazon customers. At Amazon, security is our highest priority and the SMGS Security team is responsible for defining and driving large software security initiatives across Amazon. We are looking for an engineer that will automate all metrics, analyze all aspects of our business, and provide recommendations that directly affect SMGS’s security and risk management priorities.

Are you passionate about solving business problems through data driven decision making? You will own data analytics projects from beginning to end, using business intelligence tools to drive key recommendations and produce planning models, forecasting, and analysis. Your analysis will contribute deeply to the development of our strategy and drive impact against our SMGS Security business objectives. You will work closely with security engineering teams and executives to achieve business objectives and communicate insights to key stakeholders. You will recognize and adopt best practices in reporting and analysis, including data integrity, analysis, validation, and documentation and drive results in a fast-paced, ambiguous environment

You understand that automation is key to your success and constantly find ways to automate and get more value from derived datasets. You recognize that there is a balance between personally finding new insights and delivering automation for others to construct new insights. Your automation work enables the team to scale business analysis and make use of subject matter experts, while you continuously deliver automated metrics and insights. We want you because you have a relentlessly high bar when solving hard data-driven problems at scale and relish the opportunity to challenge the norm.

Key responsibilities include:

• Analytics; establish baseline metrics and analytics, collaborate with Business Operations and the leadership team to track and report all key performance indicators against annual, quarterly and monthly goals. Establish and maintain management dashboards, regional reports, and executive review documents that will drive business outcomes
• Monitor existing KPI metrics, developing new metrics, identity correlations and root causes
• Design and build visualization dashboards to accelerate information-to-action at scale
• Performing regular system audits to ensure complete and accurate reporting of data/metrics
• Support quarterly, annual planning activities
• Develop programs, methodologies, and reports for analyzing and presenting data
• Act as a SME for BI tools as well as delivering training to team members on the usage of these tools
• Contribute to the writing of papers for internal audiences
• Invent new ways to define and measure program effectiveness and organizational productivity

About the team

Our team puts a high value on work-life balance. Striking a healthy balance between your personal and professional life is crucial to your happiness and success here, which is why we aren’t focused on how many hours you spend at work or online. Instead, we’re happy to offer a flexible schedule so you can have a more productive and well-balanced life—both in and outside of work.

Our team is dedicated to supporting new members. We have a broad mix of experience levels and tenures, and we’re building an environment that celebrates knowledge sharing and mentorship. We care about your career growth and strive to assign projects based on what will help each team member develop into a better-rounded engineer and enable them to take on more complex tasks in the future.

Here at AWS, we embrace our differences. We are committed to furthering our culture of inclusion. We have ten employee-led affinity groups, reaching 40,000 employees in over 190 chapters globally. We have innovative benefit offerings, and we host annual and ongoing learning experiences, including our Conversations on Race and Ethnicity (CORE) and AmazeCon (gender diversity) conferences. Amazon’s culture of inclusion is reinforced within our 14 Leadership Principles, which remind team members to seek diverse perspectives, learn and be curious, and earn trust.

BASIC QUALIFICATIONS

• BA/BS in Mathematics, Statistics, Computer Science, Finance or a similar quantitative field, or additional 4+ years of experience in lieu of a degree.
• 3+ years of relevant work experience in data science, business analytics, business intelligence (BI), or comparable experience in big data environments.
• 2+ years experience using, writing and optimizing SQL queries in a business environment
• 2+ years experience using business intelligence reporting and visualization tools (such as Tableau, PowerBI, MicroStrategy, Looker and QuickSight, Advanced Excel such as v-lookups, pivot tables, etc.)

PREFERRED QUALIFICATIONS

• Knowledge of data warehouse technical architecture, infrastructure components, ETL and reporting/analytic tools and environment.
• Administration/development experience with CRM Analytics and/or other CRM related technologies.
• Be self-driven, details-oriented, and show ability to deliver on ambiguous projects with incomplete or dirty data.
• 5+ years of experience in a data analyst or BIE role with a technology company.
• Strong verbal/written communication and data presentation skills, including an ability to effectively communicate with both business and technical team, and senior management as required.
• Ability to think big, understand business strategy, provide consultative business analysis, and leverage technical skills to create insightful, effective BI solutions.
• Experience working with disparate data sources and turning them into a unified solution.
• Experience in Sales or Sales operations
• Experience with developing products and features for the sales, sales operations, and marketing space