28 applicants

Company

Original Job Post

AgreeYa Solutions · 2 days ago

Data Architect

Annapolis, MD

Contract

Hybrid

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Consumer ElectronicsInformation Technology

H1B Sponsorship

Growth Opportunities

Hiring Manager

Mukesh Singh

Insider Connection @AgreeYa Solutions

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Design and build BI solutions by monitoring and tuning queries, addressing user questions, and communicating technical issues.

Implement database models, schemes, and databases to support efficient data storage, retrieval, and analysis.

Optimize data systems and infrastructure to ensure performance, scalability, and integrity.

Design and implement ETL procedures for data intake from multiple source systems.

Develop and extend data marts, meta data, and data models.

Maintain data warehouse architecture codes in a version control system.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

BI best practicesRelational structuresDimensional data modelingStructured query language (SQL)Data warehouseReporting techniquesSTAR schema designSnowflake schema designSlowly changing dimensionsConfirmed dimensionsDatabase modelsDatabase schemesDatabase designETL proceduresData qualityData cleansingNormalization processData martsMeta dataData modelsData warehouse architectureVersion control systemSQL ServerAzure Data FactorySSISStored proceduresQuality assuranceRDBMS administrationDimensional modeling techniquesAzure architecture

Required

Experience with BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques

Dimensional modeling, STAR schema design, Snowflake schema design, slowly changing dimensions, confirmed dimensions

Designing and building BI solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, data mapping, monitoring performance and communicating functional and technical issues

Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis

Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity

Designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified

Normalization process

Performing the design and extension of data marts, meta data, and data models

Ensuring all data warehouse architecture codes are maintained in a version control system

Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure Data Factory, SSIS, and stored procedures

Advanced experience developing codes, testing for quality assurance, administering RDBMS

High proficiency in dimensional modeling techniques and their applications

Azure’s architecture in order to structure optimized data workflows

Experience with Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, One Lake

Company

AgreeYa Solutions

Glassdoor

4.3

AgreeYa Solutions is a global provider of software, solutions, and services

Founded in 1999

Folsom, California, USA

1,001-5,000 employees

http://www.agreeya.com/

H1B Sponsorship

AgreeYa Solutions has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (33)

2022 (67)

2021 (70)

2020 (115)