Job Summary:The Step2 Company is building a modern data platform on Snowflake, fed by Oracle E-Business Suite and our planning, retail and operations systems. Structured (SQL) and unstructured data land in a medallion architecture (bronze, silver, gold), with Fivetran for ingestion and dbt for transformation. This role owns how that data is structured, modeled and exposed, making Snowflake the trusted source for reporting, planning and analytics across the business. You will design the tables, models and semantic layer that finance, supply chain, sales and operations rely on every day.
Job Duties:- Pipelines: Build and maintain ELT pipelines using Fivetran and dbt, ingesting SQL sources (Oracle EBS and others) and unstructured data into Snowflake. Organize data through bronze (raw), silver (cleaned and conformed) and gold (business-ready) layers. Includes incremental loads, change capture, dbt tests and scheduling.
- Fivetran management: Own Fivetran syncs for internal and external data sources: connector setup, schedules, schema changes and failure alerts. Keep transfer costs down by choosing the right sync method per source (sync frequency, incremental vs. full loads, table and column selection, Fivetran vs. native Snowflake loading) and tracking usage against budget.
- Source system knowledge: Learn the underlying table structures of our ERP and operational systems and map them to clean, documented models.
- Data quality: Put in place tests, reconciliation checks and monitoring so issues are caught before the business sees them.
- Performance and cost: Tune queries, warehouses, clustering and storage to keep Snowflake fast and within budget.
- Data modeling: Design and maintain dimensional models (star schemas, facts, conformed dimensions) in Snowflake for sales, orders, inventory, production and finance.
- Semantic layer: Work with business teams to capture their terms, definitions, rules and processes, and encode them into semantic models: metrics, relationships, hierarchies, synonyms and business logic. Resolve ambiguous terms (e.g. which "sales" or which date) so that reports, analysts and AI tools get the same deterministic answer to the same question.
- Validated queries: Build a library of automated, validated queries against the semantic models, with expected results checked on a schedule.
- Governed data access for tools and agents: Expose semantic models and validated queries through MCP servers to AI assistants and agents. Monitor what they query, how results perform, and where answers go wrong.
- Power BI migration: Migrate existing Power BI data models into Snowflake semantic models. Repoint Power BI reporting from SQL Server to Snowflake, validating that numbers match before cutover.
- Front-end evaluation: Research and evaluate modern reporting and analytics front ends, both to complement Power BI and as potential replacements for it. Include natural-language query, embedded analytics and agent-driven tools. Run pilots on the Snowflake semantic layer, compare cost and fit against Power BI, and recommend a path, including a migration plan if a replacement is chosen.
- Security and governance: Manage roles, access policies and data classification in Snowflake, working with IT Security.
- Partnering: Work with business users and analysts to turn reporting needs into well-defined models and metrics. Document everything.
- Collaboration: Work with the Manager, Data Analytics on migrating legacy Power BI and SQL Server reporting, and with the Oracle ERP Solutions Architect on the mapping, meaning and governance of ERP data in Snowflake.
Basic Qualification Requirements:- 4+ years in data engineering, data warehousing or analytics engineering.
- Hands-on Snowflake experience: SQL, warehouses, roles and access control, tasks/streams, and cost management.
- Advanced SQL and hands-on dbt (models, tests, documentation, incremental builds). Working knowledge of Python for data processing and automation.
- Experience ingesting data from relational source systems (Oracle, SQL Server) with Fivetran or similar tools, and handling semi-structured and unstructured data (JSON, documents, files). Experience building layered medallion architectures. Understanding of source table structures and keys.
- Strong data modeling skills: dimensional modeling (Kimball), normalization, slowly changing dimensions, and the trade-offs between them.
- Experience building a semantic layer or metrics layer, for example with dbt, Power BI semantic models, or Snowflake semantic views. Experience migrating Power BI datasets or reports between data sources (e.g. SQL Server to Snowflake).
- Ability to explain data concepts clearly to non-technical stakeholders.
- Bachelor's degree in Computer Science, Information Systems, or related field, or equivalent experience.
Additional Qualifications:- Oracle E-Business Suite data model experience (OM, INV, AR, GL).
- Master data management (MDM) experience: customer, item and supplier master data, matching and golden records.
- Ontology and data dictionary expertise: building business glossaries, entity relationships and shared definitions that feed the semantic layer.
- Familiarity with Snowflake Cortex, MCP (Model Context Protocol) servers, or exposing data to natural-language query tools and agents.
- Airflow or similar orchestration tools; Git-based workflows and CI/CD for dbt projects.
- Experience in manufacturing, consumer products, or retail and e-commerce supply chain data.
Work Environment/Physical Demand:Hybrid or remote; based in Streetsboro, OH. Office environment. Prolonged computer use. Standard business hours, with flexibility to be reasonably available and respond quickly to critical outages or incidents that stop business operations, especially during peak selling seasons.
FLSA Status:Exempt
What are the perks?- Parental Leave
- 401k with Employer Match
- Company Paid Life & Disability Insurance
- Adoption Assistance
- Medical, Dental and Vision
- Premium FREE Medical Plan Option
- Employee Discount
- 10 Paid Holidays
- Advancement Opportunities
Join our family!#LI-Hybrid 
