What are the responsibilities and job description for the Analytics Engineer III position at QTS Realty Trust, Inc.?
The Analytics Engineer III role is responsible for bridging the gap between, data miners, product managers, and other Data Science & Engineering teams, and mentoring junior members of the analytics engineering team in designing analytics solutions in Snowflake. You'll be providing expertise in data modeling and data warehousing concepts, and leveraging modern data stack technologies, including Snowflake and dbt, to drive actionable insights. Your experience in improving data quality will help the business gain trust in the data.
RESPONSIBILITIES, other duties may be assigned.
BASIC QUALIFICATIONS
KNOWLEDGE, SKILLS AND ABILITIES
TOTAL REWARDS
We conform to all the laws, statutes, and regulations concerning equal employment opportunities and affirmative action. We strongly encourage women, minorities, individuals with disabilities and veterans to apply to all of our job openings. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, or national origin, age, disability status, Genetic Information & Testing, Family & Medical Leave, protected veteran status, or any other characteristic protected by law. We prohibit retaliation against individuals who bring forth any complaint, orally or in writing, to the employer or the government, or against any individuals who assist or participate in the investigation of any complaint or discrimination claim.
The "Know Your Rights" Poster is included here:
Know Your Rights (English)
Know Your Rights (Spanish)
The pay transparency policy is available here:
Pay Transparency Nondiscrimination Poster-Formatted
QTS is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please send an e-mail to and let us know the nature of your request and your contact information.
RESPONSIBILITIES, other duties may be assigned.
- Monitoring, maintaining, and improving data integration logic running in the Snowflake Data Cloud.
- Design, implement, and optimize large-scale data analytics solutions based on the Snowflake Data Warehouse, leveraging data to drive significant business impact.
- Utilize dbt to create data pipelines, manage transformations, and orchestrate data workflows.
- Providing expertise in data warehousing concepts, data modeling, and data lake architecture
- Use SQL, Tableau, Python, or any combination of tools to develop rapid prototypes and educate stakeholders on analytics modeling.
- Provide expert advice and education in the usage and interpretation of data to other teams across Data Science, Data Engineering, and functional Business Units.
- Detecting data quality issues and their root causes.
- Evolving the way data is organized and maintained.
BASIC QUALIFICATIONS
- Bachelor's or Master's degree in Business Analytics, Computer Science, Mathematics, or related fields; or equivalent experience.
- 5 years experience using SQL
- 2 years of experience using dbt and Snowflake Data Cloud
- 2 years of experience working within a CICD framework.
- Advanced understanding of data warehousing concepts and modern data stack tools, specifically dbt and Snowflake Data Cloud
- Working knowledge of SCRUM and Kanban Agile methodologies
KNOWLEDGE, SKILLS AND ABILITIES
- Communication Skills: Effective communication of technical findings to non-technical stakeholders is imperative.
- Business Acumen: Ability to translate data insights into actionable business recommendations.
- Problem-Solving Skills: Analytical mindset to tackle complex data challenges.
- Agile Mindset: Adaptability to changing requirements and priorities.
- Attention to Detail: Ensuring data accuracy and quality.
- Continuous Learning: Staying updated with industry trends and emerging technologies.
- Mentorship: Ability and willingness to mentor less experienced team-members
TOTAL REWARDS
- This role is also eligible for a competitive benefits package that includes: medical, dental, vision, life, and disability insurance; 401(k) retirement plan; flexible spending and HSA accounts; paid holidays; paid time off; paid volunteer days; employee assistance program; tuition assistance; parental leave; military leave assistance; QTS scholarship for dependents; wellness program, and other company benefits.
- This position is bonus eligible.
We conform to all the laws, statutes, and regulations concerning equal employment opportunities and affirmative action. We strongly encourage women, minorities, individuals with disabilities and veterans to apply to all of our job openings. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity, or national origin, age, disability status, Genetic Information & Testing, Family & Medical Leave, protected veteran status, or any other characteristic protected by law. We prohibit retaliation against individuals who bring forth any complaint, orally or in writing, to the employer or the government, or against any individuals who assist or participate in the investigation of any complaint or discrimination claim.
The "Know Your Rights" Poster is included here:
Know Your Rights (English)
Know Your Rights (Spanish)
The pay transparency policy is available here:
Pay Transparency Nondiscrimination Poster-Formatted
QTS is committed to working with and providing reasonable accommodations to individuals with disabilities. If you need a reasonable accommodation because of a disability for any part of the employment process, please send an e-mail to and let us know the nature of your request and your contact information.