ADW BI Senior Developer
Business Intelligence architect with 8-10 years’ experience modeling, designing and developing end-to-end data warehouse solutions using the Kimball methodology and the Microsoft BI Stack (SQL Server, SSIS, SSAS and SSRS).
Roles and Responsibilities:
Meet with business users to review requirements, propose, design, document and implement solutions.
Accountable for the full cycle of consulting, design, data modeling, coding, testing and documentation of the company's data warehouse.
Translate user requirements into technical architecture vision and implementation plan. Provide hands-on development of solutions; and supports the analysis and discovery processes
Responsible for providing advanced technical skills and leadership in the design, development, control, and use of business data.
Model multidimensional data warehouse solution
Support and train business users on using the solution.
Participate in code reviews, brown bag sessions and advocate best practices during development.
Experience and skills required:
Proven experience with requirements analysis, design, development, testing, and deployment of BI Solutions (End-to-End), over multiple technologies, size and scale of projects.
Advanced knowledge of identifying and documenting business requirements in a business intelligence environment
Experience in a complex data warehousing environment building data warehouses and/or data marts
Strong understanding of data warehousing concepts & technologies such as dimensional modeling, data marts, star schemas, facts and dimensions
Skilled in the following areas:
o Using SSIS as an ETL tool to design packages for high performance.
o Can develop SSIS script components and tasks using C# or VB.
o Designing multidimensional cubes in SSAS (creating calculations, actions, security).
o Developing parameterized/hierarchical reports in SSRS using SSAS as a data source.
o Knowledgeable using MDX and T-SQL to query data.
Familiar with source control systems such as TFS.
Familiar with using Excel to analyze data.
Experience with SAP and associated data
Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.
Zero stress and one profile that can connect you directly to 1000s of companies.
We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.
Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.
Join now and be seen.