Data Engineer

Ericsson is seeking a Snowflake Data Engineer contractor to support modern analytics solutions in a data platform, with an emphasis on dbt Cloud for ELT workflows.

• Location: Boise, ID (onsite)
• Employment type: Contract
• Primary focus: Analytics Development Lifecycle using dbt Cloud in a modern data stack

Responsibilities

• Translate business requirements into technical specifications for analytics solutions
• Design, build, and maintain data models, transformations, and pipelines using dbt Cloud and Snowflake
• Develop and optimize SQL queries for performance and scalability
• Implement ELT workflows using version control with Git and established software development practices
• Participate across the Analytics Development Lifecycle: design, development, testing, and deployment
• Create and maintain documentation for functional requirements and technical specifications
• Perform unit testing, conduct peer code reviews, and maintain adherence to coding standards
• Support code promotion and environment synchronization activities
• Collaborate with stakeholders to integrate business logic into data models and reporting solutions
• Develop custom Python scripts for data extraction and transformation from APIs, SFTP, and semi-structured sources
• Apply advanced knowledge of data warehousing concepts, including Star Schema, Facts & Dimensions, and OLAP design
• Ensure alignment with Agile methodologies, including sprint planning and reviews

Requirements

• Advanced SQL with hands-on Snowflake experience
• Strong experience with dbt Cloud and dbt Core, including modular data modeling
• Proficiency in Python for data manipulation and integration tasks
• Familiarity with APIs, SFTP, and semi-structured formats such as JSON and XML
• Experience with Git-based source control and collaborative development workflows
• Solid understanding of data warehousing principles including slowly changing dimensions and bridge tables
• Exposure to cloud environments: AWS or Azure
• Strong communication and documentation skills; ability to operate in a dynamic, team-oriented environment

Technologies

• Snowflake
• dbt Cloud
• dbt Core
• SQL
• Python
• Git
• AWS
• Azure
• JSON
• XML

Nice to Have

• Experience with BI tools and visualization concepts
• Familiarity with SaaS-based data platforms
• Knowledge of Pandas or similar Python libraries for data wrangling

Benefits

• Subsidized, nationwide PPO medical benefit options, including a low-deductible Point of Service plan and a qualifying HDHP, with a generous company-provided HSA contribution
• For California employees: subsidized HMO option through Kaiser
• Subsidized dental and vision coverage
• 401(k) plan with a 4% company match and immediate vesting
• Company-paid employee basic life and AD&D insurance
• Company-paid disability benefits
• Minimum of 15 days of accrued vacation; up to 3 personal days per year; 11 annual holidays; 8 hours of volunteer time; and 80 hours of sick time annually
• Up to 16 weeks of paid maternity leave and 6 weeks of parental or adoption leave at 100% of pay
• Comprehensive Employee Assistance Program
• Mobile therapy
• Volunteer paid time off

• Job location: Boise, ID
• Work authorization disclaimer: Ericsson Enterprise Wireless Solutions Inc. does not sponsor U.S. work authorizations for this job position, including U.S. immigration filings for initial and/or change of employer paperwork for H-1, H-1B1, E-3, O-1, and TN. Ericsson also does not hire F-1’s working on CPT or EAD for this position.
• Hiring process: Click Here to find all you need to know about what the typical hiring process looks like.
• Disclaimer: The statements are intended to describe the general nature and level of work. They are not exhaustive, and additional tasks may be assigned.

• Primary country and city: United States (US) || Boise (ID)
• Job details: IT Data Engineer