BUSINESS INTELLIGENCE DEVELOPER JOB DESCRIPTION

A BI Developer turns raw warehouse data into decisions. In practice, that means owning the layer between a company's data infrastructure and the business users who need to act on it, translating stakeholder questions into dimensional models, ETL pipelines, and governed dashboards. The scope is broad: a single developer may maintain hundreds of dashboards for a global user base while simultaneously evaluating whether an aging on-premises stack should migrate to a cloud warehouse. What makes the role demanding is that technical precision and communication carry equal weight; a perfectly built report that nobody trusts is a failure.

You will own the design, delivery, and maintenance of BI solutions end-to-end, serving as the Business Intelligence Developer who connects validated data models to the reporting tools that drive operational decisions across the organization. Working within a data or analytics team, you collaborate daily with business stakeholders, data engineers, and product owners across multiple functional domains, typically reporting to a Lead BI Analyst, Analytics Manager, or Head of Data.

Career Impact: Sustained delivery against Sarbanes-Oxley-compliant reporting environments and enterprise data warehouse standards positions a BI Developer as a senior technical specialist in a market where dimensional modeling expertise remains consistently undersupplied.

Business Impact: When ETL pipelines fail, or dashboards surface inaccurate figures, operational teams lose the ability to track KPIs that govern procurement, membership, and campaign decisions; this role owns the reliability that prevents that breakdown.

Growth Opportunity: Hands-on exposure to cloud warehouse migration and modern BI platforms widens the path toward Analytics Engineering, Data Architecture, or a Lead BI role within two to three years.

Company Value: Several employers in this space offer hybrid arrangements that balance on-site collaboration with remote development cycles, with explicit expectations set at the manager level rather than mandated company-wide.

• Design and develop ETL pipelines and dimensional data models that extract, transform, and load data from multiple source systems into the enterprise data warehouse.
• Build and maintain interactive dashboards and self-service reports aligned to BI governance standards and user-role-based access controls.
• Translate business requirements from product owners and operational stakeholders into technical specifications and data model documentation.
• Conduct unit, integration, and regression testing on all developed solutions to verify accuracy, security, and performance against agreed SLAs.
• Monitor, tune, and troubleshoot existing ETL jobs, SQL queries, and BI environments to maintain performance and resolve production incidents.
• Partner with Data Engineering to resolve data quality issues, perform data discovery, and support scalability improvements to the analytics infrastructure.
• Review and enforce BI development standards across the team, contributing to documentation, governance frameworks, and best-practice guidelines.
• Mentor junior team members and support business users in interpreting data outputs and adopting self-service analytics capabilities.

• Bachelor's degree in Computer Science, Information Systems, Mathematics, or equivalent work experience.
• 3 or more years of Business Intelligence development experience, with demonstrated delivery of ETL pipelines and end-user reporting solutions.
• Proficiency in SQL including complex queries, stored procedures, and performance tuning across relational and dimensional database environments.
• Hands-on experience designing and building data warehouse solutions using dimensional modeling techniques such as star and snowflake schemas.
• Ability to gather, document, and translate functional requirements from non-technical business stakeholders into structured technical specifications.
• Experience performing multiple levels of testing including unit, integration, and user acceptance testing for BI deliverables.
• Working knowledge of Agile or Scrum development methodologies, including participation in sprint planning and iterative delivery cycles.
• Strong written and verbal communication skills, with the ability to present data insights clearly to both technical teams and senior business audiences.

• Experience with cloud data platforms or warehouse migration projects, particularly evaluation of on-premises to cloud transition strategies.
• Familiarity with ERP financial reporting or campaign management systems as data sources for enterprise BI environments.
• Exposure to predictive modeling, machine learning integration, or AI/ML data pipelines feeding BI consumption layers.
• Relevant BI platform certification or demonstrated experience in demand management and direct dialogue with business product owners.

• Dashboard adoption rate, measuring the percentage of the target user base actively consuming published reports.
• ETL job success rate as a percentage of scheduled pipeline runs completing without failure within agreed SLA windows.
• Defect rate per release cycle, tracking the number of post-deployment data accuracy issues logged against delivered dashboards.
• Mean time to resolution for production BI incidents, measuring responsiveness to stakeholder-reported data or access errors.
• Requirements-to-delivery cycle time, reflecting how efficiently new report requests move from specification sign-off to production deployment.
• Typical tools: Data warehouse platforms (commonly SQL Server, Snowflake, or Azure Synapse); BI visualization (commonly Power BI, Tableau, or Looker); ETL orchestration (commonly SSIS, Azure Data Factory).

• Base Salary Range: $90,000 to $130,000 depending on seniority and market
• Bonus: Annual performance bonus, typically 5 to 10 percent of base
• Equity: RSUs or stock options common at mid-to-large tech employers
• Health Benefits: Medical, dental, and vision coverage; employer contribution standard
• PTO: 15 to 20 days annually, plus public holidays
• Common Perks: Hybrid work flexibility, conference or certification budget, learning platform access

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

Work authorization in the United States is required; candidates must be eligible to work without sponsorship restrictions unless otherwise stated in the offer. Employment in this role is contingent on successful completion of a background check. All qualified applicants will be considered for employment without discrimination based on 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 throughout the hiring process and during employment upon request.

The Business Intelligence Developer owns the design, development, and deployment of interactive dashboards and visualizations that enable self-service access to data across the financial insights team. Reporting to team leadership and collaborating with business subject matter experts and enterprise technology teams, this role shapes analytics best practices that improve organizational decision-making, efficiency, and performance.

Key Responsibilities

• Translate business needs into technical requirements for timely and effective delivery.
• Design, develop, and deploy highly interactive dashboards, reports, and visualizations that enable self-service and provide secure, efficient access to data.
• Conduct unit testing and troubleshooting.
• Assist with end-user training and lead the development of BI governance materials.
• Perform project-based data analyses and provide technical support as necessary.
• Collaborate with business subject matter experts and data management and enterprise technology teams to implement data enhancements and resolve data quality issues.
• Continuously enhance and troubleshoot the performance, capabilities, and functional coverage of BI solutions.
• Stay up to date on the latest trends and capabilities within the BI industry.
• Serve as a thought partner to financial insights team members for the design, management, and documentation of solutions for new reports and dashboards.
• Contribute to a team working to establish business analytics best practices that drive improved decision-making, efficiency, and performance.

Required Qualifications

• Bachelor's degree in a quantitative field, such as Computer Science, Engineering, Mathematics, or Economics.
• 3+ years of experience with data visualization tools, including Tableau and MicroStrategy.
• 5+ years of overall experience with a focus on analytics, data engineering, or business intelligence delivery.
• Advanced SQL skills, including stored procedures and columnar databases.
• Experience eliciting detailed requirements that clearly define customer needs and their alignment with available data.
• Experience with project management tools and methodologies, such as Jira, Confluence, and Scrum.
• Experience with markup languages such as HTML and CSS, and web development including back-end and middleware.
• Strong written and oral communication and interpersonal skills, particularly with individuals of varying technical knowledge.
• Ability to document technical workflows and specifications.

Embedded within the technology team, the Business Intelligence Developer develops and maintains the data warehouse and ETL packages that underpin organizational BI requirements, using dimensional modelling and secure reporting interfaces. Working closely with the performance management team and business stakeholders, this role advances BI strategy while designing data visualizations that enhance understanding of operational performance.

Core Functions

• Carry out programming, development, and maintenance tasks, ensuring feasibility has been assessed, security standards have been followed, and testing is complete and successful.
• Maintain detailed knowledge of current practice in the relevant area of expertise.
• Develop and maintain the data warehouse to support BI requirements using dimensional modelling principles, and assist in the design of databases to ensure interoperability with BI solutions.
• Design and develop ETL packages to carry out data extraction, transformation, loading, and conversion tasks.
• Design and develop secure reporting interfaces to required data sources and create data visualizations to enhance understanding of performance.
• Work with the performance management team to support data visualisation and dashboard building.
• Support the development of strategic goals for BI in conjunction with business stakeholders.
• Document technical designs and implementation information.
• Stay abreast of technological advances and evaluate BI products, tools, services, and standards to support procurement and development efforts.

Qualifications & Experience

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

Reporting to the data warehouse team lead, the Business Intelligence Developer develops and maintains ETL processes, SQL queries, and data visualizations that support the integrity and performance of the enterprise data warehouse. Partnering with technical and non-technical internal resources, this role delivers analytics reports, dashboards, and data cubes while mentoring junior team members to build team capability.

Primary Duties

• Complete analysis, development, documentation, and modification of ETL processes and jobs per data architecture and modelling requirements.
• Create new ETL processes based on a standard architecture.
• Create SQL queries to extract, transform, and load data into SQL databases.
• Troubleshoot issues such as connection failures, failed jobs, application errors, server alerts, and space thresholds within predefined SLAs.
• Proactively maintain and tune SQL code according to best practices of the enterprise data warehouse.
• Ensure appropriate documentation for all new development and modifications of ETL processes and jobs.
• Perform unit testing for developed solutions and ensure the integrity and security of institutional data.
• Provide user support to customers of the enterprise data warehouse and reporting technologies.
• Collaborate with technical and non-technical internal resources to produce and support analytics reports, dashboards, and data cubes.
• Create visualizations to view data within the data warehouse.

Skills & Qualifications

• 3–5 years of experience in Business Intelligence development.
• 3–5 years of experience in SQL Server Integration Services, Data Factory, or analogous data transformation and orchestration software.
• 3–5 years of SQL experience, including data modelling tools and experience creating data cubes.
• Experience with visualisation tools, preferably Power BI, or alternatives such as SSRS, Tableau, or MicroStrategy.
• Experience with SQL Server 2012 and beyond, and with Team Foundation Server.
• Understanding of relational and dimensional data architecture concepts.
• 1+ years of experience in IT healthcare and with cloud platforms such as Microsoft Azure.
• Familiarity with DAX, .NET/PHP/Java development, and Agile/Scrum methodology.
• Ability to troubleshoot technical problems related to the implementation and processing of software.

Sitting at the intersection of healthcare data and business intelligence, the Business Intelligence Developer designs and develops reports, dashboards, and data marts that produce metrics and KPIs reflecting actual outcomes for population health business operations. Operating across IT and clinical stakeholder groups, this role ensures compliance with HIPAA regulations and data access standards while driving continuous improvement in BI processes and systems.

Duties

• Work with team members to design, develop, and optimise reports, dashboards, and user interface solutions supporting population health business.
• Perform all levels of testing, including unit, integration, regression, and user acceptance testing, to ensure BI code meets technical and business requirements.
• Develop foundational data analytics infrastructure that is maintainable, modular, and scalable.
• Develop subject-specific data marts that utilise database servers appropriately to optimise end-user BI performance.
• Create metrics and KPIs that reflect actual outcomes based on business and contractual specifications.
• Ensure standards for user access security, change management, documentation, and production control are understood and followed.
• Provide support and technical guidance to resolve issues as needed.
• Maintain effective user and IT relationships to provide a climate receptive to systems improvement and to enhance understanding of business concerns.
• Maintain confidentiality of patient, member, and staff information in compliance with HIPAA regulations.
• Identify areas of improvement in processes and procedures and offer recommendations.

Requirements

• Bachelor's degree in Computer Science or a related field.
• 5+ years of experience in Information Technology.
• 2+ years in Business Intelligence.
• Extensive experience with BI user reporting and analysis tools, preferably Tableau and/or QlikView.
• Experience working in a data warehouse agile development environment.
• Relevant healthcare experience strongly preferred.

A key member of the analytics team, the Business Intelligence Developer builds and deploys BI solutions that load, translate, and merge data from multiple sources to support organizational decision-making and medium-to-long-term technical planning. Collaborating across department leadership and new team members, this role leads cloud infrastructure and AI/ML integration to continuously meet evolving business needs.

Functions

• Load, translate, and merge data from multiple sources to prepare datasets for analysis and guide decision-making.
• Translate business needs into technical specifications and design, build, and deploy BI solutions.
• Maintain and support data analytics platforms, including OLAP cubes and existing BI systems.
• Leverage new technologies, including cloud infrastructure and AI/ML, to continuously meet business needs.
• Prepare documentation of analytic steps to enable accurate replication.
• Prioritise multiple high-priority projects to meet deadlines and assist department leadership in medium-to-long-term technical planning.
• Onboard and train new team members.

Experience & Qualifications

• Bachelor's degree in a quantitative field such as Mathematics, Statistics, Engineering, Computer Science, or Healthcare Administration.
• Master's degree in a related field.
• Three years of experience in an analytic or technical role working with multiple data systems, preferred.
• 8 years of experience in programming using SQL.
• 4 years of experience using data visualisation software such as Tableau, Power BI, or SSRS.
• Background in data warehouse design and data mining, including dimensional modelling.
• Proven experience with database management, statistical representation of data, and presentation software.

Sustained data-driven decision-making and FDA Quality System compliance depend on the Business Intelligence Developer, who supports KPI reporting, performance metrics, and ad hoc data analysis while assisting with internal compliance audits. Based within a regulated environment and working alongside data analytics team members and process owners, this role delivers BI solutions that identify improvement opportunities across quality procedures and business operations.

Accountabilities

• Develop and implement BI solutions that provide simple insights to deliver strong outcomes.
• Support collaboration and communication activities with data analytics team members, process owners, and data users.
• Read and understand business processes as needed.
• Execute project activities, prioritise tasks, and work with moderate supervision.
• Support a culture of data-driven decision-making and recurring data analysis and trending for KPIs, performance metrics, and management review.
• Participate in evaluating new BI technologies, data analytics approaches, and visualisation methods.
• Assist users with data analytic concepts and interpretations, and support ad hoc data analysis to identify improvement opportunities.
• Support internal compliance audits and monitor compliance with quality procedures and FDA Quality System Regulations, updating documentation as necessary.

Technical Qualifications

• Bachelor's degree or equivalent experience required; degree in Computer Science, Mathematics, Statistics, or a related field preferred.
• Working knowledge of BI software, including Tableau and Power BI, and one or more programming languages required.
• Experience related to data analytics activities preferred.
• Experience with GxP systems and computer systems validation preferred.
• Exposure to database models and data definitions preferred.

As the Business Intelligence Developer, this role manages a portfolio of individual and team projects that develop process improvement solutions using Python, Alteryx, Tableau, and other BI tools within a global financial institution. The broader finance team relies on this work to deliver ad hoc analysis for senior executives and external regulators while maintaining current awareness of banking industry changes and the regulatory landscape.

Activities

• Develop expertise in data management, analysis, and automation using business intelligence tools including Python, Alteryx, Tableau, Xceptor, Signavio, UiPath, and RPA.
• Manage a portfolio of both team and individual projects within a global team.
• Develop understanding of asset and liability management principles, key risk measures, and interest rate and liquidity risk management for a large financial institution.
• Stay connected to changes in the banking industry and the regulatory landscape.
• Interact with senior executives and external regulators as part of ad hoc analysis requests.

Position Requirements

• Degree in a STEM or Finance-related discipline with at least 3 years of experience in a finance-oriented role.
• 4+ years of experience developing process improvement solutions.
• Prior project management experience, including planning and managing a project end-to-end.
• Strong technical and programming skills, with prior knowledge of Alteryx an advantage.
• Strong analytical and quantitative skills, including critical thinking, investigative problem-solving, and decision-making.
• Ability to work under pressure, prioritise, multitask, and bring tasks to complete closure with minimal supervision.
• Strong written and verbal communication skills with the ability to prepare executive-level presentations.
• Ability to work across teams and drive initiatives forward.

Business Intelligence Developer delivers complex data solutions using SQL Server, SSRS, Power BI, and Azure, designing and testing ETL processes that migrate data from source systems into the data warehouse and data marts. Success in the position means building dashboards and data visualizations that meet leadership and business user requirements while maintaining ongoing performance monitoring and production support for the data environment.

Operational Focus

• Design, develop, and test complex data solutions utilising SQL Server databases, SSRS, Power BI, and Azure.
• Design, develop, and test ETL processes, programs, and scripts to migrate data from source systems into the data warehouse and data marts.
• Extract complex data from multiple sources into meaningful reports and analyses using stored procedures and SQL queries.
• Provide ongoing performance monitoring, tuning, and production support for the data environment.
• Work with business users and leadership to understand data requirements and develop dashboards, data visualisations, and analytics.
• Collaborate with BI leadership to analyse failures, revise procedures and documentation, and implement solution optimisation for data integration and quality.
• Aid leadership in creating and optimising BI standards.

Knowledge Skills & Abilities

• Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent field-related experience.
• 3+ years of experience in database programming, including SQL queries, stored procedures, and performance tuning and optimisation.
• 2–3 years of experience in SSRS/SSIS development.
• 2–3 years of experience developing data visualisations, with Power BI highly preferred.
• Experience with data warehouse architecture and design.

The Business Intelligence Developer produces reliable data ingestion and transformation pipelines capable of handling large data volumes while leading BI technology projects in close collaboration with technology groups, consultants, and business stakeholders. Evolving the data architecture and contributing to an observability data stack, this role ensures accurate and timely delivery of business intelligence solutions across a multi-platform enterprise environment.

Key Deliverables

• Lead BI technology projects while working closely with technology groups, consultants, customers, and business stakeholders.
• Evolve the data architecture and assist the team in building solutions that best fit business problems.
• Design reliable data ingestion and transformation pipelines capable of handling large data volumes.
• Build and maintain an observability data stack to ensure data is delivered accurately and on time.
• Collaborate with a diverse team to develop best practices, share knowledge, and ensure the right services are being built.

Professional Experience

• Bachelor's degree in information technology or a related field.
• 4 years of related experience.
• Experience in the design and building of enterprise data warehouses.
• Strong knowledge of Microsoft BI technology, including SSRS, SSIS, SSAS, and Power BI.
• Excellent knowledge of data modelling, SQL, and data integration strategies.
• Experience across multiple database platforms, including SQL Server.
• Experience working with end-users to gather requirements and build technical solutions from concept to implementation.

Embedded within the BI development team, the Business Intelligence Developer develops ETL and database solutions and standardized data analysis and reporting while managing development, test, and production environments across head office and branch operations. Working closely with users and consulting stakeholders, this role advances reliable BI architecture grounded in Oracle BI stack expertise and solid relational database knowledge.

Areas of Ownership

• Design technical solutions, including architecture and data models.
• Develop ETL and database solutions.
• Create and standardise data analysis and reporting.
• Support and maintain implemented solutions, including third-level support and performance optimisation.
• Manage development, test, and production environments.
• Provide technical support for project initiation and consulting services to users across head office and branches.

Education & Experience

• Degree in Computer Science with a focus on Business Intelligence.
• Degree in economics, natural sciences, or engineering with equivalent work experience in BI.
• 5 years of development experience in Business Intelligence, including ETL/ELT, database, and SQL.
• 2 years of experience preferably in the Oracle BI stack, including Oracle Database, Oracle SQL, Warehouse Builder, and Oracle Business Intelligence, or comparable toolsets.
• Solid conceptual knowledge and practical experience in Business Intelligence and relational database systems.
• Solid practical IT background.

Reporting to the data engineering team, the Business Intelligence Developer develops and maintains data models, dashboards, and reports within a Looker platform while managing BI access controls across row, column, and report levels. Partnering with product, business analytics, and engineering teams to deliver data tools and insights, this role governs metadata in a Snowflake data warehouse to ensure data reliability, accuracy, and reusability across the organization.

Role Responsibilities

• Develop and maintain data models, dashboards, and reports in a Looker platform.
• Manage BI access controls for users, including row-level, column-level, and report-level security.
• Work with product, business analytics, and engineering teams to deliver data tools and insights to the business.
• Collaborate with data engineering to resolve data-related issues, perform data discovery, and optimise warehouse utilisation in a Snowflake data warehouse.
• Establish governance around metadata to ensure data reliability, accuracy, validity, and reusability.

Background & Experience

• Degree in a technical or analytical field, or equivalent professional experience.
• 2–5 years in an analytical data role working with large datasets.
• Experience building models, reports, and dashboards with a BI platform such as Looker, Power BI, Tableau, or Data Studio.
• Proficiency in SQL for data analysis.
• Experience working on data projects with both technical and non-technical stakeholders.

Sitting at the intersection of data engineering and business strategy, the Business Intelligence Developer gathers and translates functional and technical requirements into reporting solutions, analytic tools, and dashboards that deliver actionable data to end users. Operating across CRM, HRIS, and ERP source systems, this role develops high-quality code and comprehensive test plans that validate accuracy and functionality across enterprise-level BI platforms.

Job Functions

• Develop and manage effective working relationships with other departments, groups, and personnel to coordinate and interface work effectively.
• Gather and document functional and technical requirements, and translate them into reporting solutions, analytic tools, and dashboards that deliver actionable data to end users.
• Develop an in-depth understanding of underlying data, data structures, and business uses of data to provide the most effective BI solutions possible.
• Identify gaps in data collection, the data model, and metadata for future enhancements.
• Create simple to complex data, reporting, and BI solutions utilising existing reporting, analytics, and BI platforms.
• Comply with standards, best practices, and policies defined for the team.
• Provide support to ensure the availability and optimised performance of developed BI applications and reports.
• Write high-quality code to retrieve, analyse, and present data, and work with the testing organisation to write and execute comprehensive test plans that validate accuracy and functionality.

Minimum Qualifications

• 2+ years of direct work experience with BI tools such as Dundas BI, Tableau, Spotfire, Microsoft Power BI, PowerPivot, or SSRS.
• 1–3 years of SQL development experience, including creating, debugging, and modifying complex stored procedures and views.
• Experience with production support and troubleshooting common report and data process issues.
• Familiarity with fact/dimension data modelling and validating results of data transformation processes.
• Experience extracting data from enterprise-level systems such as CRMs, HRIS, or ERPs preferred.
• Familiarity with PL/SQL in the Oracle 11g/12c environment and exposure to Microsoft Azure technologies and SSAS.
• Experience with web development, PowerShell scripting, and JavaScript/HTML/CSS programming.
• Understanding of software development methodologies and best practices as they pertain to database and report development.
• Strong analytical and problem-solving skills with attention to detail, critical and creative thinking, and a commitment to quality and continuous improvement.

A key member of the data engineering team, the Business Intelligence Developer builds automated, user-friendly BI systems, reports, and dashboards by applying deep analytic skills to extract meaningful insights from large and complex datasets across operations and the global supply chain. Collaborating with data engineers and business users, this role develops ETL pipelines and data visualizations in cloud environments including AWS to improve continuity of supply and operational efficiencies.

What You'll Do

• Design, develop, and maintain scaled, automated, user-friendly BI systems, reports, and dashboards.
• Apply deep analytic and business intelligence skills to extract meaningful insights from large and complex data sets.
• Identify and recommend opportunities to automate systems and tools.
• Build data pipelines to support automated reporting using ETL processes.
• Interface with data engineers and business users to deliver complete BI solutions.
• Build data visualizations to convey business trends, patterns, and outliers through rich visual formats.
• Review and audit existing ETL jobs and SQL queries.
• Adopt best practices in reporting and analysis, including data integrity, test design, validation, and documentation.
• Develop and implement analytics to improve continuity of supply and operational efficiencies.

Required Qualifications

• Bachelor's degree in Mathematics, Statistics, Computer Science, Finance, or a similar quantitative field, or 4+ years of additional experience instead of a degree.
• Graduate degree in Computer Science, Engineering, Mathematics, or a related technical field is an advantage.
• 3+ years of experience in data science, business analytics, or business intelligence in big data environments.
• 5+ years of experience in a data engineering or BI engineering role within a technology environment.
• Experience working with disparate data sources and consolidating them into unified solutions.
• Experience in operations, procurement, computer hardware, or global supply chain is an asset.
• Knowledge of data warehouse architecture, infrastructure components, ETL, and reporting tools.
• Familiarity with AWS services, including Glue, EC2, S3, and Redshift.
• 2+ years of experience writing and optimizing SQL queries in a business environment.
• 2+ years of experience using BI reporting and visualization tools such as Tableau, Power BI, MicroStrategy, Looker, QuickSight, and advanced Excel.

Robust decision-making at the executive and departmental level depends on the Business Intelligence Developer, who researches, plans, and assembles large, complex datasets and builds analytical tools that provide actionable insights into key business performance metrics. Serving as a technical partner to stakeholders across data, design, program, and executive teams, this role develops and maintains data architecture strategies that cover relational and multidimensional sources including OLAP, SSRS, SSAS, SSIS, and Power BI.

Day-to-Day Responsibilities

• Research and plan solutions for data consolidation, warehousing, organization, and presentation.
• Build required infrastructure for optimal extraction, transformation, and loading of data from various sources.
• Identify, design, and implement internal process improvements, including re-aligning infrastructure for greater scalability and automating manual processes.
• Govern projects for adherence to standards and approved architectures.
• Assemble large, complex data sets that meet functional and non-functional business requirements.
• Work with multidimensional data types including relational databases, spreadsheets, CSV, and XML.
• Build analytical tools to utilize the data pipeline and provide actionable insights into key business performance metrics.
• Work with stakeholders across data, design, program, and executive teams to address data-related technical issues.
• Partner with industry analysts, software vendors, and internal stakeholders to develop data architecture strategies.
• Design, code, test, debug, and maintain data tools.
• Prepare detailed reports by analyzing and interpreting data for management and other departments.

Qualifications & Experience

• Bachelor's degree in a related field with ten years of professional experience.
• Expertise in SQL Server and other relational and multidimensional data sources.
• Deep knowledge of warehousing, replication, scripting, querying, and indexing.
• Extensive knowledge of OLAP, SSRS, SSAS, SSIS, ETL, Report Builder, Power BI, DAX, and security principles.
• Experience working with private and sensitive personal information.
• Strong computer skills with the ability to use required databases and software, including some coding ability in VB, C#, or JavaScript.
• Keen eye for identifying problem areas and discrepancies.
• Strong multitasking, interpersonal, communication, and customer service skills.
• Confident in decision-making with the ability to explain processes and choices clearly.

Business Intelligence Developer refines reporting solutions by building, editing, and enhancing reports daily to transform data into a business asset across the organization. The work directly supports continuous improvement initiatives across business units, providing reporting expertise to clients and advising colleagues on day-to-day reporting needs in a financial environment.

Work Activities

• Build, edit, and enhance reports daily to meet changing requirements.
• Transform data into a business asset across the organization.
• Collaborate across business units to provide reporting solutions and drive continuous improvement initiatives.
• Advise and support report users and colleagues on day-to-day reporting questions and queries.
• Design, coordinate, and implement analytical solutions to support innovation initiatives.
• Monitor current business and IT reporting needs.
• Develop and maintain technical knowledge and provide reporting expertise to clients.

Requirements

• University degree in an analytical field such as engineering, mathematics, accounting, or IT is preferred.
• 1+ year of proven experience with Tableau or another data visualization tool.
• Experience with SQL, Python, or another coding language.
• Experience with Alteryx or another data transformation tool.
• Experience with Power BI or other business intelligence tools.
• Prior experience in a financial environment is preferred.
• Advanced Excel skills and strong working knowledge of the MS Office suite.
• Ability to manage multiple projects and deliverables simultaneously.
• Strong communication skills with a passion for data analysis and data modelling.

The Front End / Business Intelligence Developer creates and maintains dashboards built on qualitative and quantitative information from a wide range of sources, delivering critical insights that address core business demands through exploratory visualization. Reporting to analytics leadership and collaborating with business and domain stakeholders, this role ensures development output is robust, reliable, and optimized for maximum speed and scalability.

Performance Expectations

• Integrate qualitative and quantitative information from a wide range of sources to address core business demands and deliver critical insights.
• Clarify, visualize, and help interpret results of implemented analytical models.
• Design, build, and maintain dashboards based on business requirements.
• Optimize dashboards and queries for maximum speed and scalability.
• Ensure development output is robust, reliable, and adherent to agreed design guidelines and principles.

Experience & Qualifications

• Expertise in statistics, economics, or computer science.
• Experience with controlling processes and tools.
• Profound knowledge in the exploratory creation of dashboards and reports.
• Experience in retail or FMCG, or relevant domain knowledge, is an advantage.
• Experience working with RStudio, Python, and Hadoop is preferred.
• Excellent command of MS Office, with a focus on Excel.
• Strong understanding of data and information presentation and consumption by end users.

Embedded within the BI team, the Business Intelligence Developer develops, tests, maintains, and manages BI solutions utilizing SQL Server, SSIS, SSAS, and Tableau across an environment of 17 servers, 15 data marts, and over 400 dashboards serving a global user base. Working closely with development, quality assurance, deployment services, infrastructure, and product managers, this role coordinates long-term BI systems planning and ensures compliance with Sarbanes-Oxley and SAS 70 standards.

Core Responsibilities

• Develop, test, maintain, and manage BI solutions utilizing SQL Server, SSIS, SSAS, and Tableau.
• Evaluate existing data collection and analytics systems to ensure accurate and secure data extraction methods.
• Create and maintain environment documentation, including requirements, design documents, and user manuals.
• Ensure team compliance with standards, procedures, and controls in a Sarbanes-Oxley and SAS 70-influenced environment.
• Evaluate and establish procedures for data sharing with internal and external stakeholders.
• Protect the confidentiality and security of client data.
• Monitor and maintain performance, capacity plans, and system availability in a 24/7 environment.

Technical Qualifications

• Bachelor's degree in Computer Science, Information Systems, or equivalent work experience.
• 3+ years of experience with Microsoft SQL Server.
• 5+ years of expert knowledge of Microsoft SSIS.
• 4+ years of expert knowledge of ETL conversion from transactional to star schema databases.
• 2+ years of experience with transactional SQL Server databases.
• 2+ years of experience with star schema SQL Server databases.
• 5+ years of ability to troubleshoot issues using SSRS, SSIS, SSAS, SQL Server, and Windows OS.
• Experience in incident management, problem management, and change management.
• Knowledge of predictive models and machine learning is an asset.
• Familiarity with the insurance industry is an asset.

Reporting to the Lead Business Intelligence Analyst, the Business Intelligence Developer receives, analyzes, and estimates reporting and data requirements from business product owners and stream owners, transforming them into data models, visualization tools, dashboards, and reports using the full Microsoft BI suite. Partnering with business stakeholders across an agile development environment, this role maintains and supports the global BI platform while managing support cases, hotfixes, and incident resolution.

Key Responsibilities

• Receive, analyze, and estimate reporting and data requirements from business product owners, users, and stream owners.
• Proactively evaluate BI platform architecture and assess how new technologies can improve the BI product.
• Transform business requirements into data models and generate visualization tools, dashboards, and reports using SQL, Microsoft databases, and the MS BI suite, including SSIS, SSAS, SSRS, Power BI, Azure DevOps, MDS, ADF, AAS, and Excel.
• Implement technical solutions across ETL, data models, visualization, and surrounding components.
• Contribute to the daily maintenance of the BI platform and support users with platform-related issues.
• Manage support cases and hotfixes, and assist in analyzing and resolving incidents.

Position Requirements

• 4+ years of experience in business intelligence development.
• Deep knowledge of the Microsoft BI stack, including SSAS, SSRS, Excel, Power BI, and SharePoint Online.
• Experience with agile development and ETL development, including extraction, transformation, and loading.
• Proven experience developing and managing global BI platforms, covering both back-end and front-end development.
• Experience creating financial reports and ERP competence is beneficial.
• Microsoft BI certifications are advantageous.
• Ability to collaborate and communicate effectively with stakeholders at all levels in an international environment.
• Self-driven with strong analytical skills and keen attention to detail.

Sitting at the intersection of data engineering and household marketing analytics, the Business Intelligence Developer designs self-serve data and reporting solutions that ensure the validity and integrity of household and campaign reporting processes within Unix and Teradata environments. Operating across multiple business units and serving as a subject matter expert on household marketing support, this role coordinates timely project delivery while investigating data and process anomalies with a deep understanding of tools and technology infrastructure.

Core Functions

• Design and propose suitable solutions to business needs in collaboration with the broader team.
• Develop self-serve data and reports for business users.
• Ensure the validity and integrity of household and campaign reporting processes.
• Respond promptly to ad-hoc requests from team members across business units.
• Participate in the overall project life cycle.
• Work with other developers and business analysts to ensure timely and successful project completion.
• Investigate data and process anomalies, and propose and implement solutions.
• Take ownership of deliverables, communicate proactively, and escalate issues when required.
• Act as a subject matter expert on household marketing support with a deep understanding of tools and technology infrastructure.

Knowledge Skills & Abilities

• Bachelor's degree in Computer Science, Mathematics, or an equivalent qualification from a recognized institution.
• 5+ years of experience in SAS and PL/SQL programming.
• 3+ years of experience with Oracle, Unix, and NCR-Teradata.
• 3+ years of experience in an enterprise data warehouse environment.
• Solid experience with reporting tools such as MicroStrategy and campaign tools such as Unica Campaign or IBM EMM.
• Advanced knowledge of MS Office, including Excel, PowerPoint, and Word, as well as web programming in HTML, Java, ASP, and .NET.
• Knowledge of the telecommunications industry is an asset.
• Strong cross-team collaboration skills with a rigorous approach to data accuracy.
• Ability to work independently with minimal supervision in a dynamic environment.
• Ability to manage multiple projects simultaneously and meet deadlines.
• Strong organizational skills and a customer-driven approach.

A key member of the business intelligence team, the Business Intelligence Developer produces regular KPI reporting and develops technical infrastructure, data flow automation, and competitor analysis tools that support business performance in an eCommerce environment. Reporting to the Lead Business Intelligence Analyst and collaborating with the data team to manage business data systems, this role ensures BI solutions are compliant, fit for purpose, and capable of providing accurate and timely insights.

Primary Duties

• Develop technical infrastructure that meets business reporting requirements.
• Produce regular and accurate KPI reporting on a daily, weekly, and monthly basis.
• Create relevant dashboards to measure business performance.
• Develop functionality to support competitor analysis, including data scraping and insight automation.
• Develop robust data flow automation.
• Own business data systems, ensuring they are compliant and fit for purpose.
• Deputize for the lead business intelligence analyst to provide business briefings as required.

Professional Experience

• Degree in Mathematics, Computer Science, Statistics, or a related field, or equivalent qualification through professional experience.
• Proven experience developing data management solutions to a high standard.
• Experience using SQL to query databases.
• Advanced Python coding skills, with a specific focus on internet scraping.
• Ability to build dashboards in Power BI.
• Ability to manipulate datasets through SSIS or Power Query.
• Experience with Microsoft SQL database administration.
• Experience using Google Analytics, Google Data Studio, and Google Tag Manager is desirable.
• Understanding of eCommerce metrics and background in eCommerce analytics is desirable.
• Experience with testing and usability.

Sustained global BI platform performance and solution quality depend on the Business Intelligence Developer, who designs and delivers user stories across a global BI platform while switching between hands-on development and enabling deliveries managed by an offshore development partner. Serving as a technical expert and collaborating with business teams, stakeholders, and offshore partners, this role coordinates data warehouse design, ETL integrations, and dimensional modelling to reduce complexity and increase usability across the organization.

Duties

• Deliver high-quality BI back-end solutions with strong customer satisfaction.
• Ensure BI back-end solution design follows best practices and established theme principles.
• Operate and develop global solutions to reduce complexity and increase usability.
• Work closely with business teams as an IT partner on dedicated business domains.
• Obtain relevant business and system knowledge to convert requirements efficiently into technical design documentation.
• Design and deliver user stories on the global BI platform in accordance with the global release plan and solution architect guidelines.
• Switch between hands-on development and enabling deliveries managed by an offshore development partner.
• Own solutions and track that they deliver the requested benefits.
• Work with stakeholders and teams to address data-related technical issues and support data infrastructure needs.
• Participate in key projects as a technical expert.

Education & Experience

• Bachelor's degree in IT, Computer Science, Computer Engineering, or a related field.
• Minimum 5 years of experience as a BI back-end developer.
• Experience building and delivering enterprise-level data warehouse or analytical solutions.
• Technical expertise in dimensional modelling, ETL integrations, data warehouse design, multi-dimensional and tabular cubes, data quality monitoring, and documentation.
• Experience with the MS BI stack, including SQL Server, SSIS, SSRS, SSAS, MDS, and T-SQL.
• Experience with DAX and MDX is preferred.
• Good communication skills in Thai and English.