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
Click
here to apply!
|