Choreo

We Help Businesses Choreograph Change.

Associate Director, Data Engineering, Development

Full TimeRemoteTeam 1-10H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

83 days ago

Salary

$120K - $135K / year

Bachelor Degree3 yrs expEnglishAWSAzureCloudETLGoogle Cloud PlatformMS SQL ServerMy SQLOraclePostgresPythonScalaSQL

Job Description

• Provide leadership of the Performance Team, ensuring effective use of Black Diamond for data aggregation, performance reporting, and regulatory reporting. • Design, build, and maintain ETL processes and SQL pipelines that power enterprise reporting and analytics. • Develop, optimize, and document SQL Server stored procedures, views, and data transformations. • Ensure high-quality, well-structured, and auditable data across Choreo’s production systems. • Support data conversions and integration efforts during M&A onboarding projects. • Enhance existing Power BI datasets, reports, and dashboards based on advisor and leadership feedback. • Improve data models for scalability, performance, and ease of maintenance. • Partner with business teams to translate requirements into meaningful analytics solutions. • Build and maintain low-code automations and integrations using Power Automate and Power Apps. • Explore and experiment with emerging AI tools and capabilities (e.g., Copilot Studio, ChatGPT) to streamline processes. • Support internal innovation projects designed to streamline workflows and improve the client experience.

Job Requirements

  • Bachelor's degree required with a preference for computer science or a related focus.
  • 3 to 6 years of experience in SQL data engineering, ETL, or related analytics roles.
  • Strong proficiency in SQL and data modeling (views, stored procedures, query optimization, data modeling); experience with Microsoft SQL Server preferred. Equivalent experience with other relational databases (e.g., PostgreSQL, MySQL, Oracle) will be considered.
  • Experience with Azure Data Services (Azure SQL Database, Data Factory, Synapse) is preferred. Equivalent experience in other cloud platforms (e.g., GCP, AWS) will be considered.
  • Working knowledge of Power BI and the broader Power Platform required (Power Automate, Power Apps).
  • Familiarity with APIs, JSON, and data integration patterns, and working knowledge of Python or other scripting languages used in data engineering (e.g., R, Scala).
  • Experience with AI-driven automation tools (e.g., Copilot Studio, ChatGPT, Vertex AI) is a plus.
  • Comfort working with version control and documentation best practices.
  • A growth mindset—curious, collaborative, and eager to explore new technologies.

Benefits

  • Competitive salary and bonus plan
  • Competitive medical, dental, and vision plans
  • Basic life and disability coverage
  • 401(k) matching program
  • Financial support for approved designations and courses
  • Technical, leadership, sales training opportunities
  • Unlimited, discretionary time off
  • Paid parental leave

Related Categories

Related Job Pages