Senior Data Engineer
Backend Developer
Senior
Analytics
Big Data
Business Analytics
Business Intelligence
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Integration
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Design
Digital Marketing
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Microsoft
Microsoft Office
Power BI
Power Platform
Reporting and Analytics
SQL
Visual Design
Job Description
Hybrid Senior Data Engineer role near Portland, Oregon with a focus on dimensional modeling, governed analytics, and production-grade data pipelines.
Responsibilities
- Design and implement Kimball-style dimensional models and analytical datasets
- Develop ELT/ETL transformations with tests, documentation, and data contracts
- Build and maintain ELT/ETL workflows into data warehouses and lakes, including:
- Orchestration and monitoring
- Cost and performance tuning
- Create governed Power BI semantic models and supporting datasets for analytics
- Enable self-service access while enforcing data quality, lineage, and security policies
- Promote data and tooling adoption to increase organizational data access and support stakeholder ad hoc analysis and data-driven decisions
- Explore internal and external data sources and collaborate with BSAs and Data Engineering teams to ingest data into data lake/data bricks/Synapse for analysis and development
- Elicit and clarify business requirements
- Document specifications, KPIs, and acceptance tests
- Deliver demonstrations, office hours, and enablement
- Implement CI/CD using Git-based workflows, including unit/integration testing and data observability SLAs/SLOs
- Profile SQL and storage strategies, including caching and compute scaling
- Contribute to catalog/lineage, RBAC/ABAC, PII handling, and retention standards
Requirements
- Bachelor’s degree in Computer Science, Information Technology, Electrical Engineering, or related field (foreign equivalent accepted)
- 36 months of experience in the job offered or a related position
- SQL development experience, including complex queries, stored procedures, views, joins, and performance tuning in SQL Server environments
- ETL/ELT development using SSIS or equivalent tools, including data mapping, transformations, workflow scheduling, and job automation
- Power BI development: building semantic models, dashboards, and reports
- Experience creating DAX measures
- Experience with Power Query (M) transformations
- Experience publishing to Power BI Service
- Dimensional modeling using Kimball or equivalent methodologies, including star and snowflake schema design
- Data validation and profiling, including dataset optimization, incremental refresh, and cross-system data reconciliation
- Experience working with databases and cloud platforms such as Azure SQL or Snowflake
- Experience using JIRA for issue tracking and project management
Technologies
- SQL, SQL Server
- SSIS
- Power BI, DAX, Power Query (M), Power BI Service
- Kimball
- Azure SQL, Snowflake
- Git
- JIRA
Benefits
- 401k plan plus generous company match
- Medical, dental, vision, life Insurance, disability
- Flexible spending accounts and Health savings account
- EAP + free and confidential 24/7/365 counseling services
- Voluntary benefits: accident, critical illness, hospital indemnity, and legal services
- Extensive wellness benefits
- Employee discounts
- Generous time off program
Location: Portland, OR (hybrid; onsite four days per week)
Similar Jobs
