Role OverviewThe ideal candidate will design and implement processes for the efficient transfer of (ETL/ELT) between systems within and outside the agency; design and develop dashboards, summaries and visualizations using agency data and solutions such as MS Power BI; and assist with data model designs and physical data model implementations.
What You Will Do
Assist with the development and maintenance of OIC’s data warehouse using cloud solutions such as Snowflake and Azure Data Factory. Collaborate with systems administrators to set table access security, provide some data governance, write platform specific code for data migrations and visualizations (Python, SQL, Java, Dax), and monitor cloud and on-premise databases and stores utilizing logs, load test results, and performance monitoring tools.
Why It Might Be a Fit
A strong knowledge of RDBMS tools such as MS SQL Server and schemaless/no-SQL solutions is required. This role demands a solid understanding of agency business processes, along with strong organizational, problem-solving, and communication skills.
Requirements
- 36 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
- Or completion of associate core program in computer science or information systems; 18 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology specified by the agency in the position description & job posting.
- Or completion of undergraduate core program in computer science or information systems; 12 mos. combined work experience in any combination of the following: database administration providing Tier I support to information system users and/or IT staff, assisting with data modeling and conducting performance tuning and configuration including 12 mos. work experience in the primary technology 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)
]]>