Role OverviewThe Senior ELT Analytics Specialist will design, develop, and optimize data solutions that power enterprise reporting, analytics, and business intelligence. They will work across multiple environments, support mission-critical data operations, and collaborate with technical and business leaders to deliver high-quality, scalable data systems.
What You Will Do
The successful candidate will design, develop, test, implement, and support complex platform-specific ELT code using tools such as Python, SQL, Snowflake, StreamSets, and DBT. They will perform data migrations and design business process monitoring solutions, implement high-availability and disaster-resilient solutions across multiple data warehouse and reporting environments, and provide Tier II technical support for database and ELT issues.
Why It Might Be a Fit
This position is ideal for someone who thrives in complex data environments, enjoys mentoring others, and is passionate about building robust, high-performance data pipelines and architectures.
Requirements
- 60 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 months work experience in Data Warehouse specified by the agency in the position description & job posting.
- OR completion of associate core program in computer science or information systems AND 42 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 months work experience in Data Warehouse specified by the agency in the position description & job posting.
- OR completion of undergraduate core program in computer science or information systems AND 36 months combined work experience in any combination of the following: conducting performance tuning and configuration, creating data models and providing technical Tier II database support including 12 months work experience in Data Warehouse specified by the agency in the position description & job posting.
- OR equivalent of minimum class qualifications for employment noted above.
Benefits
- 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)
]]>