Data Engineer

Data Engineer                

Direct Hire

Must be local /regional to Twin Cities (ability to come onsite as needed, could be 1-2x/month)

 

Must have:

• Experience using MS SQL to establish databases and associated tables to streamline reporting for oneself and Tableau creators.
• Create processes and SQL scripts to provide accurate consistent data sources
• Experience creating user friendly tables (easy, clear content, no code translation needed) for front end team to access
• Manage and maintain the Tableau environments

 

Nice to have:

• As this is working with clinical/health care data, experience in healthcare preferred

• HelpSystems Automate experience or RPA tools
• Experience having built a data lake

 

 

Summary:

This back end Data Engineer will build, maintain and improve upon the SQL data warehouse tables, reporting tools and processes of the organizations.

Analyze common data use cases and the tables of the organization’s major software applications to establish data sources (warehouse tables) for ease of use in the generation of reports.

This position will work with Microsoft SQL Server, HelpSystems Automate and Tableau for managing data sources, the overall system administration and develop requested queries on behalf of assigned departments and will provide support to users of the data and Tableau report creators.

Primary data sources being worked on are EMR related, specifically Allscripts Touchworks and Allscripts Practice Management.

 

Responsibilities:

• Use MS SQL to establish databases and associated tables to streamline reporting for oneself and Tableau creators.
• Create processes and SQL scripts to provide accurate consistent data sources
• Manage and maintain the Tableau environments
• Assist in supporting the SQL environment that provides the data for reporting
• Act as a resource to staff in other departments who use or create reports in Tableau
• Learn the general operational practices of various clinics and surgery centers to provide the data they need to assist with quality of care and financial operations.
• Work with individuals from the supported organizations to learn how their data is stored and the best ways to display it
• Become an expert on the data schema and operational workflows for scheduling, billing and electronic records
• Assist with projects to improve the data integrity, speed and quality
• Use MS SQL and Tableau to build new reports at the request of managers, directors, and executives in the business center, clinics and surgery centers
• Maintain and improve upon existing reports within Tableau; redesign when necessary
• Assist other IT staff with enhancements or changes to major software systems, including major integration projects as needed
• Occasionally participate in community functions relating to outreach events throughout the year

 

Requirements:

• Experienced in data analytics, preferably in a medical clinic or healthcare setting.
• Strong analytical and technical skills. Highly proficient with data manipulation
• Ability to translate business processes, workflows, and user requirements into technical descriptions and requirements
• Ability to learn the organization’s operational software applications from an end users perspective and to interpret the associated system database tables
• Experience with Tableau and Microsoft SQL Server as well as SSIS package development
• Experience with HelpSystems Automate or another RPA tool
• Strong proficiency with Microsoft Excel.
• Comply with company policies, procedures, practices and business ethics guidelines.
• Comply with all applicable laws and regulations, (e.g. HIPAA, Stark, OSHA, employment laws, etc.)
• Travel to other work locations when needed to meet with management and leads in discovery work for data requests.

 

Preferred:

• Software development experience is preferred
• Experience with EMR and Practice Management systems