Business Intelligence Architect
NOTE: Physical work location in Bellingham, WA. Applicants must be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas.
Join our team, sharing the latest scientific advances in light-based technologies from around the world, including biomedical optics, astronomy, lasers, solar, nanotechnology, and more! Make a difference doing important work with a successful, international not-for-profit organization.
Full-time, 40 hours per week position available. We are an office-first organization with office hours at headquarters with the possibility of working a couple days remote with approval.
Description of duties The BI team is at the heart of building technical solutions that transform information into business opportunities. This role will be a great fit for you if you like creating BI cloud solutions leveraging Microsoft Azure tools technologies.
The BI Architect builds technical solutions for report creation to provide our stakeholders with actionable insights for data driven business decisions. As the senior member of our team, you will be a technical subject matter expert involved in creating BI solutions. You will source data from repositories (CRM D365, Dataverse, APIs), pipelining/ETL, cleansing, transforming data, and building dimensional models for reporting in Power BI/SSRS. You have experience developing ETL code in SQL Server technologies on-prem (SQL Server Analysis/Reporting/Integration Services (SSAS, SSRS, SSIS), SQL/TSQL), and migrating/building a new data warehouse in Azure Cloud.
You have advanced knowledge in data warehouse architecture with Azure cloud and implementing technical solutions using cloud resources such as Azure Storage, Integration Runtimes, Azure Data Factory, Synapse Analytics, and looking forward to new BI technologies such as Microsoft Fabric.
The ideal candidate will have strong technical expertise, curiosity for problem solving, and the ability to mentor other engineers, and work with stakeholders at large.
Education & Experience Requirements
BA in Management Information Systems (MIS) or BS in Computer Science (or equivalent experience). MA preferred.
Minimum 8 years’ experience in related position with related experience with BI development in Azure cloud and Microsoft SQL Server Data Tools.
Current MCSA: BI Reporting, SQL 2019 BI Development, Data Management and Analytics, and MPP Data Science certification or Azure Solutions Architect Expert Certification are preferred.
Experience with other Business Intelligence Tools is preferred.
Equity, Diversity, and Inclusion (EDI): SPIE recognizes that diversity and inclusion drive innovation, excellence, and new knowledge. Bringing together people from different backgrounds, experiences, and perspectives makes us stronger and supports our mission. We offer a collaborative work environment and strive to create a culture of belonging for all our employees.
Compensation and Benefits package includes:
Competitive wages, annual discretionary bonus. Pay Range $124,400 to $174,200.
Medical, dental & vision benefits provided (100% employer paid premium for the employee, 75% employer paid premium for the dependents).
Defined retirement contribution: SPIE provides an automatic 5% contribution PLUS SPIE offers UP to 5% matching contributions and 25% vesting each year, 100% vested after 4 years.
Paid Time Off plan beginning at 31 days per year.
Health savings accounts are partially funded by SPIE.
Flexible spending accounts for dependent care and dental/vision expenses available.
Employee life & disability insurance provided, dependent life insurance & Long Term Care insurance available through payroll deduction.
Many learning & development opportunities including tuition reimbursement & leadership development.
Location: Physical work location in Bellingham, WA. Occasional telecommuting may be available for this position. Applicants must be currently authorized to work in the United States on a full-time basis. The employer will not sponsor applicants for work visas.
Culture: In alignment with our mission and values as a technical society, we follow scientific findings and science-based best practices and comply with public health guidance. We are located in Bellingham, WA where you will find the perfect blend of endless outdoor recreation, incredible scenery, strong schools, great breweries, and more, making this an amazing place to work and live.
Please send a resume & cover letter, indicating how your experience & qualifications match the requirements & why you will be successful in this position to:
Apply online: www.spie.jobs
All materials must be received by 5 p.m April 7, 2024
SPIE is committed to creating a diverse environment and is proud to be an equal opportunity employer. SPIE provides equal employment opportunities to all qualified applicants without regard to race, sex, sexual orientation, gender identity, national origin, color, age, religion, protected veteran or disability status, or genetic information.
