Data Engineer 3

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 the 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:

  • None

 

Duties/Responsibilities:

  • Create workflows, templates, and design patterns
  • Communicate with stakeholders to obtain accurate business requirements
  • Create and perform unit tests for solutions
  • Converting existing SSIS packages into Azure Data Factory Pipelines
  • Performs other related duties as assigned

 

Required Skills/Abilities:

•    Familiarity of SQL programming language basic fundamentals
•    Familiarity of Basic understanding use of Python or R or Scala
•    Awareness of Python/Synapse/Snowflake Distributed/Parallel Computing
•    Familiarity of Basic understanding of modeling tools such as ERWin, Dbeaver, Lucid, Visio 
•    Awareness of Git for version control of code repositories
•    Awareness of RDBMS Development tools. SQL Enterprise Manager, Visual Studio, Azure Data Studio.
•    Awareness of Open-source database platforms. MySQL
•    Awareness of Big Data frameworks such as Pyspark, Hadoop, etc
•    Familiarity of Modern Data Estate patterns: Source to Raw To Stage To Curated
•    Familiarity of Databricks concepts: batch, streaming, autoloader, etc.
•    Familiarity of Cloud diagnostics, logging, and performance monitoring/tuning.
•    Familiarity of Understanding of data shoveling tools: ADF, Fivetran, Airflow, etc..

•    Familiarity of Database i/o skills -- writing/reading structured and unstructured DBs
•    Awareness of Debugging, documentation, testing, and optimization skills
•    Awareness of Convert business needs into technical requirements
•    Experience Explaining DE concepts to business stakeholders
•    Experience Communicating and collaborating effectively with a remote team
•    Experience Communicating effectively with interdisciplinary teams of various technical skill levels
•    Learning Working effectively and delivering value in ambiguous settings

Education 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 and long 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 (laptop and desktops) and telephone equipment including continuous 10-key, handwriting, use of mouse (or alternative input device), use of keyboard (or alternative input device), or sporadic 10-Key, telephone, or telephonic headsets. This position will also frequently use other office productivity tools such as the printer/scanner.
  • Role requires the ability to lift, carry, push, pull and/or move up to 10lbs on a frequent basis and may require twisting actions of the upper body (i.e., Picking up, carrying a laptop – and twist to work on an L shape desk).
  • Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus. This position requires frequent use of a computer monitor and visual acuity to perform email responses, prepare and analyze data; transcribe; extensive reading and online communication.
  • Role requires being able to hear and use verbal communication for interactions with internal clients and dependent on role with external clients via conference calls.

 

Cognitive Ability Requirements: The employee must have the ability to:

  • Works with others (co-workers, professionals, public, customers, clients)
  • Works professionally in alignment with the organization’s code of conduct
  • Interact face to face with others (co-workers, superiors)
  • Constant verbal and email communication with others (co-workers, supervisors, vendors, client, customers etc.) to exchange information
  • Ability to take constructive feedback and show courtesy to co-workers, professionals, public, customers, clients
  • Make quick, accurate decisions without supervision
  • Evaluate or make decisions based on experience or knowledge
  • Divide attention between issues requiring multi-tasking
  • Use judgment on routine matters
  • Distinguish situations requiring judgment and adaptation of procedures from one task to another
  • Adapt to tightly scheduled and hurried pace of work activities
  • Meet frequent project deadlines
  • Organize own work
  • Ask questions or request assistance when needed
  • Follow instructions received both orally and in writing

Work 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 organizations 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, without limitation, 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.com

Blueprint believe in the importance of a healthy and happy team, which is why our comprehensive benefits package includes:

  • Medical, dental, and vision coverage
  • Flexible Spending Account
  • 401k program
  • Competitive PTO offerings
  • Parental Leave
  • Opportunities for professional growth and development

 

Location: Remote - USA

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.