JOB SUMMARY:

The BI Engineer will play a pivotal role in NPT’s data transformation through the implementation and management of our enterprise data warehouse and business intelligence platforms. This technical position bridges data engineering expertise with business intelligence capabilities to create scalable data solutions that enhance organization-wide decision-making. The role will be responsible for designing and implementing data pipelines, creating dimensional models, and maintaining critical business intelligence reports while supporting the transition to a modern cloud data warehouse architecture. The ideal candidate will combine strong technical skills with business acumen to deliver insights that drive strategic decisions.
Salary range is $75,000 - $85,000 plus 8% annual discretionary bonus

EDUCATION/CERTIFICATION:

• Bachelor’s degree in Computer Science, Information Technology, Data Science, Data Engineering, or related field

EXPERIENCE:

• 3+ years of experience in data engineering, data warehousing, or business intelligence development
• Experience working in Agile/Scrum environments
• Experience leveraging Microsoft Fabric architecture and components as an analytics layer, including centralized semantic models, self-service analytics, report versioning & pipelines, and integration with external data platforms

REQUIRED TECHNICAL SKILLSETS

• Strong SQL skills for complex query development, optimization, and data transformation
• Experience with SQL Server Integration Services (SSIS) for ETL processes and data movement
• Experience with cloud data warehouse platforms (Azure Synapse or similar modern platforms)
• Proven experience designing and implementing dimensional data models for reporting and analytics
• Experience with modern data pipeline development and orchestration tools
• Understanding of data warehousing concepts including ETL/ELT processes, medallion architecture, slowly changing dimensions, and fact/dimension modeling
• Experience with business intelligence tools, particularly PowerBI development and administration
• Familiarity with data governance principles, data quality frameworks, and best practices

PREFERRED TECHNICAL SKILLSETS

• Experience with Snowflake or other modern cloud data warehouse implementations
• SQL Server database administration experience including performance tuning, indexing, and maintenance
• Knowledge of medallion architecture patterns and implementation across various data platforms
• Advanced PowerBI certification or demonstrated expertise in complex dashboard development
• Experience with data orchestration tools (Apache Airflow, Azure Data Factory, dbt, or similar)
• Experience with modern ELT platforms (Fivetran, Matillion, Rivery) or other cloud-native data integration tools
• Programming skills in Python for data processing, analysis, and machine learning workflows
• Experience with data science libraries (pandas, numpy, scikit-learn) and machine learning model development
• Experience with version control, CI/CD practices, and DataOps methodologies
• Familiarity with customer relationship management and financial services data models
• Experience with data migration projects and legacy system modernization
• Knowledge of data security, privacy regulations, and compliance frameworks
• Exposure to machine learning, predictive analytics, and AI implementation in business intelligence contexts
• Experience with advanced statistical analysis and data science methodologies

KNOWLEDGE, SKILLS AND ABILITIES:

• Strong analytical mindset with exceptional attention to detail and data accuracy
• Excellent problem-solving abilities and capacity to work with complex, interconnected systems
• Effective communication skills for both technical and business audiences, with ability to translate technical concepts
• Self-motivated with ability to work independently while collaborating effectively in small, agile team environments
• Comfortable taking on diverse responsibilities and wearing multiple hats in a lean team structure
• Passion for continuous learning and adapting to rapidly evolving data technologies and platforms
• Ability to manage multiple priorities in a dynamic environment while maintaining high quality standards
• Strong organizational skills and project management capabilities for complex technical implementations
• Collaborative mindset with ability to work closely with external partners while maintaining internal ownership

This role will work with NPT’s evolving data technology stack including:

• Data Warehouse Platforms: Modern cloud data warehouse (implementation in progress)
• Business Intelligence: PowerBI, data visualization and self-service analytics tools
• Data Integration: ETL/ELT tools, API integrations, data pipeline orchestration platforms
• Databases: SQL Server, cloud-based data solutions, data lake storage
• Cloud Services: Microsoft Azure and associated data services
• Data Governance: Data cataloging, quality monitoring, and lineage tracking tool