Database Analysis - Advisor II
MILWAUKEE, WIJobSeen todaySeen in employer's feed today
Most applications go out cold — see where you stand first. No sign-up to start.
Watch jobs like this. New roles like this one near MILWAUKEE, WI, by email.
Don't just apply. Show up ready.
Olive works from this exact posting.
At a glance
Olive lists jobs from US employers, including remote roles you can work from the United States.
Job overview
The Database Analysis - Advisor II designs and maintains data ingestion and transformation pipelines across StreamSets and Snowflake. The role includes building Python utilities, managing dbt models, implementing encryption or tokenization, and developing monitoring applications. It also involves pipeline optimization and deployment, collaboration in Agile ceremonies, and compliance with enterprise CI/CD, audit, and release-management standards.
Skills & qualifications
Skills
Qualifications
Full job description
JOB REQUIREMENTS: Design, develop, and maintain StreamSets Control Hub pipelines to ingest and process data from multiple upstream systems into Snowflake, ensuring scalable and consistent data movement across environments. Build metadata-driven pipelines for Raw JSON ingestion and develop Python utilities to parse and flatten nested structures. Analyze source file layouts to define transformation logic and create source-to-target mappings with data lineage and business rules. Design and implement Snowflake objects and orchestrate automated DAGs using Task Graphs in alignment with enterprise data architecture standards. Manage dbt models, tests, incrementals, and snapshots using Snowflake-native deployment patterns. Classify PCI data and apply Voltage encryption or tokenization using Groovy scripts while enforcing naming conventions and data types. Monitor, validate, and optimize pipelines for performance and scalability, including deployment, versioning, and rollback within enterprise release management practices. Build Streamlit-based monitoring and reporting applications and leverage Snowflake Cortex AI capabilities. Collaborate with cross-functional stakeholders in Agile ceremonies to meet delivery timelines and data quality objectives. Ensure compliance with enterprise CI/CD standards, SonarQube quality gates, and audit requirements. Support CAB-driven Harness deployments. Maintain documentation for audit readiness, regulatory compliance, and client deliverables. ***** OTHER EXPERIENCE AND QUALIFICATIONS: 4 years in any job title involving database engineering experience. Prior experience must include 4 years in the following: Building and optimizing StreamSets pipelines for large-scale data ingestion; Working in Snowflake, including tables, views, streams, tasks, and Task Graph orchestration; Working with SQL and data transformation, including source-to-target mappings, lineage, and business rules; Working in Python and scripting; Working with CI/CD, version control, and release management; and Maintaining JIRA stories, working in sprint-based teams, and presenting technical demonstrations. ***** APPLICATION INSTRUCTIONS: Apply Online: https://fiserv.wd5.myworkdayjobs.com/P3M/job/Milwaukee-Wisconsin/Database-Analysis\-\--Advisor-II\_R-10403114 Qualified females, minorities, and special disabled veterans and other veterans are encouraged to apply.
Similar jobs, posted recently
Open roles like this one, listed in the last 30 days.
Senior Talent AdvisorRockwell Automation, Inc. · MILWAUKEE, WI (Hybrid)
Lead Database EngineerRite-Hite Holding Corp. · MILWAUKEE, WI
PQI InternLUTHERAN SOCIAL SERVICES · MILWAUKEE, WI
Database Administrator - ONSITE - (Pleasant Prairie, WI) - 6501073Accenture · Milwaukee, WI · $50–60/hr
Financial Planning Analysis AnalystNorthwestern Mutual Life Insurance Company · MILWAUKEE, WI
You've read the whole posting — now see how you match it.