Our client is currently building out a new Business Intelligence solution, including an Enterprise Data Warehouse, and utilizing Microsoft SSIS/SSRS/(SSAS)/Power BI for reporting and analytics. As part of this program, they are looking for a hands-on Senior Business Intelligence Developer (MSBI Stack), who thrives in a collaborative work environment.
This role involves working across the entire BI lifecycle, from source data analysis, Extract Transform Load (ETL) development, through to Analysis and Reporting Services implementation, specifically with Microsoft SSIS, SSAS & SSRS. The ideal candidate would be a self-starter, thorough in their work, and willing to share best practices with a growing team. Additionally, the candidate would act as mentor on best practices both for the development team and for the business in their acceptance of the new BI solution, helping them become more mature in terms of the understanding and correct utilization of their own data assets.
BI Developer Responsibilities
The primary responsibility of the Senior Business Intelligence Developer is the analysis, design, programming, testing, integration and production support of the Business Intelligence Next Generation (BING) platform.
Participate in the entire lifecycle for Business Intelligence solution delivery.
Design, develop and deploy ETL processes using SQL Server Integration Services (SSIS).
Strong experience in writing / maintaining stored procedures.
Expert level skills in building adequate logging and traceability to ensure ability to troubleshoot issues in a production environment.
Design, develop and deploy SQL Server Reporting Services (SSRS) Reports, prior experience in utilizing DAX to create reports from Tabular Model is desirable.
Provide Business Intelligence solutions including analytics, dashboards and reports to support the company in making informed decisions that increase the bottom line through improved quality and services.
Design, develop and deploy and tune SQL Server Analysis Services Tabular Models (SSAS).
Analyze and verify technical requirements for completeness, consistency, feasibility, and testability.
Apply software engineering concepts and best practices to design a solution that meets operational requirements, such as scalability, maintainability, extensibility, and flexibility.
Communicate changes, enhancements, and modifications – verbally or through written documentation to project managers, sponsors and other stakeholders.
Champion code quality, integrity and reliability throughout the department by designing and promoting best practices.
BI Developer Qualifications
BS or BA in computer science, business, or equivalent is required.
5+ years’ experience delivering Business Intelligence solutions using the MSBI Stack (SSIS, SSAS, SSRS).
Candidates must have analytical and problem-solving skills in addition to a good grasp of both the technical and business factors of Business Intelligence Solutions Delivery.
Strong understanding of Business Intelligence / Data Warehouse concepts, methods and tools.
Proven experience designing, developing and deploying Enterprise Business Intelligence solutions to Production.
High proficiency in Microsoft Business Intelligence toolset, including:
Strong knowledge of Data Warehousing must have a strong understanding of star-schema data modeling;
SSAS (Tabular Model, DAX & MDX desirable);
Expert level skills in building out automated data validation and building in adequate controls to ensure ongoing data quality;
Write high quality code that is robust, performant, and easy to maintain.
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
Not Ready to Apply?