BI DEVELOPER JOB DESCRIPTION

Compiled BI Developer job descriptions with real responsibilities and qualifications to help candidates and hiring teams understand what the role demands.

BI Developer Job Description Template

1. About the Role

Turn a stakeholder's vague question into a dashboard that a VP acts on by end of week. That is the practical core of what a BI Developer does. BI Developers own the full chain from raw data sources through modeled datasets to published, governed reports - answering to data engineering teams on one side and to business unit leads on the other. The role demands fluency in both relational data modeling and the organizational patience to run UAT cycles, translate non-technical requirements, and maintain certified datasets that the broader analyst community depends on.

2. Position Summary

As the BI Developer, you will design, build, and maintain enterprise reporting solutions that convert business requirements into governed dashboards, data models, and self-service analytics used by stakeholders across the organization. You will work within a data and analytics function, collaborating with data engineers, business analysts, and department leads to ensure reporting infrastructure stays accurate, scalable, and aligned to evolving KPIs.

3. Why Join Us

Career Impact: Mastery of end-to-end report delivery - from tabular model design through UAT and production release - is the qualification path that moves BI Developers into Lead or Analytics Engineer roles within most enterprise data teams.

Business Impact: When the certified datasets and dashboards this role maintains are accurate and timely, department heads make resource and pricing decisions on current numbers rather than stale exports or manual spreadsheets.

Growth Opportunity: Exposure to cloud data warehouse architecture, row-level security design, and DAX modeling substantially widens the scope of BI infrastructure a developer can own, opening paths toward data architecture and senior analytics engineering.

4. Key Responsibilities

  • Design and develop enterprise reporting solutions including dashboards, KPI scorecards, and paginated reports to support business decision-making.
  • Build and maintain dimensional data models and schema documentation that serve as the authoritative glossary of measures and attributes for the organization.
  • Develop and maintain ETL pipelines that extract, transform, and load data from source systems into the data warehouse for reporting use.
  • Implement row-level security and data access governance controls to ensure report distribution meets organizational compliance requirements.
  • Translate business requirements into technical specifications and validate that delivered reports meet acceptance criteria with stakeholders.
  • Monitor and optimize existing reports and data pipelines for performance, identifying bottlenecks and applying schema or query improvements.
  • Coordinate User Acceptance Testing cycles with business owners and resolve defects before promoting solutions to production environments.
  • Mentor junior analysts and business power-users on self-service analytics capabilities to increase data literacy across the organization.

5. Required Qualifications

  • Bachelor's degree in Computer Science, Information Systems, Business Analytics, or equivalent work experience.
  • 3 or more years of BI development experience, with demonstrated ownership of dashboard delivery from requirements through production release.
  • Proficiency in relational database design, including normalization, dimensional modeling, and physical schema construction.
  • Demonstrated ability to write complex SQL queries, stored procedures, and performance-tuned views against large relational datasets.
  • Experience designing and implementing ETL or ELT processes that load structured data from multiple source systems into a centralized repository.
  • Ability to translate non-technical business requirements into documented data models, KPI definitions, and report specifications.
  • Strong written and verbal communication skills, with the ability to present analytical findings to both technical teams and non-technical stakeholders.
  • Experience with version control workflows and agile development practices including sprint planning and iterative delivery.

6. Preferred Qualifications

  • Experience with cloud-based data warehouse platforms and familiarity with cloud storage, compute, and integration service architectures.
  • Demonstrated experience building and deploying tabular or multidimensional OLAP models to support enterprise self-service reporting.
  • Exposure to advanced analytics methods including statistical analysis, predictive modeling, or machine learning in a reporting context.
  • Industry certification in a major BI or data platform, such as a recognized vendor-issued developer or analyst credential.

7. Success Metrics and Environment

  • Dashboard adoption rate, measuring the percentage of target stakeholders actively using published reports within 30 days of release.
  • Report defect rate per sprint, reflecting accuracy and completeness of UAT validation before production deployment.
  • ETL pipeline reliability, measured as the percentage of scheduled loads completing without failure or data integrity errors per month.
  • Mean time to fulfill ad hoc reporting requests, measured against pre-agreed service timeframes from intake to delivery.
  • Self-service query volume growth, indicating uptake of governed datasets among business analysts following enablement sessions.
  • Typical tools: BI and Visualization platforms (commonly Power BI or Tableau); query and warehouse environments (commonly SQL Server, Snowflake, or BigQuery).

8. Compensation and Benefits (US Market Benchmark)

  • Base Salary Range: $85,000 to $125,000 per year depending on seniority and location.
  • Bonus: Annual performance bonus typically 5 to 10 percent of base salary.
  • Equity: Stock or RSU grants offered at mid-to-large technology and enterprise companies.
  • Health Benefits: Medical, dental, and vision coverage; employer contribution varies by organization.
  • PTO: 15 to 20 days annually plus standard federal holidays.
  • Common Perks: Remote or hybrid flexibility, 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.

9. EEO and Legal

Work authorization in the United States is required, and employment is contingent on successful completion of a background check. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability, veteran status, 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.

BI Developer Job Description Example

1. BI Developer (Revenue Cycle Analytics)

The BI Developer owns the full reporting lifecycle for revenue cycle initiatives, from developing and optimizing BI reports to maintaining a centralized data repository and benchmarking for financial functions. Working within a healthcare data environment and reporting to supervisors, the developer delivers standardized analytics that enable management to monitor strategic progress and act on business intelligence.


Key Responsibilities

  • Develop and present recommendations to supervisors and management based on business reporting requirements.
  • Implement and optimize BI reports for standardization across the company.
  • Set up and maintain BI tools, infrastructure, and integration with company data sources.
  • Propose data schema and data flow optimization for reporting performance and enhancement.
  • Assist in the development and maintenance of a centralized reporting database and data repository.
  • Monitor ad hoc reporting request queues and fulfill requests within pre-determined service timeframes.
  • Create and maintain documentation and training materials for application and report implementations and changes.
  • Complete benchmarking and other research for revenue cycle functions.


Required Qualifications

  • Bachelor's degree in Business or Healthcare Administration, or equivalent experience in financial analytics, data analysis, or IT.
  • 3 or more years of experience in financial analytics, data analysis, development, or IT with demonstrated problem-solving skills.
  • 3 or more years of experience using SQL, identifying KPIs, analyzing data, and converting business requirements into technical specifications.
  • Experience with Power BI or Tableau for creating dashboards and interactive visual reports.
  • Experience designing, developing, testing, and deploying Power BI scripts and performing detailed analytics.
  • Experience with DAX queries and functions in Power BI.
  • Experience with Epic Clarity data and multiple revenue cycle applications, including Hospital Information Systems and Ambulatory Practice Management Systems.

2. BI Developer (Enterprise Reporting and Analytics)

Embedded within a Data and Analytics team, the BI Developer designs and develops technical solutions that enable enterprise-wide BI and reporting enhancements, building schema data models and translating KPIs into optimal technical specifications. Working closely with data engineering teams and business users, the developer shapes analytic insights that improve decision-making across the organization.


Core Functions

  • Design and develop technical solutions and best practices to enable continued enhancements and maintenance of enterprise-wide BI and reporting.
  • Interpret business requirements and KPIs to determine optimal BI solutions and translate them to technical specifications.
  • Build and maintain business schema data models and documentation for an organized glossary of measures and attributes.
  • Employ quick prototyping to gather feedback and adjust to user needs in an agile fashion.
  • Explore data to discover patterns, relationships, anomalies, and trends, and build key insights for a wide range of requests.
  • Evaluate and improve existing BI systems, reports, and dashboards.
  • Troubleshoot data issues identified in dashboards and collaborate with data engineering teams to reach resolution.
  • Provide training and support for business users on reporting systems.


Qualifications and Experience

  • Bachelor's degree or equivalent experience in a relevant field.
  • 3 or more years of hands-on experience in design, development, architecture, support, and operations of BI applications, visualization, reporting, data warehousing, and analytics.
  • Experience in data warehouse design and cloud-based BI and analytics technologies.
  • Certifications or experience with Incorta Business Intelligence software.
  • Knowledge of statistical analysis, machine learning, deep learning, and AI.
  • Fluency in SQL, data manipulation, and tuning for optimal performance, with knowledge of Python, Hadoop, Spark, Hive, and R.
  • Experience with one or more BI or visualization tools end to end, such as Tableau, MicroStrategy, or Power BI.
  • Strong problem-solving, analytical, and organizational skills with attention to detail.

3. BI Developer (Supply Chain and Cloud Data Warehouse)

Reporting to the Data and Analytics leadership, the BI Developer designs, codes, tests, and deploys BI applications and ETL processes that transform raw Supply Chain data into actionable automated reports and metrics. Partnering with Data Architects, Database Administrators, and Data Analysts, this role delivers scalable data warehouse architecture that strengthens analytics capability across ongoing Supply Chain initiatives.


Primary Duties

  • Design, code, test, and deploy new or modified applications, tools, and reports using agile software development methodologies.
  • Design, document, construct, and deploy database architectures and applications.
  • Develop, monitor, and maintain ETL processes that extract, transform, and load data from the data warehouse and other sources for use in Supply Chain applications.
  • Prepare and deliver automated reports, recommendations, or alternatives to address existing and potential issues across the Supply Chain.
  • Create metrics and KPIs to assist in driving management in a goal-oriented environment.
  • Coordinate and perform in-depth tests, including end-user reviews, for new systems and post-implementation support.
  • Deliver training to end users for all modified and new business systems.
  • Provide technical mentoring to developers and analysts.


Skills and Qualifications

  • Bachelor's degree in MIS, Computer Science, Information Systems, Information Sciences, or a relevant field.
  • 3 or more years of relevant experience as a BI Developer or Software Developer using the Microsoft SQL Server Stack, including SSIS, SSAS, and SSRS.
  • 3 or more years of SQL Server development experience with T-SQL to build UDFs, Stored Procedures, Views, Indexed Views, and Tables.
  • 2 or more years of modern data warehouse architecture design and implementation in Azure or AWS.
  • Experience with Azure Synapse Analytics, Azure Data Factory, Azure Blob, Azure Databricks, and Azure Analysis Services, or AWS Redshift, Aurora, DMS, Glue, Lambda, and S3.
  • Experience with SSIS or Azure Data Factory for ETL operations and MS OLAP technologies in SSAS both Multi-dimensional and Tabular.
  • Extensive experience with development, deployment, and administration of Power BI for dashboards and reports.
  • Experience with SQL Server query tuning, data partitioning, Team Foundation Server, and SQL Server extended events.

4. BI Developer (Enterprise BI Solutions)

Sitting at the intersection of business intelligence strategy and technical delivery, the BI Developer completes analysis, development, and enhancement of analytical and operational BI solutions, overseeing team member designs to ensure alignment with enterprise BI standards. Operating across end-user collaboration, production support, and subject matter expert advisory functions, the developer enables department-wide consistency in reporting and data modeling.


Duties

  • Complete analysis, development, and enhancement of analytical and operational BI solutions to fulfill business needs.
  • Work closely with end users to understand and translate business needs into well-designed and validated BI solutions.
  • Oversee team member designs to ensure alignment with BI strategy.
  • Provide production support for BI solutions, including problem analysis, break and fix, design and modeling, implementation and coding, and testing.
  • Serve as a subject matter expert on initiatives requiring business intelligence expertise.
  • Coordinate team members to develop standards and documentation as needed.
  • Maintain technical currency and certifications in areas of responsibility.


Experience and Qualifications

  • Bachelor's degree in Computer Science or a related field.
  • 5 or more years of experience in Business Intelligence.
  • Experienced in logical and physical database design, hands-on data modeling techniques, and physical schema design of table spaces, rollback segments, and data files.
  • Experienced in the design of data extracts, migration, queuing facilities, and database normalization techniques.
  • Experienced in the design and development of enterprise BI solutions, including leading large projects and implementing department-wide solutions and standards.
  • Strong working knowledge of BI concepts and designs with the ability to mentor team members.
  • Strong analytical and logical thinking, creativity, and communication skills with the ability to balance multiple priorities.

5. BI Developer (Healthcare Reporting)

A key member of the data and reporting team, the BI Developer develops logical modeling and presentation solutions that improve business operations by translating stakeholder objectives into analytical outputs. Collaborating with end users and business stakeholders, the developer delivers data governance, BI administration, and documentation that support consistent and reliable reporting in a healthcare environment.


Functions

  • Develop logical modeling and presentation solutions to implement requirements using best practices within BI environments.
  • Work with business stakeholders to understand objectives and develop analytical solutions to improve business operations.
  • Maintain and develop documentation to identify and define processes or procedures.
  • Manage data by following best practices.
  • Support and monitor BI systems and processes.
  • Administer BI server and related processes.


Education and Experience

  • Bachelor's degree in Computer Science, Management Information Systems, Business, or a related field.
  • 1 or more years of experience with SQL programming, data analysis and profiling, relational database systems, reporting, dashboards, and BI systems.
  • 1 or more years of experience as a business analyst, collaborating with end users to define metrics and business requirements.
  • 1 or more years of experience with Oracle, SQL, and data visualization using Tableau, Oracle Business Intelligence Enterprise Edition, or Crystal Reports.
  • 1 or more years of healthcare experience.
  • Strong SQL and data analysis skills with effective critical thinking and analytical abilities.
  • Knowledge of reporting and BI concepts with strong interpersonal and communication skills.

6. BI Developer (Product Analytics and e-Gaming)

Sustained product value for customers depends on the BI Developer, who performs data analysis, design, and development of BI solutions spanning modeling, transformation, visualization, and performance optimization. Based within a product and support team environment, the developer advances platform analytics by identifying bottlenecks, sharing knowledge on emerging technologies, and maintaining development best practices aligned with Agile and CI and CD standards.


Accountabilities

  • Perform data analysis, design, and development of BI solutions including modeling, transformation, and visualization.
  • Identify BI application performance bottlenecks and optimize accordingly.
  • Collaborate with product and support teams to leverage product capabilities for customers and internal initiatives.
  • Enhance the value of the product by providing key insights to customers.
  • Share knowledge and experiences on new technologies and trends across the group.
  • Maintain standard processes and follow development best practices.


Technical Qualifications

  • Understanding of BI and data warehousing concepts and methodologies.
  • Experience with Python or R for coding and scripting.
  • Expertise and experience in at least one BI visualization tool such as Oracle BI, Oracle Analytics Server, Tableau, Power BI, Qlikview, or Qliksense.
  • Expert-level SQL knowledge and familiarity with industry-standard ETL processes and tools, including Oracle Data Integrator, Talend, Pentaho Kettle, Microsoft SSIS, and Apache Airflow.
  • Familiarity with version control tools such as GitLab, Bitbucket, or Subversion.
  • Previous experience in advanced analytics, machine learning, and AI projects, with experience in Continuous Integration and Continuous Delivery.
  • Experience working with Agile methodologies such as Scrum with knowledge of sports betting or e-gaming business domain preferred.
  • Fluency in written and spoken English with strong communication and proactive problem-solving skills.

7. BI Developer (iGaming and Data Warehouse)

BI Developer refines and maintains SQL and Tableau-based dashboards and automated reporting workflows that deliver accurate, self-service analytics to business stakeholders in the iGaming sector. The work directly supports the Data Warehouse team's strategy for data accuracy and reliability while enabling data analysts to deliver on complex projects with speed and confidence.


Key Deliverables

  • Develop and maintain reports and dashboards per business owner requirements using SQL and Tableau.
  • Develop workflows to automate reporting processes and build interactive processes for stakeholder configuration of report parameters.
  • Act as a BI subject matter expert by supporting colleagues in the creation of visualizations and interpretation of data.
  • Train end users and write documentation on data tools to help them become self-sufficient.
  • Liaise with the Data Warehouse team to develop and implement BI strategies and processes to ensure data accuracy and reliability.
  • Assist data analysts with delivery of larger complex projects and handle multiple projects in a fast-paced environment.


Background and Experience

  • Bachelor's degree in Statistics, Computer Science, Economics, Finance, Mathematics, Operations Research, or a relevant quantitative discipline.
  • 2 to 3 years of experience in BI, building visualizations and dashboards based on large datasets and complex queries.
  • Strong knowledge of SQL for reporting and experience with visualization tools such as Tableau or similar.
  • Basic understanding of data warehousing and ETL concepts, including knowledge of web APIs, web scraping, data cleaning, and writing simple ETL scripts.
  • Knowledge of Python or willingness to learn, with experience in the iGaming industry preferred.
  • Strong analytical, problem-solving, and communication skills with the ability to convey data and technical ideas to both technical and non-technical audiences.

8. BI Developer (Regulatory Risk Reporting)

BI Developer produces regular and time-sensitive regulatory and RWA visualizations using MicroStrategy and Tableau, acting as a subject matter expert to senior stakeholders on data quality, governance, and corrective action. The work directly supports risk reporting leads and executive management by improving automation, identifying key trend drivers, and ensuring data controls meet governance standards.


Day-to-Day Responsibilities

  • Manage and prepare regular and time-sensitive visualizations and reports covering regulatory and RWA data.
  • Build dashboards and reports using MicroStrategy and Tableau.
  • Collaborate with risk and subject matter expert reporting leads on initiatives, key reports, and presentations.
  • Realize opportunities to improve timing, efficiency, and degree of automation for reporting deliverables.
  • Participate in initiatives to develop effective controls for data quality metrics and governance.
  • Communicate issues to impacted parties and implement corrective action plans.
  • Act as subject matter expert to senior stakeholders and other team members.


Minimum Qualifications

  • Bachelor's degree or equivalent experience.
  • 4 or more years of experience in MicroStrategy and Tableau.
  • Knowledge of Power BI or other BI visualization tools is a plus.
  • Knowledge of Credit Risk, Regulatory Reporting, and Finance applications is a plus.
  • Strong analytical and problem-solving skills with attention to detail and the ability to quickly analyze granular data, summarize top-level trends, and identify key drivers.
  • Excellent written and verbal communication skills with proven presentation skills and ability to relay information to senior management in a succinct and insightful way.

9. BI Developer (Financial Services Analytics)

The BI Developer delivers financial analysis, modeling, and portfolio reporting using SQL, Power Query, Power BI, ETL development, Azure, and Advanced Excel to produce custom analytic outputs for clients and internal stakeholders. Working within a finance or lending environment and interfacing with clients and third parties, the developer produces written reports, data files, and presentations that enable credit and investment decision-making.


Scope of Work

  • Perform financial analysis, modeling, and portfolio reporting using advanced analytic tools including SQL, Power Query, Power BI, ETL development, Azure, and Advanced Excel.
  • Use analytic tools to create transformations and calculations from raw data files to produce custom outputs.
  • Understand complex credit structures and valuation.
  • Interface with clients and other third parties.
  • Prepare project deliverables including written reports, data files, and presentations.


Professional Experience

  • Bachelor's degree in Business, Finance, Accounting, Computer Science, Analytics, or a relevant business field.
  • Experience at a finance or lending company, fund administrator, commercial bank, specialty servicing company, or investment firm is a plus.
  • Advanced Excel, SQL, Power Query, and Power BI experience required.
  • Experience with Microsoft Power Apps and Dataverse is highly desirable, with proficiency in VBA and Azure.
  • Strong problem-solving, decision-making, and organizational capabilities with high ownership and drive.
  • Excellent verbal and written communication skills in a highly professional environment.

10. BI Developer (Healthcare Sales Analytics)

The BI Developer leads reporting template development, KPI tracking, and data model support for Healthcare Systems divisions, serving both internal business teams and external customers with analysis of sales, pricing, and customer data. Reporting to divisional leadership and collaborating with cross-functional business teams, the developer builds actionable recommendations from large volumes of complex quantitative and qualitative data.


Work Activities

  • Provide analysis of customer information, sales data, and historical pricing levels to business divisions.
  • Serve as a key process and system resource for Healthcare Systems, including development of reporting templates, matrix formats, and KPIs.
  • Understand existing data models and assist in development of new data models.
  • Participate in development of processes and mechanisms for data cleansing and proactive monitoring of data quality.
  • Respond to ad hoc data requests from divisional business teams and internal team members.
  • Document and maintain process instructions to assist in the training of new analysts.
  • Provide exceptional service to both internal and external customers.


Knowledge Skills and Abilities

  • Bachelor's degree in Computer Information Systems, Business Analytics, Data Science, Business, Accounting, Finance, or a related discipline.
  • 1 or more years of experience working with data and BI tools or languages.
  • Experience in medical manufacturing or healthcare environment is a plus.
  • Advanced educational degree or industry certification in data or business analytics is a plus.
  • Experience with information systems, data integration technologies, and data warehouse concepts.
  • Experience with reporting and visualization tools such as Power BI or Tableau, and exceptional skills with data management, pivot tables, and advanced Excel functions.
  • Basic knowledge of statistical packages such as R, SPSS, or MATLAB, with experience in B2B sales and financial data analysis.
  • Strong analytical skills with the ability to synthesize large volumes of complex quantitative and qualitative data into actionable recommendations.

11. Lead BI Developer (Power BI and SSAS)

Embedded within the Data Analysis and IT function, the Lead BI Developer develops and designs tabular models in SQL Server Analysis Services and Azure Analysis Services while building insightful Power BI dashboards that support corporate Data Strategy implementation. Working closely with business stakeholders, data engineers, and IT leadership, the developer elevates data quality, manages UAT processes, and ensures timely delivery across all reporting initiatives.


Strategic Responsibilities

  • Work closely with key business stakeholders to help implement Data Strategy.
  • Develop and design meaningful tabular models within SQL Server Analysis Services or Azure Analysis Services.
  • Help develop and maintain ETL logic throughout the data pipeline.
  • Develop, design, and build meaningful and insightful reports and dashboards using Power BI.
  • Develop health monitoring reports to assist in locating areas of poor data quality and propose improvement projects to address data quality at source.
  • Publish reports via the Power BI service, managing them using Workspaces and Apps and monitoring usage, data refreshes, and security access.
  • Manage stakeholders, gather requirements for analytical reports, and work with users to manage User Acceptance Testing and defect resolution.
  • Provide timely updates to team members including Head of Data Analysis and IT stakeholders on delivery progress, risks, issues, and quality.


Position Requirements

  • Ability to obtain security clearance at SC level.
  • Expert knowledge of Power BI features including PowerQuery, DAX, and visualizations to build compelling data-driven stories.
  • Expert knowledge of SQL and SQL Server Management Studio.
  • Expert knowledge of SQL Server Analysis Services or Azure Analysis Services, including Tabular modeling within tools such as Microsoft Visual Studio.
  • Experience with SQL Server Integration Services and working with relational databases.
  • Experience reporting on data from ERP and Manufacturing or Operations Systems is desirable, with familiarity with Oracle SQL and databases preferred.
  • Excellent written and in-person communication skills with the ability to manage self and work at speed when necessary.

12. BI Developer (Corporate Transformation and eCommerce)

As the BI Developer, this role builds program management tools and executive-ready content that support a corporate transformation roadmap, covering performance monitoring, visualization and analytics, and agile tooling for strategic initiatives. The Technology Program Management Office relies on this work to provide senior leadership with clear visibility into interdependencies, risks, staffing, and transformation milestones across eCommerce and strategic programs.


Role Responsibilities

  • Support program management of the long-range strategic roadmap and planning process as well as corporate governance.
  • Develop a deep understanding of active and backlog sprints and longer-term transformation roadmap efforts to help leadership manage interdependencies, risks, sequencing, staffing, and budgeting.
  • Build new program management tools for transformation including performance monitoring, decision making, visualization and analytics, and collaborative and agile tools.
  • Build client-ready content for senior executive steering sessions related to strategic transformation milestones.
  • Support capability building initiatives in areas such as lean, agile, and digital transformation.


Education and Experience

  • Bachelor's degree in Statistics, Operational Research, Economics, Finance, Business, Engineering, Technology, or a related quantitative discipline.
  • Scrum and agile certifications are considered an asset.
  • Previous experience in corporate transformation, retail, eCommerce, or analytics is preferred.
  • Experience building and validating compelling Excel models and business cases, with proficiency in Power BI, Tableau, Jira, Confluence, and JQL.
  • Experience reconciling large volumes of data, understanding data indexing, and developing unique IDs.
  • Exceptional PowerPoint, storytelling, and communication skills including facilitation in remote and virtual models.
  • Independent self-starter with high tolerance for change and the ability to adapt in a fast-moving environment.

13. BI Developer (Healthcare EMR Reporting)

BI Developer oversees the full report development lifecycle for clinical, financial, and business reporting using Microsoft SQL tools, Tableau, Power BI, and Epic Systems, ensuring accuracy and integrity through proper testing and validation. Success in the position means translating Electronic Medical Records workflows into data repository outputs, obtaining Epic Certification within 12 months of hire, and delivering well-documented, multi-project reporting solutions to healthcare stakeholders.


Performance Expectations

  • Develop logic for reports and data analysis utilizing Microsoft SQL tools, Crystal Reports, Epic Systems reporting tools, Tableau, Power BI, or other reporting applications.
  • Prepare and present concise summaries to explain findings, limitations, and recommendations based on initial analysis.
  • Use and refine complex clinical, financial, and business requirements related to reporting applications.
  • Understand Electronic Medical Records workflows to translate between the transactional system and the data repository.
  • Obtain and maintain Data Model and reporting tools certifications or training as needed, including Epic Certification within 12 months of hire.
  • Perform proper testing and validation techniques to ensure accuracy and integrity of reported or extracted data.


Required Qualifications

  • Bachelor's degree in Computer Science, Business, Mathematics, Statistics, Science, or Engineering required, with a Master's degree preferred.
  • 3 to 4 years of related experience required, with 1 to 2 years in a supervisory capacity preferred.
  • Epic Certification in Clinical Data Model or Revenue Data Model required within 12 months of hire.
  • Experience with SQL, SSRS, Microsoft Visual Studio, Tableau, and healthcare information systems preferred.
  • Experience with Epic reporting preferred.
  • Strong problem-solving, customer service orientation, and excellent oral and written communication skills.
  • Ability to work on multiple projects simultaneously, both independently and as part of a team.

14. BI Developer (Power BI and DAX Development)

The BI Developer builds Power BI reports, dashboards, and data models that serve business units through customized DAX metrics, mobile push, and email communications, while maintaining deep awareness of data security, access scope, and distribution controls. Reporting to Global team leadership and collaborating with business units on production issues and configurations, the developer ensures timeliness and accuracy of data processing across all BI outputs.


Job Functions

  • Work closely with business units to understand business processes and data requirements and abstract data models based on existing business data.
  • Participate in the model design and development of data warehouse and data mart, and process and clean business data.
  • Use DAX to create customized metrics and dimensions to meet business requirements.
  • Build reports, dashboards, mobile push, and email communications using Power BI to support business units.
  • Ensure deep understanding of security as it pertains to data access, scope, and distribution of reports and dashboards.
  • Respond to online problems in a timely manner and ensure timeliness and accuracy of data processing.
  • Support users in analyzing and resolving production issues, or collaborate with the Global team on configurations and data fixes.


Qualifications and Experience

  • Bachelor's degree in a technical or business-related field or equivalent technical work experience.
  • 3 or more years of development experience with Power BI or Tableau, with Instrument industry experience preferred.
  • Extensive hands-on experience in Power BI report and dashboard design and development, including dataset ingestion, data model creation, KPIs, Power BI Pro features, workspaces, and security.
  • Good experience using DAX for custom metrics and dimension creation.
  • Familiarity with database technologies such as SQL Server and Oracle.
  • Team-oriented and good communicator, fluent in Chinese, with excellent English communication skills preferred.

15. BI Developer (Commercial Analytics and Continuous Improvement)

The BI Developer shapes proof-of-concept Power BI and Tableau dashboards and supports Continuous Improvement initiatives by analyzing source systems including Salesforce and SQL Databases to identify and connect potential datasets. Working within commercial teams spanning Strategy and Insights, Field Sales, and Key Accounts, the developer delivers standardized data quality and process documentation that enable more effective management reporting across the business unit.


Areas of Ownership

  • Generate new ideas for creative and effective methods of presenting management information and implement these into proof of concept Power BI and Tableau dashboards.
  • Analyze source systems, particularly Salesforce and SQL Databases, to identify and connect to potential datasets.
  • Assist technology teams to communicate requirements for potential new reports.
  • Communicate with subject matter experts and report customers to ensure outputs meet business needs.
  • Support data quality efforts through the use and maintenance of standardized data and calculation definitions.
  • Document processes and support facilitation of process workshops for review and approval of new and improved reports and processes.
  • Support the development, planning, and implementation of Continuous Improvement initiatives.


Skills and Qualifications

  • Degree-level education in Business Studies, Finance, or Information Systems.
  • Academic experience with BI tools including Power BI, Tableau, or similar products at a basic level.
  • Academic experience with SQL and ETL tools at a basic level.
  • Advanced proficiency in MS Office Suite, especially Excel including pivot tables and charts, and PowerPoint.
  • Fluent English language skills.
  • Logical thinking with strong problem-solving mindset, attention to detail, and structured and organized working style.
  • Self-motivated and adaptable with a willingness to learn and openness to challenges.

16. BI Developer (Government Contracts and Microsoft BI Stack)

Embedded within a data analytics team, the BI Developer creates datasets and self-service reporting dashboards by connecting to multiple data sources and deploying applications across development, testing, UAT, and production environments. Working closely with the data team and using program management tools to track intakes, the developer produces visualization reports that support government contract requirements and data warehousing projects.


Operational Focus

  • Create datasets for self-service reporting and service dashboards.
  • Publish reports via the Power BI service, managing distribution of apps and monitoring usage, data refreshes, and security access.
  • Interact with business users to understand needs and gather report specifications.
  • Develop business requirement documents, technical specifications, and design documents using appropriate documentation standards.
  • Test and deploy applications across development, testing, UAT, and production environments, and fix any defects identified.
  • Connect to multiple data sources, import data, and transform data for BI purposes.
  • Use program management tools to track intakes and monitor progress.


Experience and Qualifications

  • Bachelor's degree in Analytics or Computer Science with 8 or more years of relevant experience, or advanced degree with 5 or more years of relevant experience.
  • 4 or more years of experience with data analytics.
  • 3 or more years of experience with Microsoft Business Intelligence Stack including Power BI, SSAS, SSRS, and SSIS.
  • Experience with SQL development to create and maintain functions, stored procedures, packages, triggers, and data structures, along with data preparation, data gateway, and data warehousing projects.
  • Experience with R or Python programming and understanding of JavaScript, CSS, and JavaScript libraries.
  • Knowledge of Jira and Confluence with working knowledge of entity relationship modeling.

17. BI Developer (MicroStrategy and GCP)

Reporting to data leadership, the BI Developer supports business and executive teams in their data visualization needs using MicroStrategy on a GCP and BigQuery-based data warehouse, sculpting and transforming data to make it usable for analysts. Partnering with data governance specialists, data engineers, data scientists, and an international team spanning Barcelona, Brussels, and Paris, the developer creates self-service BI capabilities and animates the business analyst community through training and best practice guidance.


Key Responsibilities

  • Support business and executive leadership in their data visualization needs using MicroStrategy.
  • Serve as the first point of contact for business analysts and stakeholders, understanding their needs and proposing the best solutions.
  • Animate the business analyst community, train them on MicroStrategy for dashboard and self-service usage, and ensure best practices are applied.
  • Understand data lineage, sculpt and transform data, and make it usable for analysts in MicroStrategy.
  • Collaborate with data governance, data engineers, data scientists, and data analysts across an international team.


Required Qualifications

  • MicroStrategy Certified Developer with at least 3 or more years of experience with MicroStrategy, with release 10.x experience a plus.
  • Strong SQL and RDBMS skills with experience with BigQuery and previous experience on GCP or other cloud environments preferred.
  • Demonstrated experience translating business requirements into data analysis and reporting solutions, including complex metrics creation, filters, and prompts for self-service BI.
  • Strong verbal and written English communication skills with the ability to animate workshops and training sessions.
  • Commitment to improving technical knowledge through conferences and training, with open and transparent communication skills to build strong links with remote colleagues.

18. BI Developer (Power BI and Row-Level Security)

The BI Developer develops visual reports, KPI scorecards, and dashboards in Power BI Desktop, executing advanced DAX queries and row-level security implementation to deliver secure, informative analytics to business users. Working across infrastructure and software development environments and collaborating with business stakeholders on requirements gathering, the developer refines and standardizes reporting solutions to support data-driven decisions.


Core Responsibilities

  • Develop visual reports, dashboards, and KPI scorecards using Power BI Desktop.
  • Connect to data sources, import data, and transform data for BI purposes.
  • Implement row-level security on data and understand application security layer models in Power BI.
  • Write advanced DAX queries and apply advanced-level calculations on datasets.
  • Consult with business to identify new reports, enhancements, or data needs to support business decisions.
  • Simplify and standardize reports at regular intervals.
  • Provide technical support during implementation, deployment, and troubleshooting of dashboards.


Technical Qualifications

  • Microsoft Certification PL-300 preferred.
  • 3 or more years of experience in an infrastructure or software development environment.
  • 2 or more years of experience with Microsoft services including SharePoint Online, Microsoft Teams, and Power BI.
  • Advanced-level knowledge of Power BI with experience developing solutions and implementing row-level security and application security layer models.
  • Expert in using advanced-level DAX calculations with strong analytical thinking skills for translating data into informative visuals and reports.
  • Strong skills in client requirements gathering, process analysis, and testing.

19. BI Developer (Cloud Analytics and Data Literacy)

The BI Developer builds and maintains visually appealing dashboards for external customers and internal stakeholders, designing complex data models and executing queries across GCP-based cloud infrastructure including BigQuery, Apache Airflow, and Terraform. Working alongside Data Engineers and Data Scientists to define data standards, this role elevates data literacy and analytical curiosity throughout the company while ensuring systems run correctly and efficiently.


Day-to-Day Responsibilities

  • Work with stakeholders to translate business requirements and problems into analytical solutions.
  • Build and maintain visually appealing dashboards for external customers and internal stakeholders.
  • Design complex data models to implement valuable metrics and address customer needs.
  • Master datasets and craft and execute queries upon request for data.
  • Work with Data Engineers and Data Scientists to help define data standards and requirements.
  • Provide internal trainings and documentation to ensure successful onboarding of new team members and stakeholders.
  • Extend data literacy and curiosity throughout the company.


Position Requirements

  • Ability to write complex SQL queries with extensive experience working with BI platforms such as Tableau, Power BI, or Qlik.
  • Experience with implementation of embedded analytics content and row-level security preferred.
  • Experience working in cloud computing environments such as GCP or AWS, with proficiency in Google Cloud Platform including BigQuery, Apache Airflow, Terraform, Docker, and Git.
  • Holistic understanding of IT systems, data warehousing, and ETL pipelines.
  • Fluent in English with the ability to explain and present analysis to business stakeholders both verbally and in writing.
  • Strong analytical mindset with the ability to plan, prioritize, and troubleshoot effectively.

20. BI Developer (Commercial KPI and Self-Service Analytics)

A key member of a commercially focused analytics team, the BI Developer develops high-quality Tableau and Power BI visualizations that support KPI monitoring and self-service analytics for commercial stakeholders. Collaborating across business and data teams, the developer uses SQL, R, and Python to prepare data for automated reporting and drives efficient query development that translates commercial processes into actionable data outputs.


Primary Duties

  • Develop new and enhanced reporting and visualization of data to support effective decision-making.
  • Gather requirements for new and enhanced data visualization and reporting based on BI backlog.
  • Develop high-quality visualizations within Tableau or Power BI, iterating efficiently via stakeholder feedback.
  • Develop a strong understanding of the underlying KPIs and business processes being supported by data.
  • Support teams using self-service data analytics to drive efficient development of queries and ad hoc reporting.
  • Use SQL and other languages such as R or Python to prepare data for automated and scheduled reporting, visualization, and self-serve analytics.


Minimum Qualifications

  • 1 to 2 years of experience working in or with commercial teams in an analytically focused role.
  • Good understanding of KPIs, commercial levers, data structures, and systems used to deliver BI.
  • Advanced analytical skills with good SQL development skills.
  • Strong to intermediate Tableau and Power BI skills with advanced MS Office skills.
  • Strong communication skills with the ability to listen to and relay requirements using simple, non-technical language.
  • Ability to understand business processes and translate them into data and visualization requirements.

21. BI Developer (Insurance and Marketing Analytics)

Sustained data-driven decision-making across the organization depends on the BI Developer, who designs, develops, tests, and deploys advanced BI and analytics solutions while mentoring business power-users as part of self-service analytics and data democratization initiatives. Based within a team serving marketing and financial analytics functions, the developer advances data accuracy, automates validation procedures, and bridges gaps in data consumption across the Insurance sector.


Activities

  • Design, develop, test, and deploy advanced BI, reporting, and analytics solutions throughout the organization.
  • Support business stakeholders by enabling data-driven decision-making processes.
  • Be responsible for data accuracy and integrity, and automate testing and data validation procedures.
  • Proactively identify gaps in data consumption and suggest enhancements to bridge them.
  • Proactively identify performance issues, suggest and implement optimization solutions.
  • Mentor and nurture business power-users as part of data democratization and self-service analytics initiatives.
  • Create documentation and training materials, and support and train end users.


Background and Experience

  • Degree in Business, Computer Science, or a related field.
  • 2 or more years of experience as a BI Developer or Analyst.
  • Excellent hands-on SQL skills with high proficiency in visualization and dashboarding solutions such as Power BI or Tableau.
  • Proven track record in marketing or financial analytics, data modeling, and systems analysis preferred.
  • Experience with ETL tools and processes, and programming languages such as Python or R preferred.
  • Familiarity with the Insurance industry is an advantage.
  • Fluent in English, with German as an advantage.
  • Self-learner and problem-solver with strong analytical skills, high attention to detail, and a team-player mindset.

22. BI Developer (SQL Server and IBM Analytics)

As the BI Developer, this role creates and deploys reports and dashboards by extracting and analyzing data from disparate sources, building complex SQL queries and stored procedures, and utilizing Power BI and Cognos to maintain data analytics solutions. The analytics and IT team relies on this work to continuously enhance the performance and functionality of reporting systems and to ensure business processes are documented and users are fully trained.


Scope of Work

  • Work with business users to create and deploy reports and dashboards.
  • Extract and analyze data from disparate sources.
  • Create complex SQL queries and stored procedures.
  • Translate business needs into technical specifications.
  • Utilize Power BI and Cognos to maintain and support data analytics.
  • Continuously enhance the performance and functionality of analytics solutions.
  • Document business processes and train users.


Professional Experience

  • Bachelor's degree in Business, Computer Science, or a related field.
  • 5 or more years of BI and analytics experience.
  • 5 or more years of experience with SQL Server including SSIS, SSRS, and SSAS.
  • 3 or more years of experience with Excel including DAX measurements and queries.
  • Experience with IBM Planning and Analytics.
  • Strong verbal and written communication skills.

23. BI Developer (GCP and Payments Analytics)

BI Developer builds clear, reusable dashboards and static reports for payments, finance, and regulated marketing functions, working with engineers to design robust data sources on Google Cloud Platform including BigQuery for efficient data extraction and analysis. The work directly supports the Data Engineering team and business stakeholders by ensuring data accuracy, enabling platform administration, and applying big data and streaming pipeline technologies to drive financial reporting outcomes.


Key Responsibilities

  • Understanding the business with particular attention to financial reporting to ensure analytical needs and reporting requirements are met.
  • Liaise with all sections of the business and technology community to collect functional and non-functional requirements.
  • Build elegant, reusable, and easily maintainable solutions for data extraction, reports, and dashboards.
  • Work with engineers to build and design robust and effective data sources for efficient analysis.
  • Create clear and aesthetically pleasing static reports and interactive dashboards.
  • Perform platform administration including user setup and security configuration.
  • Present work to Data Engineering team members and stakeholders on a continuous basis.


Experience and Qualifications

  • 2 or more years of experience in a BI or Data Analytics role.
  • Strong SQL skills with strong experience creating efficient dashboards using BI tools such as Tableau, Cognos, Data Studio, Power BI, or Qlik.
  • Experience with data warehousing concepts, principles, and best practices, and cloud platforms, preferably Google Cloud Platform and BigQuery.
  • Practical experience with Python or Java is a plus, with experience in Docker containers and CI and CD practices preferred.
  • Experience working in a team adhering to agile principles with a demonstrated self-motivated and proactive approach.
  • Strong communication skills with the ability to translate technical descriptions for non-technical business-facing team members.
  • Very numerate and analytical with exceptional attention to detail, a problem-solving mindset, and strong diagnostic skills.

24. BI Developer (Data Governance and Power BI)

The BI Developer guides partners in dashboard design that drives process improvements, uses Microsoft Power BI to create certified datasets and KPI dashboards, and acts as a data governance champion to improve consistency and documentation across the organization. Reporting to data leadership and representing the organization as a data expert in group meetings, the developer produces thorough technical design documents and test plans aligned with Agile and Kanban software development practices.


Core Functions

  • Use Microsoft Power BI to create certified datasets and KPI dashboards.
  • Guide partners in the design of dashboards that drive process improvements and automation.
  • Act as a data governance champion and actively work to improve consistency, visibility, and documentation across the organization.
  • Represent the organization as a data expert, including presenting data analysis results in small group meetings.
  • Assist super users with performance tuning, best practices, and modifications to existing reports.
  • Create technical design documentation in adherence to business, source system, target report, and data quality requirements.
  • Work with end users to translate business requirements into technical specifications and produce thorough technical design documents, test plans, and documented results.


Qualifications and Experience

  • Bachelor's degree in a technology-focused or Engineering-related field, or equivalent combination of experience.
  • 3 or more years of experience developing and implementing reporting-based solutions using any reporting platform.
  • Intermediate proficiency with Microsoft Power BI and SQL including both DDL and DML.
  • Experience designing database models in support of reporting environments and with data warehousing technologies such as Snowflake, Azure SQL DW, and Redshift.
  • Experience with JSON, API calls, Databricks, Python or Spark, and legacy technologies such as SSIS and Tableau.
  • Experience using T-SQL stored procedures and functions, and familiarity with complex SQL Server scaling concepts.
  • Knowledge of Load and Performance test practices with preferred knowledge in Azure Stream Analytics, Azure Functions, and Azure Data Factory.

25. BI Developer (MicroStrategy and ETL Development)

The BI Developer crafts ETL processes, semantic layers, and MicroStrategy or Tableau reports that translate business needs and KPI monitoring requirements into technical BI solutions for quality control and game delivery teams. Working alongside Business Analysts, data modelers, and an Enterprise Data team transitioning to cloud technologies, the developer delivers documentation and production-ready deployments that support ongoing platform evolution and R and D participation.


Accountabilities

  • Work with the Business Analyst to identify and understand business needs and translate them into technical solutions.
  • Model the decision-making process in collaboration with data modelers.
  • Design and test ETL processes including extraction, transformation, and loading from the data lake.
  • Build the necessary semantic layers and reports using MicroStrategy.
  • Prepare deliverables for production environments and participate in functional validation by providing technical support to users.
  • Write technical documentation to improve content follow-up and system evolution.
  • Be active in the developer community by monitoring technology and participating in R and D projects.


Education and Experience

  • University degree in Information Technology.
  • 3 or more years of experience working with BI projects and in the modeling and development phases of data warehouse solutions.
  • Experience with one of the following databases: Snowflake, Teradata, SQL Server, or Oracle.
  • Experience with Informatica, SSIS, IBM Datastage, or other major ETL tools, with at least 1 year of Python development experience.
  • Knowledge of Hadoop technologies including HDFS, Hive, and Spark, and experience with reporting tools such as MicroStrategy or Tableau.
  • Knowledge of cloud environments including AWS, GCP, or Azure is an asset, with Airflow knowledge a strong asset.
  • Bilingual in French and English with strong problem-solving, organizational, and interpersonal communication skills.
  • Demonstrates responsibility, initiative, and strong autonomy.

26. BI Developer (Podcast and Digital Marketing Analytics)

The BI Developer manages client and industry-level reporting for a media analytics department, developing and maintaining weekly Tableau and Looker dashboards that surface optimization opportunities across podcast and digital marketing programs. Reporting to the head of analytics and collaborating with media, client, and accounting teams, the developer delivers standardized models and tools that serve both internal stakeholders and external clients with quantitative and qualitative analysis.


Key Deliverables

  • Work with media and analytics teams to develop and maintain weekly client reporting and customer and industry-level insights.
  • Work with client teams to address analytical needs and perform quantitative and qualitative analysis of marketing programs for optimization opportunities.
  • Research trends in Podcast and digital marketing to help management set strategic priorities.
  • Create user-friendly models and tools that can be standardized across the organization.
  • Act as a firm expert on modeling and reporting tools.
  • Work with analytics, client, and accounting teams to ensure cleanliness of input data.


Skills and Qualifications

  • Bachelor's degree in Economics, Finance, Statistics, Mathematics, or another STEM field.
  • At least 2 years of experience in Analytics with at least 1 to 2 years of experience working with Python.
  • Expertise in visualization technologies including Tableau and Looker.
  • Hands-on experience with programming languages such as Java or Ruby, and advanced ability to analyze and model business functions and information flow within or between systems.
  • Design, code, test, and aggregate results from SQL queries to provide information to clients and employees.
  • Must be proficient in Excel using pivot tables, v-lookups, and functions with excellent communication skills.
  • Must be a self-starter with strong attention to detail and the ability to provide custom dashboards and reports using both traditional and ad hoc BI reporting tools.

Editorial Process and Content Quality

This content is developed by the Lamwork Editorial Team using structured analysis of real-world job data, skill requirements, and hiring patterns.

Research framework by Lam Nguyen, Founder & Editorial Lead.

Reviewed by Thanh Huyen, Managing Editor.

Learn more about our editorial standards.