Data Engineer

About the Role

Key Responsibilities

• Interprets and delivers impactful strategic plans to improve data integration, data quality, and data delivery in support of A&I initiatives and roadmaps
• Create entity-relationship diagrams (ERDs), data flow diagrams, and other visualization tools to represent data flows
• Build and operationalize complex data solutions, correct problems, apply transformations, and recommend data cleansing/quality solutions
• Designs the structure and layout of data stores in the Reporting schema within VC Datamart, partnering with the VC systems team
• Continually optimizes data storage as well as supports data access controls and security measures
• Incorporate core data management competencies, including data governance, data security and data quality
• Designs and implements processes for the ETL process from various sources into the necessary data systems
• Develop and maintain data dictionaries, data flow diagrams, and other documentation related to data architecture and modeling
• Evaluate existing data models and identify areas for improvement or optimization
• Partner with A&I Manager to define and manage standards, guidelines, and processes to ensure data quality
• Work with IT teams, A&I analysts, and VC Systems to understand data consumers' needs and develop solutions
• Evaluate and recommend emerging technologies for data management, storage, and analytics
• Perform data and security audits to ensure processes allow for consistent and accurate reporting

Requirements

• Bachelor's Degree required, preferably in statistics, data science, mathematics, engineering, or computer science
• 3 years of experience in design and implementation of data architecture initiatives
• Strong proficiency in M, SQL, DAX, and Excel
• Experience with other programming languages preferred (Python, etc)
• Strong understanding of Data Warehousing, Data Quality, Data Analytics, and Data Visualization concepts/tools
• Ability to understand and articulate data needs while working with teams to create accurate and efficient data stores and calculations
• Ability to guide solution design and architecture, quickly master new and complex content to meet business needs
• Ability to work with large quantities of detailed data from multiple sources
• Strong initiative and willingness to take on projects proactively
• Ability to adapt to a constantly changing environment
• Interest in constant performance improvement and comfort with change
• Excellent organization, prioritization, and time management skills
• Experience with data integration, ETL processes, and data warehousing concepts
• Familiarity with data governance and data management principles

Nice to Have

• Experience with other programming languages such as Python
• Experience with BI tools such as Power BI, Power Platform, Tableau

Qualifications

• Bachelor's Degree in relevant field

Benefits & Perks

• World-class benefits and highly competitive compensation
• Disproportionate rewards for top performers
• Hybrid work environment with flexibility to work virtually or in-office
• Generous PTO
• 401k match up to $7,200 per year
• Opportunity to purchase company stock at a discount
• Market leading benefit programs