Urgent Requirement || Data Engineer (PowerBI,SSIS) || White Marsh, MD(Hybrid) || 6+ Months at White Marsh, Maryland, USA |
Email: [email protected] |
From: Suraj Prashar, Pivotal [email protected] Reply to: [email protected] Hi, Hope you are doing great!! Please find the requirement below, If you find yourself comfortable with the requirement please reply back with your updated resume and I will get back to you or I would really appreciate if you can give me a call back at my contact number (703) 570-8775 * (Ext. 232). Job Title: Data Engineer (PowerBI/SSIS) Location: White Marsh, MD(Hybrid) Duration: 6+ MONTHS Visa Type: USC/GC Job Description:- 9+ years of experience with SQL Server Integration Services (SSIS). Must have C# experience (Scripting Tasks) and Power BI Reporting experience. Must have some sort of Source Control Experience (ideally GIT) Must have experience using a ticketing system (They use JIRA) Must have experience with API communication You will be responsible for the design and implementation of datasets, integrations, and analytical infrastructure. Responsibilities: Gather and process raw data from multiple disparate sources (including writing scripts, calling APIs, write SQL queries, utilizing SSIS, etc.) into a form suitable for analysis. With assistance of Team Lead, review and interpret ongoing business requirements, research required data, and build appropriate deliverables. Refactor or develop relational data models, dimensional data models, data dictionaries, and necessary metadata using SSAS. Research and propose opportunities for data acquisition and new uses for existing data. Code, test, and document new or modified data systems to create robust and scalable applications for analytics. Work with Team Lead on the design and direction of enterprise-wide data architecture as well as design documentation deliverables. In collaboration with Team Leads and Senior Developers, create supporting technical and functional documentation, including data flow diagrams, and provide support for deployed solutions. Create advanced multi-leveled (drill-downs/sub-reports) tabular and graphical reports to meet user requirements using SQL and Microsoft SQL Reporting Services (SSRS) and Power BI. Collaborate with Quality Assurance team to ensure valid and proper deliverables. Explain tasks and processes in a clear and concise manner that can be consumed and understood to non-technical business associates. Cultivate business relationships with stakeholders. Requirements: Bachelors degree in a related discipline (Computer Science, Information Systems Management, Engineering, or similar) or equivalent work experience. C# expertise at it pertains to RESTful APIs Advanced knowledge of Microsofts SQL Server, SSRS, SSIS, and SSAS or Power BI. Knowledgeable with Power BI, preferably with an on-premises environment. Intermediate SQL Query, ETL, and Data Architecture experience. Advanced Knowledge and ability in writing complex T-SQL code. Ability to quickly identify and troubleshoot problematic SQL code. Ability to design tables, data marts, and/or databases to suit reporting needs. Knowledge of data mapping, database design, and data warehouse concepts. Introductory experience with SQL Database Administration. Knowledge using Jira, Bitbucket, GitKraken, and/or SourceTree with a good understanding of Git. Ability to interpret report requests and requirements in order to build appropriate automated solutions. Ability to work with shifting deadlines in a fast-paced environment. Strong computer skills, including Microsoft Office (Access, Excel, Word, & Outlook). Strong attention to detail, interpersonal skills, and notation skills. Keywords: csharp business intelligence information technology green card Maryland |
[email protected] View all |
Mon Sep 18 19:11:00 UTC 2023 |