| BI Architect, Remote at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=650380&uid= From: Nikesh Mishra, Stellent IT LLC [email protected] Reply to: [email protected] BI Architect White Marsh, MD(open to 100% remote, but prefer someone who can come on site a few times a month or weekly) Local Preferred 6 months GC/US Citizens ONLY J:D: Top 3 skills Manager is looking for: 5-10 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) In This Role, You Will Complete projects, prioritize tasks, and provide frequent progress reports with moderate direction from team leads and senior developers based on company needs. 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. Required: 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. Minimum Technologies Required for Consideration: SQL Server Integration Services (SSIS) Knowledge in Project Parameters, Expressions, and Environments required C# (Scripting Tasks) Interacting with RESTful Services is a plus SQL Server Reporting Services / PowerBI SQL Server Analysis Services is a plus JIRA (ticket management) BitBucket (or any GIT/Source Control alternative) Keywords: csharp business intelligence information technology green card Maryland http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=650380&uid= |
| [email protected] View All |
| 08:59 PM 18-Sep-23 |