.Job Overview:
Hybrid Data Architects/Engineers proficient in database management, data analysis, and experienced with ETL tools, Visual Studio, XML, and SQL. This role requires strong analytical abilities, consultative expertise, and effective communication skills across technical and business domains. Must be willing to come on-site for in person interview.
Key Responsibilities:
- Query and analyze source data for various projects.
- Work with ETL tools and Visual Studio to transmit and reconstruct data using XML and SQL.
- Automate repetitive tasks in Azure using scripting languages like Python.
- Maintain productive working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel.
- Critically think, problem-solve, and quickly evaluate, learn, and prototype new technologies.
- Write optimized SQL queries and manage databases, frequently interacting with Azure SQL database and other SQL-based services.
Preferred Skills, Experience, and Capabilities:Database and Analytical Skills:
- Strong database management and analytical abilities.
- Proficient in querying and analyzing source data.
Technical Knowledge:
- Experience with ETL tools, Visual Studio.
- Knowledge of XML and SQL for data transmission and reconstruction.
- Proficient in scripting languages such as Python for automating tasks in Azure.
Analytical and Communication Skills:
- Strong analytical, consultative, and communication skills.
- Ability to make sound judgments and work with both technical and business personnel.
Interpersonal Skills:
- Ability to maintain effective working relationships with peers, end users, and all levels of management and Judicial personnel.
- Strong problem-solving skills and the ability to provide excellent communication and mentoring.
Technical Proficiency:
- Advanced skills in SQL and database management.
- Experience with BI best practices, relational structures, dimensional data modeling, and data warehouse/reporting techniques.
- Knowledge of dimensional modeling, STAR schema design, Snowflake schema design, and slowly changing dimensions.
- Proficient in designing and building BI solutions, addressing data integrity issues, and optimizing data systems.
Experience with Tools and Technologies:
- Advanced experience with SQL Server 2016 or above, Azure Data Factory, SSIS, and stored procedures.
- Proficient in:
- Power BI
- Tableau
- Azure Synapse
- Azure Data Factory
- Azure Blob Storage
- Azure Databricks
- Microsoft Fabric
- One Lake
Qualifications:
- Minimum of three (3) years of experience in providing similar staffing services.
- Demonstrated experience with designing and implementing database models, ensuring data quality, and optimizing data workflows in Azure.
- High proficiency in dimensional modeling techniques and advanced experience with RDBMS administration and BI solutions.
- Will Be Required to come onsite for Interview
Job Types: Full-time, Contract
Pay: From $100,000.00 per year
Experience level:
Schedule:
- 8 hour shift
- Day shift
- Monday to Friday
Application Question(s):
- Must be Willing to come onsite for Interview
Experience:
- Data modeling: 2 years (Preferred)
Ability to Commute:
- Annapolis, MD 21401 (Required)
Work Location: Hybrid remote in Annapolis, MD 21401