Business Intelligence Engineer II, R2L
Amazon
Full-time
On-site
Bellevue, Washington, United States
$89,600 - $185,000 USD yearly
The LPE – Technical Solutions team, supporting the Rapid and Rural Logistics (R2L) org, is seeking a truly innovative Business Intelligence Engineer with broad technical skills to help build the infrastructure and tools required to support a new, fast growing business.
The ideal candidate will have a passion for automation and clean, streamlined process design. The applicant will draw upon advanced analytical, critical thinking, problem solving skills, software development experience, and an aptitude for creating maintainable, highly reliable, distributed systems which operate 24/7/365. You will work with analytic tools, write excellent scripts, partner with customers to answer key business questions, and act as an advocate for your customers. Successful members of this team collaborate effectively with internal end-users, cross-functional software development teams, and technical support/sustaining engineering teams to solve problems, implement new solutions, and deliver successfully against high operational standards of system availability and reliability. We look for candidates who are excellent communicators, self-motivated, flexible, hardworking, and who like to have fun.
The complexity of research and skills for a Business Intelligence Engineer is well beyond basic data entry and extraction. It involves design and development of automated data pipelines, sophisticated analytical model and intuitive data visualization. In addition, this role is on a large analytical team that supports a wide range of businesses. This role has great exposure to a broad scope that can really help shape the future of operational fulfillment and promotes career progression.
Key job responsibilities
• Perform data extraction, manipulation, and production from database tables
• Own the design, development, and maintenance of reports, analyses, dashboards, etc. to drive key business decisions
• Create automated tools via VBA and connection to streamline process execution
• Create data flows and develop/manage new metrics
• Design, implement and validate complex logic using queries
- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- 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 large-scale, complex datasets
Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.
The ideal candidate will have a passion for automation and clean, streamlined process design. The applicant will draw upon advanced analytical, critical thinking, problem solving skills, software development experience, and an aptitude for creating maintainable, highly reliable, distributed systems which operate 24/7/365. You will work with analytic tools, write excellent scripts, partner with customers to answer key business questions, and act as an advocate for your customers. Successful members of this team collaborate effectively with internal end-users, cross-functional software development teams, and technical support/sustaining engineering teams to solve problems, implement new solutions, and deliver successfully against high operational standards of system availability and reliability. We look for candidates who are excellent communicators, self-motivated, flexible, hardworking, and who like to have fun.
The complexity of research and skills for a Business Intelligence Engineer is well beyond basic data entry and extraction. It involves design and development of automated data pipelines, sophisticated analytical model and intuitive data visualization. In addition, this role is on a large analytical team that supports a wide range of businesses. This role has great exposure to a broad scope that can really help shape the future of operational fulfillment and promotes career progression.
Key job responsibilities
• Perform data extraction, manipulation, and production from database tables
• Own the design, development, and maintenance of reports, analyses, dashboards, etc. to drive key business decisions
• Create automated tools via VBA and connection to streamline process execution
• Create data flows and develop/manage new metrics
• Design, implement and validate complex logic using queries
- 3+ years of analyzing and interpreting data with Redshift, Oracle, NoSQL etc. experience
- Experience with data visualization using Tableau, Quicksight, or similar tools
- Experience with data modeling, warehousing and building ETL pipelines
- Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling
- Experience in Statistical Analysis packages such as R, SAS and Matlab
- 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 large-scale, complex datasets
Amazon is committed to a diverse and inclusive workplace. Amazon is an equal opportunity employer and does not discriminate on the basis of race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status. For individuals with disabilities who would like to request an accommodation, please visit https://www.amazon.jobs/en/disability/us.
Our compensation reflects the cost of labor across several US geographic markets. The base pay for this position ranges from $89,600/year in our lowest geographic market up to $185,000/year in our highest geographic market. Pay is based on a number of factors including market location and may vary depending on job-related knowledge, skills, and experience. Amazon is a total compensation company. Dependent on the position offered, equity, sign-on payments, and other forms of compensation may be provided as part of a total compensation package, in addition to a full range of medical, financial, and/or other benefits. For more information, please visit https://www.aboutamazon.com/workplace/employee-benefits. This position will remain posted until filled. Applicants should apply via our internal or external career site.