Data Integration Engineer
Posted on Indeed on Feb 09, 2021

The BI Data Integration Engineer will ensure data integrity and process consistency while maintaining efficient data integration solutions. This role will be responsible for analysis, design, documentation, unit testing, and support of data integration and database objects development. As member of our team, you will be working closely with business partners to present their critical data into manageable reports, cubes and models. The right person for this role will be comfortable with regular and collaborative interaction with business users

Job Responsibilities:

  • Attends work on a regular and predictable basis
  • Gather and analyze business technical requirements
  • Ensure a high degree of data quality from end to end across integrations
  • Maintain and support existing ETL processes
  • Create and maintain documentation on integration processes, execution procedures, data profiling results, data dictionaries, business glossaries, and data analysis findings
  • Work with 3rd party data providers and API's to pull data into Microsoft SQL Server
  • Write, test, and troubleshoot complex SQL queries, stored procedures, and ETL processes
  • Manage assigned projects to ensure they are delivered successfully and in a timely manner
  • Participate in method development, process improvement, and standardization
  • Continuously develop professional skills to use most effective approaches/methods/technologies
  • Perform other duties and responsibilities as assigned

Qualifications:

  • Strong SQL development skills
  • Comprehensive knowledge of Data Warehousing and Business Intelligence including various data modeling methodologies and techniques
  • A solid background in Microsoft based ETL and T-SQL development
  • Extensive experience working with SSIS
  • Hands on experience using databases like SQL Server, Oracle, and DB2
  • Experience in SQL Server performance tuning and administration working with large databases
  • Ability to use and explain all aspects of relational database design, multidimensional database design, OLTP, OLAP, KPI's, Scorecards, and Dashboards
  • Ability to recommend architecture best practices related to ETL, ELT, BI, and the life-cycle of an EDW solution
  • Experience with REST and other web API data transmission technologies
  • Exposure to Business Intelligence tools such as Tableau, Microsoft, Power BI
  • Experience with MS Excel including Power Pivot
  • High interpersonal, communication, analytical, presentation skills, with a high business maturity
  • Able to think creatively and analytically to solve problems
  • Strong organizational skills and the ability to meet deadlines/work independently

Education and Experience:

  • Bachelor's Degree in Analytics, Statistics, Computer Science, or other related field OR equivalent work experience
  • 3+ years Data Integration technologies and principles with strong knowledge of SSIS package development, deployment, and troubleshooting
  • 5+ years Microsoft T-SQL and Microsoft databases technologies (strong knowledge of stored procedures, ETL's, complex queries & joins, and user-defined functions)
  • Experience or certification with Azure, specifically SQL DB, SQL DW, or Azure fundamentals

Physical Demands:

While performing the duties of this job, the employee is regularly required to sit and use hands to finger, handle, or feel. The employee frequently is required to talk or hear. The employee is occasionally required to stand. The employee must occasionally lift and/or move up to 10 pounds. Specific vision abilities required by this job include close vision.

Job Type: Full-time

Pay: $80,000.00 - $100,000.00 per year

Benefits:

  • 401(k)
  • 401(k) matching
  • Dental insurance
  • Disability insurance
  • Employee assistance program
  • Employee discount
  • Flexible schedule
  • Flexible spending account
  • Health insurance
  • Health savings account
  • Life insurance
  • Paid time off
  • Referral program
  • Retirement plan
  • Tuition reimbursement
  • Vision insurance

Schedule:

  • 8 hour shift

Experience:

  • SQL: 3 years (Required)
  • Data Warehouse: 1 year (Required)
  • SSIS: 3 years (Required)
  • ETL and T-SQL development: 3 years (Required)

Work Location:

  • Fully Remote

Work Remotely:

  • Temporarily due to COVID-19

COVID-19 Precaution(s):

  • Remote interview process
  • Personal protective equipment provided or required
  • Temperature screenings
  • Social distancing guidelines in place
  • Virtual meetings
  • Sanitizing, disinfecting, or cleaning procedures in place

Let us know

Help us maintain the quality of jobs posted on RemoteTechJobs and let us know if:

Loading...
Success
Error on reporting

Related jobs

Horizontal Talent
Today
Justrite Safety Group
Today