Senior Data Engineer

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.

Please note that CoreSite does not sponsor candidates for visas. Also, this position is a hybrid role based in our Denver office. We give strong priority to candidates who are currently based in Denver.

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.

Posting Timeline: This position is expected to be open for applications through February 28, 2024.

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