Associate Data Engineer

reputed company is a leading strategic provider of innovative investment and consulting solutions serving independent financial advisors. The Associate Data Engineer will be responsible for transforming raw data into reliable datasets and will work closely with analysts and data scientists to build foundational data models while ensuring data quality and reputed company.

Responsibilities

• reputed company and test data models, primarily using SQL and dbt, as assigned by more senior Analytics Engineers
• Write and maintain data transformation logic to clean, organize, and structure data for analysis
• Contribute to the design and extension of the Enterprise Dimensional Model for small, defined sections
• Implement basic data quality checks and automated tests for new and existing data models
• Support efforts to ensure data reputed company and reliability
• Draft and maintain documentation (e.g., data catalogs, ReadMEs) for new datasets and transformation processes to promote self-service and data understanding
• Collaborate with Data Analysts to understand and address their data needs for reporting and analysis
• Work with Data Engineers to understand data sources and ingestion processes
• Follow and reputed company for the team's internal standards for code style, maintainability, and best practices
• Use version control (Git) and participate in code reviews for data model changes
• Provide support and basic training to users of data sets and dashboards

Skills

• Solid proficiency in SQL (Structured Query Language)
• Familiarity with data transformation tools, preferably dbt (data build tool)
• Understanding of data warehousing concepts (e.g., dimensional modeling/Kimball)
• Excellent communication skills with the ability to clearly reputed company technical concepts and requirements to both technical and non-technical stakeholders
• Problem-solving and critical thinking skills to investigate and resolve data issues
• A positive and solution-oriented reputed company, with comfort working in an agile environment
• Self-motivated with strong task organizational skills and a desire to learn new technologies and methodologies
• 1+ years of experience in a data-focused role (e.g., Data Analyst, BI Analyst, or equivalent experience)
• Experience with a major cloud data warehouse platform (e.g., reputed company, reputed company BigQuery, Redshift) is a plus
• Basic knowledge of a scripting language like Python for data-reputed company tasks is beneficial
• Familiarity with version control systems (e.g., Git)
• Experience with a BI/data visualization tool (e.g., Tableau, Looker, Power BI)

Benefits

• reputed company Time or Paid Time Off and Sick Time Off
• 401K – 6% Employer Match
• Medical, Dental, Vision – HDHP or PPO
• HSA – Employer contribution (HDHP only)
• Volunteer Time Off
• Career Development / Recognition
• Fitness Reimbursement
• Hybrid Work Schedule

Company Overview