Road Map:

The Analytics Engineer builds high-quality data sets, models, and pipelines that that allow users to multiply the value of data, and is familiar with the modern data stack from disparate data sources to BI visualizations.

What Your Ride Will Look Like:

• Primary developer and owner of business-critical data sets, pipelines, and models.
• Develop, automate, optimize, and maintain data collection, organization, management, and storage for ad hoc and repeated use.
• Extract and transform data from internal and external systems for inclusion in the data warehouse for data users.
• Process confidential data and information according to established guidelines.
• Manage and maintain the analytics workflows including performance, health, security, and metadata.
• Review, optimize, refactor, or retire legacy datasets and ETL/ELT jobs.
• Identify and evaluate the use, benefit, and implementation of new technologies.
• Project level responsibility for research and development associated with assigned project initiatives.
• Work with technology and product teams to define requirements and execute project plans.Provide guidance related to project work for data users.

Show Off What You Have:

• 5+ years' experience in a data analytics or engineering role
• Proficient in relational and dimensional data modeling
• Experience with large, diverse data sets; familiar with geodata analysis and geospatial relationships
• ETL and ELT, pipeline and model development, observability, and documentation
• Proficient in T-SQL and familiar with SQL Server columnstores and query performance optimization
• Proficient with Python
• Comfortable with Linux and PowerShell command line interface
• Comfortable with version control and following software development best practices
• Experience with cloud data warehouse and data storage
• Experience with BI software
• Passion for learning new technologies and collaborating with colleagues on innovative solutions.
• Inclusive mindset, whether you are implementing a design from a colleague or heading the charge.
• Effective interpersonal skills with the ability to communicate technical information to both technical and non-technical personnel.
• Preferably based in Albany NY or Madison WI, or ability to travel to Albany NY minimum of four times per year.
• Bachelor's degree in STEM field, or a combination of equivalent education and experience,

Fuel Gauge:

This role is budgeted $80,000 to $90,000 per year to start.