The Data Engineer will help develop, deploy, manage and maintain analytic data products within MS SQL Server, Snowflake, AWS cloud technology or other environments utilizing tools and languages including SQL, Python and Tableau. The role will require the data collection, analysis, preparation and processing of big data and the building of predictive models and analytic data solutions including their deployment and ongoing maintenance. Additionally, the role will require the management and maintenance of a legacy database application and several databases requiring skills and experience in MS SQL Server, database administration, OLAP (SSAS), data orchestration/ETL (SSIS) and the development, maintenance and support of databased applications.   To be successful in this role, the Data Engineer will need a solid understanding of data processing and data science processes, data wrangling and database management tools and have good problem-solving and analytical skillsets.  Additionally, experience with MS SQL Server as an administrator, developer, manager or maintainer of databases and database applications. 

This role will report to the Senior Manager of Data Analytics.
 

Highly qualified applicants should have the following qualifications and skills:

Detailed oriented with strong analytical skills.Solid background and experience with database management platforms, data processing, ETL and data wrangling.Proficiency with using SQL required, and other languages such as python desired.Good experience and familiarity with MS SQL Server is highly desirable including as DBA, database developer or operations and utilizing such components as T-SQL, SSAS (OLAP) and SSIS (data orchestration). Good familiarity with data visualization tools such as Tableau, Excel, Microsoft BI.Good familiarity with data cleansing and data quality tools that perform address cleaning, parsing, deduping and matching.Proficiencies with office productivity suite Microsoft Office (particularly Excel) or other similar suite of tools.   Ability to create and produce data driven reports that clearly summarize results and insights.Previous workplace experience with at least 5 years of experience required with 3 or more years in similar field.College graduate or higher with a degree in data engineering, data analysis, data sciences and/or computational sciences or similarly related technical/analytical foundation. Work independently and as a part of a team.Effective organization skills with the ability to simultaneously work on multiple projects, prioritize, and manage overall workload.Experience or familiarity in the application of machine learning algorithms and predictive analytics to building data and analytic solutions and products is desirable.Experience with building or maintaining analytic and predictive modeling solutions using cloud-based tools in AWS, Snowflake or 3rd party tools such as H2O Driverless AI is a plus.Experience using data science, data wrangling and python programming libraries such as scikit-learn, XGBoost, LightGBM, Snowpark or others is a plus.Experience as a member of an agile (Scrum/Kanban) product development or engineering team is a plus.

 

The roles and responsibilities of the Data Engineer will include, but are not limited to:

Refine and improve core analytic products and services including Connex segmentation platform and predictive modeling capabilities.Manage and implement database updates on periodic refreshes to key data sets including the Simmons/MRI Survey of the American Consumer.Implement new analytic product updates including deployment of Connex Targets builds and its integration into production systems such as Connex Cluster Explorer.Load, process, and provide analysis on a wide range of data for analytic use within Enterprise databases such as Snowflake, SQL Server and AWS cloud environments.Assist and support execution of analytic projects including client Connex Interactive Profile projects and custom predictive models.Assist and support for the development and maintenance of the Connex product line including the Connex V8.0 development road map.Develop and refine interactive visual dashboards and applications using Tableau and other dashboarding and reporting tools.Execution of complex SQL queries supporting list counts, extracts and fulfillment.Assist with processing and automation of analytic data solutions including data ingestion, cleansing, enhancement, transformation, data preparation, model building, model deployment and model operations.Help build, deploy and manage predictive models leveraging best practices for the model management lifecycle.Contribute to analytic data product development including product. enhancements, exploring alternatives, and implementation of prototypes and PoCs.Work and collaborate with other Data Engineers, Data Scientists, Product Managers to effectively explore, define, build and deploy analytic solutions and products.Create necessary documentation for technical design, process and data flows, project tracking, training material, etc.Manage and administer MS SQL Server databases and OLAP applications for SaaS productMaintain and support database applications and provide technical supportService ad hoc data requests and extractsManage operations for the database application including periodic batch jobs and email deployment campaigns.