Data Architect

If you are highly skilled and passionate about data architecture and looking for opportunity to grow your career and knowledge, look no further than the Michigan Supreme Court. Judicial Information Services (JIS), the IT arm of the Michigan Supreme Court is looking for a motivated individual for our Data Architect position. Our mission is to create innovative technology solutions and provide expert service and support for Michigan’s courts. We have a rich culture characterized by opportunity, integrity, and teamwork which facilitates career development and personal growth. The Supreme Court offers competitive compensation, 401k match, comprehensive medical benefits, and flexible work schedules.

This position will have a primary focus on the implementation and on-going support of our data lakehouse environment. It requires deep knowledge and understanding of data architecture & design, data warehousing, data lakes, Databricks, data governance & security, ETL process development, and excellent communication skills. This role will also involve collaborating with cross-functional teams in an agile environment to meet the evolving data needs of judicial services users. Essential duties include, but are not limited to the following:

• Support the data lakehouse environment in compliance with industry standards, strategic direction, and platform business requirements.

• Provide technical leadership for the management of the data lakehouse infrastructure and overlaying Databricks based medallion architecture.

• Develop, document, and enforce database models, designs and management, and access controls.

• Provide technical leadership for the development and support of the data lakehouse.

• Provide technical leadership for the development and organization of the databases.

• Provide technical leadership for software installations, upgrades, patches, and configuration changes of relational database management systems.

• Plan and determine impacts for scheduling changes in the operations of the data.

• Responsible for the resolution of escalated support issues surrounding database management, system monitoring, tuning, and optimization to ensure that the database management system is working to meet data performance requirements.

• Serve as an expert in designing and identifying effective use of shell scripting as it relates to database administration and overseeing its implementation.

• Provide management with a long-term perspective on the relationship of database technology to supported systems.

• Ensure data security policies and procedures are always adhered to.

• Ensure the enforcement of database security standards.

• Mentor DBA’s with lesser experience on database security related issues.

• Provide SQL coding expertise including writing functions, procedures, and packages, reviewing, analyzing, and testing code written by others, and for database performance reasons.

• Provide consultations to developers during application design.

• Foster a culture that promotes continuous delivery and automation.

• Make presentations about complex data processing applications to systems users, management, and representatives.

• Lead or participate in task forces, special committees, and research groups to support development of major data processing applications and establishment of Agency standards.

• Lead and/or attend staff meetings, informal and formal training classes, seminars, and conferences.

• Prepare status reports as requested.

Position Available

Data Architect

Judicial Information Services

Salary Range: $94,878.72 - $125,259.12

EDUCATION

• Degree in Computer Science, Information Technology or related field or equivalent combination of education and work experience

EXPERIENCE

• 5 years of experience in data architecture, data warehouse/lake development, and ETL processes

• 5 years of experience with SQL Server, DB2, and Oracle database platforms

• Experience working with data warehouses and ETL tools

• Implementation of data governance, security, and data integrity best practices

• Developing and implementing data warehousing strategies

• Experience with and supporting Databricks based solutions

• Data hosting and support in the Microsoft Azure Cloud environment

• Developing complex technical diagrams

• Scripting languages/tools such as (Python, Powershell, etc.)

• Preferred experience:

o Experience with and desire to work in an Agile/SCRUM team environment

KNOWLEDGE

• Data Warehouse, Data Lake, Data Lakehouse

• Databricks (Delta Lake, Parquet)

• Medallion architecture principles

• SQL

• ETL and related tools

• Software Development Lifecycle

• Master Data Management strategies, tools, and techniques

• Proficient with Microsoft Office tools

• Principles and practices of producing effective project documentation

ABILITY

• Excellent relationship building skills, strong orientation toward collaboration and communication, ability to earn trust

• Ability to effectively work independently on and across teams

• Capable of acting as a thought partner and trusted advisor

• Strong change management skills and ability to lead and motivate others

• Demonstrate outstanding interpersonal and communication (written and oral) skills; able to explain technical information clearly to non-technical audiences

• Demonstrate intense curiosity to understand how complex systems and challenges ‘work’

• Demonstrate desire to seek out complex issues and solve them

• Willingness to challenge the status quo and develop creative and innovative recommendations

• Demonstrate deep empathic skills that allow exploration of insights from many different perspectives and enables ability to detect patterns that yield ideas

PHYSICAL REQUIREMENTS

• Work is typically within in an office and/or remote environment

• Lift and transport materials, equipment, and supplies weighing up to 45 pounds

OTHER REQUIREMENTS

• Must possess a valid Michigan driver’s license

• Travel by automobile within the state may be required on a varying basis

WORK LOCATION: Official work-site location is the Hall of Justice, Lansing, Michigan. Remote work may be available in accordance with the MSC/SCAO Remote Work Policy. TO APPLY: Please e-mail your cover letter and resume in Word or Adobe (.pdf) format to jobapps@courts.mi.gov and include “JIS Data Architect” in the subject line. If you are unable to send applicant materials electronically, please contact Judicial Human Resources at (517) 373-1147.

OPEN UNTIL FILLED AN EQUAL OPPORTUNITY EMPLOYER

Job Type: Full-time

Pay: $94,878.72 - $125,259.12 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible schedule
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Retirement plan
• Vision insurance

Schedule:

• Day shift

Work Location: In person

Salary : $94,879 - $125,259