Business Intelligence Consultant
Redmond, Oregon, United States of America
Contract
3 days ago
Key skills
PythonSQLETLData EngineeringAnalyticsBIBusiness IntelligenceTableauPower BIRedshiftSparkAirflowAWSLambdaS3GlueAthenaMySQLSQL ServerSalesforceLeadershipStakeholder ManagementRisk ManagementA/B Testing
About this role
Local only/Looking 13+ years of experience
Job Title: Business Intelligence Consultant
Location: Must be onsite in Redmond, WA
Duration: 3 Months
Duration: 3 Months
Role Overview
We are seeking a data-driven Senior Business Intelligence Consultant to join our team in Redmond. This role is designed for a professional who thrives on bridging the gap between complex data engineering and executive-level strategy. You will be responsible for architecting automated ETL pipelines, managing petabyte-scale data platforms, and delivering data-validated solutions that drive high-level decision-making.
The ideal candidate has a proven track record of managing data integrity through major migrations and leveraging statistical modeling to solve intricate business problems in the tech and finance sectors.
Key Responsibilities
We are seeking a data-driven Senior Business Intelligence Consultant to join our team in Redmond. This role is designed for a professional who thrives on bridging the gap between complex data engineering and executive-level strategy. You will be responsible for architecting automated ETL pipelines, managing petabyte-scale data platforms, and delivering data-validated solutions that drive high-level decision-making.
The ideal candidate has a proven track record of managing data integrity through major migrations and leveraging statistical modeling to solve intricate business problems in the tech and finance sectors.
Key Responsibilities
- Data Architecture & ETL Engineering: Design and deploy high-volume automated ETL pipelines processing 4+ billion records daily using Apache Iceberg, AWS Glue, and Lambda to ensure high-performance querying and efficient refresh cycles.
- Stakeholder Management: Collaborate with cross-functional stakeholders and Product Managers to define KPIs and deliver strategic reports for L10/VP-level leadership.
- Querying & Database Management: Run complex queries and manage disparate logging systems across AWS environments, including Redshift, Aurora, S3, and Athena.
- Risk Management & Quality Assurance: Lead data integrity validation during large-scale system migrations (e.g., Salesforce 1.0 to 2.0) and develop custom SQL logic to mitigate human input errors and environmental risks.
- Advanced Analytics: Leverage data science techniques such as A/B testing, regression models, and segmentation algorithms to identify high-value opportunities and optimize operational performance.
- Reporting & Visualization: Create and maintain high-visibility dashboards (QuickSight, Tableau) utilizing SPICE and calculated fields to automate Weekly, Monthly, and Quarterly Business Reviews.
- Required Qualifications
- Experience: Minimum of 4+ years of experience in Business Intelligence, Data Engineering, or a related consulting role.
- AWS Fluency: Deep technical expertise in the AWS ecosystem, specifically Redshift, S3, Athena, Glue, and QuickSight.
- Languages: Expert-level SQL, Python, and Spark.
- Databases: Experience with Trino, EMR, MySQL, and Microsoft SQL Server.
- Tools: Proficiency in Airflow, Tableau, Power BI, and Excel VBA.
- Analytical Skills: Strong background in statistical modeling, including Bayesian Analysis, Decision Trees, and Random Forests.
- Education: B.S. in Business Administration, Accounting, or a related quantitative field.
- Experience in Risk Management, specifically conducting root cause analysis on hardware or environmental failure rates.
- Proven ability to automate manual reporting processes, saving significant daily man-hours for organizational stakeholders.
- Ability to manage 30,000+ project migrations across diverse global regions.