New

Business Intelligence Engineer

Ampcus, Inc
United States, Washington, Bellevue
Jan 22, 2025
Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Business Intelligence Engineer Location(s): Bellevue, WA Have you ever ordered a product on client and when that box with the smile arrived you wondered how it got to you so fast? Have you wondered where it came from and how much it cost client to deliver it to you? If so, the Logistics, Last Mile team is for you. We manage the delivery of tens of millions of products every week to customers, achieving on-time delivery in a cost-effective manner. We are hiring a Business Intelligence Engineer to identify strategic initiatives that will form the next generation of client Logistics. As a Business Intelligence Engineer you will be working in one of the world's largest and most complex data warehouse environments. In this role, you will primarily work on designing and building automated reporting and dashboards using complex data. We are still in the nascent stage so it is an exciting opportunity to be involved from design-to-execution. As a BI Engineer, you will operate as a mix of hands-on builder and influencer. Key job responsibilities: Develop complex queries for ad hoc requests and projects, as well as ongoing reporting. Design, develop and maintain scalable, automated, user-friendly systems, reports, dashboards, etc. that will support our analytical and business needs. Design, implement, and support key datasets that provide structured and timely access to actionable business information addressing stakeholder needs. Interface directly with stakeholders, gathering requirements and owning automated end-to-end reporting solutions. Partner with analysts, data engineers, business intelligence engineers, and software development engineers across client to produce complete data solutions. Simplify and automate reporting, audits, and other data-driven activities; build solutions to have maximum scale and self-service ability by stakeholders Proficiency with SQL queries to retrieve and analyze data. Learn and understand a broad range of client data resources and know how, when, and which to use. Estimate models, write analyses, and extract insights and provide business recommendations. Basic Qualifications: 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 in Statistical Analysis packages such as R, SAS and Matlab. Experience using SQL to pull data from a database or data warehouse and scripting experience (Python) to process data for modeling. Preferred 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 large-scale, complex datasets. Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.