Azure Data Architect/Data Analyst

Chainbridge Technologies
Full time ssas etl azure-data-lake data-warehouse azure-databricks
Software Development
United States
Hiring from: United States

About this job


Location options: Remote
Job type: Full-time
Experience level: Mid-Level, Senior
Role: Database Administrator, Data Scientist



Technologies

ssas, etl, azure-data-lake, data-warehouse, azure-databricks



Job description

Our company has an immediate need for an experienced Data Architect/Analyst to join our talented team. Your central responsibility as the Data Architect will be to develop, optimize, and oversee conceptual and logical data systems. You may design, develop, test, monitor, manage, and validate data warehouse activity, including data extraction, transformation, movement, loading, cleansing and updating processes.  You will monitor the system performance by performing regular tests, troubleshooting and integrating new features. You must have Sr. Level experience participating in and leading teams and be able to suggest new and innovative ways of gaining data processing efficiencies and be able to participate in architectural and modeling discussions.


Due to current Government Contract Requirements: ONLY US CITIZENS CAN BE CONSIDERED.  NON-CITIZEN applicants, including Green Card Holders, will not be reviewed. 


We envision this as a full-time temporary employment opportunity for a minimum of 3 months. This position will require the ability to obtain a Public Trust Clearance.


Requirements/Responsibilities:



  • Proficiency in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)


    • Able to write and understand SQL


  • Hands on experience designing and delivering solutions using the Azure Data Analytics platform  including Azure Storage, Azure SQL Data Warehouse, Azure Data Lake

  • In-depth understanding of SSAS database management systems, OLAP and ETL frameworks


    • Capable of ETL and DB performance tuning, table partitioning, shell scripting, driving prototypes and POCs


  • Able to integrate the end to end data pipeline to take data from source systems to target data repositories ensuring the quality and consistency of data is maintained at all times

  • Able to set up infrastructure for Data visualization tools like Tableau and PowerBi

  • Experience with MDX

  • Able to troubleshoot the reporting database environment and reports.

  • Self-starter that can manage conflicting priorities, excels at time management, and can identify areas of continued improvement



How to apply

To apply for this job you need to authorize on our website. If you don't have an account yet, please register.

Post a resume

Similar jobs

ACV Auctions
Full time
View job 110,000 - 150,000 USD / year
About this job Compensation: $110k - 150kLocation options: RemoteJob type: Full-timeExperience level: SeniorIndustry: AutomotiveCompany size: 1k–5k peopleCompany type: PrivateTechnologies python, java Job description ACV Auctions is looking for a Software Engineer that will work on a cross-functional agile team in...
python java
Software Development
No Location
Hiring from: U.S. / Canada, North America
THE OPPORTUNITYAtomi creates engaging online video courses for students, teachers and schools across the globe. Our products are used by tens of thousands of students, teachers and administrators every day and we’re growing rapidly. This is an incredible opportunity to...
Software Development
Australia
Hiring from: Anywhere
About this job Location options: RemoteJob type: Full-timeExperience level: Mid-Level, Senior, LeadRole: QA/Test DeveloperIndustry: eCommerce, Enterprise Software, Web TechnologyCompany size: 51–200 peopleCompany type: VC FundedTechnologies reactjs, node.js, testing Job description Shogun is on a mission to help brands create the...
reactjs node.js testing
Software Development
No Location
Hiring from: Anywhere