Lead IT Data Architect - Military veterans preferred

The Maryland Judiciary offers a generous benefit package including medical, dental, vision, life insurance, paid time off, paid holidays, tuition assistance, continuing education programs, employee assistance programs, and State Retirement and Pension plans.Telework, up to 2 days per week, may also be available. Telework eligibility is based on job functions and the approval of the Administrative Head.

Essential Job Function

This multifaceted role involves leading both the Enterprise Custom Reports (ECR) team and the Data Warehouse team. The incumbent will be responsible for leading team operations; providing direction and support; delegating tasks; and ensuring the integration of business processes, training, documentation, and quality assurance.

Key responsibilities include the development of customized case management system reports using T-SQL, SSRS, and SSIS, as well as designing and implementing data transformations within the data warehouse. This includes architecting and building out scalable data pipelines that follow a medallion architecture?organizing data into bronze (raw data), silver (cleansed and enriched), and gold (business-level aggregates and metrics) transformation layers. The ideal candidate will ensure that data flows are efficient, well-documented, and aligned with business intelligence needs.

The position also requires gathering and analyzing business requirements, translating them into technical specifications, and maintaining thorough documentation. Additionally, the role involves testing, debugging, and maintaining existing reports and data models to ensure accuracy, reliability, and performance.

Essential Duties and Responsibilities:

Provides leadership and strategic direction to the ECR and Data Warehouse team, guiding daily operations while setting clear expectations for performance and outcomes. Delegates responsibilities effectively, ensuring team members are empowered and equipped to meet project goals. Oversees the development and delivery of high-quality work products, conducting thorough quality assurance reviews to maintain excellence. Manages timelines and project milestones to ensure all deliverables are completed on schedule. Actively identifies opportunities to streamline processes, drive efficiency, and implement improvements that enhance team productivity and data management outcomes.

Works with systems business analysts, researchers and/or court users to gather and elicit requirements to determine reporting criteria. Plan, Design, Develop, Test, Document and Implement MDEC Reports and Ad-Hoc queries, using SSRS, SSIS, T-SQL, C++, XML and MS VB .Net.

Assist in data warehouse work, as many case management system reports will move to the data warehouse. Performs the design and extension of data marts, meta data and data models. Ensures all data warehouse architecture codes are maintained in Azure Dev Ops. (This may shift to higher frequency as the data warehouse expands).

Report Customer Service:  Provides Help Desk (ServiceNow) support to end users remotely and on-site.

Works collaboratively with other report developers and business analysts on Judiciary processes and procedures.

Other duties as assigned.

Minimum Qualifications:

Education:

Bachelor?s Degree from an accredited college or university.

Experience:

Four (4) years of professional experience with MS SQL Server (writing and performance tuning). Two (2) years of experience in Enterprise Data Warehouse platforms.

Note:

Additional related work experience as defined above may be substituted on a year for year basis for up to four (4) years of the required education

Knowledge, Skills, and Abilities:

Knowledge of:

Some demonstrated working knowledge of VB .Net and FTP.

Some knowledge of XML & JSON syntax and parsing is preferred.

Demonstrated knowledge of Systems Development Life cycle. 

Demonstrated knowledge of evaluating and enhancing T-SQL performance.

Domain knowledge of court related concepts and business activities is preferred.

Microsoft Office Tools.

Cloud data export/migration tools

Enterprise data lakes

Skill in:

Strong analytical skills for evaluating, documenting and enhancing existing queries and develop new T-SQL queries.

Strong demonstrated understanding and work with T-SQL, SSRS, SSIS, C++.

Reverse Engineering and Refactoring T-SQL queries.

Good collaboration, communication and documentation skills are essential.

Environments:

MS SQL Server

C++

Azure Data Factory

Azure Dev Ops

Fourth Normal Form Database

Visual Studio

GitLab

Ability to:

Work in Azure Data Factory and with data warehousing.

Handle multiple high priority development items and production related issues.

Translate business processes into technological solutions. 

Perform all essential job functions with minimal supervision. 

Physical Requirements:

Sedentary work. Exerting up to 10 pounds of force occasionally and/or negligible amount of force frequently or constantly to lift, carry, push, pull or otherwise move objects, including the human body. Sedentary work involves sitting most of the time. Jobs are sedentary if walking and standing are required only occasionally and all other sedentary criteria are met.

Equipment, Machinery and Tools:

Personal computer (laptop and desktop), photo copier, scanner, projector, telephone with microphone for tele-conferencing.

Software and Computer Skills:

T-SQL, SSRS, SSIS, VB .Net, FTP, XML, Azure Data Factory, Azure Databricks, Microsoft Fabric

Selection Process:

Your application package will be used to determine your eligibility, qualifications, and ranking for this position. If you are determined to be ineligible or not qualified, your application will receive no further consideration. It is essential that you provide complete and accurate information on your application. Please report all related education, experience, dates, and hours of work. If you have held more than one (1) position at the same employer, you must list each position that you held, the length of time that you held each position, and the corresponding duties. Description of duties that state, "see resume" will negatively impact consideration for this position. Applicants will not be contacted for additional information. Only applicants considered for this position will be contacted.

Complete applications must be submitted by the closing date. Information submitted after this date will not be added. Incomplete applications will not be accepted. Resumes will not be accepted in lieu of a completed application.

For further information please contact Talent Acquisition at aocta@mdcourts.gov.

The Maryland Judiciary is an equal-opportunity employer committed to fostering a workplace culture of diversity, equity, inclusion, and belonging. We do not discriminate on the basis of race, color, religion, age, sex, pregnancy, marital status, national origin, military or veteran status, physical or mental disability, familial status, genetic information, gender identity or expression, sexual orientation, or any other characteristic protected by State or federal law. Applicants who need an ADA Accommodation during the application and/or interview process should send their via email to or call 410-260-1732. The Maryland Judiciary is a drug-free workplace. Applicants must be United States citizens or eligible to work in the United States.

Please find the Maryland Judiciary's equal employment opportunity policy here: .