Data Engineer

Volusion   •  

Austin, TX

Industry: Technology

  •  

Less than 5 years

Posted 177 days ago

This job is no longer available.

As a Data Engineer, you will assist in the development of data warehouse information architecture on both Google Cloud BigQuery and Microsoft SQL Server, optimize SQL performance, and provide operational support to our high availability Microsoft SQL Server Warehouse infrastructure. An ideal candidate will be a proficient warehouse developer versed in data integration services development, report development, data analysis, and database administration.

You will:

  • Assist in building and maintaining data warehouse data integrations leveraging both MS SQL Integration services and Python technologies
  • Assist in the development of BigQuery Data Model
  • Develop and Optimize SQL Queries leveraged by existing integration services ,reporting processes and data analysis reports
  • Develop  dashboards and visualizations for ongoing measurement and KPIs.
  • Plan for non-transactional data storage for reporting and analytics
    • Database Schema design and data flow architecture planning
    • Maintain current reports in existing reporting platforms
    • Profile source system data as needed to provide feedback for business requirements
    • Analyze and verify Data Warehouse data
    • Assist in the design, build and maintenance of SSAS cubes

    We are looking for someone with:

    • MUST be a team player with excellent oral and written communication skills
    • Bachelor’s degree in Computer Science or Engineering
    • SQL Skills for data analysis is a strong must have
    • 2+ Years Microsoft SQL Server Integration Services development or similar Extract Transform Load development
    • 2+ years of experience Microsoft SQL Server database administration
    • 2+ years of experience with Python 2.7 or 3.x
    • Strong experience with performance optimization and tuning with database applications is a MUST
    • Python Scripting and .NET knowledge preferred
    • Familiarity with Cloud Services. Google Cloud Platform (GCP) and the GCP Data Services experience is a plus