Software Development Specialist 3 - Data Cloud & Marketing Cloud Engineer

About us\:  

Our mission is to promote positive, lifelong outcomes for Ohio youth through early intervention, quality education, and family support programs. At DCY, we offer our employees a rewarding work experience in public service helping Ohioans achieve a sustainable lifestyle that includes generous benefit options and a flexible work life balance making our agency a great place to work!

To learn more about DCY, please visit our website at Department of Children and Youth | Ohio.gov. 

Drug-Free Workplace:

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting. 

60 mos. combined work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or completion of associate core program in computer science or information systems; 42 mos. combined work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or completion of undergraduate core program in computer science or information systems; 36 mos. combined work experience in any combination of the following\: assuring requirements are defined and approved, performing code reviews and ensuring application development standards are met including 12 mos. work experience in the primary technology as specified by the agency position description & job posting.

-Or equivalent of minimum class qualifications for employment noted above. Note\: The official position description on file with the designated agency is to reflect the required, primary technology directly relating to the duties of the position. Only those applicants possessing the experience in the required, primary technology listed in the position description & job posting are to be considered for any vacancies posted. The job posting must list the required technology commensurate with the position in question.

Preferred Skills:

·       Certifications in Salesforce Data Cloud, Mulesoft, and ETL tools (e.g., Informatica, Talend).

·       Strong understanding of data governance, security, and compliance regulations for child welfare and government agencies.

·       Proficiency in SQL, NoSQL databases, and data modeling.

 

Job Skills: Software Development/Implementation

The State of Ohio is a drug-free workplace which prohibits the use of marijuana (recreational marijuana/non-medical cannabis). Please note, this position may be subject to additional restrictions pursuant to the State of Ohio Drug-Free Workplace Policy (HR-39), and as outlined in the posting.

At the State of Ohio, we take care of the team that cares for Ohioans. We provide a variety of quality, competitive benefits to eligible full-time and part-time employees*. For a list of all the State of Ohio Benefits, visit our Total Rewards website! Our benefits package includes:

• Medical Coverage
• Free Dental, Vision and Basic Life Insurance premiums after completion of eligibility period
• Paid time off, including vacation, personal, sick leave and 11 paid holidays per year
• Childbirth, Adoption, and Foster Care leave
• Education and Development Opportunities (Employee Development Funds, Public Service Loan Forgiveness, and more)
• Public Retirement Systems (such as OPERS, STRS, SERS, and HPRS) & Optional Deferred Compensation (Ohio Deferred Compensation)

*Benefits eligibility is dependent on a number of factors. The Agency Contact listed above will be able to provide specific benefits information for this position.

Unless required by legislation or union contract, starting salary will be the minimum salary of the salary range 35 (step 1, currently $38.84 per hour) associated with this position.

DCY’s core hours of operation are Monday-Friday from 8\:00am to 5\:00pm, however, daily start/end times may vary based on operational need across DCY divisions.  Employees may begin as early as 7\:00am and as late as 9\:00am, based on supervisory approval. This position performs work on-site daily at DCY’s office space.  

All answers to the supplemental questions must be supported by the work experience/education provided on your civil service application. Attachments will not be considered as part of your application.

Proficiency Instruments/Assessments may be required for this position; Applicant must demonstrate proficiency with a passing score to move on to the structured interview portion. Regardless of a passing or failing score, all results will be maintained for 6 months. Applicant with a passing score will be retained and utilized this 6-month period. Applicant with a failing score in the same classification may not re-take the same selection assessment for this 6-month period.

Travel required, as needed. Must provide own transportation or, in order to operate a state vehicle, you must have a valid driver’s license.

Background Check Information 

The final candidate selected for the position will be required to undergo a criminal background check. Criminal convictions do not necessarily preclude an applicant from consideration for a position. An individual assessment of an applicant's prior criminal convictions will be made before excluding an applicant from consideration. 

Status of posted positions 

You can check the status of your application online be signing into your profile and clicking the “My Jobpage” tab to view completed submissions and submission details. If you have questions other than your applications status, please direct them to DCY.HumanResources@childrenandyouth.ohio.gov.  

This is an exciting opportunity to be part of DCY’s transformative Agent force journey, exploring and innovating with Salesforce’s most advanced AI capabilities. As we collectively push the boundaries of what’s possible, you will have the opportunity to learn and work with cutting-edge automation, AI-driven decision-making tools, and next-generation data intelligence solutions—driving efficiency and enhancing services for Ohio’s children and families.

The Ohio Department of Children and Youth (DCY) is seeking an experienced Data Engineer to lead and support the agency’s Salesforce Data Cloud and MuleSoft applications. In this role, you will be responsible for designing, implementing, and managing end-to-end data solutions that unify, transform, and activate data—empowering data-driven decision-making and improving the agency’s services across the state.

As a key technical contributor, you will collaborate closely with IT teams, data analysts, and business stakeholders to develop seamless data integrations, optimize data sets, and ensure smooth connectivity between Salesforce Data Cloud, Mulesoft APIs, and other enterprise systems. This position offers the unique opportunity to shape the future of AI-enhanced child welfare data management, leveraging the latest technological innovations to make a meaningful impact. 

Key Responsibilities\:

Salesforce Data Cloud and marketing Cloud Management

• Design, implement, and manage data solutions that leverage Salesforce Data Cloud to create a unified view of child welfare data.

 • Lead data ingestion, transformation, and activation processes, ensuring high-quality and accurate data availability.

• Develop and optimize data sets to support targeted programs and data-driven decision-making. 

• Ensure seamless integration of Data Cloud with other enterprise applications and analytics tools.

• Design, build, and manage marketing automation workflows, customer journeys, and multi-channel campaigns in Salesforce Marketing Cloud.

• Develop and maintain data integrations between Salesforce Marketing Cloud and other systems using Data Sync, Data Cloud, or other ETL tools. 

• Utilize scripting languages such as AMPScript and SQL for customization and personalization of marketing communications.

MuleSoft & API Integration Development

• Develop secure and scalable APIs using MuleSoft Anypoint Platform to enable seamless data exchange between systems.

• Implement API-led connectivity strategies and best practices for state and federal child welfare data integration. 

• Configure monitoring and troubleshoot integration issues, optimizing system performance and data flow.

• Work with stakeholders to define data governance policies, ensuring compliance with security and privacy regulations.

 Technical Leadership & Collaboration

• Work closely with cross-functional teams to understand business requirements and translate them into scalable technical solutions.

• Provide technical expertise and guidance on Salesforce Data Cloud, Mulesoft, and data integration strategies. 

• Lead efforts to optimize data segmentation and activation for reporting, analytics, and operational improvements.

• Ensure best practices in data management, API development, and cloud security.

Ohio is a Disability Inclusion State and strives to be a model employer of individuals with disabilities. The State of Ohio is committed to providing access and inclusion and reasonable accommodation in its services, activities, programs and employment opportunities in accordance with the Americans with Disabilities Act (ADA) and other applicable laws.