In search for a talented, senior-level Tableau Developer to act as an analytic consultant to develop, enhance, and implement data visualizations including but not limited to dashboards, reports, and other Microsoft visualizations using the SharePoint platform. This position supports the Health Department, joining a team of three. The ideal candidate has demonstrated experience administering data warehouse and business intelligence (BI) solutions. This individual must be Extremely proficient in writing T-SQL queries and SSIS; Comfortable with SQL Management Studio; Proficient with Tableau and Tableau Server including Dashboard Creation; Experience writing custom MDX

• Project Description:
  
  • Administers Department's data warehouse and business intelligence (BI) solutions. Manages development database servers following scripts provided by external vendors and/or IDPH developers.
  • Business Case: Support the Iowa Department of Public Health data warehouse and business intelligence (BI) solutions.
• Project Deliverables: Delivery of high-quality business intelligence (BI) solutions using current Microsoft BI technologies.
• Milestones: This is an ongoing project that continue support for IDPH SQL Database and Data Warehouse.
• Contractor Information:
  
  • Extremely proficient in writing T-SQL queries and SSIS.
  • Comfortable with SQL Management Studio
  • Proficient with Tableau and Tableau Server including Dashboard Creation
  • Experience writing custom MDX

Responsibilities

• Assist the Lead DBA with maintaining the integrity of databases and servers and evaluate operational problems and implement solutions.
• Works across the Department with all levels of program personnel, business analysts, and project managers to understand users' needs and monitor user access and security.
• Partners with business units and technical teams to deliver high-quality business intelligence (BI) solutions using current Microsoft BI technologies.
• Leads the design and development of business intelligence (BI) solutions
• Will utilize the SharePoint platform, including Performance Point, PowerPivot, PowerView, and Reporting Services.
• Participates in the procurement process for technical solutions, including evaluating business needs, understands functional and technical requirements, participates in preparing and evaluating vendor proposals, and makes recommendations to meet the department's long-term objectives.
• Oversee third party technical resources, provide an architectural review, evaluate compliance with standards, and ensure delivery quality.
• Guides less senior staff and vendors on solutions to complicated technical problems.
• Investigates recurring and related system failures/inefficiencies by reviewing system logs, system dumps, and other information from clients and technical personnel.

EEO Employer

Apex Systems is an equal opportunity employer. We do not discriminate or allow discrimination on the basis of race, color, religion, creed, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, political affiliation, union membership, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at [email protected] or 844-463-6178.