Data Architect/ Engineer
Annapolis, MD, USA
SHLD, Inc.
This position will be hybrid, with 3 days onsite in Annapolis, MD. Please only apply if you can commute 3 days to Annapolis.
Responsibilities:
1. Participation in all aspects of DW and ETL process design, creation, and specification for components. 2. Providing the following services in coordination with technical, functional and management representatives from JIS and the AOC. a. Source Data Model to DW Logical Design ERD (1) Understanding the general structure of the MDEC data and star schema models currently in use by JIS, and any related data sources identified as a result of initial planning and assessments. (2) Creating a logical warehouse data design. (3) Collaboration with platform administration team, design an ETL process to move data from the source system to the data warehouse, including, but not limited to, the following: i Outlining the ETL process, setting the borders of data processing. ii Providing system architecture for each element and the whole data pipeline. iii Documenting the requirements of the system, manage its development and facilitate necessary knowledge transfer. iv Assisting in the actual development/implementation of ETL tools. v Conducting testing of the tools and data pipelines. b. DW Schema (1) Developing effective DW model(s) representing the data entities of the logical design based on functional analytic, reporting and bulk data requirements. c. DW Physical Design (1) Collaborating with platform administration to assist their efforts in creating a DW Physical design including technical considerations for data quality and operational efficiency.- Database and analytical skills.
- Ability to query source data.
- Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).
- Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.
- Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
Shld, Inc. is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or veteran status, or any other protected class.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Architecture Azure Databricks Data pipelines Data quality Data warehouse ETL Pipelines Power BI Python RDBMS SQL SSIS Tableau Testing XML
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Research Scientist jobs
- Open Junior Data Analyst jobs
- Open Business Data Analyst jobs
- Open Data Scientist II jobs
- Open Sr Data Engineer jobs
- Open Principal Data Scientist jobs
- Open BI Analyst jobs
- Open Business Intelligence Engineer jobs
- Open Data Science Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Business Intelligence Analyst jobs
- Open Lead Data Analyst jobs
- Open Azure Data Engineer jobs
- Open Software Engineer, Machine Learning jobs
- Open Junior Data Scientist jobs
- Open MLOps Engineer jobs
- Open Manager, Data Engineering jobs
- Open Marketing Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Engineer III jobs
- Open Junior Data Engineer jobs
- Open Data Engineering Manager jobs
- Open Product Data Analyst jobs
- Open Data Analyst II jobs
- Open Privacy-related jobs
- Open GCP-related jobs
- Open Tableau-related jobs
- Open Excel-related jobs
- Open ML models-related jobs
- Open Data pipelines-related jobs
- Open APIs-related jobs
- Open PhD-related jobs
- Open PyTorch-related jobs
- Open Finance-related jobs
- Open LLMs-related jobs
- Open TensorFlow-related jobs
- Open Deep Learning-related jobs
- Open Data visualization-related jobs
- Open Consulting-related jobs
- Open Business Intelligence-related jobs
- Open Generative AI-related jobs
- Open Data governance-related jobs
- Open CI/CD-related jobs
- Open NLP-related jobs
- Open DevOps-related jobs
- Open Kubernetes-related jobs
- Open Git-related jobs
- Open Docker-related jobs
- Open Snowflake-related jobs