Work for Indiana
Begin a fulfilling career with the State of Indiana by joining one of the largest employers in the state, offering a range of opportunities across 60+ agencies. At the state, you'll find competitive compensation, a robust benefits package and a commitment to work-life balance. Most importantly, you'll have the chance to make a real and measurable impact on the lives of Hoosiers across Indiana.
About the Department of Child Services:
Join a group of passionate, dedicated public servants to support one of Indiana’s most critical missions!
The Department of Child Services helps children who are victims of abuse or neglect and strengthens families through services that focus on family support and preservation. We pursue permanency for children and families through reunification, guardianship, and adoption. Our services also encompass foster care, child support, and transitional support for those adjusting to adulthood. Our culture is built upon our MVP foundation:
Mission: Champion Indiana’s future by protecting children and strengthening families with compassion and determination.
Vision: Every child in Indiana thrives in a safe, loving, forever home.
Purpose: Ignite hope. Cultivate joy.
Role Overview:
The Data Archtect creates comprehensive data solutions that align with DCS objectives. You will partner with various teams to define data needs and establish data warehouse architecture and standards. This teachnical leadership position requires strong problem-solving skills, the ability to guide teams, ability to perform logic analysis, and the capacity to respond to complex technical challenges.
Salary:
The salary for this position traditionally starts at $79,118 but may be commensurate with education or work experience.
Use our Compensation Calculator to view the total compensation package.
A Day in the Life:
The essential functions of this role are as follows:
-Create and develop the architecture for cloud/on-prem data management systems, ensuring they are secure, scalable, highly available, recoverable, maintainable and efficient.
-Define and establish cloud/on-prem Data warehouse and/or Data Lake.
-Create and Manage cloud/on-prem Data Governance, Data Management, Master Data Management and other relevant Strategies and Plans.
-Consults with and makes recommendations to business and technical groups at all levels to define data requirements, evaluate data technology needs, and formulate solutions.
-Develops and monitors the standards, best practices, procedures, integrity and integration of data.
-Analyzes data needs and requirements of existing and proposed systems and develop technical, structural and organizations designs and specifications.
-Evaluates technology and products to determine the feasibility of adding to agency standards.
-Provides guidance and reviews the work of team members on projects as needed.
-Facilitate discussions for long-term planning implementation.
-Identifies and explores the potential strategies for long-term planning implementation.
-Works with and provides guidance to information systems personnel or user agencies, for maximum utilization of the agency data.
The job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee. Other duties, responsibilities and activities may change or be assigned at any time.
This position is exempt from overtime compensation for additional work hours that may be required to complete essential functions or other assigned work. Exempt employees may work more than 75 hours in a pay period without additional compensation and must report a minimum of 75 hours per pay period of work hours and/or paid leave taken to receive their base biweekly salary.
What You'll Need for Success:
You must meet the following requirements to be considered for employment:
-Proficiency in database management systems like SQL, NoSQL, PostgreSQL, SQL Server, DB2 etc.
-Expertise in designing data models, including conceptual, logical, and physical models.
-Strong knowledge of ETL (Extract, Transform, Load) processes and tools like AWS Glue, Informatica, Talend etc.
-Experience with cloud services such as AWS, Azure, or Google Cloud Platform, especially their data storage and processing services.
-Thorough knowledge of data warehouse architecture and standards.
-Understanding data warehousing and data lake concepts and tools like Amazon Redshift, Snowflake, Databricks etc.
-Knowledge of data governance practices, including data quality, data lineage, and data security.
-Proficiency in programming languages such as Python, PySpark, Lambda Functions, Scala for data manipulation and analysis.
-Thorough knowledge of database software, database definition languages, data dictionaries, computer programming and testing of programs.
-Through knowledge of data communication, connectivity and the agency used operating systems.
-Extensive knowledge of the most recent technical developments in the data management field.
-Ability to perform logic analysis.
-Ability to read and understand complicated technical manuals.
-Ability to communicate effectively, both orally and in writing.
-Ability theories, principles and methodologies to existing computer or database software.
-Ability to design complex data architectures to support the use of agency data.
-Ability to guide and coordinate the work of others.
Supervisory Responsibilities/Direct Reports:
This role may be utilized in a supervisory capacity based on agency needs.
Benefits of Employment with the State of Indiana:
The State of Indiana offers a comprehensive benefits package for full-time employees that includes:
-Three (3) medical plan options (including RX coverage) as well as vision and dental plans
-Wellness Rewards Program: Complete wellness activities to earn gift card rewards
-Health savings account, which includes bi-weekly state contribution
-Deferred compensation 457(b) account (similar to 401(k) plan) with employer match
-Two (2) fully-funded pension plan options
-A robust, comprehensive program of leave policies covering a variety of employee needs, including but not limited to:
-150 hours of paid New Parent Leave and up to eight weeks of paid Childbirth Recovery Leave for eligible mothers
-Up to 15 hours of paid community service leave
-Combined 180 hours of paid vacation, personal, and sick leave time off
-12 paid holidays, 14 on election years
-Education Reimbursement Program
-Group life insurance
-Referral Bonus program
-Employee assistance program that allows for covered behavioral health visits
-Qualified employer for the Public Service Loan Forgiveness Program
-Free Parking for most positions
-Free LinkedIn Learning access
Equal Employment Opportunity:
The State of Indiana is an Equal Opportunity Employer and is committed to recruiting, selecting, developing, and promoting employees based on individual ability and job performance. Reasonable accommodations may be available to enable individuals with disabilities to complete the application and interview process as well as perform the essential functions of a role. If you require reasonable accommodations to complete this application, you can request assistance by contacting the Indiana State Personnel Department at jobsspd.IN.gov.
