Job Description :
Data warehouse Business Analyst (BI)


We have an immediate opportunity with a large F500 client in the Winston Salem, NC area.


We are looking for Data warehouse Business Analyst (BI) at Winston Salem, NC with one of our major clients. Please go over the details let me know


Data warehouse Business Analyst (BI)
Winston Salem, NC
6 month, possible extensions
Open to C2H


Job description

Client is looking for a highly energetic and collaborative BI DW Business analyst with experience leading enterprise data projects around Business and IT operations. The ideal candidate should be an expert in leading projects in the BI DW space, using traditional, new and emerging technologies. Candidate should have good experience in defining the overall technical architecture for enterprise and customer data platforms. A good understanding of enterprise data architecture and systems is expected. Excellent written and verbal communication skills and ability to liaise with technologists to executives is key to be successful in this role. This position should have ability to work well in team environment, ability to meet deadlines, time management and multi tasking in a fast paced project environment


Roles and Responsibilities

The Sr Business Analyst will

- Work with Business and IT stakeholders on business requirement
- Participate in activities related to the design, development and maintenance of the business initiatives
- Perform system analysis and development of technical solutions for an enterprise data warehouse EDW , extract, transform, and Load ETL , business intelligence BI , and reporting.
- Develop, document, and implement data models for OLAP systems and reporting
- Develop, document, and implement data mappings for ETL implementations
- Contribute in the full software development life cycle from scoping, analysis, design, implementation, and quality assurance to delivery and support
- Use ETL tools to automate data load and integrate different data source
- Rapidly prototype new data sets for exploratory analysis
- Collaborate with IT partners to move data prototypes into production
- Develop data model design, data curation, and BI reporting for the enterprise data warehouse.
- Design, implementation, and integration of BI solutions for complex reporting and analytical processes for internal and externally facing applications.
- Work with client for the requirement gathering and collaborate with offshore team for the development, testing and deployment
- Manage, use and maintain business architecture models
- Share best practices, lessons learned and constantly updates the business architecture requirements based on changing technologies, and knowledge related to recent, current and upcoming vendor products and solutions.


Must have Skills:

The Sr. Business Analyst combines many different skills and experiences to address and solve business, information, and technology related opportunities, and problems. The ideal candidate is

- 5 years of experience working with SQL Server Database, relational data modeling
- 5 years of experience in Data warehouse, Data mining, Data Engineering, ETL, Schema design and dimensional data modeling
- Expert level SQL coding querying skills in a relational database Oracle and SQL Server
- Experience in Oracle SQL, PL SQL
- ETL expérience Informatica, SSIS, SQL Procedures
- Experience in reporting Tools SSRS, Excel
- Experience in working with SSAS or any OLAP cubes
- Proficiency in Microsoft TFS or related tools
- Excellent verbal and written communication skills
- Advanced knowledge and understanding of data warehouse concepts
- Experience with performance tuning complex SQL queries
- Excellent knowledge in understanding business requirements through discussions and effectively translating user requirements to functional non functional requirements with Business sponsors
- Strong communication skillset and ability to engage with business stakeholders as Pharmacy domain experts
- Experienced in User Acceptance Testing UAT


Good to have :

- Certifications in Business Analysis
- Data Analytics Tools, Reporting Tools
- Good understanding of frameworks and MS architecture


For immediate consideration please contact:


Madhu
UpStream Global Services.
Reply to: