Data Engineer

Ericsson is hiring a contract Snowflake Data Engineer in Boise, Idaho to support modern analytics solutions within its data platform. The role centers on the Analytics Development Lifecycle, with primary ELT development in dbt Cloud and transformation work in Snowflake.

What you will do

• 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 with version control using Git and established software development practices.
• Work across the Analytics Development Lifecycle, including design, development, testing, and deployment.
• Create and maintain documentation for functional requirements and technical specifications.
• Perform unit testing, conduct peer code reviews, and follow coding standards.
• Support code promotion and environment synchronization activities.
• Collaborate with stakeholders to incorporate 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 participation in sprint planning and reviews.

Key requirements

• Advanced SQL skills with hands-on experience in Snowflake.
• Strong experience with dbt Cloud/Core and 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 using 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 such as AWS or Azure.
• Strong communication and documentation skills, with the ability to work in a dynamic, team-oriented environment.

Technologies

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

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 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.

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.

Job Location: Boise, ID (onsite). Job Type: contract. Ericsson Enterprise Wireless Solutions Inc. does not sponsor U.S. work authorizations for this 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 Enterprise Wireless Solutions also does not hire F-1 employees working on CPT or EAD for this position.

To learn about the typical hiring process, review the information provided after you apply.

Disclaimer: The statements above describe the general nature and level of work for this position and are not an exhaustive list of responsibilities, duties, or skills. Additional job tasks may be assigned.