Data Engineer 3

Who is Blueprint?We are a technology solutions firm headquartered in Bellevue, Washington, with a strong presence across the United States. Unified by a shared passion for solving complicated problems, our people are our greatest asset. We use technology as a tool to bridge the gap between strategy and execution, powered by the knowledge, skills, and expertise of our teams, who all have unique perspectives and years of experience across multiple industries. We're bold, smart, agile, and fun.What does Blueprint do?Blueprint helps organizations unlock value from existing assets by leveraging cutting-edge technology to create additional revenue streams and new lines of business. We connect strategy, business solutions, products, and services to transform and grow companies.Why Blueprint?At Blueprint, we believe in the power of possibility and are passionate about bringing it to life. Whether you join our bustling product division, our multifaceted services team or you want to grow your career in human resources, your ability to make an impact is amplified when you join one of our teams. You'll focus on solving unique business problems while gaining hands-on experience with the world's best technology. We believe in unique perspectives and build teams of people with diverse skillsets and backgrounds. At Blueprint, you'll have the opportunity to work with multiple clients and teams, such as data science and product development, all while learning, growing, and developing new solutions. We guarantee you won't find a better place to work and thrive than at Blueprint.What will I be doing?Job Summary:The Data Engineer's responsibilities include designing, developing, and deploying Data Integration (ETL and or ELT) solutions using agreed upon design patterns and technologies; working with a large variety of data sources from json, csv, Oracle, SQL Server, Azure Synapse, Azure Analysis Services, Azure SQL DB, DataLake, polybase; and Streaming data sets.Supervisory Responsibilities:NoneDuties/Responsibilities:Create workflows, templates, and design patternsCommunicate with stakeholders to obtain accurate business requirementsCreate and perform unit tests for solutionsConvert existing SSIS packages into Azure Data Factory PipelinesPerform other related duties as assignedRequired Skills/Abilities:Familiarity with SQL programming language basic fundamentalsBasic understanding of Python or R or ScalaAwareness of Python/Synapse/Snowflake Distributed/Parallel ComputingBasic understanding of modeling tools such as ERWin, Dbeaver, Lucid, VisioAwareness of Git for version control of code repositoriesAwareness of RDBMS Development tools: SQL Enterprise Manager, Visual Studio, Azure Data Studio.Awareness of Open-source database platforms: MySQLAwareness of Big Data frameworks such as Pyspark, Hadoop, etc.Familiarity with Modern Data Estate patterns: Source to Raw To Stage To CuratedFamiliarity with Databricks concepts: batch, streaming, autoloader, etc.Familiarity with Cloud diagnostics, logging, and performance monitoring/tuning.Understanding of data shoveling tools: ADF, Fivetran, Airflow, etc.Database I/O skills -- writing/reading structured and unstructured DBsAwareness of Debugging, documentation, testing, and optimization skillsAbility to convert business needs into technical requirementsExperience explaining DE concepts to business stakeholdersExperience communicating and collaborating effectively with a remote teamExperience communicating effectively with interdisciplinary teams of various technical skill levelsAbility to work effectively and deliver value in ambiguous settingsEducation and Experience:Bachelor's degree in Computer Science, Industrial Engineering, Business Analytics, or equivalent.3+ years of broad-based IT experience with technical knowledge of data Integration (ETL, ELT) technologies and approaches, Data Warehousing, Data Lake Methodologies.3+ years' experience with SQL Server. Expert level TSQL knowledge required.3+ years' experience designing and implementing scalable ETL processes including data movement (SSIS, replication, etc.) and quality tools.2+ years' experience building cloud hosted data systems. Azure preferred.2+ years' experience with SQL Server Analysis Services (SSAS)2+ years' experience with SQL Server Integration Services (SSIS)Physical Requirements:The employee is frequently required to sit at a workstation for extended periods of time. The employee will occasionally walk; will frequently use hands to finger, handle, grasp or feel; and reach with hands, wrists, or arms in repetitive motions.The employee will frequently use fingers for manipulation of computers and telephone equipment including continuous 10-key, handwriting, use of mouse, or keyboard.Role requires the ability to lift, carry, push, pull and/or move up to 10lbs on a frequent basis.Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.Role requires being able to hear and use verbal communication for interactions with internal clients.Cognitive Ability Requirements:Works with others (co-workers, professionals, public, customers, clients)Works professionally in alignment with the organization's code of conductInteract face to face with others (co-workers, superiors)Constant verbal and email communication with others (co-workers, supervisors, vendors, clients)Ability to take constructive feedback and show courtesy to co-workersMake quick, accurate decisions without supervisionEvaluate or make decisions based on experience or knowledgeDivide attention between issues requiring multi-taskingUse judgment on routine mattersDistinguish situations requiring judgment and adaptation of proceduresAdapt to tightly scheduled and hurried pace of work activitiesMeet frequent project deadlinesOrganize own workAsk questions or request assistance when neededFollow instructions received both orally and in writingWork Environment:The work environment is usually a traditional office, indoor setting with no exposure to outside elements.This position requires no travel.The employee will frequently be required to work closely with others and occasionally work alone.This position may require a work schedule across weekends and holidays.This position is subject to blackout dates which may include holidays where PTO is not approved.May work remotely based on adherence to the organization's work from home policy.Reasonable accommodations may be made to enable individuals with disabilities to perform the job.Salary Range:Pay ranges vary based on multiple factors including skill sets, education, responsibilities, experience, and geographical market. The pay range for this position reflects geographic based ranges for Washington state: $88,300 - $115,300 USD/annually. The salary/wage and job title for this opening will be based on the selected candidate's qualifications and experience and may be outside this range.Equal Opportunity Employer:Blueprint Technologies, LLC is an equal employment opportunity employer. Qualified applicants are considered without regard to race, color, age, disability, sex, gender identity or expression, orientation, veteran/military status, religion, national origin, ancestry, marital, or familial status, genetic information, citizenship, or any other status protected by law.If you need assistance or a reasonable accommodation to complete the application process, please reach out to: recruiting@bpcs.comBenefits:Blueprint believes in the importance of a healthy and happy team, which is why our comprehensive benefits package includes:Medical, dental, and vision coverageFlexible Spending Account401k programCompetitive PTO offeringsParental LeaveOpportunities for professional growth and developmentLocation: Remote - USA

#J-18808-Ljbffr