About Vanir
Vanir has been exceeding client expectations since 1964. Our progressive growth and quality of service has led Vanir to become consistently ranked among the top construction management firms in the nation by Engineering News-Record. As we continue growing into new areas and markets, our focus is to maintain a team of creative, ambitious, and visionary individuals.
Job Description
The Business Intelligence (BI) Architect is responsible for overseeing all business intelligence development
activities for assigned projects. In addition, the candidate will drive all architectural strategies for BI efforts
and ensure these strategies are being applied to solutions built. The BI Architect may be required to act as
Technical Lead on BI-centric projects. Additionally, it will be necessary for this position to participate in
development as well as architecture and design. He/she is expected to have deep knowledge of the
Microsoft BI stack (SSIS, SQL Server, SSAS, SSRS, PerformancePoint, Excel Services, and SharePoint) and
may work with one or a range of these tools depending on project deliverables and team resourcing. The
BI Architect must also have expert level skills in Data Warehousing and BI architecture such as the ETL
process, dimensional modeling, OLAP, and Dashboards. Candidates must be interested in working in a
collaborative environment and possess good client interfacing skills, good communication skills and able to
work in both a team environment as well as individually. Responsibilities range from architecting, designing
and planning business intelligence solutions, configuring BI services, aggregating data from multiple sources
into a data warehouse, creating and deploying reports, enhancements and providing solutions.
Essential Duties and Responsibilities:
- Translates business requirements into a full end-to-end Business Intelligence Solution
- Architects all BI solutions for assigned projects
- Creates (ensures creation of) all solution documentation
- Achieves and maintains relevant technical competencies and helps to foster an environment of
continued growth and learning among colleagues on existing and emerging technologies - Effectively prioritizes responsibilities and communicates status of efforts to the project team
- Other duties as assigned
Minimum Qualifications:
- A Bachelor’s Degree in Computer Science or related field is required. A high school diploma, GED
- and/or equivalent combination of education and work experience may be substituted
- A minimum of 10 years relevant experience with relational and multidimensional database design,
implementation, strong T-SQL and knowledge of MDX - Proficient in Power BI
- Experience with reporting systems and data warehouse requirements gathering, analysis and
design of ETL processes using SQL Server Integration Services (SSIS) - Expert knowledge of Data Warehousing and Business Intelligence design principles
- Strong knowledge of BI tools, including the Microsoft BI Stack: SSIS, SSAS, and SSRS
- Experience with delivering OLAP data to end users through Excel or other analytics products
- SharePoint implementation experience a plus
- Possess strong business acumen and consistently demonstrates forward thinking
- Is able to effectively work with ambiguous or incomplete information
- Has have a working knowledge and understanding of architectural frameworks and best practices
- Must have a strong working knowledge of technical infrastructure, protocols and networks
- Must have experience on multiple hardware and software environments and be comfortable in
heterogeneous systems - Must possess a deep working knowledge of multiple platforms, operating systems, databases and
mobile technology - Excellent organizational, communication and interpersonal skills are required
- Must be able to routinely work with little or no supervision
- Must be able to effectively and efficiently handle multiple and shifting priorities
- Must remain calm while working in a high pressure environment with many short deadlines
Offered rate of compensation will be based on a variety of non-discriminatory factors, including education, qualifications, experience, and geographic location. The Salary range for this position is $115,000-$130,000.
Benefits
Vanir offers a comprehensive, competitive benefits package that includes 401(k) Savings with employer matching contributions, medical, dental, vision, health savings account (HSA) with employer contributions, life, AD&D and disability benefits, flexible spending account (FSA), voluntary benefits, Teladoc, pet insurance, paid time off, national employee assistance program (EAP) and employee referral program.
How to Apply
If you’re interested in working for Vanir please visit our website to learn more and to apply online at www.vanir.com.
VEVRAA Federal Contractor
Request Priority Protected Veteran Referrals
EOE Minorities/Females/Protected Veterans/Disabled
Contact Email: careers@vanir.com
Persons with medical limitations may, with reasonable accommodations, be capable of performing the duties of this position. Such a determination must be made on an individual basis considering the person’s limitations, the requirements of the position, and the company’s ability to make reasonable accommodations to the person’s limitations.
We Participate in E-Verify
Pursuant to the Ban The Box Act/Fair Chance Initiative, we will consider for employment qualified applicants with arrest and conviction records.
#LI-SF1