Senior Analytics Engineer [AQ-11066]

Aquent, a leading talent solutions company, is partnering with a prominent organization in the financial services sector. This client is dedicated to empowering individuals and institutions with innovative financial tools and insights, and they are at the forefront of leveraging data to drive strategic decisions and enhance customer experiences. As an Aquent talent, you will be instrumental in shaping their data landscape, directly contributing to initiatives that impact critical business operations and future growth.

We are seeking a highly skilled and motivated professional to join our client’s team, where you will embark on an exciting journey to transform raw internal data into trusted datasets, actionable insights, and executive-grade dashboards. This is an exceptional opportunity to take ownership of the end-to-end analytics stack, from data ingestion and modeling to pipeline engineering, semantic layer development, and dashboard delivery. You will play a pivotal role in modernizing their analytics environment, migrating from a legacy system to a cutting-edge cloud platform, and designing the next generation of data solutions. Your work will directly support operational and strategic decision-making, influencing audiences from frontline teams to senior leadership and board-level stakeholders. This role offers the chance to make a significant impact by delivering robust data products, fostering a data-driven culture, and driving measurable success across the organization.

What You Will Do

• Data Engineering & Platform Migration
• Design, build, and operate robust data pipelines across both the current legacy environment and the target modern cloud platform, ensuring seamless data flow and integrity.
• Implement rigorous data quality, lineage, freshness, reliability, and observability practices throughout the entire data lifecycle, especially during the transition.
• Conduct thorough assessments of existing legacy workflows and define optimal target-state architectures leveraging modern cloud services for data transformation, orchestration, and related cloud capabilities.
• Lead incremental migration efforts, establishing comprehensive validation processes to guarantee functional parity and data accuracy between legacy and modernized workflows.
• Data Modeling & Analytics Architecture
• Design sophisticated dimensional models, semantic layers, and reusable data marts within the modern cloud data warehouse to support scalable analytics and reporting.
• Implement industry-leading star-schema and medallion (Bronze/Silver/Gold) architectures, optimizing for performance and maintainability.
• Create high-quality, reusable data assets that significantly accelerate dashboard development and empower self-service analytics across the organization.
• Dashboard Development & Business Intelligence
• Design and deliver production-grade dashboards using leading visualization tools, providing clear and actionable insights.
• Develop complex data models, advanced calculation expressions, row-level security, intuitive drill-through experiences, and performance optimizations to ensure an exceptional user experience.
• Publish and govern reporting solutions that deliver executive-ready insights and critical operational visibility to various stakeholders.
• Analytics & Insight Generation
• Perform in-depth trend, cohort, time-series, and comparative analyses to uncover critical business insights and opportunities.
• Apply hypothesis testing, A/B test analysis, and lightweight predictive techniques to validate assumptions and inform strategy.
• Translate complex data findings into clear, compelling narratives, actionable recommendations, and measurable business outcomes.
• Proactively identify opportunities to unlock additional value from the organization's vast data assets, driving innovation and efficiency.
• Stakeholder Partnership
• Serve as a trusted subject matter expert for departmental data and analytics, providing guidance and expertise.
• Collaborate closely with business and technical teams to meticulously define requirements, metrics, and reporting needs, ensuring alignment with strategic goals.
• Efficiently resolve data inquiries and provide accurate, timely analysis to support critical business decisions.
• Build durable partnerships across various functions, establishing yourself as a trusted advisor who can bridge the gap between data and business strategy.
• Documentation & Leadership Communication
• Thoroughly document requirements, data contracts, metric definitions, technical designs, and migration runbooks to ensure clarity and maintainability.
• Create impactful executive presentations and supporting materials for leadership and board-level discussions, translating complex data into strategic insights.
• Actively promote reporting standards, advocate for reusable assets, and champion analytics best practices across the entire organization, fostering a data-driven culture.
• Required Qualifications

• Education
• Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, Statistics, Mathematics, Economics, or a related quantitative field.
• Experience
• 7+ years of experience in Analytics Engineering, Data Engineering, Business Intelligence, or a comparable role with demonstrated leadership responsibilities.
• Hands-on experience developing, maintaining, optimizing, and modernizing legacy data processing workflows.
• Proven experience translating complex business problems into scalable analytics solutions and actionable insights.
• Cloud Data Ecosystem Expertise
• Strong experience with a leading cloud data warehouse and its associated cloud data ecosystem, including several of the following:
• Cloud data warehousing (partitioning, clustering, materialized views, authorized views, performance optimization, in-warehouse machine learning capabilities)
• Cloud Storage
• Data transformation tools (e.g., Dataform and/or dbt)
• Workflow orchestration (e.g., Cloud Composer/Airflow)
• Scheduling services (e.g., Cloud Workflows or Cloud Scheduler)
• Data processing services (e.g., Dataflow, Dataproc, or Pub/Sub)
• Identity and Access Management, network security controls, and analytics security controls
• Business Intelligence & Visualization
• Extensive experience developing reporting solutions in leading visualization platforms, including:
• Enterprise semantic models and analytics layers
• Advanced calculation expressions in visualization tools
• Interactive dashboards and executive reporting
• Performance optimization strategies
• Governance and deployment through enterprise visualization services
• Analytics Engineering
• Strong knowledge of dimensional modeling, star-schema architecture, medallion architecture, data quality frameworks, data lineage, Git-based source control, and CI/CD for analytics and data engineering assets.
• Technical Skills
• Advanced SQL, including complex joins, window functions, CTEs, and cloud data warehouse optimization techniques.
• Proficiency in Python for analytics, automation, and data transformation.
• Communication
• Strong written and verbal communication skills.
• Experience developing executive-level narratives and presentations.
• Ability to communicate effectively with both technical and non-technical audiences.
• Preferred Qualifications

• Experience migrating from legacy ETL platforms to cloud-native architectures.
• Relevant professional cloud data engineering or associate cloud engineer certification.
• Experience with other leading data visualization or business intelligence tools.
• Familiarity with streaming and near-real-time data architectures using messaging and stream processing services.
• Experience with data governance and catalog platforms.
• Knowledge of applied predictive analytics, forecasting, anomaly detection, and segmentation techniques.
• Experience within financial services, wealth management, or other regulated industries.
• Relevant professional data analyst certification.
• Working knowledge of R.

About Aquent Talent

Aquent Talent connects the best talent in marketing, creative, and design with the world's biggest brands.

Our eligible talent get access to amazing benefits like subsidized health, vision, and dental plans, paid sick leave, and retirement plans with a match. We also offer free online training through Aquent Gymnasium. More information on our awesome benefits!

Aquent is an equal-opportunity employer. We evaluate qualified applicants without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, and other legally protected characteristics. We’re about creating an inclusive environment-one where different backgrounds, experiences, and perspectives are valued, and everyone can contribute, grow their careers, and thrive.