BUSINESS INTELLIGENCE ENGINEER JOB DESCRIPTION

A Business Intelligence Engineer turns raw warehouse data into the metrics and dashboards that product, finance, and operations teams rely on to make daily decisions. In SaaS environments, this means navigating star-schema dimensional models, ETL pipelines, and self-service reporting layers simultaneously, often while maintaining SLA commitments on dashboards consumed by hundreds of internal stakeholders. Not every data practitioner owns that full stack. The BIE does: from source-to-target mapping and data quality monitoring through to the semantic layer that lets non-technical users answer their own questions without writing a line of SQL.

As the Business Intelligence Engineer, you design, build, and maintain the reporting infrastructure and analytical data products that drive data-backed decision-making across a SaaS organization. You sit within the data or analytics function, partnering with data engineers, product managers, and business stakeholders at all levels to translate complex requirements into governed, scalable BI solutions.

Career Impact: Owning the semantic layer and dimensional model for a SaaS product positions you among the specialists who can credibly move between data engineering and analytics leadership tracks, a distinction that commands premium in a market that increasingly separates BIEs from generalist data analysts.

Business Impact: The dashboards and pipelines you ship become the operational nerve center for finance, product, and operations teams. When data quality or SLA adherence slips, those teams lose the visibility they need to manage customer retention and revenue.

Growth Opportunity: Sustained exposure to cloud data warehousing architecture, dbt-style transformation workflows, and stakeholder-facing reporting builds the scope and credibility needed to advance into a Senior BIE, Analytics Engineering Lead, or Data Platform Manager role.

• Design and build dimensional data models, semantic layers, and datamarts that support governed reporting and self-service analytics.
• Develop ETL and data pipeline solutions connecting heterogeneous source systems to the central data warehouse, meeting defined SLA requirements.
• Create and maintain dashboards, reports, and visualizations that translate complex datasets into actionable insights for non-technical stakeholders.
• Collaborate with data engineers and product teams to define data elements, source-to-target mappings, and data structures for new analytical use cases.
• Conduct source data analysis, profiling, and quality monitoring to ensure accuracy and consistency across reporting assets.
• Gather and translate business requirements from cross-functional stakeholders into documented technical specifications and data solutions.
• Monitor production data pipelines and dashboards, diagnose root causes of data discrepancies, and drive resolution within agreed SLA windows.
• Mentor junior analysts and business users on SQL best practices, self-service reporting tools, and data literacy.

• Bachelor's degree in Computer Science, Information Systems, Engineering, Statistics, or equivalent work experience.
• 4 or more years of business intelligence or data engineering experience, with demonstrated ownership of end-to-end reporting solutions.
• Advanced proficiency in SQL, including complex query optimization, DDL, and schema design across large-scale relational databases.
• Hands-on experience with data warehouse design principles including star schema, snowflake schema, and slowly changing dimensions.
• Demonstrated experience designing and implementing ETL or ELT pipelines using modern transformation and orchestration frameworks.
• Proven ability to build and deliver dashboards and visualizations that serve both technical and non-technical audiences.
• Experience working in Agile environments, including backlog grooming, sprint planning, and iterative delivery.
• Strong written and verbal communication skills with the ability to convey technical concepts clearly to business stakeholders.

• Master's degree in Computer Science, Statistics, Engineering, or a closely related quantitative discipline.
• Experience with cloud data warehousing platforms and associated services, particularly within AWS or Azure ecosystems.
• Background in statistical analysis or scripting for advanced analytics and predictive modeling use cases.
• Familiarity with data governance frameworks, SOX compliance controls, or data quality monitoring tooling in a public company environment.

• Dashboard SLA adherence rate, measuring the percentage of reports delivered within agreed refresh windows.
• Data pipeline uptime percentage, reflecting reliability of ETL processes across all production environments.
• Mean time to resolution for data quality incidents, tracking how quickly discrepancies are identified and corrected.
• Self-service adoption rate among business stakeholders, measured by the share of report queries fulfilled without BIE intervention.
• Source-to-target mapping coverage percentage, indicating completeness of documentation for governed data assets.
• Typical tools: Data warehouse platforms (commonly Snowflake or Amazon Redshift); visualization (commonly Tableau or Power BI); transformation (commonly dbt).

• Base Salary Range: $115,000 to $155,000 annually, depending on experience and location
• Bonus: Annual performance bonus typically 8% to 12% of base salary
• Equity: RSU grants common at Series C and above; options typical at earlier-stage companies
• Health Benefits: Medical, dental, and vision coverage; employer typically covers 80% to 100% of premiums
• PTO: 15 to 20 days annually; many SaaS employers offer unlimited PTO policies
• Common Perks: Home office stipend, professional development budget, and conference attendance support

Figures are estimates based on general US market benchmarks and may be outdated. Adjust based on location, company size, and seniority level.

Background check completion is a condition of employment for this role. All qualified applicants will receive equal consideration without regard to race, color, religion, sex, national origin, age, disability, veteran status, sexual orientation, gender identity, or any other characteristic protected under applicable federal, state, or local law. Reasonable accommodations are available to individuals with disabilities throughout the application and employment process upon request. Candidates must be authorized to work in the United States.

The Business Intelligence Engineer owns the full lifecycle of enterprise BI and analytics products, from architecting large-scale data management solutions to tuning PostgreSQL and NoSQL databases, within a cross-functional development environment. Working across product management, QA, and junior team members, this role delivers reliable data infrastructure that supports feature definition and organizational decision-making.

Key Responsibilities

• Architect and design large-scale data management and business analytics solutions applying industry knowledge, best practices, and architectural guidance.
• Design, develop, and unit-test enterprise BI and analytics products using proprietary and third-party tools.
• Design, build, test, implement, and support ETL and data integration solutions that meet defined requirements.
• Tune and optimize PostgreSQL and NoSQL databases and diagnose and resolve performance issues.
• Manage daily goals, priorities, tradeoffs, risks, and performance across all development projects.
• Provide technical leadership, career development, and mentoring to junior team members.
• Collaborate with cross-functional teams to develop project goals and timelines.
• Drive detailed definition of feature requirements through discussions with product management.
• Work with QA to define test plans and test cases for applications.

Required Qualifications

• Substantial experience with large data warehouse environments, ETL processes, and relational and multi-dimensional modeling.
• 4+ years of professional BI and analytics development experience with heavy use of tools such as Tableau, OBIEE, BOBJ, or Cognos.
• 3+ years of professional RDBMS development experience leveraging complex SQL, DML, DDL, and well-designed schemas.
• 2+ years of professional web application development experience with heavy use of Java, Ruby, Python, or related open-source frameworks.
• Working experience with report design tools, including Tableau, Birst, Cognos, BOBJ, or OBIEE, and hands-on experience with complex SQL.
• Experience with BI solution vendors such as Birst, BOBJ, or Cognos, including report design and model creation.
• Excellent RDBMS engineering skills on SQL Server, including high proficiency with SQL, DDL, stored procedures, and schema design.
• Experience with BI and analytics on NoSQL or big data systems, including Hadoop, S3, or Redshift, is a plus.
• Experience with cloud-based data warehousing platforms such as Snowflake is a plus.
• 2+ years of project management experience with onshore and offshore engineers is a plus.

Embedded within a high-performing enterprise analytics organization, the Senior Business Intelligence Engineer architects scalable data pipelines across on-premise and cloud repositories and creates user-facing dashboards that surface key business insights. Working closely with internal stakeholders at all levels, this role advances analytical capability and drives data-informed decision-making across the organization.

Core Functions

• Architect scalable data pipelines across on-premises and cloud data repositories.
• Create data flow diagrams and document source-to-target mapping.
• Maintain data warehouse performance by optimizing batch processing through parallelization, performance tuning, and aggregations.
• Create user-facing dashboards that provide key insights for specific audiences.
• Recognize and adopt best practices and cost-effective solutions for developing analytical insights on-premises and in the cloud.
• Provide guidance and mentor junior team members.
• Keep current with business intelligence data trends and technological innovations.
• Execute proofs of concept with new technologies and drive innovation.

Education & Experience

• Bachelor's degree in Computer Science, Information Systems, Operations Research, Mathematics, Statistics, or a related technical field.
• 7+ years of direct experience using databases, including Oracle, MySQL, or SQL Server.
• 5+ years of hands-on experience developing with SQL, PL/SQL, SSIS, SSAS (Tabular), Power BI, and C#.
• Strong understanding of data modeling, including conceptual, logical, and physical model design, and experience with operational data stores, enterprise data warehouses, and data marts.
• Strong experience with business intelligence and data warehousing design principles, including multi-dimensional modeling with star schemas, snowflakes, de-normalized models, and slowly changing dimensions.
• Experience with AWS and its associated offerings, including Glue, Redshift, Athena, S3, and Spectrum.
• Deep expertise in Python.
• Experience collaborating with a development team using established source control such as Git.
• Ability to learn and apply new technologies to business problems.
• Excellent written and verbal communication skills.

Reporting to senior IT leadership, the Business Intelligence Engineer designs and develops ETL packages and secure reporting interfaces, including Qlik-based data visualizations, to enhance understanding of organizational performance across business units. Partnering with the performance management team and business stakeholders, this role supports the strategic development of BI capability and ensures the data warehouse remains interoperable with current BI solutions.

Primary Duties

• Carry out programming, development, and maintenance tasks, ensuring feasibility has been assessed, security standards have been adhered to, test scripts are prepared, and testing is complete and successful.
• Maintain detailed knowledge of current practice in own area of expertise.
• Develop and maintain the data warehouse to support BI requirements using dimensional modeling principles and assist in the design of databases to ensure interoperability with BI solutions.
• Work with the performance management team to assist in data visualization and the building of dashboards.
• Design and develop ETL packages to carry out extraction, transformation, loading, and data conversion tasks.
• Design and develop secure reporting interfaces to required data sources and create data visualizations using Qlik to enhance understanding of organizational performance.
• Support the development of strategic goals for BI in conjunction with the business and stakeholders.
• Document solution technical designs and implementation information.
• Keep abreast of technological advances and conduct research, evaluate, and make recommendations about BI products, tools, services, and standards to support procurement and development efforts.

Skills & Qualifications

• Degree or equivalent qualification in a technology discipline.
• Experience developing user requirements into successful BI visualizations, ideally using Qlik, to support organizational performance improvement.
• Experience with data warehouse design.
• Experience using and configuring Team Foundation Server (TFS).
• Proven analytical and problem-solving skills and demonstrable experience providing technical and user support at an advanced level.
• Understanding of data modeling techniques for relational and dimensional databases, including dimensional modeling theory.
• Knowledge or experience of Oracle or Microsoft SQL Server databases, including the creation of database objects and stored procedures.
• Working knowledge of XML, ASP.NET, HTML, JavaScript, CSS, and SQL Server.
• Ability to communicate effectively and professionally.

Sitting at the intersection of data architecture and end-user analytics, the Business Intelligence Engineer designs and builds dashboards and BI semantic layers that serve both governed reporting and self-service data discovery for business stakeholders. Operating across BI platform administration, stakeholder requirement workshops, and user training, this role shapes an analytics environment that extends beyond stated requirements to address core business needs.

Duties

• Design and create data marts, views, and BI semantic layers for governed reporting and self-service data discovery and analytics.
• Design and build dashboards and reports that go beyond stated requirements and serve core business needs.
• Contribute to data warehouse architecture using industry best practices as the foundation of BI.
• Participate in requirement workshops with business stakeholders to understand root business needs for new reporting and analytics use cases.
• Build experimental data models to create prototypes of reports and dashboards from a variety of data sources, including flat files.
• Administer BI platforms to ensure the environment is secure, up to date, and accessible by the user base.
• Provide training and support to non-technical users on accessing reports and dashboards and self-servicing using the semantic model.

Requirements

• Hands-on experience architecting, developing, and administering front-end BI tools such as Sisense and Tableau.
• Hands-on experience with data warehouse technologies, preferably cloud-based platforms such as Google BigQuery and Snowflake.
• Progressive experience querying data using SQL, Python, or other means.
• Knowledge of data warehouse architecture and concepts such as the star schema.
• Knowledge and experience in data transformation using SQL, Python, or Java is a strong asset.
• Well-versed in dashboard UX principles with the ability to build visually impactful, organized, and effective dashboards using appropriate visualizations.
• Excellent communication skills with the ability to convey highly technical concepts to a non-technical audience.
• Excellent problem-solving skills with the ability to systematically analyze, hypothesize, and resolve issues in the BI platform.
• Experience working in an Agile environment, including developing stories, prioritizing tasks, and backlog grooming.

A key member of the Prime Video Channels analytics team, the Business Intelligence Engineer leads large-scale data and analytical projects by generating actionable insights and building self-service Tableau infrastructure that supports marketing, vendor management, and content acquisition decisions. Collaborating across leadership, business partners, and cross-regional teams, this role delivers sound methodological analysis that scales the business across the EU and worldwide.

Functions

• Work with marketing, vendor management, content acquisition management, and leadership to identify data needs and requirements.
• Generate and present concrete and actionable insights and recommendations for leadership based on sound methodological analysis.
• Communicate analysis results and techniques clearly and confidently to peers and business partners, both verbally and in writing.
• Build mechanisms to surface knowledge and learnings to the business.
• Recognize and adopt best practices in reporting and analysis, and write quality code to retrieve and analyze data.
• Set up and maintain self-service infrastructure, including dashboards, for the team in Tableau.
• Lead large-scale data and analytical projects to help scale the business across the EU or worldwide.

Experience & Qualifications

• Bachelor's degree in computer science, mathematics, engineering, statistics, or a quantitative field, or equivalent experience.
• Master's degree in computer science, mathematics, engineering, statistics, or a highly quantitative field, or equivalent.
• Experience as a Business Intelligence Engineer, Data Scientist, Applied Scientist, Data Engineer, or in a similar role.
• Experience with BI visualization tools, including Tableau, Power BI, or Qlik.
• Experience using AWS services such as Amazon Redshift and S3.
• Experience translating business requirements into data models.
• Excellent SQL writing skills and solid experience with Excel and working with databases.
• Extensive experience applying theoretical models in an applied environment.
• Expertise in a broad set of machine learning approaches and techniques.

Reliable delivery of IT solutions for customer satisfaction, operations, and manufacturing engineering depends on the Senior Business Intelligence Engineer, who develops and supports information systems, integrates databases through ETL processes, and monitors running applications to resolve software and data issues. Based within a team reporting up through computer engineering and IT, this role aligns modernization and legacy replacement projects with internal customer requirements across manufacturing operations.

Accountabilities

• Develop and support information systems required for customer satisfaction, operations, and manufacturing engineering organizations.
• Integrate existing applications and databases with ETL processes.
• Support data visualization using BI tools.
• Implement developed IT solutions, including documentation and training.
• Analyze internal customer requirements in the area of applications and databases.
• Monitor working applications, collect feedback from users, and resolve software and database issues.
• Monitor required system resources.
• Identify opportunities to improve running applications to better align them with process requirements.
• Support modernization and legacy system replacement projects.

Technical Qualifications

• Bachelor's degree in Computer Engineering, Computer Science, Information Systems, Electrical Engineering, or a related field.
• Experience with ETL processes.
• Knowledge of programming languages and databases, including SQL, Java, MySQL, Oracle, and Python.
• Analytical skills in collecting, comparing, and relating data from different sources.
• High proficiency in information technology and familiarity with critical business data systems, including SAP, Confluence, and Jira.
• Experience in the automotive industry.

As the Business Intelligence Engineer, this role develops dashboards, automated reporting, and interactive data visualizations while partnering with underwriting, actuarial, and finance teams to translate business strategy into efficient digital solutions. The analytics and IT organization relies on this work to maintain a close working relationship that ensures existing solutions and available resources are applied to drive measurable efficiency and outcomes.

Activities

• Develop dashboards, automated reporting, and interactive data visualizations using BI software and other tools to ensure reliable and efficient delivery.
• Analyze, design, code, and test tools and provide technical troubleshooting, support, and resolution for application problems.
• Create and maintain documentation, including business requirements, functional design, technical design, implementation plans, and user guides.
• Define and implement best practices for clean, extensible code, agile development, design principles, frameworks, and toolkits.
• Lead and drive large- and small-scale initiatives with short development cycles, high-quality work, and timely delivery against commitments.
• Work closely with underwriting, actuarial, and finance teams to understand business strategy and provide thought leadership on digital solutions that improve efficiency and outcomes.
• Maintain a close working relationship with analytics and IT teams to understand existing solutions and available resources.

Position Requirements

• Bachelor's degree in a technical discipline such as Computer Science, Finance, Economics, Engineering, or Statistics, or an advanced degree in Business.
• 3+ years of experience in a development role demonstrating practical application of technical skills.
• Proficiency in Power BI, SQL, R, VBA, or Stata.
• Experience with Python or similar languages preferred.
• Knowledge of agile development methodologies and willingness to experiment with and learn new technologies.
• Strong advanced verbal and written communication skills, including listening, teamwork, and effective presentation.
• Ability to explain complex details and methodologies to both technical and non-technical audiences.
• Ability to introduce and drive innovative ideas and processes within established environments.

Sr Business Intelligence Engineer builds and delivers day-to-day reporting and dashboards across finance, HR, legal, product, operations, and executive functions, and designs platforms that provide ad hoc access to large datasets. Success in the position means continuously improving reporting processes through collaboration with business systems, data engineering, and business partner teams while ensuring SOX compliance and statistical integrity across all analytics outputs.

Operational Focus

• Build and deliver day-to-day reporting and dashboards for various functional areas, including finance, HR, legal, product, operations, and executive teams.
• Work with functional areas to gather reporting requirements, identify data gaps, highlight enhancement opportunities, and propose solutions.
• Extract and combine data from various heterogeneous data sources.
• Design, implement, and support a platform that provides ad-hoc access to large datasets.
• Utilize internal and external data and systems to establish an understanding of customer behavior and engagement.
• Support and contribute to the BI team's knowledge base through documentation, data mapping, delivery methods, and areas of improvement.
• Model data and metadata to support ad-hoc and pre-built reporting.
• Continuously improve the future state of reporting processes by collaborating with business systems, data engineering, and business partner teams.
• Provide statistical analysis on critical data to derive insights.
• Assess the effectiveness and accuracy of new data sources, data points, and data gathering techniques.

Knowledge Skills & Abilities

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field.
• 4+ years of experience in an analytical business operations and data engineering role, preferably at a technology or high-growth company.
• Hands-on experience writing complex SQL queries for data analysis and DBT data modeling skills.
• Functional domain knowledge of finance, HR, legal, sales, product, and operations.
• Experience using Tableau or other visualization tools.
• Background in statistical analysis using Python is a plus.
• Understanding of SOX compliance and internal controls for a public company.
• Demonstrated experience building and maintaining key dashboards.
• Strong communication and organizational skills to collaborate with multiple stakeholders and drive outcomes.
• Ability to manage and deliver on shifting priorities in a fast-paced environment with strong time management skills.

The Business Intelligence Engineer produces ongoing metrics, reports, analyses, and dashboards that drive key business decisions, operating at the intersection of data engineering and stakeholder engagement across a cross-functional environment. Working with business customers, data engineering, and embedded business analysts, this role develops the reporting infrastructure and analytical recommendations that improve operational and quality outcomes at scale.

Key Deliverables

• Engage with leadership and diverse customer groups to understand needs and recommend business intelligence solutions.
• Partner with the data engineering team to define the data elements and structures the team should leverage to enable capabilities.
• Design, implement, and support platforms that provide business teams ad-hoc access to large datasets, including data visualization tools for non-technical business users.
• Interface with business customers, gather requirements, and deliver complete reporting solutions.
• Own the design, development, and maintenance of ongoing metrics, reports, analyses, and dashboards to drive key business decisions.
• Participate in strategic and tactical planning discussions.
• Standardize data and report consumption across all customer groups.
• Make recommendations for new metrics, techniques, and strategies to improve operational and quality metrics.

Professional Experience

• Bachelor's degree in Computer Science, Engineering, Mathematics, or a related technical discipline.
• Master's degree in BI, Finance, Engineering, Statistics, Computer Science, Mathematics, or a related field.
• 3+ years of experience as a Business Intelligence Engineer or in a similar role.
• 3+ years of relevant experience as a data scientist, data engineer, software engineer, business intelligence engineer, or equivalent.
• Expert-level proficiency in writing complex, highly optimized SQL queries across large datasets.
• Hands-on experience and advanced knowledge of SQL and Python or other scripting languages.
• Experience with data modeling, data warehousing, and building ETL pipelines.
• Experience in data mining, SQL, ETL, and using databases in a business environment with large-scale, complex datasets.
• Experience building and operating highly available, distributed systems for data extraction, ingestion, and processing of large datasets.
• Experience with visualization tools such as Quicksight or Tableau.

Embedded within a cross-functional analytics environment, the Business Intelligence Engineer enables decision-making by conducting analyses from multiple sources, developing key performance metrics, and leading information security vetting processes to ensure data compliance. Working closely with subject matter experts, business analysts, and security and legal teams, this role advances the organization's capacity to resolve operational issues and translate business requirements into actionable technical outputs.

Areas of Ownership

• Provide technical expertise in integrating and analyzing critical data.
• Enable decision-making by conducting analyses from multiple sources and presenting research in a digestible and actionable format.
• Analyze large datasets using a variety of query and visualization tools.
• Anticipate, identify, structure, and solve critical problems.
• Design and develop key performance metrics and indicators using standardized and custom reports.
• Perform ad-hoc analysis to quickly resolve time-sensitive operational issues and business cases.
• Lead information security and privacy vetting processes with security and legal teams to ensure data compliance and navigate compliant solutions.
• Provide mentorship and coaching to embedded business analysts.
• Manage multiple projects and proactively communicate issues, priorities, and objectives.
• Work with subject matter experts to document and translate business requirements into technical requirements.

Education & Experience

• Bachelor's degree in Business, Statistics, Finance, Computer Science, Engineering, Economics, or a related field, or equivalent work experience.
• 3+ years of experience in data analysis, dashboard design, research, or similar work.
• 3+ years of experience using SQL to extract and aggregate data used for reporting or modeling.
• 3+ years of experience creating dashboards in data visualization software such as Tableau, Looker, or Power BI.
• 3+ years of experience in Python or R to develop statistical models and analyses.
• Advanced Excel skills.

Reporting to senior technical leadership, the Senior Business Intelligence Engineer designs dimensional models and BI semantic layers, develops and monitors data pipelines, and leads strategic planning of BI infrastructure, including budget analysis and business case recommendations, within an Azure-based technology environment. Partnering with departmental data owners, stewards, and cross-functional IT teams, this role oversees data governance documentation and drives the quality monitoring framework that sustains high service levels across the organization.

Role Responsibilities

• Collaborate with business and IT teams to design dimensional models that represent business processes.
• Design and build data models, views, BI semantic layers, and BI assets for governed reporting and self-service data discovery and analytics.
• Engage in workshops with business stakeholders to understand underlying requirements for new reporting and analytics use cases and develop dashboards and reports that meet those needs.
• Conduct source data analysis and profiling to complete source-to-target mapping.
• Develop, implement, and monitor data pipelines to maintain a high level of service and data quality.
• Support the development and implementation of a data quality monitoring framework with departmental data owners and stewards.
• Supervise staff in maintaining data governance documentation.
• Lead strategic planning of BI infrastructure, including budget analysis, identification of technical requirements, and business case recommendations.

Background & Experience

• Post-secondary education or training in Engineering or Computer Science is an asset.
• A minimum of 5 years of in-depth business reporting and analytics experience.
• Extensive experience in Business Intelligence, Data Architecture, and cloud-based technologies, especially within the Azure technology stack.
• Advanced knowledge of Power BI functionalities, administration, design, and implementation.
• Advanced working knowledge of SQL and DAX scripting.
• Deep understanding of data structures and schemas.
• Experience working in an Agile environment, including developing stories, prioritizing tasks, and backlog grooming.
• Excellent communication skills.
• Ability to quickly understand business needs and learn domain-specific knowledge.

Sitting at the intersection of data strategy and advanced visualization, the Senior Business Intelligence Engineer designs and executes end-to-end data collection solutions for an organization of 650+ customers and builds storytelling approaches to engage senior stakeholders up to the VP level. Operating across SQL-optimized data pipelines, scripting, and automated data collection, this role shapes the analytical direction of large-scale organizations and mentors colleagues on technical and product-related topics.

Job Functions

• Own end-to-end data collection, from planning to collection to analysis, including writing custom queries, cleaning and manipulating data, and working with large datasets.
• Design and execute the data solutions strategy for an organization of 650+ customers.
• Create advanced visualizations and reporting to support impact analysis of improvement opportunities.
• Build storytelling approaches to engage senior stakeholders up to VP level.
• Identify data sources and automate data collection using queries, scraping, and other techniques.
• Mentor colleagues on technical and product-related topics.

Required Qualifications

• Bachelor's degree in Mathematics, Statistics, Computer Science, or a related technical field.
• Master's degree in Computer Science, Engineering, Mathematics, Statistics, or a related discipline.
• 7+ years of relevant experience in business intelligence or data engineering.
• Hands-on experience writing complex, highly-optimized SQL queries across large datasets.
• Advanced use of scripting languages such as Python or R.
• Experience creating data pipelines and analytics and data visualization platforms, including Tableau, QlikSense, or Power BI.
• Previous experience with AWS technologies.
• Track record of driving data strategy for large organizations.
• Ability to display complex quantitative data in a simple, intuitive format and present findings clearly and concisely.

A key member of the analytics team, the Business Intelligence Engineer builds and supports robust data pipelines, creates dashboards and self-service tools, and serves as the resident expert on the nuances of the data infrastructure to ensure business partners can monitor trends and key metrics. Collaborating across data engineers, analysts, and business partners across multiple time zones, this role develops the analytical capability that fills gaps in data assets and drives measurable business impact.

What You'll Do

• Work directly with analysts and engineers to understand goals, gather requirements, and guide the development of new data assets by producing robust feature guides.
• Build and support robust data pipelines to support business tools and analytical needs and meet SLAs.
• Conduct UAT on new tables.
• Liaise with data engineers to understand and communicate the impacts of underlying data changes and update dependent pipelines.
• Identify and fill gaps among data assets and key metrics.
• Serve as the resident expert in understanding the nuances of the data infrastructure for the analytics team.
• Create reports, dashboards, visualizations, and self-service tools to help partners monitor business trends and key metrics.
• Monitor key metrics and business processes to identify trends and uncover root causes that drive business impact.

Qualifications & Experience

• 2+ years of relevant work experience in analytics, business intelligence, or technical operations.
• Fluency in SQL and Python and ETL using big data tools such as Hive or Presto and Redshift.
• Experience writing data pipelines using Airflow preferred.
• Strong understanding of data warehousing principles, pipelines, and APIs.
• Strong communication skills.
• Ability to work independently and across multiple time zones.

Sustained alignment between organizational strategy and operational execution depends on the Business Intelligence Engineer, who leads the design, development, and implementation of a BI-powered performance management platform with real-time connectivity to enterprise data sources, including IoT integrations. Serving as the primary technical partner to IT teams and external bodies, this role refines data governance practices and ensures balanced scorecard measures cascade accurately from strategy through to operational metrics across the organization.

Day-to-Day Responsibilities

• Develop and maintain a rich understanding of organizational offerings and processes in line with strategic direction and value proposition.
• Lead the design, development, implementation, and ongoing enhancement of a BI solution for performance management measurement.
• Lead the design, development, and maintenance of the data structure powering the BI solution with real-time connectivity to various data sources, inclusive of ETL, data aggregation, and custom calculations, following data governance best practices.
• Lead the technical development and delivery of user-centric information delivery channels, including IoT integrations, smart alerts, and portals.
• Create and execute advanced queries to search, validate, and test data.
• Create and maintain appropriate environments for development, testing, and production.
• Troubleshoot and resolve issues related to data structure and management.
• Work in partnership with IT teams to align goals and strategy to achieve enterprise master data management and ensure best practices and standards are followed in solution design and development.
• Ensure balanced scorecard measures are developed and maintained, mapping the linkage from strategy to operational metrics as they cascade through the organization.
• Engage with external bodies to share learnings and best practices on performance management.

Skills & Qualifications

• University degree in engineering, computer science, or a similar discipline.
• A minimum of 3 years of experience implementing and supporting an enterprise BI platform with demonstrated organizational, interpersonal, communication, data management, and analytical skills.
• Expert understanding of data and systems engineering concepts to effectively integrate and analyze data and develop actionable business information deliverables.
• Experience with BI, data manipulation, and data science tools and their application, including Tableau, Power BI, SQL, Cognos, and Sisense.
• Experience with cloud and on-premises data architecture, data integration and ETL, data warehousing, and BI deployed in complex environments.
• Extensive experience in multidimensional data modeling.
• Experience with relational SQL and multidimensional MDX query languages.
• Strong collaboration and problem-solving skills.
• Experience developing or integrating with IoT devices is considered an asset.

As the Business Intelligence Engineer at Shopbop, this role designs, develops, and implements scalable automated processes for data extraction and analysis while building and improving the presentation layer through enterprise reporting tools including Cognos, Tableau, and QuickSight. The enterprise data analytics team relies on this work to mine customer behavior insights, uncover trends that improve product and strategy decisions, and maintain a scalable, efficient reporting infrastructure across the organization.

Scope of Work

• Engage stakeholders in constructive dialogues to convert business problems into logic problems solvable with data, statistics, and scripting.
• Design, develop, and implement scalable, automated processes for data extraction, processing, and analysis.
• Partner with data engineering and software engineering teams to understand the underlying data model and drive scalable implementations of BI.
• Mine data and work with business partners to develop actionable data analysis to drive new customer acquisition, feature adoption, and customer satisfaction.
• Develop new customer behavior and product insights to enable business partners to make informed decisions.
• Analyze relevant business information and uncover trends and correlations to develop insights that can improve product and strategy decisions.
• Build and improve the presentation layer using enterprise reporting tools such as Cognos, Business Objects, Tableau, or QuickSight, and develop cubes or summary and reporting tables for various departments to enable self-service BI.
• Develop clear communications for recommended actions.
• Establish scalable, efficient, automated processes for tracking and reporting on progress of initiatives.
• Monitor and troubleshoot operational or data issues in data pipelines and reporting systems and review and audit existing ETL jobs and SQL queries.

Requirements

• Degree in Computer Science, Engineering, Mathematics, or a related field with 5+ years of industry experience.
• Master's degree in Engineering, Mathematics, Statistics, or a related discipline.
• Advanced SQL querying skills.
• 3+ years of experience with data visualization tools such as IBM Cognos Analytics, Business Objects, Tableau, or QuickSight.
• Experience working with large-scale, complex datasets.
• Demonstrated strength in data modeling, ETL, and data warehousing with databases such as Oracle, Redshift, or PostgreSQL.
• Ability to draw insights from data and clearly communicate them to stakeholders and senior management.
• 1+ year of experience working in a cloud infrastructure environment and using AWS technologies, including Data Pipeline, Redshift, Athena, S3, EC2, and QuickSight.
• Experience building and operating highly available, distributed systems for data extraction, ingestion, visualization, and processing of large datasets.
• Experience with programming tools, including Python or R, to create custom applications based on analytical needs.
• Proven capability in statistical analysis, including regression, modeling, and forecasting approaches.

Business Intelligence Engineer develops an in-depth understanding of data within related data warehouses and provides technical expertise in extracting, integrating, and analyzing critical data to support self-service analytics across the Ring Alarm product organization. The work directly supports the creation of interactive dashboards, key performance metrics, and scalable reporting infrastructure that enable data-backed decisions throughout the business.

Work Activities

• Develop an in-depth understanding and interpretation of data within related data warehouses.
• Provide technical expertise in extracting, integrating, and analyzing critical data.
• Analyze large datasets using a variety of database query and visualization tools.
• Perform ad-hoc analysis to quickly identify high-priority and time-sensitive operational issues.
• Clearly communicate data discrepancies and reporting downtime, including root cause, steps to resolution, and resolution date.
• Design and develop key performance metrics and indicators.
• Partner with key stakeholders to document and translate business requirements into technical requirements.

Experience & Qualifications

• Bachelor's degree in Information Systems, Business Intelligence, or Computer Science.
• 3+ years of experience as an analyst or engineer in the data and BI space.
• 3+ years of experience transforming datasets into visualizations using Tableau or a similar tool.
• SQL development experience using Amazon Redshift, PostgreSQL, Microsoft SQL Server, or similar engines.
• Front-end and self-service BI visualization development experience using Tableau.
• Knowledge of fundamental relational database technology and terminology.
• Database development experience in Amazon Redshift, Athena, or similar data warehouses.
• Ability to analyze complex datasets and business processes and quickly adapt to new technologies.
• Ability to analyze current work processes and systems and articulate potential improvement opportunities to leadership.
• Ability to work directly with key stakeholders to gather and interpret functional requirements.
• Strong organizational skills, attention to detail, and process-driven orientation toward continuous improvement.

The Business Intelligence Engineer creates data analysis and visualization tools that track cost, mass, and product readiness across multiple configurations, drawing on data from CAD, PLM, ERP, and MES platforms to support engineering and manufacturing decision-making. Collaborating with Program Managers, Solution Architects, and product owners, this role elevates data quality across design and manufacturing groups while reinforcing source systems as the authoritative foundation for business insight.

Performance Expectations

• Develop data analysis and visualization tools to support effective decision-making.
• Provide tools to track cost, mass, and product readiness for multiple product configurations.
• Direct data efforts for transformative initiatives such as resource planning and optimization.
• Analyze and report on design engineering's impact on various downstream stakeholders, ranging from manufacturing to service.
• Drive data quality across design and manufacturing groups.
• Establish the processes needed to achieve operational excellence in all areas to improve data reliability and quality.
• Provide coaching and training to team members.
• Improve the value of PLM and ERP platforms by partnering with product owners and solution architects.

Technical Qualifications

• Bachelor's degree in Engineering or Computer Science, with a Master's in Business Administration as a plus.
• Experience in consulting firms translating abstract requirements into business value.
• Experience with data processing and data visualization tools, including SQL, APIs, Power BI, Tableau, D3.js, Python, and Airflow.
• Exposure to CAD tools, including Catia, 3DX, SolidWorks, ProE, Creo, or NX, is a plus.
• Exposure to PLM tools, including Enovia, Windchill, TeamCenter, SmartTeam, Aras, or AgilePLM, is a plus.
• Exposure to ERP systems is a plus.
• Strong sense of ownership with proven ability to take projects to completion.
• Ability to communicate with patience and engagement.

Embedded within a platform engineering group and reporting to the Technical Director, the Business Intelligence Engineer develops, maintains, and optimizes the current data pipeline spanning commerce sales, live games, platform operations, and third-party vendors while providing subject-matter expertise on data warehouse and ETL subsystems. Working closely with analysts and cross-departmental teams, this role creates the data infrastructure foundation that ensures validity, quality, and reliable integration of new data sources across multiple games.

Core Responsibilities

• Become an expert on all aspects of the data infrastructure.
• Develop, maintain, and optimize the current data pipeline, including data from commerce sales, live games, platform operations, third-party vendors, and social media.
• Perform quality control and auditing of databases to ensure data validity.
• Provide hands-on implementation and subject-matter expertise around data warehouse and ETL subsystems.
• Monitor production databases for potential migration issues.
• Implement data streams through collaboration with other departments.
• Help analysts with reporting tasks and data meaning and location.

Position Requirements

• Bachelor's degree in Applied Mathematics or Computer Science.
• 4+ years of experience in data management, development, and business intelligence.
• Strong knowledge of current data structures and systems and how to integrate new data sources into existing pipelines.
• Experience writing ETL processes and building data warehouses with dimensional modeling.
• Knowledge and understanding of best practices for development, including query optimization, version control, code reviews, and documentation.
• Experience with TB/PB-level data systems, HDFS, and columnar data systems.
• Basic programming knowledge in C#, Java, or another high-level language.
• Amazon S3 and Amazon Kinesis experience is a plus.