Dimensional & Joining Engineer Job at General Motors (Alvear)

Data Engineer

This role will focus on designing, developing, and supporting Databricks-based p...

Location

United States , Austin; Mountain View; Warren

Salary:

138700.00 - 206950.00 USD / Year

General Motors

Expiration Date

Until further notice

Requirements

Bachelor's degree in Computer Science, Information Systems, Data Engineering, Data Science, Engineering, or a related field
or equivalent experience
5+ years of experience as a data engineer, ETL developer, or integration engineer building production-grade data pipelines and data products
Hands-on experience with Databricks for data engineering and analytics enablement, including: Strong SQL skills in Databricks
Experience building and supporting ETL/ELT pipelines in Databricks
Experience developing pipelines using Python, notebooks, DataStage, and scalable data transformation patterns
Experience with workflow orchestration, dependency management, scheduling, monitoring, and operational support of production pipelines
Proven experience designing and implementing dimensional, layered, or medallion-style data models for analytics and operational use cases
Strong knowledge of data warehousing and ETL/ELT concepts, including how upstream design impacts downstream performance, usability, and trust in data products
Experience integrating data from enterprise applications, especially operational platforms such as ServiceNow

Job Responsibility

Design, build, and maintain scalable data pipelines in Databricks to ingest, transform, validate, and publish trusted data products for analytics, reporting, and AI use cases
Develop and support end-to-end ETL/ELT workflows using Databricks notebooks, Python, Spark, and SQL, including orchestration, parameterization, error handling, restartability, and performance optimization
Build and maintain Bronze, Silver, and Gold data products that are reusable, governed, and aligned to business and downstream consumption needs
Build and support integrations both into Databricks and between enterprise applications, including legacy and modern integration patterns such as DataStage-based workflows
Implement pipeline logic for ingestion, standardization, cleansing, enrichment, joins, aggregations, and publishing of curated data assets for downstream use
Partner with product owners, architects, source-system teams, report and analytics teams, and data consumers to translate business needs into well-defined technical solutions and trusted data products
Define and implement data transformations, semantic structures, and curated data assets that improve usability, consistency, downstream performance, and trust in the data
Apply strong data quality, validation, reconciliation, and documentation practices to ensure data products are accurate, discoverable, reliable, and production-ready
Use GitHub-based development practices for version control, code review, collaboration, and promotion of pipeline changes across environments
Support secure and compliant data delivery by implementing access controls, permissions, and governance requirements in alignment with GM policies

What we offer

health and wellbeing benefit programs
medical
dental
vision
Health Savings Account
Flexible Spending Accounts
retirement savings plan
sickness and accident benefits
life insurance
paid vacation & holidays

Fulltime

Staff Software Engineer

Anima saves lives every day. Hey! Shun here, I’m the CEO and co-founder of Anima...

Location

United Kingdom , London

Salary:

Not provided

Helpcare AI

Expiration Date

Until further notice

Requirements

Expert competency in TS, plus being reasonably tech + language agnostic. Comfortable with key frameworks/libraries like Angular, Node and React. Able to work full stack in JS/TS. Values pragmatism and open discussion from first principles rather than dogma
Exceptional at 'breadth-first search' through Googling when tackling new challenges, and consistently mindful of local maxima
Intellectually curious with a growth mindset - able to tackle entirely novel challenges that lack prior precedent through applying strong CS fundamentals and first principles thinking, creatively using the right data structures & algorithms to solve problems 90/10
Familiarity with AWS (e.g. APIG, SQS, DynamoDB, Lambda, Cognito, Amplify, CloudFormation) and/or hungry to learn
Disciplined towards best practice version control, CI/CD and code extensibility. Values 'interface safety' through dimensionality reduction at interfaces
Seeks to maximize not only self productivity, but combined team productivity, communicating the right things at the right time through the right channels (verbal/Slack/Notion)
Obsessively concerned with UX, and optimises for this when building features rather than arbitrary technical goals
Hungry and wants their shot to change the world - a force of nature when empowered with the tools, resources and development to do it. Sees joining Anima as potentially their shot to do this, and takes duty to crew and mission extremely seriously
Bored and frustrated at big companies
feel held back by red tape, bureaucracy and poor decisions

Job Responsibility

Help add further key third party API integrations, including with legacy EMR systems and national APIs like e.g. the electronic prescribing service, allowing Anima to directly issue prescriptions
Iterate on a proprietary graph traversal algorithm to improve patient care and clinical value, and increasingly move away from explicit curation to implicit curation by NNs
Ship important features that will directly increase delta lives saved in your first 2 weeks
Join customer calls to develop a deep understanding of their fundamental motivations and needs/pain points
Help architect and deploy a scalable & cost effective ETL data pipeline with version control, outputting clean data ready for tokenisation
Help deploy our active deep learning training & validation architecture to prod, so that we can correctly eat up our '1.0' systems at the right time
Build cutting edge products like global context aware chat with semantic search, care orchestration and LLM-enabled cloud telephony e2e
Hire/scale the team, while implementing the right processes at the right times to maximise discounted team productivity and minimise discounted dev time cost for shipping
Potential to transition to a more managerial/executive role. Lead an autonomous lance of elite engineers to fix healthcare and save lives
Work with the ML/data team to creatively ideate and ship features to improve ETL pipeline throughput and quality through a data-driven approach powered by analytics

What we offer

Flexibility over work schedule and location
Get the whole team together at least twice a year for team retreats
Visa sponsorship

Fulltime

Application Developer

This Long-term Contract position will focus on building governed reporting solut...

Location

United States , Glendale

Salary:

Not provided

Robert Half

Expiration Date

Until further notice

Requirements

8+ years of experience delivering enterprise BI reporting, dashboard development, and semantic modeling solutions
Expert-level SQL skills with strong experience in complex queries, performance tuning, stored procedures, and data reconciliation
Hands-on background in data warehousing concepts such as star schemas, snowflake schemas, conformed dimensions, and slowly changing dimensions
Proven ability to translate business needs into scalable reporting solutions with governed metrics and clear documentation
Experience working with BI and analytics platforms such as Tableau and related dashboarding technologies
Familiarity with Python, automation practices, and modern development tools including GitHub-based workflows
Strong understanding of data security, quality assurance, testing, and troubleshooting within production reporting environments
Ability to work effectively with technical teams, business stakeholders, and executive audiences in Agile delivery settings

Job Responsibility

Develop and maintain enterprise reports, dashboards, and analytical products that support strategic and operational decision-making
Create and manage semantic models, including business metrics, hierarchies, prompts, and security rules, to ensure consistent reporting standards
Write and optimize advanced SQL for warehouse and lakehouse platforms, using joins, CTEs, stored procedures, and other complex query techniques
Partner with data engineering teams to design curated datasets, aggregation structures, and performance-focused data assets for reporting use cases
Investigate and resolve data quality issues by profiling source data, validating results, and reconciling discrepancies across reporting layers
Apply dimensional modeling and modern data warehousing principles to align reporting solutions with governed enterprise architecture
Lead the transformation of legacy BI outputs into modern web-based dashboards while preserving calculation accuracy, filtering logic, and drill functionality
Use approved AI-assisted development tools to accelerate report creation, documentation, validation, and dashboard modernization with strong human oversight
Support security validation, regression testing, and production readiness activities before releasing reporting solutions to end users

What we offer

medical
vision
dental
life and disability insurance
401(k) plan

Sr. Data Engineer

The Senior Data Engineer supports enterprise data unification and analytics init...

Location

United States , Deerfield

Salary:

Not provided

Tier4 Group

Expiration Date

Until further notice

Requirements

Experience designing, developing, and supporting data pipelines (ETL/ELT) that integrate data from multiple systems
Strong SQL skills, including writing and optimizing complex queries, joins, and stored procedures in Microsoft SQL Server or comparable relational databases
Hands-on experience with Azure Synapse Analytics, Azure Data Factory, or similar cloud-based data warehousing and integration platforms
Experience working with large datasets in cloud or hybrid data environments
Working knowledge of data modeling concepts, including fact and dimension tables and schema design for analytics and reporting
Experience supporting business intelligence tools, particularly Microsoft Power BI, including datasets and dataflows
Ability to use scripting or programming languages such as SQL, Python, or PySpark for data transformation and automation
Approximately 3–5 years of professional experience in data engineering, analytics engineering, or a related role
Approximately 1–3 years of experience in data modeling or database design for analytics use cases
Undergraduate degree or equivalent experience in Computer Science, Information Systems, or a related field

Job Responsibility

Design, build, and maintain automated ETL/ELT data pipelines that ingest and transform data from Microsoft Dynamics 365 and legacy systems into an Azure Synapse data lake and enterprise data warehouse
Monitor, optimize, and support data pipeline performance to ensure reliable, timely data refreshes and efficient resource utilization
Implement data quality checks, validation rules, and cleansing processes to ensure data accuracy, consistency, and readiness for enterprise-wide analysis
Support data unification efforts by integrating data from multiple business units and systems without altering source system integrity
Contribute to the design and evolution of enterprise data models, including dimensional and star schemas, to support standardized reporting and unified business definitions
Define and maintain master data structures and relationships that enable analysis across both ERP and non-ERP data sources
Prepare curated and optimized datasets for business intelligence and analytics use cases, including Power BI dashboards and self-service reporting
Write and optimize SQL queries and develop new pipeline components to support reporting, analytics, and ad hoc data needs
Collaborate with business analysts, business intelligence developers, ERP specialists, and other stakeholders to translate reporting and analytics requirements into technical solutions
Apply data engineering and analytics best practices, including version control, documentation, code review, and performance tuning

Fulltime

Business Intelligence Engineer

We are looking for a Business Intelligence (BI) Engineer to design, develop, and...

Location

Mexico , Guadalajara

Salary:

Not provided

NTT DATA

Expiration Date

Until further notice

Requirements

Strong SQL expertise (complex joins, window functions, query optimization)
Hands-on experience with ETL/ELT tools (Informatica, SSIS, AWS Glue, dbt, Airflow)
Solid understanding of data modeling: star schema, snowflake, and 3NF
Experience with dimensional modeling (Kimball methodology)
Experience building and managing data pipelines and orchestration workflows
Strong knowledge of data warehousing concepts and data quality practices
Relational databases: PostgreSQL, MySQL, SQL Server, Oracle
Cloud data platforms: Redshift, BigQuery, Snowflake, Azure Synapse
Strong experience with BI tools (Tableau preferred, Power BI)
Data analysis, profiling, and interpretation skills

Job Responsibility

Design and develop scalable BI solutions, including dashboards, reports, and data models
Build, maintain, and optimize ETL/ELT pipelines to support analytics and reporting needs
Write and optimize complex SQL queries for data extraction, transformation, and performance tuning
Develop data models (star schema, snowflake, 3NF) aligned with dimensional modeling best practices (Kimball methodology)
Partner with business stakeholders to gather requirements and translate them into data products and insights
Define and implement KPIs, metrics, and reporting frameworks
Perform data analysis, profiling, and validation to ensure data accuracy and consistency
Develop interactive dashboards using BI tools to support strategic and operational decisions
Ensure data quality, governance, and consistency across reporting layers
Support experimentation initiatives, including A/B testing and performance analysis

What we offer

Competitive salary and benefits
Flexible working environment (remote/hybrid)
Exposure to modern BI and data platforms
Opportunities for professional growth and certification

Fulltime

Data Analyst

Location

Salary:

79650.00 - 88500.00 CAD / Year

Tucows

Expiration Date

Until further notice

Requirements

Experience: 3+ years in a Data Analyst, Analytics Engineer, or BI Analyst role in a modern cloud data stack environment
SQL mastery: Advanced SQL including CTEs, window functions, joins, and performance-aware querying in Snowflake or a comparable cloud warehouse
Looker expertise: Hands-on experience with Looker: dashboard development, Explores, LookML, governed metrics, and enabling self-service analytics for business users
dbt proficiency: Ability to read, maintain, test, and document dbt models. Familiarity with sources, tests, macros, lineage, and dbt development workflows
Finance domain knowledge: Solid understanding of GL, journal entries, trial balance, financial statements, reconciliations, and period-close processes. SOX/ITAC experience is highly valued
Data modeling: Working knowledge of dimensional modeling — fact/dimension tables, star schemas, slowly changing dimensions
Statistical & predictive analysis: Applied experience with regression, classification, A/B testing, segmentation, and forecasting using SQL, Python, or similar tools
Communication: Ability to explain complex analysis clearly to both Finance leadership and technical peers. Strong written and verbal skills
Version control: Comfortable with Git/GitHub: branching, PRs, and collaborative development in a terminal environment
AI & LLM analytics: Experience with LLMs or AI-assisted analytics tools (Claude, Gemini, GPT, Looker Conversational Analytics). Exposure to Cortex Analyst, Cortex Search, or AISQL capabilities. Understanding of MCP integration patterns is a plus

Job Responsibility

SQL & Business Analysis: Translate ambiguous business questions into precise SQL queries against our Snowflake warehouse. Own and deliver recurring financial reporting, reconciliation, and operational analytics with an eye for improving efficiency over time
Diagnostic & Advanced Analytics: Go beyond dashboards to explain why metrics move. Conduct root cause analyses, build forecasting models, and support decision-making through churn analysis, customer segmentation, CLV, A/B testing, and similar techniques
Business Intelligence & Self-Service Analytics: Build, maintain, and optimize Looker dashboards, Explores, and LookML definitions that provide governed, reliable, self-service analytics. Govern the semantic layer — metrics, dimensions, and business logic — that powers trusted reporting and AI-enabled analytics. Train business users to leverage these tools confidently
Finance Partnership & Compliance: Serve as the primary analytical partner to the Finance team. Own financial reporting, reconciliation, and forecasting workflows. Support SOX audits and ITAC testing, ensuring financial data is accurate, auditable, and well-documented
Data Quality & Cross-Functional Collaboration: Monitor and improve data quality across analytical pipelines, especially for finance-critical datasets. Gather requirements from stakeholders, translate business needs into technical specs, and collaborate with Data and Analytics Engineers to resolve upstream issues

Fulltime

Senior Data Engineer

Are you passionate about shaping the future of AI and empowering millions of use...

Location

Canada , Vancouver

Salary:

114400.00 - 203900.00 CAD / Year

Microsoft Corporation

Expiration Date

Until further notice

Requirements

Bachelor's Degree in Computer Science or related technical field AND 4+ years technical engineering experience with coding in languages including, but not limited to, C, C++, C#, Java, JavaScript, or Python OR equivalent experience
Ability to meet Microsoft, customer and/or government security screening requirements are required for this role. These requirements include but are not limited to the following specialized security screenings: Microsoft Cloud Background Check: This position will be required to pass the Microsoft Cloud background check upon hire/transfer and every two years thereafter.

Job Responsibility

Compliance: Anticipates the need for data governance and designs data modeling and data handling procedures, with direct support and partnership with Corporate, External, and Legal Affairs (CELA), to ensure compliance with applicable laws and policies across all aspects of the development process
Tags data based on categorization (e.g., personally identifiable information [PII], pseudo-anonymized, financial)
Documents data type, build data dictionary, classifications, and lineage to ensure traceability
Governs accessibility of data within assigned data pipelines
Provides guidance on contributions to the data glossary to document the origin, usage, and format of data for each program
Independently implements data governance and privilege of least access practices leveraging security tools
Builds responsible AI-compliant data products and/or applications
Data Management and Transformation: Plans and creates efficient techniques and operations (e.g., inserting, aggregating, joining) to transform raw data into a form (e.g., dimensional data model) that is compatible with downstream data consumers, databases, and formats that support applications, analytics and reporting
Independently uses software, query languages, and computing tools (e.g., cloud-based) to transform raw data across end-to-end pipelines
Evaluates data to ensure data quality and completeness using queries, data wrangling, and statistical techniques

Fulltime

Senior Business Intelligence Developer

We are seeking an experienced Senior Business Intelligence Developer to design, ...

Location

United States , Torrance

Salary:

Not provided

Robert Half

Expiration Date

Until further notice

Requirements

Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or equivalent practical experience
7+ years of experience in Business Intelligence development and data analytics
Expert‑level experience with Power BI, including: Data modeling, DAX, Report and dashboard optimization
Strong hands‑on experience with SAP BusinessObjects
Advanced SQL development skills, including: Complex queries, Joins, Window functions, Data transformations
Proven experience writing stored procedures and performance‑optimized SQL code
Hands‑on experience working with: SQL Server, DB2, Amazon Redshift
Strong understanding of data warehousing concepts and dimensional data modeling
Experience troubleshooting slow‑running queries and optimizing BI/reporting performance
Strong analytical, problem‑solving, and communication skills

Job Responsibility

Design, develop, and maintain enterprise BI reports, dashboards, and analytical solutions
Build advanced dashboards and data models using Power BI, including DAX and performance optimization
Design and support enterprise reporting solutions using SAP BusinessObjects
Partner with business stakeholders to gather, analyze, and document reporting and analytics requirements
Develop complex SQL queries, stored procedures, and optimized data retrieval logic
Perform backend data analysis across SQL Server, DB2, and Amazon Redshift databases
Design optimized datasets and semantic layers to support BI and analytics tools
Troubleshoot data discrepancies, reporting inconsistencies, and performance issues
Implement data validation and reconciliation logic to ensure reporting accuracy
Optimize database queries and stored procedures for high‑performance analytics workloads

What we offer

medical
vision
dental
life and disability insurance
401(k) plan

Select Country

Dimensional & Joining Engineer

Job Description

Job Responsibility

Requirements

Nice to have

Looking for more opportunities?