Senior Data Engineer

Senior Data Engineer

Experience

Location

RESPONSIBILITIES:

Maintain and support existing MSSQL processes, pipelines, and schemas

Migrate existing pipelines and processes to cloud (Snowflake, GCP)

Analyze and organize raw data sets to meet both functional and non-functional requirements

Develop and test new pipelines and processes, both in MSSQL and cloud environments

With the data engineering team, design and implement solutions that scale to meet business needs

Design and implement data models to support analytics and reporting initiatives

With the software team, develop products that deliver value to our clients

Participate in peer-reviews of solution designs and related artifacts

Package and support deployment of releases

Analyze and resolve technical and application problems

Adhere to high-quality development principles while delivering solutions on-time and onbudget

Provide third-level support to business users

Participate in business operations as necessary to meet business goals

REQUIREMENTS:

Bachelor's degree in information systems, Computer Science, or Information Technology (a 4-year bachelor's degree is acceptable) - OR - expertise in above subject matters matched by experience

8+ years experience in MSSQL data engineering and development required

Expertise understanding of relational and warehousing database design and querying concepts

Exposure to agile development methodology

Strong desire to learn

Experience with SSIS, data integration and ETL procedures

Excellent understanding of T-SQL, stored procedures, indexes, stats, functions, and views

Understanding of version control concepts

Strong desire to be world-class data and SQL troubleshoot

BENEFICIAL:

Experience with Google Cloud Platform technology stack: BigQuery, Data Flow, Data Fusion

Experience with Snowflake cloud data warehouse

Experience with Matillion (Snowflake/BigQuery)

Experience with BI tools like Sigma, Tableau or others

Experience with NoSQL database