ETL Application Developer

DentaQuest - Milwaukee, WI (30+ days ago)3.5

The Application Developer is responsible for the development and implementation of technical solutions. This role will leverage technical expertise in database applications, ETL processes, and automation in support of internal and external customer’s data exchange and integration needs-

This posting is for sourcing purposes for future openings. Once position is active, a representative will reach out to qualified candidates for further consideration

Please note the location of the position is in Milwaukee, WI .

Develop complex data extracts, applications, and ad-hoc queries as requested by internal and external customers using SQL, SSIS or Informatica toolset (Powercenter, B2B with MFT)
Requests include custom flat files, EDI, user applications, and a significant focus on healthcare encounters and HIPAA X12 transactions: 837, 999, 277, 835
Maintain the production Business Intelligence products and solutions, including resolving production issues and responding quickly to priority problems
Research, troubleshoot, and resolve data issues impacting extract delivery.
Work closely with Business Systems Analysts to understand requirements regarding solutions, ensure data quality and match-back to core systems transaction results.
Collaborate on the definition, development, and maintenance of standards and processes.
Drive continuous improvement and automation in BI solutions and processes.
Serve as mentoring resource for other developers.
Support DentaQuest’s goals and objectives by working closely with management team to deliver value to the business.
Other duties as assigned.

Required Skills

Must have strong understanding and ability to script in Advanced Transact SQL
Extensive knowledge of data integration and processing including extraction, transformation, and loading (ETL).
Self-managing and ability to lead project solution end-to-end.
High analytical skill and experience to support transitioning data architecture in a legacy and service oriented environment.
Strong communication skill and ability to interact at all levels including management level communication.
Excellent interpersonal skills
Ability to prioritize and organize multiple tasks
Ability to remain organized with multiple interruptions
Ability to lead other technical team members and knowledge share
Experience with Healthcare data domain is strongly preferred.
Experience with data access performance tuning and performance optimization.

Required Experience

BS. or MS degree in Computer Science, business or related discipline, or equivalent experience.
4 - 7 year experience T-SQL Stored Procedures, Views and T-SQL design and development using Visual Studio and SQL Management Studio (or equivalent tools)
4 - 7 Years’ experience using SQL Server 2008, 2012, 2016 or equivalent tools.
4 Years’ exp. with ETL tools like Informatica (Informatica Power center 9x, Informatica Data Quality 9x) and/or SSIS or equivalent tools.
1 + Years’ experience with Business intelligence reporting development experience using Microsoft SQL Server Reporting Services (SSRS), Tableau, Cognos and others is preferred but not necessary.
2 years exp. in design of appropriate data structures for the development of a database system