BI ENGINEER JOB DESCRIPTION

A BI Engineer is someone who turns raw warehouse data into decisions a product team can act on tomorrow. In SaaS and cloud-native companies, the role owns the full analytical chain from ETL pipeline design through self-service dashboard delivery, answering to product managers and senior engineering leads who set quarterly OKRs. Data volumes routinely span multi-terabyte Redshift or BigQuery environments, and the engineer is the person who decides what gets modeled, what gets automated, and what gets retired. Good work here shortens the distance between a business question and a verified answer.

As the BI Engineer, you design and maintain the data pipelines, warehouse models, and reporting solutions that allow product, operations, and finance stakeholders to make evidence-based decisions at scale. You work within a data or analytics engineering team, collaborating daily with data scientists, product managers, and business analysts to translate requirements into production-grade BI infrastructure.

Career Impact: Owning ETL-to-dashboard delivery in a SaaS environment builds the dimensional modeling and cloud warehouse depth that senior data roles require for consideration.

Business Impact: The dashboards and pipelines this role produces directly determine whether product and operations teams can close their weekly OKR reviews with verified numbers or estimates.

Growth Opportunity: Engineers who master multi-terabyte query optimization and self-service BI platform architecture are well positioned to step into Analytics Engineering or BI Architect roles within two to three years.

• Design and maintain ETL and ELT pipelines that move data from disparate source systems into a centralized warehouse reliably.
• Build dimensional data models including star and snowflake schemas to support scalable, consistent reporting across the organization.
• Develop and publish dashboards and KPI scorecards that give product, operations, and finance teams structured access to performance data.
• Partner with product managers and business analysts to gather requirements and translate them into precise data model and reporting specifications.
• Monitor and audit data quality across warehouse tables, remediating issues before they surface in downstream reports.
• Automate report delivery and self-service data access so that teams can resolve at least 80% of their data questions without engineering intervention.
• Validate new pipeline deployments and software upgrades through unit testing and troubleshooting to ensure accuracy and performance.
• Mentor junior analysts and business stakeholders on data asset usage, query best practices, and available reporting capabilities.

• Bachelor's degree in computer science, information systems, statistics, mathematics, or equivalent work experience.
• 3 or more years of data engineering or business intelligence experience, with demonstrated ownership of production pipelines in a cloud environment.
• Proficiency in advanced SQL including analytical window functions, query optimization, and dimensional modeling techniques.
• Experience designing and implementing ETL and ELT workflows against large, multi-source datasets.
• Ability to build and maintain data warehouse models using star schema, snowflake schema, or de-normalized approaches for reporting performance.
• Proven skill in developing self-service dashboards and automated reporting solutions consumed by non-technical stakeholders.
• Experience working within Agile or DevOps delivery methodologies, including participation in sprint planning and iterative delivery cycles.
• Strong written and verbal communication skills with the ability to translate complex data concepts for product and business audiences.

• Experience with cloud-native data warehouse platforms and modern source control practices including branching, code review, and deployment pipelines.
• Familiarity with statistical modeling, A/B testing methodology, or machine learning pipeline integration within a BI context.
• Prior exposure to SaaS business metrics such as monthly recurring revenue, churn rate, or customer lifetime value reporting.
• Experience leading or mentoring other engineers on data modeling standards and BI best practices.

• Pipeline reliability rate, measured as the percentage of scheduled jobs completing without failure or manual intervention.
• Dashboard adoption rate among non-technical stakeholders, reflecting how widely self-service reporting replaces ad hoc requests.
• Mean time to resolution for data quality incidents, tracking how quickly warehouse errors are identified and corrected.
• Query performance regression rate, measuring whether new model deployments maintain or improve average execution time.
• Backlog throughput, counted as the number of validated reporting requirements delivered per sprint.
• Typical tools: Data warehouse platforms (commonly Redshift or BigQuery); BI and visualization platforms (commonly Tableau or Power BI); pipeline orchestration (commonly Airflow or similar).

• Base Salary Range: $110,000 to $155,000 per year depending on experience and location.
• Bonus: 5% to 15% annual performance bonus, structure varies by employer.
• Equity: stock options or RSUs common at SaaS companies, typically with a 4-year vesting schedule.
• Health Benefits: medical, dental, and vision coverage for employee and dependents.
• PTO: 15 to 20 days per year, with many SaaS employers offering unlimited PTO policies.
• Common Perks: Remote or hybrid work options, 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 checks are a standard condition of employment for this role, and all offers are contingent on successful completion. All qualified applicants will receive equal consideration for employment 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 BI Engineer owns end-to-end ETL pipeline development and data warehouse solutions, building and maintaining dashboarding applications in Qlik Sense and Tableau while coaching team members within an Agile Scrum environment. Working closely with cross-functional stakeholders, this work enables scalable, maintainable data systems that translate complex business requirements into actionable intelligence.

Key Responsibilities

• Develop and maintain end-to-end ETL pipelines and data warehouse solutions to support business intelligence needs.
• Design and implement scalable, maintainable data solutions by translating business requirements into technical specifications.
• Write complex SQL queries and develop ETL pipelines and frameworks for large-scale datasets.
• Build and maintain dashboarding applications using Qlik Sense, Qlik Compose, N-Printing, and Tableau.
• Develop PL/SQL packages, procedures, functions, triggers, views, and exception handling for Oracle databases.
• Diagnose and troubleshoot Oracle database issues including reading AWR, ADDM, and ASH reports.
• Implement web services based on SOAP and REST principles and integrate XML-based technologies.
• Apply continuous integration and delivery practices using Git, Jenkins, Sonar, and Nexus.
• Coach and mentor team members while contributing to an Agile Scrum development process.

Required Qualifications

• Bachelor's or advanced degree in information systems, business analytics, economics, finance, or a related technical field.
• 4 or more years of experience in analytics and business intelligence in an Agile Scrum environment.
• Solid experience with Oracle Streams AQ and JEE-compliant servers such as WebLogic and Apache Tomcat.
• Proficiency in Python, Java, PL/SQL, and JavaScript, with knowledge of scripting languages such as Bash, PowerShell, and Groovy.
• Strong experience with Qlik Sense, Qlik Compose, N-Printing, and Tableau for dashboarding and visualization.
• Knowledge of functional programming languages such as Erlang, Go, or Scala, and Web 2.0 technologies including JavaScript, jQuery, AJAX, CSS, and HTML5.
• Strong TDD and BDD expertise with unit testing skills and experience with complex data analysis and process optimization.
• Excellent verbal and written English communication skills with the ability to adapt to changing requirements and priorities.

Embedded within the Device Finance analytics organization, the BI Engineer interfaces with finance and business customers to gather metrics requirements and translate them into technical specifications for reporting and decision support tools. Working closely with data engineers on BI data marts and data quality, this role increases visibility into key business performance measures and enables financial and operational planning at a global scale.

Core Functions

• Interface with finance and business customers to gather data and metrics requirements and translate them into technical specifications.
• Develop reporting, analytics, and decision support tools to enable financial and operational planning for business leaders.
• Own and maintain analytics tools, BI models, and visualizations to increase visibility into key business performance measures.
• Mine data from database tables including Redshift, Oracle, MySQL, and data warehouse systems, and manage ETL processes.
• Build a platform for self-service reporting and analytics at a global scale.
• Partner with data engineers to build BI data marts, manage data quality, improve data delivery, and optimize reporting performance.
• Conduct deep quantitative analyses, deliver business insights, and complete root cause analyses.

Qualifications and Experience

• Bachelor's or master's degree in information systems, business analytics, economics, finance, or a related technical field.
• 4 or more years of relevant work experience in analytics and business intelligence.
• Proficiency in SQL, ETL, and data warehouse solutions with large-scale, disparate datasets.
• Financial acumen including familiarity with forecasting, budgeting, and variance analysis.
• Strong experience with data visualization using Tableau or similar tools and building scalable automated reports.
• Familiarity with statistical analytics and programming languages such as Python or R, and forecasting and machine learning tools.
• Experience with cloud storage and computing technologies such as AWS Redshift and SageMaker, and familiarity with financial reporting tools such as Cognos.
• Strong verbal and written communication skills with the ability to manage competing priorities in a fast-paced environment.

Reporting to the operations leadership team, the BI Engineer defines problems and builds analytical frameworks to streamline retail processes, identifying gaps through data analysis and presenting written business recommendations. Partnering with business and operations teams, this work delivers automated dashboards and advanced data models that enable teams to self-service 80% of data needs.

Primary Duties

• Defining the problem and building analytical frameworks to help operations streamline processes, identifying gaps by analyzing data and liaising with relevant teams.
• Identify, develop, manage, and execute analyses to uncover areas of opportunity and present written business recommendations.
• Report key insight trends using statistical rigor to simplify and inform the larger team of noteworthy insights affecting the business.
• Provide the right metrics to measure productivity and process quality and deliver meaningful feedback to business and operations teams.
• Build automated data solutions and dashboards to enable teams to self-service 80% of data needs.
• Develop innovative tools to analyze and leverage data, including use of advanced data models.
• Learn and understand a broad range of data resources and determine how, when, and which to use.

Skills and Qualifications

• Bachelor's degree in a relevant field.
• 2 or more years of relevant work experience in business intelligence, analytics, data engineering, or a related field.
• Proficiency in SQL, ETL, and data warehouse solutions with large-scale, complex datasets, Microsoft Excel, and Python.
• Highly proficient in at least one data visualization product such as Tableau, Looker, or Amazon QuickSight.
• Proven analytical and quantitative skills with the ability to use data and metrics to develop business cases and complete root cause analyses.
• Strong verbal and written communication skills with the ability to effectively communicate with both business and technical teams.
• Detail-oriented with strong organizational skills including prioritizing, scheduling, time management, and meeting deadlines.

Sitting at the intersection of data architecture and business reporting, the BI Engineer creates and maintains reports, dashboards, and KPI scorecards in Power BI while serving as subject matter expert on available features and tools for business users. Operating across all phases of the Agile BI development lifecycle, this role establishes standards and best practices that ensure scalable, secure, and well-governed analytics solutions.

Duties

• Create and maintain reports, dashboards, and KPI scorecards using Power BI to support business management routines.
• Serve as a subject matter expert for Power BI, educating team members and business users on available features and tools.
• Partner with cross-functional stakeholders to gather requirements and combine data from multiple sources.
• Produce scheduled and ad hoc reports with accurate and complete data and analysis.
• Establish standards and best practices for BI and analytics development and perform architectural reviews before deployment.
• Implement row-level security on data and manage application security layer models.
• Engage in all phases of the Agile BI development lifecycle including requirement analysis, prototyping, designing, developing, publishing, and scheduling Power BI reports.

Education and Experience

• Bachelor's degree and 5 years of experience, or master's degree and 4 years of experience in Microsoft Power BI.
• Minimum 2 years of Snowflake experience.
• Experience with Power BI Desktop, Power BI Report Builder, Tabular Editor, ALM Toolkit, and DAX Studio across complex deliverables.
• Experience with Power BI architectures including Import, Direct Query, Live Connections, and Composite Models.
• Proficiency in complex Power Query, DAX, and M, and dimensional data modeling using Star Schema and Snowflake.
• Strong understanding of security best practices with experience implementing the Power BI security framework.
• Strategic and analytical thinking ability with strong cross-organizational collaboration skills.

A key member of the Digital Operations team at ThinkHR with Mammoth, the BI Engineer translates business requirements into precise user stories and builds connected digital infrastructure solutions across Customer Support, Operations, Account Management, and Sales. Collaborating across departments to integrate SaaS products and establish KPIs, this role enables leaders to measure ROI of digital projects and drive significant business growth.

Job Functions

• Research and understand internal customer requirements, industry best practices, and operational needs across Customer Support, Operations, Account Management, and Sales.
• Translate business requirements into detailed and precise user stories and build and maintain effective solutions.
• Establish, monitor, and optimize KPIs that communicate intrinsic value and ROI of digital projects to organizational priorities.
• Create campaign performance dashboards from a variety of data sources and develop actionable recommendations.
• Develop a deep understanding of processes within each department, document key process flows, and translate business processes into information system needs.
• Integrate independent SaaS products with ThinkHR's platform and execute ad hoc analytical projects.

Position Requirements

• Bachelor's degree in computer science, finance, business, economics, mathematics, statistics, or a related field.
• 3 to 5 years of relevant work experience in a SaaS or recurring revenue business model.
• Working knowledge of scripting, Linux, Apache, MySQL, PHP, APIs, authentication, SSO, JavaScript, AngularJS, AWS Cloud Services, and SQL query writing.
• Strong ability to analyze high-volume data against business requirements to identify deliverables, gaps, inconsistencies, and process improvements.
• Ability to translate user stories and requirements into well-tested, scalable solutions.
• Proficiency in explaining and presenting complex concepts in a clear and easy-to-understand manner.
• Passion for building business-driven data solutions regardless of technology with a desire to work in a fast-paced startup environment.

Actionable business intelligence depends on the BI Engineer, who interprets business requirements and leads the design, implementation, and support of data warehouse systems, database architecture, and ETL processes. Based within a cross-functional project team, this role ensures technical deliverables meet quality standards and contributes to the BI and data transformation roadmap.

Accountabilities

• Interpret business requirements and design, build, and test processes to ensure high data quality and optimal system performance.
• Lead data design and creation of database architecture and data repositories.
• Produce technical documentation including architecture diagrams, process flow diagrams, and prototypes to communicate design ideas.
• Ensure technical deliverables for the design, implementation, maintenance, and support of data warehouse systems and applications.
• Verify and validate all new software or software upgrades, including development and management of test plans.
• Lead the definition, scope, and technical estimates for portions of large, complex projects.
• Build and support dashboards using business intelligence tools and contribute to the BI and data transformation roadmap.

Experience and Qualifications

• Bachelor's degree in computer science or a related field.
• 6 to 10 years of experience with SQL and ETL development or BI development tools.
• Experience in full-phase ETL implementation using tools such as SSIS and Informatica, and databases including Hadoop and Teradata.
• Proficiency with enterprise BI tools such as MicroStrategy and exposure to cloud integration technologies.
• Hands-on experience with both relational and dimensional databases and strong analytical and problem-solving skills.
• Experience managing third-party and vendor relationships and delivering technical implementations of BI applications.
• Strong interpersonal, planning, and prioritization skills with the ability to communicate effectively with project teams, business partners, and senior management.

As the BI Engineer, this role leads data administration, modeling, and integration activities across data warehouse systems while managing the strategy and engineering of data lifecycle management. The data and analytics team relies on this work to deliver optimized SQL queries, scalable ETL and ELT infrastructure, and Tableau-based reporting solutions that meet evolving business requirements.

What You'll Do

• Lead data administration, modeling, and integration activities in data warehouse systems and manage the strategy and engineering of data lifecycle management.
• Analyze user requirements and translate them into database requirements, implementing solutions in database code.
• Build the infrastructure required for optimal ETL and ELT of data from a wide variety of data sources, optimizing delivery and redesigning for greater scalability.
• Create and optimize SQL queries and stored procedures.
• Maintain business intelligence solutions to achieve data reporting and analysis goals in Tableau.
• Coordinate with business units to identify new data requirements, analysis strategies, and reporting mechanisms, and automate report delivery.
• Conduct unit testing and troubleshooting across data pipeline and BI solutions.

Technical Qualifications

• Bachelor's degree in engineering, computer science, data science, statistics, information systems, or a related quantitative field.
• 3 or more years of hands-on experience in database administration, configuration, and querying.
• Proficiency with multiple SQL versions including Microsoft SQL Server and MySQL, and experience with dimensional modeling and data mining.
• Experience building and deploying software using cloud infrastructures such as AWS or Azure.
• Experience supporting data pipelines into Tableau or Power BI cloud platforms, with Snowflake, Python, and MapReduce as a plus.
• Strong analytical and organizational skills with the ability to document and analyze business processes.
• Familiarity with modern source control systems such as Git.

BI Engineer develops data analysis and visualization tools to support decision making across engineering and business teams, tracking cost, mass, and product readiness for multiple configurations within a CAD, PLM, and ERP platform ecosystem. The work directly supports design and manufacturing stakeholders by driving data quality, enabling self-sufficiency, and improving the value of PLM and ERP systems in partnership with Product Owners and Solution Architects.

Key Deliverables

• Develop data analysis and visualization tools to support effective decision making across engineering and business teams.
• Provide tools to track cost, mass, and product readiness for multiple product configurations.
• Analyze and report on design engineering's impact on downstream stakeholders ranging from manufacturing to service.
• Drive data quality across design and manufacturing groups and establish processes to achieve operational excellence.
• Direct data efforts for transformative initiatives such as resource planning and optimization.
• Improve the value of PLM and ERP platforms by partnering with Product Owners and Solution Architects.
• Provide coaching, training, and support to key users to enable self-sufficiency with data needs.

Background and Experience

• Bachelor's degree in engineering, computer science, or an equivalent field, 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 visualization tools including SQL, APIs, Power BI, Tableau, D3.js, Python, and Airflow.
• Exposure to CAD tools such as CATIA, 3DX, SolidWorks, ProE, Creo, or NX as a plus.
• Exposure to PLM tools such as Enovia, Windchill, TeamCenter, or Aras as a plus, and exposure to ERP platforms as a plus.
• Strong sense of ownership with proven ability to take projects to completion and a talent for visual communication.
• Patient and engaging communicator with endless curiosity and strategic thinking ability.

The BI Engineer delivers business-critical data pipelines and cloud-based dashboards that support the analytical needs of product, engineering, and business stakeholders across multiple use cases. Working closely with cross-functional teams, this role improves data discovery and literacy and contributes to the strategy for better data quality across the organization.

Role Responsibilities

• Design, implement, and maintain data pipelines that produce business-critical data reliably and efficiently using cloud technologies.
• Collect, process, and clean data from different sources using SQL, Python, or other scripting languages.
• Improve data discovery and literacy by creating exploration and visualization interfaces in BI tools and promoting their use across the company.
• Design and develop dashboards to support the analytical needs of the business.
• Collaborate with product teams, engineering, and business stakeholders to produce relevant data solutions for multiple use cases.
• Contribute to the strategy for better data quality and think broadly about scalable data solutions.

Minimum Qualifications

• 2 to 3 years of experience in business intelligence, analytics, data engineering, or a similar role.
• Experience designing and building scalable and robust data pipelines to enable data-driven business decisions.
• Knowledge of modern data warehouses including Snowflake, Redshift, and BigQuery, and big data structures.
• Strong proficiency in SQL and Python, and experience collecting requirements and creating data modeling designs.
• Experience implementing enterprise dashboarding tools and working with modern BI tools such as Tableau, Looker, and Qlikview.
• Good understanding of software development and agile methodologies.
• Excellent spoken and written English with a passion for analyzing large, complex datasets and converting them into actionable business insights.

Reporting to the marketing analytics team, the BI Engineer maintains and expands the paid marketing data ecosystem by building ETL processes from ad partner APIs and designing Python scripts to drive a paid search automation platform. Partnering with marketing and operations teams, this role delivers actionable reporting and alerting that directly supports daily campaign optimization and revenue performance.

Day-to-Day Responsibilities

• Maintain and expand the paid marketing data ecosystem by maintaining the ETL process and consuming data from ad partner APIs.
• Design and maintain Python scripts to drive the paid search automation platform, including campaign restructures and rule-based bidding.
• Track, report on, and make recommendations to optimize paid marketing performance.
• Create actionable email reporting and alerting to support daily manual optimizations.
• Experiment with new technologies and acquire new skills to find solutions to unique data challenges.

Professional Experience

• Bachelor's degree in a relevant field.
• 3 or more years of direct experience in a data analyst or data engineering role, preferably with data requirements from multiple sources.
• Expert-level knowledge of SQL and Python, and experience designing data schemas and creating ETL processes from external APIs.
• Strong organizational and communication skills with the ability to translate technical data into actionable insights and marketing goals into effective digital campaigns.
• Proven ability to accomplish objectives proactively, handle multiple tasks simultaneously, and work both independently and as part of a team.

Embedded within a software development organization, the BI Engineer analyzes historical data to identify trends, develops predictive models, and sets up A/B tests to support data-driven decision making at scale. Working closely with business owners and technical teams, this role advances data quality improvement projects and delivers strong data presentation to senior audiences.

Operational Focus

• Analyze historical data to identify trends, develop predictive models, and support decision making.
• Collaborate with software development teams to design and implement analytic systems and data structures for large-scale data analysis.
• Set up A/B tests and ensure measurements are configured correctly and results are reported accurately.
• Analyze data from logs, Spark, and simulation results to derive actionable insights.
• Identify data needs and drive data quality improvement projects.

Knowledge Skills and Abilities

• Master's degree or higher in computer science, engineering, statistics, mathematics, econometrics, or a similar quantitative field.
• 5 or more years of work experience in data mining and analysis.
• Expert-level SQL skills with proven success working with extremely large datasets using big data technologies such as Spark and Hive.
• Experience with web development, automation, scripting languages, and functional programming.
• Strong data presentation and visualization skills with the ability to communicate effectively to senior audiences.
• Detail-oriented with an aptitude for solving unstructured problems and partnering directly with business owners to understand requirements.

Sitting at the intersection of data engineering and business intelligence, the BI Engineer develops and maintains analytical data models and owns data development tools that support reporting solutions, policy experiments, and product decisions. Operating across tech and business teams in a FinTech environment, this role shapes the analytics infrastructure that influences which policies and products the organization adopts.

Areas of Ownership

• Develop and maintain analytical data models and own data development tools for internal use.
• Create new ETL processes and optimize existing ones.
• Provide integration into reporting tools and deliver dashboards and reports.
• Work closely with tech and business teams to design and implement reporting solutions, policy experiments, and evaluate results.
• Conduct analyses to influence policy adoption and product development decisions.

Requirements

• Bachelor's degree in industrial or information systems engineering, computer science, statistics, or an equivalent field.
• At least 2 years of proven experience with Python and very high-level SQL and data warehouse modeling.
• Experience writing production-level code for data pipelines and real-time applications and contributing to a large code repository.
• Experience with data warehousing and query platforms such as BigQuery.
• At least 1 year of experience with reporting platforms such as Looker, Tableau, Sisense, or QlikView.
• Experience in the FinTech industry is an advantage.

A key member of the data team, the BI Engineer designs and implements data processing pipelines and participates in the full development lifecycle of data warehouse and BI reporting systems. Collaborating across business and technical stakeholders, this role turns data into critical information and knowledge that supports reliable and accurate organizational decision making.

Work Activities

• Design and implement data processing pipelines
• Involved in the development lifecycle of data warehouse and BI reporting systems.
• Identify and combine different sources of information to create ETLs, build reports, and develop dashboards.
• Understand business processes and provide accurate, congruent, and reliable data.
• Turn data into critical information and knowledge to support decision making.

Qualifications and Experience

• Bachelor's degree in computer science or a related field.
• 2 or more years of prior experience in BI-related roles.
• Deep knowledge of SQL and query languages, and programming experience in Python, C#, or Java.
• Experience with ETLs at big data scale and data visualization tools such as Tableau and Power BI.
• Good understanding of reporting systems at operational and strategic levels.
• Eager to learn, able to operate independently in a flexible environment, with solid communication skills and a team-player mindset.

Robust operational intelligence depends on the BI Engineer, who interfaces with business customers to gather metrics requirements, builds data pipelines for seamless self-service, and drives analytic projects that solve complex challenges for the AWS Finance organization. Serving as a partner to senior leaders and cross-functional teams, this role delivers insights that guide operational excellence and product development strategy.

Performance Expectations

• Interface with business customers to gather data and metrics requirements and drive analytic projects that solve complex challenges.
• Design, implement, and support key datasets that provide structured and timely access to actionable business information.
• Perform deep-dives to find root causes behind variances of key parameters.
• Build data pipelines for customers to self-serve seamlessly and investigate new big data technologies to address stakeholder needs.
• Analyze data and drive insights related to operations and compliance.
• Gather customer requirements, drive initial scoping and design, and help senior leaders make roadmap decisions.

Minimum Qualifications

• Bachelor's degree in analytics, MIS, computer science, engineering, statistics, mathematics, or a related field, with advanced degrees preferred.
• 1 or more years of experience as a BI engineer, data scientist, data engineer, or similar role at a technology company.
• Demonstrated strength in SQL, data modeling, ETL development, and data warehousing.
• Advanced skills in data visualization tools such as QuickSight, Tableau, or Cognos.
• Experience in end-to-end projects involving complex datasets and high variability, and experience handling confidential and sensitive data.
• Working knowledge of Python, Java, or similar coding languages, and familiarity with AWS solutions such as Redshift, S3, EC2, and QuickSight as a plus.
• Strong verbal and written communication skills with the ability to independently influence outputs, meet deadlines, and set clear expectations.

As the Lead, BI Engineer, this role partners with RCL stakeholders to set precise business KPIs and builds reports, dashboards, and scalable BI solutions that provide timely operational insights across the enterprise. The BI team relies on this work to ensure operational stability, mentor team members, and champion best practices that advance analytics adoption organization-wide.

Leadership Responsibilities

• Partner with stakeholders to set precise business KPIs and build reports and dashboards that provide timely and strategic operational insights.
• Discover, analyze, and clarify trends or patterns in organizational datasets and report findings and recommendations to stakeholders.
• Develop and recommend new scalable BI solutions that best meet reporting use cases.
• Administer, optimize, and monitor BI solutions to ensure operational stability and provide user support including configuration, access, and issue resolution.
• Mentor and train others on BI tools, best practices, and promote BI solutions across the enterprise.
• Develop and maintain technical documentation and contribute to solution estimates for proofs-of-concept and BI analytical initiatives.
• Participate in project planning and handle on-call and after-hours support requests as needed.

Education and Experience

• Bachelor's or master's degree in computer science, data science, engineering, or equivalent experience.
• 3 or more years of development experience with Microsoft Power BI, Tableau, SAS, or equivalent systems.
• 3 or more years of experience in SQL tuning with multi-terabyte data sources and leading BI initiatives in medium to large companies.
• Proficiency with Oracle, SQL Server, DB2, and Azure Synapse, and familiarity with Azure Data Factory V2 and Azure Data Lake concepts.
• Experience with MS Office 365, SharePoint, Teams, and JIRA, and familiarity with Agile methodology and data warehouse concepts.
• Strong leadership, collaboration, and mentoring skills with the ability to articulate technical concepts to non-technical audiences.
• Excellent written and verbal communication skills with the ability to handle multiple tasks simultaneously and adapt quickly to change.

The BI Engineer delivers scalable data pipelines and user-facing dashboards across on-premise and cloud repositories while maintaining data warehouse performance through optimization and tuning. Working closely with development teams, Product Owners, and business stakeholders, this role strengthens the analytics infrastructure that drives data-driven innovation and operational excellence.

Strategic Responsibilities

• Architect scalable data pipelines across on-premise and cloud data repositories and maintain data warehouse performance through optimization and tuning.
• Create data flow diagrams and document source-to-target mapping.
• Extract business requirements from stakeholders and translate them into actionable tasks using analytical and communication skills.
• Create user-facing dashboards that provide key insights for specific audiences.
• Execute proofs-of-concept with new technologies and drive innovation and new ideas.
• Recognize and adopt best practices and cost-effective solutions for analytical insights on-premise and in the cloud.
• Provide guidance and mentor junior team members while keeping current with BI data trends and technological innovations.

Professional Experience

• 4-year college degree in computer science, information systems, operations research, mathematics, statistics, or a related technical field.
• 7 or more years of direct experience with databases including Oracle, MySQL, and SQL Server.
• 5 or more years of hands-on experience with SQL, PL/SQL, SSIS, SSAS Tabular, Power BI, and C#.
• Deep expertise in Python and experience collaborating with development teams using established source control with Git.
• Strong proficiency with AWS services including Glue, Redshift, Athena, S3, and Spectrum.
• Strong understanding of data modeling including conceptual, logical, and physical model design, operational data stores, enterprise data warehouses, and data marts.
• Strong experience with BI and data warehousing design principles including multi-dimensional modeling such as star schemas, snowflakes, and de-normalized models.

Embedded within the AWS analytics engineering team, the BI Engineer analyzes legacy reports and dashboards to determine migration strategies and converts KPI calculations into modern AWS QuickSight solutions for customers ranging from small to large scale. Working closely with product and cloud teams, this role designs automated tooling for report deployments and produces test results that drive diagnostics, troubleshooting, and migration success.

Delivery Expectations

• Analyze reports and dashboards to determine appropriate migration strategies.
• Convert legacy report layouts and KPI calculations into modern AWS QuickSight solutions.
• Identify and remediate technical obstacles to migrations and research new opportunities for innovation on behalf of customers.
• Operate test and development environments in the cloud, run and analyze test results, perform diagnostics and troubleshooting, and track and report test status.
• Design solutions and tooling to execute automated report deployments, upgrades, and migrations.

Technical Qualifications

• Bachelor's degree in mathematics, statistics, computer science, finance, or a similar quantitative field, with a master's or advanced technical degree preferred.
• 2 or more years of work experience in a BI engineering environment, with 5 or more years for senior-level roles.
• Advanced SQL including analytical functions, ETL, and data warehousing knowledge.
• Experience with BI analytics, reporting, and visualization tools such as Tableau, AWS QuickSight, Cognos, Power BI, or Apache Superset.
• Experience with AWS solutions such as EC2, DynamoDB, S3, Redshift, RDS, and Aurora Postgres, and knowledge of DB migration software and technologies.
• Python scripting knowledge and familiarity with TensorFlow and Keras.
• Strong verbal and written communication skills with an analytical mindset and the ability to work effectively in a fast-paced, ambiguous environment.

Reporting to the data services leadership team, the BI Engineer leads technical design, implementation, and optimization of BI and analytics platforms while managing regular auditing of data sources and improving self-service support across enterprise areas including Controlling, HR, and Purchasing. Partnering with the data services team, this role shapes data storage, reporting best practices, and multi-dimensional modeling solutions that meet both strategic and operational objectives.

Ownership Areas

• Lead technical design, implementation, optimization, monitoring, and support of BI and analytics platforms.
• Gather and assess key requirements for analytical and modeling solutions to improve business processes and support decision making.
• Design and implement technical architecture of BI and analytics platforms, select and implement data warehouse automation tools, and provide strategic advice on best practices for data storage and reporting.
• Continually improve ongoing reporting and analysis processes and automate or simplify self-service support for customers across key enterprise areas.
• Manage regular auditing of data sources and take remedial action to improve data quality.
• Manage the pipeline of work for the data services team based on agreed priorities.
• Collaborate with the data services team to design and deliver new BI solutions that meet both strategic and operational objectives.

Background and Experience

• Bachelor's degree in computer science or tertiary qualifications in information technology.
• Several years of experience developing BI solutions and performing multi-dimensional modeling.
• Expert knowledge in database design and data warehouse modeling including auditing, and expert knowledge of SQL and ETL.
• Proven experience in BI support, managing workflow prioritization and client expectations to deliver high-quality services and projects.
• Strong data visualization and data modeling skills, with demonstrated knowledge of predictive analytics, reporting, and operational KPIs.
• Experience with Power BI, Cognos, or SSRS as an advantage, and awareness of data lifecycle management.
• Strong written and verbal communication skills with a successful track record of stakeholder management.

BI Engineer refines enterprise reporting by designing, building, and implementing automated BI solutions that deliver a guided analytics experience to different user communities across a Qlik Sense, Tableau, and Power BI environment. The work directly supports data analysts, business stakeholders, and product development initiatives by ensuring solutions meet scalability, reliability, and compliance requirements within Agile and DevOps methodologies.

Scope of Work

• Deliver solutions leveraging robust data pipelines and data models to support enterprise reporting use cases.
• Serve as a subject matter expert on best practices for BI platforms and enterprise data warehouse assets.
• Design, build, test, and implement automated BI solutions that deliver a guided analytics experience to different user communities.
• Partner with stakeholders to drive product development initiatives, strategic projects, and delivery commitments.
• Serve as a data evangelist and facilitate alignment of analytics across the organization.
• Ensure solutions meet operational requirements including scalability, maintainability, reliability, security, and compliance with company data and software policies.
• Provide mentorship to data analysts and business stakeholders on available data assets, reporting solutions, and analytics capabilities.

Required Qualifications

• Bachelor's degree in computer science, MIS, business, or a related four-year degree, with a master's degree preferred.
• 3 or more years of experience designing, developing, testing, and implementing BI solutions using various technology stacks and platforms such as Qlik Sense, Tableau, and Power BI.
• Proficiency with SQL and working knowledge of data modeling, ETL development, and data warehousing.
• Experience delivering BI solutions within Agile and DevOps methodologies.
• Strong problem-solving, project management, and organizational skills with a highly self-motivated work ethic.

The BI Engineer manages large-scale data analysis to extract business insights and automate routine analyses through scripts, macros, and programs across equipment reliability, installation quality, and degradation datasets. Working closely with product management, engineering, and finance partners, this role runs actionable reports and presentations that influence business direction for upper management and cross-functional stakeholders.

Engineering Responsibilities

• Perform large-scale data analysis to extract useful business insights and identify actionable recommendations.
• Influence the direction of the business by communicating results to cross-functional groups.
• Mine raw data to identify trends in equipment reliability, installation quality, and degradation.
• Write scripts, macros, and programs to automate routine analyses and actions.
• Collect, consolidate, and securely store data streamed in real time.
• Create reports and presentations for upper management, finance partners, and other stakeholders.

Background and Experience

• Bachelor's, master's, or PhD degree in computer science, applied mathematics, statistics, economics, or a related technical field.
• Experience solving analytical problems using quantitative approaches.
• Experience with SQL or other programming languages including Python, Java, and C++, and development experience in at least one scripting language such as Python or Bash.
• Proficiency with Python libraries such as Pandas, NumPy, and scikit-learn.
• Familiarity with large datasets and distributed computing tools such as Spark, MapReduce, and Hadoop on cloud platforms as a plus.
• Curious, self-driven, and analytical with the ability to work effectively both independently and as part of a cross-functional team in a fast-paced environment.