BI Architect Maryland

Company: CloudRay Inc
Location: White Marsh
Posted on: September 22, 2023

Job Description:

Role: BI Architect
Location: Marsh, MD(2 days a week onsite)


Duration: 6- 12 Months Contract





































































































































































































































































































































































































































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:
Bachelor's degree in a related discipline (Computer Science, Information Systems Management, Engineering, or similar) or equivalent work experience.
C# expertise at it pertains to RESTful API's
Advanced knowledge of Microsoft's 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: CloudRay Inc, Baltimore , BI Architect Maryland, Professions , White Marsh, Maryland