Our client is looking for a Business Intelligence Engineer to join their team. The mission of the Information Technology Group (ITG) is to develop, implement and maintain technology-based services and solutions to effectively manage information. This position is responsible for engineering efforts to transform our existing Research Data Warehouse to support a next generation, high quality database and related toolset to better meet needs. Initial focus is on solution design, development, testing and implementation of ETL using a combination of Microsoft SQL Server Integration Services (SSIS), T SQL queries, and PL/SQL to populate database objects. This position will need to perform scoping and estimating on Data Warehouse activities, presenting technical information and design proposals in verbal and written form using easily understood terms.
Future efforts will include utilization of the latest cloud solutions for delivery of advanced analytics and big data solutions. This will include architecture that enables the management and delivery of large and diverse data sets of clinical data.
This position is also responsible for detailed technical analysis to assure the availability and accuracy of data processed by ETL into the Research Data Warehouse and cloud solutions. From time to time, this will include availability for rotation through an after-hours on-call support model as needed for upgrades, project go lives or to provide ongoing support of new systems that may have 24x7 support agreements. This will require a broad knowledge of Research systems and workflows.
Business Intelligence Engineer Responsibilities
Microsoft SSIS and TSQL, Oracle PL/SQL support, maintenance and development.
Build and migrate SSIS projects, TSQL and database objects and perform necessary testing and validation such as unit testing during development and/or QA testing as required.
Share SQL Server SSIS, TSQL and related development expertise and provide support to data warehouse developers, data analysts, and users in the ETL migration and support of the Research Data Warehouse environment.
Develop and modify Oracle PL/SQL and related database objects in the ETL migration and support of the Research Data Warehouse environment.
Participate in peer code review sessions and offer suggestions that improve performance, maintainability, and best practice compliance.
Review and troubleshoot SSIS packages, TSQL and PL/SQL queries to address errors that occur during nightly and ad hoc processing.
Apply updates and ensure that data are loaded into the data warehouse according to defined requirements.
Maintain, support, and apply change data capture (CDC) processes for incremental loading of data.
Apply standard data warehouse transformation concepts for the integration, validation, and organization of data necessary for loading into a dimensional data warehouse environment.
Perform query and process tuning and optimization.
Follow change and version control procedures.
Apply appropriate security structures and/or policies to data and/or database objects.
Make recommendations on best practices for code maintenance, deployments, and migrations specific to SSIS working in conjunction with SQL Server DBAs and enterprise data architects.
Maintain and Support the Research Data Warehouse data pipelines.
Modify tables, views and other database objects.
Provide complete and consistent documentation of the data warehouse and ensure that users can determine what data are available in the warehouse, how data elements are defined, how key metrics are defined, how analyses are performed, and how information is presented in accordance with company standards.
Monitor and tune Data Warehouse processes to address system performance issues to ensure performance benchmarks are maintained at an acceptable level.
Work with vendors to address any critical issues and apply code changes or fixes as needed.
Provide feedback and accurate technical information to project managers, analysts, engineers and administrators in other groups working to identify and resolve issues.
Validate Data in the Data Warehouse.
Work with QA analysts to establish test plans that evaluate ETL performance and data quality of deliverables.
Assume responsibility for mitigating all issues discovered during the QA process.
Provide support to data warehouse developers, line-of-business analysts, and users to validate data in the data warehouse. Investigate and report on problems and work to ensure the validity of the data warehouse.
Collaborate with team members and analysts to validate data in the data warehouse.
Investigate and report on problems and work to ensure the validity of the data warehouse.
Business Intelligence Engineer Qualifications
8 years work related experience in the information technology field or a combination of clinical or operational healthcare environments.
Bachelor’s degree in computer science, a related field, or a clinical field and 6 years work related experience in the information technology field or a combination of clinical or operational healthcare environments or Equivalent combination of education and experience.
Experience applying advanced MS SQL server knowledge in the use of SSIS, T SQL and database object definition.
Designing, developing, implementing and optimizing Oracle PL/SQL solutions.
Supporting and maintaining a Data Warehouse in a MS SQL Server database.
Experience with development of large-scale data structures for business intelligence
Use ETL/ELT processes and tools, both relational and dimensional data modeling, in both on premise and cloud environments.
Knowledge of data warehousing architecture.
Incremental (changes only) data loading.
Ability to read, write and maintain T SQL and SSIS code.
Ability to define and maintain, MS SQL Server & Oracle database objects such as Views, tables, indexes, stored procedures.
Benefits are available to eligible VanderHouwen contractors and include coverage for medical, dental, vision, life insurance, short and long term disability, and matching 401k.
VanderHouwen is an award-winning, Women-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen has been successfully placing experienced professionals throughout the Pacific Northwest and nationwide. Our recruitment teams are highly specialized in either Technology and IT, Engineering, or Accounting and Finance career markets. Our recruiters value building meaningful, professional relationships with each candidate as well as developing honed knowledge of companies' staffing needs and workplaces. Partner with us to land your next exciting career.
VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate on the basis of race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state or federal civil rights laws.
Systems Engineer- Defense Program Support