Business Intelligence Engineer - AWS

Role: Business Intelligence Engineer
Type: Full Time Employment
Location: Bellevue WA

The BI Engineer will work with large datasets and distributed computing technologies. This role will be creating and optimizing table structures identifying KPIs that drive the business generating reports for those KPIs that are consumed across the Key for Business organization analyzing data to inform strategic and tactical initiatives and writing up the findings from analyses for lesstechnical audiences. Strong SQL (any implementation) is a must. Scripting skills and background in operations is extremely valuable. This is a highly visible role that partners with business product management operations and the technical team.

Responsibilities

• Enable decisionmaking by retrieving and aggregating data from multiple sources to present in a digestible and actionable format

• Work with product teams to identify gaps and trends in existing reporting

• Analyze large data sets using a variety of database query and visualization tools

• Provide technical expertise in extracting integrating and analyzing critical data

• Design and develop key performance metrics and indicators using standardized and custom reports

• Perform ad hoc analysis to quickly solve time sensitive operational issues and business cases

• Work with technical and nontechnical stakeholders to improve current data & analytics processes and develop new capabilities

• Maintain documentation for systems processes and decisions.

• Contribute to the design implementation and delivery of BI solutions for complex and ambiguous problems

• Conduct deep dive analyses of business problem statements and formulate conclusions and recommendations to leadership

• Identify opportunities and key criteria to drive analytical reporting and business strategy

• Develop and drive best practices in data integrity consistency analysis validations and documentation

Minimum Qualifications

• Experience with SQL/Python/VBA;

• Power user with Tableau/PowerBI or other BI tools;

• Proficiency in MS Excel;

• Fluency in SQL

• Experience in building relational databases reporting/BI platforms or leveraging statistics for data analytics;

• Experience in modern data warehousing techniques (dimensional data modeling experience with ETL etc.);

• Experience with data visualization using Tableau Quicksight or similar tools

• Strong team player and the ability to work in a diverse environment with people in various locations;

• Impeccable attention to detail passion for processes systems and data mining;

• Excellent listener quick learner and able to handle ambiguity;

• Ability to work independently in a fastpaced and rapidly changing environment.

• Excellent verbal and written communication skills with the ability to convey complex information in an understandable way.

• Degree in Computer Science Mathematics Statistics or related field

Desired Qualifications

• Experience with AWS solutions such as EC2 DynamoDB S3 and Redshift

• Experience in data mining ETL etc. and using databases in a business environment with largescale complex datasets

• Experience in Statistical Analysis packages such as R SAS and Matlab

• AWS Certification: AWS Certified Solutions Architect or AWS Certified Data Analytics Specialty.

• Experience with BI tools like Tableau or Power BI.

• Expertise in data visualization principles and best practices.