Overview
On Site
Full Time
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - Ongoing
Skills
SQL
Azure
tableau
ETL
Job Details
ZIO Technologies is an IT solutions company powered by certified professionals with decades of experience across a myriad of industries.
We partner with our clients to help design, implement, and manage infrastructure that supports mission-critical business applications. What sets ZIO apart is our ability to leverage our broad range of experience through a streamlined and flat organizational structure. This allows ZIO to be agile and flexible with our solutions, and to have rapid response times to customer needs and challenges.
ZIO is proud to represent the following job opportunity:
ZIO Technologies is seeking 2 Data Architects/Engineers to support one of our esteemed state clients in Maryland. This is a HYBRID position, and candidates must be within commuting distance of Annapolis, MD.
REQUIREMENTS:
- 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.
- Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.
- Ability to:
- Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
- Critically think and problem solve,
- Provide excellent communication and mentoring needs,
- Quickly evaluate, learn and prototype new technologies.
- Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.
- 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, Snow fake 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.
- The following tools:
- Power BI
- Tableau
- Azure Synapse
- Azure Data Factory
- Azure Blob Storage
- Azure Databricks
- Microsoft Fabric
- One Lake
PLACE OF WORK:
3 days on site at the client's office located in Annapolis, MD. 2 days remote.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.