FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
Senior Associate, Data Engineer
Northern Trust. Consult with Business Unit and IT management and staff throughout the project development cycle .
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in data engineering, ETL/ELT processes, and large data warehousing projects, with a strong focus on optimizing SQL and implementing data architectures. Capable of providing technical leadership and consulting while balancing operational execution with strategic direction.
Highest-signal resume keywords
Data EngineeringETL/ELT ProcessesRDBMS and SQL OptimizationCloud Computing PlatformsData Visualization Tools
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
Data WarehousingComplex SQLPythonData LakesData LakehousesStar and Snowflake SchemasSlowly Changing DimensionsAgile Development MethodologiesData VisualizationBatch Orchestration
Soft Skills
Technical LeadershipConsultingCross-Functional CollaborationOperational ExecutionStrategic Direction
Tools & Technologies
SnowflakeDatabricksControl-MPower BITableauAzureAWSGCP
Industry Keywords
Business Unit ConsultingBrokerage ApplicationPlatform TransformationReengineeringImprovement of Applications
Tech Stack
Tools & technologiesAWSAzureCloudETLGoogle Cloud PlatformPythonRDBMSSnowflakeSQLTableau
About the role
Key responsibilities & impact- Consult with Business Unit and IT management and staff throughout the project development cycle
- Help design major systems and subsystems using available technology, tools, and existing designs
- Design and develop high-performance programming language components for trading applications
- Provide technical expertise to support and enhance the core brokerage application
- Oper independently with in-depth knowledge of the business unit or function
- Provide comprehensive, in-depth consulting and technical leadership as a subject-area expert
- Carry out large-scale, cross-functional, technically difficult activities
- Balance operational execution and development with strategic direction for business-function activities
- Ensure code meets standards and is appropriately tested on the platform
- Participate in platform transformation, reengineering, and improvement of current applications
Requirements
What you’ll need- 5 years of experience working in large data warehousing projects, implementing data warehouses, data marts, ETL, BI solutions, etc.
- Understanding of star and snowflake schemas, facts, dimensions, and slowly changing dimensions (SCD)
- Familiarity with data architectures, data lakes, data lakehouses, and medallion architecture
- Strong experience in data engineering and ETL/ELT
- Strong experience with RDBMS, complex SQL, and SQL optimization
- Working experience in Snowflake or Databricks
- Working experience in Python
- Experience with scheduling and batch orchestration tools such as Control-M
- Exposure to data visualization tools such as Power BI or Tableau
- Experience with cloud computing platforms such as Azure, AWS, or GCP
- Familiarity with Agile development methodologies
- Exposure to generative and Agentic AI tools and solutions
Benefits
Comp & perks- Flexible and collaborative work culture
- Movement within the organization is encouraged
- Accessible senior leaders
- Inclusive workplace
- Opportunities to assist communities through philanthropy
- Reasonable accommodations during the employment process
- Office amenities including Arrival Hub - Jungle, GameZone, and Employee Experience Zone