Sr. Business Intelligence Eng, EC2 Capacity Intelligence & Enablement

Key Skills

Python Programming, SQL

Job Description

EC2 Capacity Intelligence & Enablement team is looking for a customer-obsessed Business Intelligence Engineer to join the team. AWS has a culture of data-driven decision making, and requires business intelligence that is timely, accurate and actionable. This role will partner closely with the business teams to understand the data-needs of the team and ensure that the business teams are able to answer hard questions with real data. This individual will participate in business reviews and new-initiatives. They should be able to identify and help close gaps in the information available, as well as predict up-and-coming data-needs when participating in discussions about new products or features.

You should be highly collaborative and organized. You should be capable of prioritizing multiple deliverables and effectively communicate progress and blockers. You should feel comfortable working across multiple data-sources, and be capable of participating in and understanding how multiple systems communicate information to one-another.

Key job responsibilities

• Designing, developing, troubleshooting, evaluating, deploying, and documenting data management and business intelligence systems, enabling stakeholders to manage the business and make effective decisions.
• Work with business customers in understanding the business requirements and implementing solutions to support analytical and reporting needs.
• Design and implement an analytical environment using third-party and in-house reporting tools, modeling metadata, building reports & dashboards and providing our customers timely, flexible and structured access to their data.
• Ensuring completeness and compatibility of the technical infrastructure to support system performance, availability and architecture requirements
• Reviewing and participating in testing of the data design, tool design, data extracts/transforms, networks and hardware selections
• Implement training and documentation solutions that enable business stakeholders to get the most out of our self-serve reporting tools.

BASIC QUALIFICATIONS

• Bachelor's Degree in Computer Science or a related technical field, and solid years of relevant experience.
• Strong grasp of SQL and at least one scripting or programming language.
• 8+ years of experience with and detailed knowledge of data warehouse technical architectures, data modeling, infrastructure components, ETL/ ELT and reporting/analytic tools and environments, data structures and hands-on SQL coding.
• 3+ years of large IT project delivery for BI oriented projects.
• 3+ years of working with very large data warehousing environment

PREFERRED QUALIFICATIONS

• Experience in designing and delivering cross functional custom reporting solutions.
• Experience with Massively Parallel Processing (MPP) databases - Redshift (preferred), Teradata
• Experience with reporting tools - Quicksight, Tableau (preferred)
• Excellent oral and written communication skills including the ability to communicate effectively with both technical and non-technical stakeholders.
• Proven ability to meet tight deadlines, multi-task, and prioritize workload
• A work ethic based on a strong desire to exceed expectations.
• Strong analytical skills