As a member of the company’s information technology team, the Senior Data Engineer is responsible for development, monitoring, and deployment of technology components. The position will participate in requirement specifications with the business and will lead the technical design and implementation of the evolving enterprise software and data solutions. The Senior Data Engineer will work proactively with business partners and technical counterparts to understand software and data requirements and will own the development required to implement the solution. The Senior Data Engineer also provides guidance and mentors more junior data engineers as well as providing guidance related to best practices.

　　Duties:

　　Participate and lead in architecture and design discussions

　　Deliver innovative solutions that provide value to both internal and external end users

　　Consult / partner with the business on current software and data priorities

　　Document and communicate proposed technology solutions

　　Comply with Software Development Lifecycle (SDLC) methodology and governance strategies

　　Utilize skills that span across disciplines and comfortably play different roles in more than one area

　　Develop and maintain data warehouse, ETL, data integration and SSIS solutions

　　Contribute to and modify automated test suite

　　Create and maintain data layers for consumption

　　Collaborate with DevOps team to solidify and enhance data-related CICD pipelines

　　Troubleshoot software for data accuracy

　　Monitor data solutions to address performance and operational issues

　　Promote and demonstrate the behaviors consistent with CoreSite’s culture and Guiding Principles

　　Other projects and duties as assigned

　　Requirements

　　Knowledge, Skills & Abilities:

　　Ability to take on a new project and be able to organize, plan and build a schedule to complete project from start to finish

　　Ability to thrive in a hybrid work environment; 2+ days per week in the downtown Denver office (including required Tuesdays and Wednesdays for in-person team collaboration)

　　Strong communication skills, capable of communicating effectively at both technical and business levels and interacting with individuals across organizational hierarchies.

　　Problem-solving skills to identify root causes, recommend solutions, and implement them effectively

　　Proficiency in analyzing requirements, retrieving source data, and presenting accurate results in a timely manner

　　Accomplished in using best practices for gathering and documenting complete and detailed requirements

　　Ability to translate ideas and designs into working solutions

　　Adaptable within a dynamic agile environment

　　Education/Experience:

　　Bachelor’s degree in Information Technology or other applicable field preferred

　　10+ years overall experience including:

　　6+ years’ experience in Data Engineering role

　　6+ years’ working with Microsoft SQL Server

　　2+ years’ experience in Software Engineer role

　　Experience with Microsoft SQL SSIS and SSAS

　　Experience with Data Lakes, Data Warehousing and scaling solutions

　　Working understanding of CICD

　　Expert in data analysis, database design, data modeling, and data testing

　　Experience working with large, complex data sets and high transactional volumes

　　Working knowledge of API development

　　Experience with AWS, Azure, RedShift, Snowflake, Salesforce and/or Mulesoft a plus

　　Physical Demands:

　　The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

　　While performing the duties of this job, the employee is occasionally required to stand; walk; sit; use hands to handle, or feel objects; reach with hands and arms; climb stairs; balance; stoop or kneel; talk and hear. The employee must occasionally lift and/or move up to 25 pounds.

　　Compensation:

　　Compensation for this role includes a base salary between $120,000 and $145,000 annually. This role is also eligible for an annual bonus and equity, based upon individual and company performance.

　　Benefits

　　Not only does CoreSite have a fun, team-focused work environment, but we also offer great benefits!

　　First-day medical insurance through Cigna with generous premium cost coverage

　　Dental insurance through Delta Dental

　　Vision insurance through VSP

　　Telemedicine through MDLive for Cigna

　　Healthcare and dependent care flexible spending account (FSA) plans and health saving account (HSA) plans

　　Life, AD&D, short-term disability, and long-term disability insurance fully paid by the company

　　Voluntary coverage benefits for supplemental life, critical illness, accident, and hospital insurance

　　First-day eligibility for 401(k) savings plan through Fidelity, which includes an attractive matching company contribution

　　Discretionary annual bonus and equity incentive plan

　　Employee stock purchase plan with a 15 percent discount

　　16 days of paid time off (PTO)

　　11 paid company holidays and additional floating holidays

　　School visitation and elder care paid time off

　　Parental leave, adoption and surrogacy benefits, and family planning/fertility support

　　Wellness reimbursement program & wellness incentive program

　　Free parking or a company contribution toward a public transit pass

　　Education reimbursement and student loan debt assistance program

　　Employee assistance program, childcare resources, and personal finance management support

　　Pet insurance