Data Analytics Engineer

D.A. Davidson Companies is an independent, employee-owned company with a rich history spanning more than 80 years. We are dedicated to conducting our business in accordance with the highest standards of integrity and ethics, and delivering outstanding service to our clients and each other. We support a friendly, open and supportive culture, and encourage candid communication and productive engagement that make our companies and each of us better. Just as we work to improve our clients’ financial well-being, we also work to strengthen local communities—and giving back is one of our core values. You can learn more about our company culture and impact in our latest annual report.

Summary/Function:

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.

Qualifications:

•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.

Duties:

•Data Infrastructure and Engineering

o Oversee the design, development, and maintenance of scalable and reliable data pipelines, ETL processes, and data models

o Ensure data architecture aligns with organizational goals, supports analytics needs, and adheres to best practices.

o Leverage tools like Microsoft Fabric, Power BI, Databricks, or similar platforms to support analytics initiatives.

o Operationally support, monitor, and manage data integrations 

•Analytics Enablement

o Collaborate with cross-functional teams, including data scientists, analysts, and business stakeholders, to ensure the availability of actionable and accurate data.

o Translate business needs into technical requirements and scalable solutions.

oEnsure data consistency, reliability, and performance across the analytics stack.

o Build data reporting into MS CRM leveraging PowerBI integrations and dashboards for efficient publication and distribution of data 

•Governance and Compliance

o Implement robust data governance, ensuring compliance with organizational and regulatory requirements.

o Assist with the curation and Master Data Management frameworks for client data, production data, assets under administration

o Define and enforce data quality standards and best practices.

•Strategic Planning

o This role is aligned with the CRM Product Team and will prioritize strategic roadmap initiatives 

o Stay updated on emerging trends and technologies in data engineering and analytics to propose innovative solutions.

What we offer:

Competitive salary plus excellent benefits and perks including, but not limited to:  

•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.  

The potential base pay hiring range for this role is $85,000 - $115,000. The compensation offered will be determined on a case-by-case basis considering a variety of factors including, but not limited to, the skills, relevant work experience, and geographic location of each specific candidate. This role is eligible to participate in applicable D.A. Davidson variable compensation programs.

At D.A. Davidson, we are committed to fostering a diverse environment that supports the development and inclusivity of all employees.

We are an equal opportunity employer and value diversity at our company. We do not discriminate on the basis of race, religion, color, national origin, sex, gender, gender expression, sexual orientation, age, marital status, veteran status, or disability status. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodation.

Please answer all questions carefully: incomplete or inaccurate answers may impact your potential employment. By clicking Submit Application, you declare that all statements in this application are truthful to the best of your knowledge. California applicants please see D.A. Davidson's California Resident Privacy Policy.