Business Intelligence (BI) Developer

Essential Duties and Responsibilities 

The BI Developer develops analytical products, dashboards, predictive models, machine learning solutions, and decision-support capabilities. This includes translating business questions into analytical workflows, engineer features, build models, and deliver insights that support FAA mission operation Responsibilities include support data exploration, visualization, statistical modeling, and AI/ML development in alignment with responsible AI and governance policies. This role creates dashboards, reporting layers, KPIs, and business semantic models for FAA1, PURE, and EDP.

Minimum Qualifications (Knowledge, Skills, and Abilities) 

• Experience using Tableau, Business Objects (BO), Power BI, and SQL.
• A minimum of 4 years of demonstratable experience developing business intelligence products in an enterprise environment.
• Bachelor’s degree in business administration, data science, IT, or a related field.
• Extensive experience as a Business Intelligence Analyst or in a similar role.
• Demonstrated experience delivering sophisticated business intelligence deliverables (reports, dashboards, etc.) in BI tools such as Tableau, Power BI, or Looker.
• Strong SQL skills and experience with data modeling and data warehousing concepts.
• Excellent analytical and problem-solving with keen attention to detail.
• Strong communication skills and the ability to convey complex analytical findings to non-technical audiences.
• Ability to work independently and manage multiple projects simultaneously.
• Experience in aviation industry is preferred.
• Solid understanding of business intelligence concepts, data warehousing, and reporting best practices.
• Knowledge of relational and dimensional data modeling, including star and snowflake schemas.
• Proficiency with BI and data visualization tools (e.g., Power BI, Tableau, Qlik, or Palantir Foundry’s visualization modules if applicable).
• Familiarity with SQL for querying, data extraction, and manipulation.
• Awareness of ETL processes and data integration techniques.
• Understanding of key business processes and metrics, with the ability to translate business needs into analytical requirements.
• Knowledge of data governance, data quality, privacy, and compliance standards (e.g., NIST, FISMA, FAA if applicable).
• Familiarity with cloud-based analytics platforms, especially AWS (e.g., QuickSight, Redshift) and Azure (e.g., Power BI, Synapse).
• Ability to analyze large and complex datasets to identify trends, patterns, and actionable insights.
• Skilled in designing, developing, and maintaining dashboards, reports, and visualizations to support business decision-making.
• Proficient in gathering business requirements and translating them into functional BI solutions.
• Experience with creating and optimizing SQL queries, views, and stored procedures for reporting purposes.
• Ability to validate and ensure the accuracy, integrity, and consistency of reported data.
• Skilled in automating recurring reports and developing self-service BI solutions for stakeholders.
• Strong problem-solving and critical thinking skills, including root cause analysis and data validation.
• Proficient in documenting BI processes, definitions, and methodologies for transparency and reproducibility.
• Experience with data storytelling—explaining insights and recommendations clearly to non-technical audiences.
• Ability to collaborate with business users, data engineers, and data scientists to deliver effective BI solutions.
• Ability to manage multiple projects, prioritize tasks, and meet tight deadlines in a dynamic environment.
• Ability to adapt quickly to new BI technologies, tools, and evolving business requirements.
• Ability to communicate complex analytical results in a clear, concise, and actionable manner.
• Ability to maintain confidentiality and ensure compliance with data privacy and security policies.
• Preferred experience with BI development in regulated industries (e.g., aviation, government, finance, healthcare).
• Experience working directly with users to configure, troubleshoot, and otherwise revise business intelligence assets (reports, dashboards, etc.) and related data.
• Experience optimizing existing business intelligence assets (reports, dashboards, etc.) including their associated and data and workflows for performance, time and space efficiency.

Scope Infotech offers all employees the following benefits: 

• Health Insurance (medical, dental, vision)
• Retirement Savings Plans (401K)
• Paid Time Off (Vacation, Sick Leave, Holidays)
• Employee Assistance Programs (EAP)
• Insurance (Life, Short/Long Term Disability, AD&D)
• Employee Referral Bonus

Physical Demands and Work Environment  

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the functions. While performing the duties of this position, the employee is regularly required to talk or hear. The employee frequently is required to use hands or fingers, handle or feel objects, tools, or controls. The employee is occasionally required to stand; walk; sit; and reach with hands and arms. The employee must occasionally lift and/or move up to 25 pounds. Specific vision abilities required by this position include close vision, distance vision, and the ability to adjust focus. The noise level in the work environment is usually low to moderate.  

Note 

This job description in no way states or implies that these are the only duties to be performed by the employee(s) incumbent in this position. Employees will be required to follow any other job-related instructions and to perform any other job-related duties requested by any person authorized to give instructions or assignments. All duties and responsibilities are essential functions and requirements and are subject to possible modification to reasonably accommodate individuals with disabilities. To perform this job successfully, the incumbents will possess the skills, aptitudes, and abilities to perform each duty proficiently. Some requirements may exclude individuals who pose a direct threat or significant risk to the health or safety of themselves or others. The requirements listed in this document are the minimum levels of knowledge, skills, or abilities. This document does not create an employment contract, implied or otherwise, other than an “at will” relationship.