Data Architect/Engineer in Annapolis, MD(Hybrid).

Dice is the leading career destination for tech experts at every stage of their careers. Our client, Winning Edge Solutions, LLC, is seeking the following. Apply via Dice today!

Job Description:

Data Architect/Engineer in Annapolis, MD (Hybrid).

Key Skills: Data Architecture/ Engineering, ETL, XML, SQL Server, Python, SSIS/ ADF, Power BI, Tableau.

Preferred Qualifications:

1. Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing XML and SQL.
2. Knowledge of scripting languages, such as Python, with the ability to automate repetitive tasks in Azure.
3. Excellent communication and mentoring skills.
4. Ability to write optimized SQL queries and manage databases.
5. Knowledge of BI best practices, relational structures, dimensional data modeling, and reporting techniques.
6. Experience designing and building BI solutions, monitoring performance, and addressing data integrity issues.
7. Experience designing and implementing database models and ETL procedures for data intake.
8. Advanced experience with SQL Server 2016 or above, Azure Data Factory, SSIS, and stored procedures.
9. Proficiency in dimensional modeling techniques and Azure's architecture for optimized data workflows.
10. Exposure to tools such as Power BI, Tableau, Azure Synapse, Azure Data Factory, Azure Blob Storage, Azure Databricks, Microsoft Fabric, and One Lake.

Roles and Responsibilities:

1. Participate in all aspects of DW and ETL process design, creation, and specification.
2. Understand the client data structure and star schema models, creating a logical warehouse data design.
3. Collaborate with the platform administration team to design an ETL process for data movement.
4. Document system requirements and manage development, facilitating knowledge transfer.
5. Assist in the development/implementation of ETL tools and conduct testing of tools and data pipelines.
6. Develop effective DW models representing data entities based on functional analytic, reporting, and bulk data requirements.
7. Collaborate with stakeholders to ensure data warehouse architecture development and compliance with regulatory standards.

About Us WinningEdge:

Job search can be a painful and frustrating process. We take time to understand candidate skillsets and job search preferences, matching them with our ideal clients. Our team has a combined experience of over 100 years and we have successfully placed hundreds of candidates.

#J-18808-Ljbffr