Data Management - Data Warehouse Developer III

Job Details

We have an immediate opening at the Department of Employee Trust Funds (ETF) for a Tableau Developer/Admin. ETF is a state agency that is recognized as a leader in providing public employee benefit systems. This position will primarily be involved in business intelligence including Tableau development and administration. Candidates must be able to write SQL.

location: Madison, Wisconsin

job type: Contract

salary: $53.66 - 58.66 per hour

work hours: 8am to 5pm

education: Bachelors

Responsibilities:

• Design Tableau dashboards following best practices including visual design principles.
• Gather and document business requirements for dashboards.
• Provide ideas for dashboards aligning with high-level requirements and work iteratively with
• business partners to refine requirements to deliver the final product
• Participate in the development and enforcement of Tableau standards and processes to ensure high-quality deliverables.
• Perform testing to certify data sources and Tableau dashboards for production use
• Write SQL queries to execute in the data lake platform.
• Provide direction and mentoring to analysts on Tableau development, dashboard usability, and design best practices.
• Perform Tableau site administration in DEV, UAT, and PROD including organization, optimization, tuning, and ensuring the security of data using Tableau Server with a strong understanding of security policies and best practices
• Analyze data sets, draw conclusions and relationships, and perform data reconciliation
• Perform data profiling and provide development and support for data quality exception reporting (not sure on this one for this role).
• Promote data literacy concepts
• Use software for source code version control and continuous integration/continuous delivery
• (CI/CD)
• Perform peer reviews of deliverables
• Troubleshoot issues and facilitate resolution.

Required Skills:

• Experience writing complex SQL with relational databases (not generated from a tool) - 4 years
• Experience with Tableau development - 4 years
• Experience with Tableau site administration - 4 years
• Experience with dashboard development, including hands on development of analytics
• dashboards and working with complex data sets - 6 years
• Experience with data warehouses - 4 years
• Experience with BI governance including data usage, metadata, data management, data quality, privacy, and security - 4 years
• Ability to manage multiple, concurrent, 3 to 6-month BI dashboard design and development projects - 4 years
• Agile development practices, particularly Scrum - 2 years
• Good interpersonal and communication skills, ability to influence others and to interact with individuals at all levels - 4 years
• Experience working productively with cross-functional working groups and across organizational
• layers with consideration for organizational priorities - 4 years
• Mentoring and coaching on data analysis and dashboard development - 2 years
• Ability to develop and deliver presentations to both technical and non-technical audiences - 2 years
• Ability to develop good knowledge and understanding of business needs while
• establishing/maintaining a high level of customer trust and confidence - 4 years

Preferred Skills:

• Experience with Alteryx or similar ETL tools
• Experience with R and Python

Primary Technologies Used at ETF:

• Alteryx
• SQL Server
• Tableau
• Semarchy
• Github

qualifications

• Experience level: Experienced
• Minimum 8 years of experience
• Education: Bachelors

Skills

• Data Warehouse, SQL (8 years of experience is required), Tableau (4 years of experience is required), Agile, Python, Alteryx