Business Intelligence Engineer
Location: Carlisle, PA
Assignment: 6 month contract to Direct Hire
Domain : Financial
Work Authorization: GC, GC EAD or USC only
*must be available for onsite interview* F2F
Summary: Help us design, implement and maintain data warehouse capabilities to meet reporting and analytic needs. The Business Intelligence Engineer will solve complex business problems in a fast-paced environment and will design the warehouse for flexibility and performance. The successful candidate effectively communicates and is comfortable explaining technical concepts to non-technical people.
Essential Duties and Responsibilities:
Work inside our team of Software Developers, SQL Server DBAs, Report Analysists, Business Analysist and Testers to:
· Define, implement and document the technical architecture of data warehouse.
· Identify, design and manage the Business Intelligence tools and application environment.
· Coordinate discussions with internal customers at all levels to identify business reporting needs and implement solutions to meet those needs.
· Publish documented datasets and ensure their availability and accuracy.
· Analyze, design, build and support current and new data feeds from various data sources to the data warehouse.
· Create Entity Relationship models to capture business concepts.
· Create metadata mappings for technical and process data lineage reporting.
· Support the data needs of internal users and external clients.
· Responsibilities may require evening and weekend work.
Qualifications:
· Bachelor's degree in Computer Science or relevant field or equivalent combination of education and experience.
· At least 3 years of experience with data warehousing, technologies and tools. Thorough knowledge of the Microsoft stack of BI tools and can help us implement best practices based on your experience.
· Demonstrated experience and ability to work with business users to gather requirements and develop solutions.
· Knowledge of SQL/MDX/DAX and database concepts in a dimensional large data warehouse environment, including star and snowflake schemas, cubes, dimensions, and measures.
· Experience with data quality, data profiling, metadata management and reporting.
· Keywords: SQL Server, Integration Services (SSIS), Reporting Services (SSRS), Analysis Services (SSAS), Power BI.
Regards ,
Anushtha | KPG99,INC
3240 E
State, St Ext | Hamilton, NJ 08619
732-515-3900 II anus...@kpgtech.com