D.A. Davidson Companies-posted 10 months ago
$85,000 - $115,000/Yr
Full-time • Mid Level
Denver, CO
Securities, Commodity Contracts, and Other Financial Investments and Related Activities

The Analytics Engineer is responsible for building, deploying and maintaining analytic solutions using best known technologies, methods and practices. The Analytics Engineer works with other software development teams, database architects, data analysts and end users to design and implement complex analytics initiatives that will be built into MS CRM Dynamics using Microsoft PowerBI (fabric). The Analytics Engineer solves emerging technical challenges so that others may leverage and build upon them. An Analytics Engineer contributes to the overall data architecture and technology roadmaps to support strategic data warehouse growth and technology utilization. This role champions the organization's data and analytic strategies by implementing modern engineering practices, and ensuring the delivery of scalable, reliable, and impactful analytics solutions. The role will be part of the Microsoft CRM Product team focused on delivering highly valuable data integrations that include production data, portfolio views, business process integrations using MS PowerBI and Low-Code, No Code PowerApp integrations. The position will understand the MS Ecosystem as it pertains to Fabric, CRM, and MS Office integrations.

  • Oversee the design, development, and maintenance of scalable and reliable data pipelines, ETL processes, and data models
  • Ensure data architecture aligns with organizational goals, supports analytics needs, and adheres to best practices
  • Leverage tools like Microsoft Fabric, Power BI, Databricks, or similar platforms to support analytics initiatives
  • Operationally support, monitor, and manage data integrations
  • Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to ensure the availability of actionable and accurate data
  • Translate business needs into technical requirements and scalable solutions
  • Ensure data consistency, reliability, and performance across the analytics stack
  • Build data reporting into MS CRM leveraging PowerBI integrations and dashboards for efficient publication and distribution of data
  • Implement robust data governance, ensuring compliance with organizational and regulatory requirements
  • Assist with the curation and Master Data Management frameworks for client data, production data, assets under administration
  • Define and enforce data quality standards and best practices
  • Stay updated on emerging trends and technologies in data engineering and analytics to propose innovative solutions
  • Bachelor's degree in Computer Science, Data Engineering, Analytics, or a related field
  • 2+ years of experience in data engineering, analytics, or a related field
  • Extensive domain-specific experience in the Financial Services industry
  • Experience performing operational and usage analysis on analytic products to identify opportunities for improvement and ensure adequate curation of the environments
  • Technical expertise in modern data platforms (Microsoft Fabric preferred)
  • Holistic awareness of processes supporting data preparation, metadata, dependencies, lineages, compliance, and workload management
  • Solid communication skills and business acumen, with the ability to bridge technical and non-technical audiences
  • Experience with Microsoft cloud-based technologies in a hybrid architecture
  • Understanding of data modeling concepts like: conceptual data modeling, logical data modeling, relational data modeling, dimensional and multi-dimensional data modeling
  • Understanding of data governance, security, regulatory compliance, meta-model and metadata management requirements
  • Experience with data visualization technologies such as: Tableau, PowerBI
  • Experience designing and implementing data structures and interfaces for applications and business processes
  • Experience working with relational database platforms: preferably MS SQLServer or cloud-based equivalents
  • Experience working with web services and API integrations
  • Knowledge of data pipeline tools such as: SSIS
  • Knowledge of orchestration tools such as: ActiveBatch
  • Knowledge of scripting languages such as: Python and Powershell
  • Knowledge of Agile, DevOps and DataOps methods and technologies including: Source Code Control, Versioning, Test Automation, Continuous Integration, Automated Deployment, Recoverability, Telemetry, etc.
  • Company 401(k) and ESOP contribution
  • Generous sick, vacation, and maternity/parental leave
  • Paid holidays
  • Professional Development Opportunities
  • Discounted personal insurance including home, auto and recreational vehicles
  • Charitable gift-matching program
  • Davidson Day of Giving - Our tradition of positively impacting communities in which we live and work
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service