Data Integration Engineer (Based in Boise, Idaho, In-Person)

About the position

Boise Cascade has an exciting opening for a Data Integration Engineer. We are one of the largest manufacturers of plywood and engineered wood products in North America and are the only wholesale stocking distributor for building products that can service the entire United States. We offer a wide range of entry-level careers for new workers and advanced career opportunities for seasoned professionals. Our broad national footprint provides opportunities in many career fields including sales, technical design/drafting, engineering, maintenance, I/T, administrative, production, warehousing, and distribution and CDL truck driving. We welcome diverse backgrounds, views, and skills as we believe it results in stronger teams, inspired solutions, and greater agility as an organization.

Responsibilities

• Measure, manage, and troubleshoot the selection, deployment, and maintenance of any data integration tools, i.e. cloud or on-premise
• Develop the semantic layer, metadata, PowerBI reports, and report definitions
• Administration of database servers including but not limited to scale, performance, implementation and troubleshooting
• Administration of PowerBI workspaces, lifecycle and embedded services
• Demonstrate strong commitment to safety, quality, environmental awareness, and continuous process improvement
• Perform other duties and responsibilities as assigned
• Execute, monitor, and QA ETL and DevOps work items related to integration of new data and data stores into existing systems and infrastructure throughout the enterprise, including introduction of Cloud services as applicable
• Develop database/data warehouse components, including hardware, relational database management systems, ETL software, metadata management tools, and database design solutions
• Hold responsibilities in data warehouses and/or data marts used for reporting or to support decision making including tabular and dimensional models
• Hold some responsibilities in master data management services and development
• Experiment with new technologies to solve business problems
• Participate in building new ecosystems for business value

Requirements

• Significant strength with n-tier applications, databases, and data warehouses, such as MS SQL, Db2, MariaDB, and no-SQL databases
• Experience with data modeling data quality and Master Data Management principles and practices
• Knowledge in ADF, SSIS, PowerBI and excel
• Understanding of relational database structures, theories, principles, and practices
• Bachelor's degree, or equivalent work experience in related job function

Nice-to-haves

• 1-5 years of experience in related job function, or advanced degree and/or superior technical skills
• Strength in Db2, ADF, Synapse/Spark, working with large datasets
• Strength in PowerBI, DAX, R, PowerBI
• Strength in data warehouse methodologies and data modeling, tabular, and multidimensional
• Knowledge of DevOps, GitOps, ML Ops, ML and AI
• Knowledge of Python, PowerShell, Bash, Ansible, Terriform

Benefits

• Medical + Prescription Drug
• Dental + Vision
• Flexible Spending Accounts (Healthcare + Dependent Care)
• 401(k) Retirement Savings with company contribution
• Paid Time Off (20 days per year)
• Paid Holidays (10 per year)
• Paid Parental Leave (6 weeks)
• Life Insurance