Programmer (Tableau Dashboards, Data Sets, Framework Manager, COGNOS, SQL)

MVP Consulting

Rensselaer, NY

JOB DETAILS
SKILLS
Analysis Skills, Child Protection/Welfare, Community and Social Services, Computer Programming, Consulting, Data Quality, Data Sets, Documentation, IBM Cognos, Operational Support, People Management, Performance Analysis, Performance Metrics, Presentation/Verbal Skills, Problem Solving Skills, Reporting Dashboards, Requirements Management, SQL (Structured Query Language), Social Work, Tableau, Technical Writing, Testing, Warehousing
LOCATION
Rensselaer, NY
POSTED
10 days ago
HBITS: HBITS-07-14834

NYS OCFS - Expert, Programmer

24 month contract

Interview: Virtual Interview

Work model: 50% telecommuting, 50% Office per week

--- Project Description ---
This request is for a Programmer to work in the OCFS Office of
Research, Evaluation and Performance Analytics (OREPA) Data
Warehouse (DW) unit. Incumbent will elicit, analyze, design, and
document business and technical requirements for Child Welfare
reporting and data visualizations intended for OCFS staff, Local
Districts, Voluntary Agencies, and the public. Reporting includes Child
Protective Services, Federal Financial Reporting, Child Care
Assistance Block Grants, Family First, KPIs, and related dashboards to
support operational and data quality efforts.

--- Day-to-Day Tasks ---
1. Elicit and collect necessary information and create business and
technical requirements documents,
2. Write SQL scripts to extract and analyze child welfare data to
determine data quality,
3. Extract data to investigate issues associated with reporting and
dashboard development,
4. Develop and maintain COGNOS reports, data sets/modules and
dashboards
5. Develop and maintain Tableau data sets and dashboards,
6. Configure and maintain Tableau site environment, user accounts and
permissions, and data refresh schedules

Programmer
Creates computer software. May specialize in one area of computer software or may write code for many kinds of software. 
Expert 84+ months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.

--- Required Qualifications ---
• 84 Months of Experience in using SQL for analysis and reporting including conditional formatting and joining multiple queries
• 84 Months of Experience testing reports, analytics, troubleshooting, problem solving, documenting and presenting complex data challenges to stakeholders
• 84 Months of Experience working in social services or related fields 
• 84 Months of Experience in business requirement gathering, analysis and logical design; understanding and translating complex issues both in oral and written communication
• 84 Months of Experience in creating and modifying Tableau Dashboards and Data Sets
• 84 Months of Experience in creating and modifying Framework Manager models and reports using COGNOS tools

MVP Consulting Plus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Reasonable accommodations are available for qualified individuals with disabilities during the application process.

About the Company

M

MVP Consulting