HYBRID DATA ARCHITECT/ENGINEER

About DMIDMI is a leading global provider of digital services working at the intersection of public and private sectors. With broad capabilities across IT managed services, cybersecurity, cloud migration and application development, DMI provides on-site and remote support to clients within governments, healthcare, financial services, transportation, manufacturing, and other critical infrastructure sectors. DMI has grown to over 2,100+ employees globally and has been continually recognized as a Top Workplace in both regional and national categories.About the OpportunityDMI, LLC is seeking a Hybrid Data Architect/Engineerto join us. Duties and Responsibilities:The Hybrid Data Architects/Engineer will provide Data Warehouse Architect/Engineer services to serve as the primary resource(s) responsible for designing and building a data warehouse solution and working with conventional data warehouse technologies to devise plans that support designing data warehouse solutions in alignment with the Maryland Judiciary’s initiatives. The Maryland Judiciary’s Administrative Office of the Courts (AOC) has a strategic initiative to establish comprehensive data warehousing and analytics capabilities. The initial source for a Data Warehouse (DW) will be the Maryland Electronic Court (MDEC) database which uses Tyler Technologies’ Enterprise Justice software. However, the Judiciary will expand the Data Warehouse to other source systems after adding MDEC. The Maryland Judiciary intends to use Azure services for the data warehouse. There is a need to store, process and manage large data sets in the cloud.Offeror proposed resource(s) shall be responsible for the following: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.3. Collaborating with business and technology stakeholders to ensure data warehouse architecture development and utilization.4. All work completed by the proposed resource(s) shall be completed within regulatory compliance standards to protect sensitive data.5. Reporting as follows: a. Weekly progress report on programs and project, b. Weekly report communicating project progress and status, c. Weekly time reporting on JIS provided forms, and d. Any additional reports as assigned by the supervising managerQualificationsEducation and Years of Experience: Bachelors of Science and 7-10 years minumumRequired and Desired Skills/Certifications: The Candidate should have the following skills:a. Database and analytical skills.b. Ability to query source data.c. Knowledge and experience with ETL tools, Visual Studio, and transmitting and reconstructing Extensible Markup Language (XML) and Structured Query Language (SQL).d. Knowledge of scripting languages, such as Python, and the ability to automate repetitive tasks in Azure.e. Strong analytical, consultative, and communication skills; as well as the ability to make good judgment and work with both technical and business personnel.f. Ability to: (1) Work productively and maintain effective working relationships with peers, end users, vendor development staff, and all levels of management and Judicial personnel. (2) Critically think and problem solve, (3) Provide excellent communication and mentoring needs, (4) Quickly evaluate, learn and prototype new technologies. (5) Write optimized SQL queries and manage databases, as Azure data analysts frequently interact with Azure SQL database and other SQL-based services.g. Experience with: (1) BI best practices, relational structures, dimensional data modeling, structured query language (SQL) skills, data warehouse and reporting techniques. (2) Dimensional modeling, STAR schema design, Snow fake schema design, slowly changing dimensions, confirmed dimensions. (3) 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. (4) Designing and implementing database models, schemes, and databases to support efficient data storage, retrieval, and analysis. (5) Monitoring and optimizing data systems, data lifecycle, and infrastructure to ensure performance, scalability, and integrity. (6) Designing and implementing ETL procedures for intake of data from multiple source systems; as well as ensure data quality and cleansing is verified. (7) Normalization process (8) Performing the design and extension of data marts, meta data, and data models. (9) Ensuring all data warehouse architecture codes are maintained in a version control system. (10) Advanced experience with technologies such as SQL Server 2016 or above, as well as with Azure data factory, SSIS and stored procedures (11) Advanced experience developing codes, testing for quality assurance, administering RDBMS. (12) High proficiency in dimensional modeling techniques and their applications (13) Azure’s architecture in order to structure optimized data workflows. (14) The following tools: i Power BI ii Tableau iii Azure Synapse iv Azure Data Factory v Azure Blob Storage vi Azure Databricks vii Microsoft Fabric viii One LakeAdditional Requirements:Min Citizenship Status Required: Must be a U.S. CitizenPhysical Requirements: No Physical requirement needed for this position.Location: Hybrid, Three days a week on-site in Annapolis, MD, US and two days at an approved remote site.Working at DMIDMI is a diverse, prosperous, and rewarding place to work. Being part of the DMI family means we care about your wellbeing. We offer a variety of perks and benefits that help meet various interests and needs, while still having the opportunity to work directly with several of our award-winning, Fortune 1000 clients. The following categories make up your DMI wellbeing:Convenience/Concierge - Virtual visits through health insurance, pet insurance, commuter benefits, discount tickets for movies, travel, and many other items to provide convenience.Development – Annual performance management, continuing education, and tuition assistance, internal job opportunities along with career enrichment and advancement to help each employee with their professional and personal development.Financial – Generous 401k matches both pre-tax and post-tax (ROTH) contributions along with financial wellness education, EAP, Life Insurance and Disability help provide financial stability for each DMI employee.Recognition – Great achievements do not go unnoticed by DMI through Annual Awards ceremony, service anniversaries, peer-to-peer acknowledgment, employee referral bonuses.Wellness – Healthcare benefits, Wellness programs, Flu Shots, Biometric screenings, and several other wellness options.Employees are valued for their talents and contributions. We all take pride in helping our customers achieve their goals, which in turn contributes to the overall success of the company. The company does and will take affirmative action to employ and advance in employment individuals with disabilities and protected veterans, and to treat qualified individuals without discrimination based on their physical or mental disability or veteran status. DMI is an Equal Opportunity Employer Minority/Female/Veterans/Disability. DMI maintains a drug-free workplace.***************** No Agencies Please *****************Applicants selected may be subject to a government security investigation and must meet eligibility requirements for access to classified information. US citizenship may be required for some positions.Job SummaryJob ID: 2024-26917Category: AzureLocation: US-MD-Annapolis