ResolveTech Solutions

BI Intelligence Architect - SSIS

Data Engineer in Irving, TX

Posted 2020-02-27

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.
Preferred skills
 Experience with SAP and associated data

Ready to be seen?

Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.

Be seen in a new Data Engineer job

Skip the search

Zero stress and one profile that can connect you directly to 1000s of companies.

Best-fit jobs—for you

We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.

Free Career Coaching

Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.

You get tech. We get you.

Join now and be seen.