CrawlJobs Logo

Data Consultant (End-to-End ETL & Visualization)

apexsystems.com Logo

Apex Systems

Location Icon

Location:
Canada , Toronto

Category Icon

Job Type Icon

Contract Type:
Not provided

Salary Icon

Salary:

40.00 - 45.00 USD / Hour

Job Description:

We are seeking a versatile Data Consultant to bridge the gap between complex data engineering and executive decision-making. In this role, you will be responsible for the full data lifecycle—from designing robust ETL pipelines in Databricks to crafting compelling, high-impact stories through Power BI. The ideal candidate doesn't just 'move data'; they understand the business context and can translate technical architecture into actionable insights for senior leadership.

Job Responsibility:

  • End-to-End ETL Orchestration: Design, build, and maintain scalable data pipelines. You will take ownership of the 'Data Ingestion' process, moving data from legacy warehouses and external sources into unified environments
  • Databricks Development: Leverage Databricks to transform raw, unstructured data into clean, analysis-ready datasets. You will be responsible for optimizing performance and ensuring data integrity across the pipeline
  • Data Storytelling: Go beyond basic reporting. You will use Power BI to create intuitive dashboards that highlight trends, risks, and opportunities, helping stakeholders 'see' the story behind the numbers
  • Business Alignment: Work closely with Product Owners and Analytics teams to understand campaign requirements and ensure that technical outputs align with the 2030 strategic vision
  • Process In-Housing: Contribute to the strategic initiative of moving external analytics processes in-house to reduce time-to-market and improve data agility

Requirements:

  • ETL Expertise: Deep professional experience with ETL/ELT frameworks and data warehousing principles
  • Databricks Mastery: Proven ability to develop and optimize notebooks and workflows within the Databricks environment
  • Advanced Power BI: Expert-level skills in Power BI, including DAX, data modeling, and advanced visualization techniques
  • SQL Proficiency: Strong SQL skills for data querying, manipulation, and validation
  • Analytical Mindset: The ability to look at a data set and identify the 'Relevance' (the why behind the numbers) for a business audience
  • Communication: Exceptional soft skills with the ability to 'translate' technical findings for non-technical stakeholders

Nice to have:

  • Experience within the Banking or Financial Services sector (specifically Business Banking or Marketing Analytics)
  • Familiarity with Agile/Scrum methodologies
  • Experience with 'In-housing' projects or migrating legacy data processes to modern cloud stacks
What we offer:

Apex hosts an on-demand training program, provides access to certification prep and a library of technical and leadership courses/books/seminars once you have 6+ months of tenure, and certification discounts and other perks to associations that include CompTIA and IIBA

Additional Information:

Job Posted:
April 23, 2026

Employment Type:
Fulltime
Work Type:
Hybrid work
Job Link Share:

Looking for more opportunities? Search for other job offers that match your skills and interests.

Briefcase Icon

Similar Jobs for Data Consultant (End-to-End ETL & Visualization)

Senior/Staff Platform Consultant - Data and BI Specialist

10Pearls is seeking a highly skilled Data & BI Specialist to support data-driven...
Location
Location
Pakistan , Karachi; Lahore; Islamabad
Salary
Salary:
Not provided
10pearls.com Logo
10Pearls
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in IT or related discipline. (Software Engineering preferred)
  • 3+ years of hands-on experience in data analysis, BI development, or data engineering roles
  • Strong experience working with ETL pipelines, data transformations, and data modeling concepts
  • Proficiency in at least one BI / data visualization tool such as Qlik Sense, Power BI, Tableau, or similar
  • Solid command of SQL and experience working with relational databases (e.g., PostgreSQL, MySQL, SQL Server)
  • Experience integrating and consuming data from APIs and external data sources
  • Strong analytical and problem-solving skills with attention to detail
  • Ability to manage multiple priorities and work effectively under time constraints
  • Self-driven learner with a passion for data, analytics, and continuous improvement
  • Excellent written and verbal communication skills, with the ability to explain data insights to non-technical audiences
Job Responsibility
Job Responsibility
  • Lead the design, development, and maintenance of Business Intelligence solutions, ensuring scalability, reliability, and performance
  • Own and manage end-to-end BI workflows, including data ingestion, transformation (ETL), data modeling, and reporting layers
  • Ensure high standards of data quality, accuracy, and governance across all BI assets and reports
  • Collaborate closely with stakeholders, product teams, and leadership to translate business requirements into actionable insights and analytical solutions
  • Proactively identify data gaps, reporting inefficiencies, and technical risks, and propose scalable improvements
  • Apply best practices in BI development, including performance tuning, documentation, and version control
  • Support business decision-making by delivering meaningful dashboards, reports, and ad-hoc analysis with clear insights
  • Diagnose and resolve data and reporting issues in production environments
  • Embrace a consulting mindset by recommending data-driven approaches that align technical solutions with business objectives
  • Mentor junior team members by sharing BI best practices, analytical techniques, and tooling knowledge
Read More
Arrow Right

Senior/Staff Platform Consultant - Data and BI Specialist - Afternoon Shift

10Pearls is seeking a highly skilled Data & BI Specialist to support data-driven...
Location
Location
Pakistan , Karachi, Lahore, Islamabad
Salary
Salary:
Not provided
10pearls.com Logo
10Pearls
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree in IT or related discipline (Software Engineering preferred)
  • 3+ years of hands-on experience in data analysis, BI development, or data engineering roles
  • Strong experience working with ETL pipelines, data transformations, and data modeling concepts
  • Proficiency in at least one BI / data visualization tool such as Qlik Sense, Power BI, Tableau, or similar
  • Solid command of SQL and experience working with relational databases (e.g., PostgreSQL, MySQL, SQL Server)
  • Experience integrating and consuming data from APIs and external data sources
  • Strong analytical and problem-solving skills with attention to detail
  • Ability to manage multiple priorities and work effectively under time constraints
  • Self-driven learner with a passion for data, analytics, and continuous improvement
  • Excellent written and verbal communication skills, with the ability to explain data insights to non-technical audiences
Job Responsibility
Job Responsibility
  • Lead the design, development, and maintenance of Business Intelligence solutions, ensuring scalability, reliability, and performance
  • Own and manage end-to-end BI workflows, including data ingestion, transformation (ETL), data modeling, and reporting layers
  • Ensure high standards of data quality, accuracy, and governance across all BI assets and reports
  • Collaborate closely with stakeholders, product teams, and leadership to translate business requirements into actionable insights and analytical solutions
  • Proactively identify data gaps, reporting inefficiencies, and technical risks, and propose scalable improvements
  • Apply best practices in BI development, including performance tuning, documentation, and version control
  • Support business decision-making by delivering meaningful dashboards, reports, and ad-hoc analysis with clear insights
  • Diagnose and resolve data and reporting issues in production environments
  • Embrace a consulting mindset by recommending data-driven approaches that align technical solutions with business objectives
  • Mentor junior team members by sharing BI best practices, analytical techniques, and tooling knowledge
Read More
Arrow Right

Analytics Product Manager

Responsible for expanding and optimizing overall Digital Technology data product...
Location
Location
India , Bangalore
Salary
Salary:
Not provided
gevernova.com Logo
GE Vernova
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s Degree in business, computer science or in “STEM” Majors (Science, Technology, Engineering and Math)
  • Minimum of 3 years of experience working with Data Management, Business Intelligence, or Data Analytics
  • A minimum of 6 years of technical experience along with established leadership credentials across disciplines and functions within a product
  • Working knowledge of mathematics, statistics, text mining, and modeling skills
  • Willingness to learn and develop critical data science skills (e.g. statistical analyses, advanced data visualization, data mining, and data cleansing/transformation)
  • Working knowledge of Big Data programming environments and Competency in major analytics software packages and programming environments (e.g. Databricks
  • Python, R, Java etc. in big data paradigms)
  • Hands on experience working with database technologies, including Oracle, SAP, SQL / NoSQL platforms, visualization applications such as Spotfire or Tableau
  • Familiarity with writing SQL queries and working with databases
  • Exposure to unstructured datasets and ability to handle XML, JSON file formats
Job Responsibility
Job Responsibility
  • Be responsible for coordinating multiple interdependent projects forming a program in support of the Digital Technology and Data & Analytics function
  • Work on large-size project or a program comprising of multiple projects impacting a single or multiple domains and be able to coordinate across different analytics product managers to identify direct and derived outcomes
  • Work with business functions to gather requirements to document functional specifications and process flows, drive design and development strategy and funding requirements
  • Handle multiple projects across partner and business process leaders and provide clear visibility on program plan, progress and execution
  • Consult analytics leader on analytics “best practices” process implementation and drive end-to-end process implementation or improvements initiatives
  • Promote user adoption by facilitating user acceptance testing and training, data literacy and change management
  • Identify opportunities for improvements and enhancements to maximize the use of data lake analytics solutions throughout the organization
  • Partner with the data security and audit teams to ensure compliance and hygiene from GITC, SOx, and controls
  • Works on AI adoption leveraging Databricks services to enable self-service and LLM services through data catalog and AI space metadata enrichment
  • Develop and maintain an integrated data architecture spanning the relational and nonrelational data landscape
What we offer
What we offer
  • Relocation Assistance Provided: No
  • Fulltime
Read More
Arrow Right

Systems Architect

This is a 30 month opportunity on the Hourly-Based IT Services (HBITS) Contract ...
Location
Location
United States , Albany
Salary
Salary:
Not provided
genesysonline.com Logo
GENESYS Consulting Services
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 72- months experience developing systems in workers' compensation, insurance for WC, DBL, PFL, PBM accounting and financial reporting using westren and eastren method
  • 72-months experience in developing, documenting, maintaining end-to-end ETL data pipeline (Information Builder International “IBI” Data Migrator aka TIBCO Data Migrator)
  • 72- months Data Modeling experience in designing underwriting, claims DataMarts, Data warehouse in Insurance industry (Workers’ Compensation and disability)
  • 72-months experience with developing maintaining predictive systems written R or Python using TIBCO Spotfire/TERR
  • 72-months experience with TIBCO Spotfire Analyst, Web Player and Business Authors, using Iron Python, R, and Java Scripts
  • 72-months experience in Oracle PL/SQL development, including triggers, stored procedures, packages, and advanced query optimization, database design and implementation
  • 72-months experience in Agile/scrum project management methodology
  • 72-months experience in automated testing, build and deployment tools (TFS, PowerShell and Visual Build Pro)
  • 72-months experience in development tools, such as: VS Code, Visual Studio Code, Visual Studio, Git, Azure, and TFS
  • Bachelor’s Degree
Read More
Arrow Right
New

Data Analytics Lead Analyst

Location
Location
United States , Irving
Salary
Salary:
166000.00 - 173000.00 USD / Year
https://www.citi.com/ Logo
Citi
Expiration Date
June 16, 2026
Flip Icon
Requirements
Requirements
  • Requires a Master’s degree, or foreign equivalent, in Applied Computer Science, Computer Applications or related field and 4 years of experience as a Senior Data Analyst, Associate Consultant, Consultant, Software Engineer or related position performing data modelling, data governance, and maintaining data quality within the financial services domain. Alternatively, employer will accept a Bachelor’s degree in the listed fields and 6 years of progressively responsible, post-baccalaureate experience in the listed positions. Full span of experience must include: Maintaining data warehouses, ETL processes, and schema designs
  • SQL, PL/SQL Development
  • Database Performance Optimization
  • Ab Initio, EME, and Autosys
  • Software development methodologies (waterfall, agile, scrum)
  • Git, Collibra, Data Catalog
  • System integration and UAT
  • AWS S3 stage and snowpipe
  • Shell Scripting development. Additionally, 2 years of experience must include: SAP BO (BI) report Development.
Job Responsibility
Job Responsibility
  • Perform data modeling, integrating data from diverse sources while upholding data governance principles
  • Contribute significantly to the design, development, and maintenance of data warehouses, complex ETL processes, and robust schema designs, working collaboratively with data governance teams on standards and policies
  • Actively define Critical Data Elements (CDEs) and Data Quality Processes (DQP) for multiple data sources during ingestion
  • Maintain strict data model versioning and metadata management in repositories including Git and Collibra
  • Ensure all designs aligned with business requirements and data governance policies through close collaboration with senior architects and project managers, confirming adherence to established data modeling best practices
  • Develop and maintain complex PL/SQL applications for critical banking systems, encapsulating intricate transactions and ensuring data consistency, while also optimizing database performance through indexing, partitioning, and diligent query tuning
  • Work on Tableau reporting to prepare data sets for visualization
  • Assist with building a centralized robust and scalable software system in support of the development of ICRM Applications
  • Prepare design documents, design patterns, component design specifications, and technical specifications to define the software system architecture, application programs, modules, interfaces, and data flows for ICRM and other ICRM related initiatives
  • Apply best practices to ensure high data quality and reduced redundancies
What we offer
What we offer
  • medical, dental & vision coverage
  • 401(k)
  • life, accident, and disability insurance
  • wellness programs
  • paid time off packages, including planned time off (vacation), unplanned time off (sick leave), and paid holidays
  • Fulltime
Read More
Arrow Right

Business Intelligence Specialist

The Work Dynamics Data & Insights team is looking to recruit a Business Intellig...
Location
Location
India , Bengaluru
Salary
Salary:
Not provided
jll.com Logo
JLL
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s degree, Master’s degree or equivalent experience in BI, computer science, econometrics, operations research or statistics preferred, or equivalent working experience
  • A minimum of 6 years of work experience as a business intelligence, business, or data analyst is required
  • Fluent English
  • Ability to engage with colleagues across the Business Intelligence Team
  • Exceptional communicator
  • Experienced in working within a complex corporate environment
  • Inspire trust, adapt, and learn
  • Ability to drive focus and excitement within teams
  • Ambitious and driven to win
  • Consistently exceeds performance targets and takes quick, corrective action when required
Job Responsibility
Job Responsibility
  • Lead the technical development of complex Business Intelligence initiatives, ensuring constant communication and partnership with the Head of Business Intelligence
  • Liaise with key stakeholders, including directly with JLL and Work Dynamics client senior management, to translate complex requirements into practical business solutions
  • Lead and work as part of sprint development teams to develop sustainable solutions
  • Ensuring iterative design processes are followed, providing regular feedback and engagement to the business
  • Identify new analytics technology and techniques, building proof of concepts demonstrating the potential use case and return on investment for the business
  • Be an active member of the internal and external Work Dynamics Business Intelligence communities to identify and implement industry best practices on the business’s analytics
  • Facilitate the continuous growth in skills and knowledge of the other analysts within the business
  • Actively participating in feedback to analysts on the development of new initiatives
  • Be continuously looking 12-18 months in the future, actively participating in defining the Business Intelligence strategy and identifying growth opportunities in revenue, compliance and productivity
  • Develop innovative analytical solutions that support the business's efforts to increase productivity, reduce risk, lift customer satisfaction, and drive revenue
  • Fulltime
Read More
Arrow Right

Data & Analytics Manager in Supply Chain

As a Manager at NTT DATA Supply Chain Consulting, you will lead strategic supply...
Location
Location
India , Bengaluru
Salary
Salary:
Not provided
nttdata.com Logo
NTT DATA
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • Bachelor’s or Master’s degree in Industrial Engineering, Operations Research, Supply Chain Management, Logistics, or related field
  • 5–7 years of experience in supply chain consulting, with a focus on network design, inventory optimization, and digital twin modeling
  • Proven experience managing client-facing projects and leading cross-functional teams
  • Proficiency in analytical tools: Excel, SQL, Tableau, Power BI, Python, Alteryx, KNIME
  • Experience with supply chain modeling platforms such as Optilogic, LLamasoft, ToolsGroup, River Logic, or similar
  • Strong communication, presentation, and stakeholder management skills
  • Ability to work across geographies and cultures
Job Responsibility
Job Responsibility
  • Lead end-to-end supply chain design and optimization projects, ensuring timely and high-quality delivery
  • Define project scope, objectives, and deliverables in collaboration with clients and internal stakeholders
  • Manage project plans, resources, risks, and budgets across multiple geographies
  • Serve as the primary point of contact for client leadership, building trusted relationships
  • Facilitate workshops, present findings, and guide clients through solution adoption
  • Translate complex analytical insights into actionable business recommendations
  • Oversee data ETL, model development, scenario analysis, and visualization efforts
  • Guide consultants in using tools like Tableau, Power BI, KNIME, SQL, Alteryx, and supply chain modeling platforms (e.g., Optilogic, LLamasoft)
  • Ensure analytical rigor and quality across all deliverables
  • Mentor and coach junior consultants and analysts, fostering skill development and career growth
Read More
Arrow Right

Product Manager, Automation

We are seeking a visionary Product Manager to lead Benchling's automation and da...
Location
Location
United States , San Francisco
Salary
Salary:
182000.00 - 247000.00 USD / Year
benchling.com Logo
Benchling
Expiration Date
Until further notice
Flip Icon
Requirements
Requirements
  • 5+ years of product management or relevant automation industry experience, preferably in B2B SaaS, with a focus on workflow automation and data orchestration platforms
  • Strong technical background, including deep understanding of APIs, data pipelines, ETL workflows, and software engineering principles
  • Experience building low-code/no-code platforms or workflow automation tools, with the ability to balance simplicity for non-technical users with extensibility for technical users
  • Demonstrated ability to lead complex, platform-level products that serve multiple customer personas (e.g. scientists, automation engineers, IT administrators)
  • Proven track record of developing and launching successful products, from ideation through implementation
  • Excellent technical communication skills, with the ability to collaborate effectively with engineers, architects, and other technical stakeholders
  • Comfort with ambiguity and strategic thinking, with the ability to balance long-term platform vision with near-term customer needs
  • Excellent communication and collaboration skills, with the ability to work effectively across different teams and stakeholders
  • Experience with Agile/Scrum methodologies, with the ability to adapt quickly in a fast-paced, evolving environment
Job Responsibility
Job Responsibility
  • Define and drive the product vision and strategy for Benchling's automation and data orchestration platform, including Pipelines (backend platform) and Automation Designer (customer UX) capabilities
  • Enable automation that orchestrates end-to-end scientific workflows—from instrument and automated workcell data capture through analysis, Benchling actions, and cross-system integrations
  • Work closely with engineering teams to prioritize, develop, and launch product features that align with the company's goals and user needs
  • Collaborate with UX/UI designers to ensure the Automation Designer provides a flexible, intuitive interface that enables customers to create complex, multi-step data automation workflows through a visual, low-code/no-code environment
  • Foster a culture of innovation, encouraging team creativity and problem-solving to address the complex needs of our users
  • Conduct thorough market research and user feedback sessions to understand the needs and challenges faced by end users, translating these insights into product features
  • Define KPIs and success metrics for automation adoption, workflow reliability, and the product's impact on enhancing scientific research and decision-making processes
  • Collaborate cross-functionally with Platform, Infrastructure, and Application teams to ensure automation capabilities are scalable, reliable, performant, and seamlessly integrated into the broader Benchling platform, delivering unified customer experiences that support enterprise workloads and complex requirements
  • Drive the strategic evolution toward agentic AI and DBTL (design-build-test-learn) workflows while partnering closely with AI & Analytics teams to embed intelligent automation, experiment optimization, and lab-in-the-loop learning into scientific workflow orchestration
  • Partner with customer-facing teams (Sales Consulting, Professional Services, Customer Success) to identify high-value automation use cases, build reference implementations, and drive adoption
What we offer
What we offer
  • Competitive total rewards package
  • Broad range of medical, dental, and vision plans for employees and their dependents
  • Fertility healthcare and family-forming benefits
  • Four months of fully paid parental leave
  • 401(k) + Employer Match
  • Commuter benefits for in-office employees and a generous home office set up stipend for remote employees
  • Mental health benefits, including therapy and coaching, for employees and their dependents
  • Monthly Wellness stipend
  • Learning and development stipend
  • Generous and flexible vacation
  • Fulltime
Read More
Arrow Right