BI Developer Texas

BI Developer

Responsible for Development of Business Objects Data Warehouse and Business Intelligence applications. You will provide day to day support of the Data Warehouse environment and as needed to the Business Universe.

Coordinates all phases of analysis and development for the enhancement or new feature, including establishing timelines and project schedule. Provides periodic report of project status to Data Warehouse manager.

Analyzes problems encountered during design and development and work with management to develop solutions. Design and/or review module and integration test plans for the enhancement of the new feature.

Write major parts of complex applications enhancements of new features.

Collaborate with other developers in recommending change in Universe.

Research new technology and trends and attends training classes or seminars as necessary.

Research documentation and Industry publications to remain current with industry.

More detail:

Daily duties

Security for SAP 4.0 environment
Adding users to existing groups
Managing password resets, terming old users
Creating new Folders for new departments brought on
Report folder management

Migration of WebIntelligence Reports from R3 environment to 4.0 environment
o Crystal Reports
o WebIntelligence
Modification/Creation of SQL stored procedures to solve business problems as well as provide more meaning data for DW.
o Creation of derived metrics.
o Modification/Creation of extracts for vendor feeds (Truven and others)
Ability to create and maintain a universe using SAP 4.0 IDT – UDT only would not be enough since there are a lot of changes between UDT and IDT

• Create/Maintenance of Universe using SAP 4.0 IDT

o Adding dimensions and measures
o Changes to the universes
o Creation of universes
Working knowledge of Explorer
o Creation of Information Spaces
MS SQL Server 2005, 2008, 2012 ( 2008 or better should be fine) we are mostly on 2012
SAP 4.0 IDT – good working knowledge
o Creating Data Foundation Layer
o Creating Business Foundation Layer
o Setting up Secured connections
o Working with the Repository
o Understanding of Promotion Jobs within CMS
SAP Security administration/management
o Understanding ‘Groups’
o Understanding Inheritance within the SAP folder structure
o General Familiarity with SAP 4.0 and R3 CMS
Some working knowledge of interaction with the SAP Marketplace
o Acquiring License Keys
Downloading and Installing upgrades – we want to upgrade from 4.0 to 4.1

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500

No agencies! No subs! No telecommuting!

It is ok to live in Waco, Killeen, Austin, Houston, Dallas or College Station or surrounding areas in Texas.

Job Type: Full-time

 

Application Developer

Job Description
The candidate must be able to successfully interface with internal clients to gather requirements for new projects and troubleshoot problems with existing applications. The successful applicant must be able to handle the full software development lifecycle and the environments the applications run in. Other duties include closely working with the internal customers to resolve problems with existing applications, design and creation of new applications, design and implementation of new SQL server databases, troubleshooting problems with existing SQL server databases, creation of unit tests for new and existing applications, website deployment, and maintenance of existing development environments. This is not a development only position the candidate should be a proven self-starter and able to be a one person show.

Required Skills
• C#
• .Net framework 2.0 thru 4.0
• Unit Testing
• Object Oriented Design
• Windows Communication Foundation (WPF)
• Windows Presentation Foundation (WCF)
• ASP.Net
• Subversion
• Cruise Control
• Click Once Deployment
• SQL Server
o Database, stored procedure, user defined function and table creation and maintenance
o Troubleshooting database objects
• Website creation and maintenance
• Desktop and Web software deployment
• Software Development Lifecycle
• Excellent analytical skills
• Microsoft Enterprise Library

Nice to have
1. SQL Server Management Studio
2. Microsoft Expression Design and Blend
3. Team Foundation Server
4. Inversion of Control
5. Microsoft Prism

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500

Delivery Lead

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com

My client is looking for a Delivery Lead with strong project management experience for immediate hire. The Information Delivery Lead directs and coordinates activities of projects of varying sizes to ensure
that goals and objectives of the projects are accomplished within a determined timeframe and in a
cost effective manner.
Knowledge, Skills and Abilities
– Project management, analysis, processing skills preferred
– Excellent communication skills, both orally and written
– Familiarity with targeted business areas

Job Functions
Participates in all phases of project implementation including planning, evaluating, selecting, testing and training.

Provides technical and analytical expertise and product knowledge required to
provide for successful implementation and continued support.

Coordinates project assignments.

I.
Coordinates and assists in preparation of documentation and functional
specifications, conversion specifications, interface specifications, maintenance
procedures, and all other project documentation as needed. Ensures
documentation is maintained for all changes applied to systems.

II.
Fulfills requests for help, special reports/queries, error diagnosis & resolution
and other requests for assistance from end users. Develops new database
queries and reports on supported applications in response to work orders.
Trains end users on supported applications. Stimulates efficient and effective
use, by end users, of supported applications.

III.
Provides consultative services to assigned areas and serves as a liaison between
management, users and other assigned personnel. Serves as the primary
contact for problem resolution, user interaction and status of projects, preparing
reports as needed.

IV.
Assembles, compiles and analyzes needs and requirements from stakeholders.
Consults with other knowledgeable sources. Researches and formulates
possible solutions. Coordinates with stakeholders to select the best solution
and implements that solution.

V.
Establishes, distributes and maintains operating procedures, end user training
materials and end user documentation. Conducts end user training sessions.

VI.
Develops Requests for Proposals (RFPs) and Requests for Inquiry (RFIs) and
evaluates vendor responses to such. Recommends a course of action upon
evaluation of vendor responses to an RFP or RFI.

VII.
May perform other duties as assigned or requested
Implements new/changed application software. Establishes and maintains
formal production, test development and training environments for applications.
VIII.
Provides ongoing technical support post-system implementation and assists
with additional corrections, enhancements and change requests. Works with
users to determine and assess any future needs.

IX.
May make hiring recommendations, assists in performance reviews and other
personnel functions for assigned employees.

X.
Bachelor’s Degree or 7 plus years experience in Lieu of Eduation
Required Education and/or Experience: 6-8 Years Work Experience Applicable to Position

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com

Senior Business Intelligence Developer

Senior Business Intelligence Developer
Fort Worth, TX

My client is looking for a strong Senior Business Intelligence Developer in Fort Worth, TX. My client provides risk management services to Healthcare Companies.

Requirements: Skills/Qualifications:
• At least 5 years SSIS 2008/2012 experience.
• 3- 5 years ETL experience.
• Strong analytical and problem solving skills.
• 3 – 5 years. SSRS 2005/2008/2012 experience
• 1 – 3 years SSAS 2008/2012 experience.
• At least 5 years SQL Server 2005/2008/2012 experience.
• Strong knowledge in writing stored procedures, functions.
• Excellent communication skills.
• Knowledge of Microsoft Office Suite.
• The ideal candidate will have a record of success with problem-solving and managing multiple priorities.
• ASP.Net knowledge is a plus.
• Business Objects and Crystal Reports is a plus.
• Healthcare industry experience and advanced knowledge of claims, membership, and healthcare provider data is a plus.
Benefits:
• Competitive Salary
• Medical, Dental, Vision plans
• Life, LTD and Accidental Death insurance
• 401(K)
• Progressive PTO program
• Professional work environment
MY CLIENT is proud to be an EEO-AA employer M/F/D/V and maintains a Drug-Free Workplace
About The Company:
My client is a national firm that provides a variety of risk management services to the healthcare, insurance and business communities. We are customer driven and technology focused, with a commitment to providing cutting edge business solutions and service excellence to our customers.
About the opportunity:
MY CLIENT is looking for a BI/SQL Developer to join our Ft. Worth team. As part of the Healthcare Services team; the developer is responsible for consulting with business users on their reporting and analytical requirements, documenting the user requirements, constructing functional report designs, communicating with business stakeholders on projects, request status and issues, and participate with the other BI team members with the overall delivery and support of BI projects/solutions.
Job Purpose:
The Senior BI Developer has primary responsibility for creating and/or modifying all the needed stored procedures, functions, scripts, and SSIS packages to load, transform, and map the data from several sources to MSSQL Server databases or the other way around as needed. Also, the candidate should have strong experience in creating fully automated ETL processes using SSIS and C# scripting within SSIS. Also, creating and modifying SSRS reports, dashboards, and SSAS cubes. The individual also has significant interaction with Software Development, Quality Assurance and Data Processing. These interactions may include, but are not limited to, leading and facilitating meetings, working with colleagues to identify data and information needs. In addition
Duties (but are not limited to):
• Creates/modifies all the needed stored procedures, functions, schemas, and SSIS packages.
• Creates/modifies all the needed SSRS reports and SSAS cubes.
• Writes C# scripts within SSIS.
• Writes scripts using SQL to answer the business ad hoc requests.
• Recommends controls by identifying problems and writing improved procedures.
• Maintains system data protocols by writing and updating procedures.
• Maintains client confidence and protects operations by keeping information confidential according to HIPAA standards.
• Identify enterprise-wide data needs and assessing data integrity and analyzing data gaps.
• Collaborates with business units and employs iterative methodologies to meet and exceed client expectations.
• Passion for problem-solving and managing multiple priorities.
• Analyzing data as needed.
• Contributes to team effort by accomplishing related results as defined by established priorities and internal timeframes

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com

Systems Analyst III Healthcare

Systems Analyst III position –

Bachelor’s degree and 7 years of experience or 10+ years of experience in healthcare and data warehousing

 

The Systems Analyst III acts as a consultant to user departments to enhance existing business

applications and to facilitate solutions to meet business requirements, ensuring that all related

applications are consistent with overall organizational strategies.

Knowledge, Skills and Abilities:

– Project management, analysis, processing skills preferred

– Excellent communication skills, both orally and written

– SQL certification preferred

1. Recommends, plans, tests upgrades and conversions

of applications and products to improve data integrity and functionality. Ensures

appropriate integration of new applications and projects with existing production

applications. Continues technical support post-system implementation and

assists with additional corrections and enhancements.

1. tests programs according to system

standards or mentors/supervises other junior level staff performing this

functionality.

1. Troubleshoots problems, implements changes to resolve issues and documents

findings.

1. May act as project leader to develop, program, implement, and maintain a system

application.

1. Produces project plans for implementation.
2. Reviews and develops interface specifications and advises manager on best

approach for implementation.

1. Develops team understanding of overall project, working with customers in

planning and designing of new system functionality and enhancements to

existing functions. Documents current workflow and assesses future needs.

1. Communicates project status to management, including meeting minutes,

project timelines, and issue logs.

1. Participates in current and future directions of the industry while maintaining

awareness of new technologies to assist in the planning and design of new and

current projects.

1. Trains and assists in the development of personnel as needed.

Melanie Kirk

214-457-3500

mkirk@empx.com

 

Data Governance Healthcare

 

Database Analyst II position that will focus on data governance –Bachelor’s degree and 3-5 yrs experience or 8-10 yrs experience in the Healthcare domain and data warehousing/data governance

• Data governance responsibilities:
• Maintain data dictionary
• Document data standards for the enterprise
• Document master data management workflows
• Document enterprise data flows
• Profile data sources
• Analyze and recommend solutions to data quality issues
• Coordinate and prepare materials for data governance meetings
• Coordinate data governance processes/workflows

Proficient in Powerpoint, Excel, Word, Access, SQL 

 

Melanie Kirk

Empyrean Consulting, Inc.

214-457-3500

mkirk@empx.com

EHR Project Lead

Our client is looking for an EHR Project Lead. Must have experience leading a team in the EHR space. Eclipsys/Allscripts preferred.

Longer job description available upon request.
Melanie Kirk
Empyrean Consulting, Inc.
mkirk@empx.com
214-457-3500
972-961-4864

Healthcare EDW Manager–Business Intelligence/IT

Healthcare EDW Manager–Business Intelligence/IT (1)

Job Responsibilities

As a Healthcare EDW Manager, you will support and enhance OUR CLIENT’S’s data warehouse environment. You will report to the Director of Data Management and function as the liaison between your team and other department managers and directors.
Your specific duties as a Healthcare EDW Manager will include:
Managing and supervising Healthcare Business Intelligence Developers, ETL Architects, ETL Developers
Responsibilities:
• Lead team delivery, which includes working across peer teams to deliver product, drive process improvement, oversee work management, and provide team communication, direction, and support.
• Provide guidance, coaching and development opportunities appropriate to each direct report’s individual needs. Perform all necessary management functions, including hiring, evaluations, merit allocations, and disciplinary action as required.
• Serve as main point of contact for Business Intelligence and Enterprise Data Warehouse business partners by understanding business objectives, ensuring alignment, driving regular communication, and managing delivery assurance.
• Manage the evolution of our EDW and BI solutions by working closely with business and IT stakeholders to evolve strategy and ensure strategy alignment.
• Perform other duties as assigned

Knowledge, Skills, and Abilities:

• Strong knowledge of enterprise systems integration, technical design & development standards, including knowledge of best practices for performance & maintainability, and appropriate product/tool analysis & selection.
• Strong knowledge of Business Intelligence tools and techniques, Enterprise Data Warehouse design and usage concepts, including knowledge of best practices.
• Ability to effectively communicate with all levels of the organization, clearly expressing ideas and concepts both verbally and in writing to effectively handle sensitive issues and facilitate critical interactions.
• Strong proven leadership skills with the ability to motivate team members.
• Outstanding interpersonal, relationship building and employee coaching skills.
• Effectively create and foster a positive team environment that gives way to collaboration and unified goals.
• Excellent prioritization skills and the ability to handle multiple job duties in a fast paced environment.
• Developing necessary skill sets within the BI and ETL teams
• Developing, maintaining and enforcing departmental policy and procedures
• Developing, implementing and maintaining ETL solutions.
• Developing and enforcing best practices and standards.
• Maintaining an overall plan of projects and efforts
• Coordinating efforts with other managers and supervisors within the Data Management department
• Assessing the scope and impact of projects
• Documenting technical requirements
• Responsible for development, unit testing, integration testing, system testing activities
• Supporting the development teams in the understanding of the technical requirements
• Managing and reporting overall development project status
• Providing consultative, technical and staff support as appropriate
• Evaluating new technologies, tools and methods that could help support the ETL environment
• Working with database administrators to ensure that ETL processes are tuned for optimal performance.
• Support the enterprise with skilled development resources, knowledge and tools to improve the quality and speed of information delivery to the business.
• Accountable for all ETL support activities, including delegating tasks.
• Mentoring ETL team members in the use of ETL tools and best practices
Job Requirements

As the Healthcare Business EDW Manager you must be self-motivated and well organized. You must also have strong problem-solving skills as well as strong multitasking and time-management skills. You must also have excellent verbal and written communication, and interpersonal skills. It is vital that you be able to effectively communicate technical information to persons from technical teams at variety of levels.

Specific qualifications for the EDW Manager position include:

• Bachelor’s degree in any field
• 10 years of experience overall
• Demonstrated management or supervisory experience
• Direct experience managing multiple platforms and ETL tools
• Experience with Oracle, Cognos, Stored Procedures, and Netezza a huge plus
• Demonstrated experience managing ETL enhancement efforts from design to implementation
• Skill in performing data analysis to troubleshoot data quality issues, develop/validate technical specifications and test data results
• Strong follow-through skills
• Two years of healthcare industry experience preferred

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com
972-961-4864

Technical Lead Healthcare- Dallas

The Project Lead plans, directs and coordinates activities of technical efforts of varying sizes to ensure that goals and objectives of the technical efforts are accomplished within a determined timeframe and in a cost effective manner. Establishes work plans to determine schedule, funding limitations, and procedures for accomplishing technical effort, staffing requirements, and allotment of available resources in the project phases.

Directs the process of change management, change control, planning, organizing, staffing, managing and controlling a technical effort. Develops and maintains a technical plan, project budget and other project documentation. Conducts project meetings. Participates in all phases of project implementation including planning, evaluating, selecting, testing and training.

Provides technical and analytical expertise and product knowledge required to
provide for successful implementation and continued support. Coordinates
project assignments.

I.
Coordinates and assists in preparation of documentation and functional
specifications, conversion specifications, interface specifications, maintenance
procedures, and all other project documentation as needed. Ensures
documentation is maintained for all changes applied to systems.

II.
Fulfills requests for help, special reports/queries, error diagnosis & resolution
and other requests for assistance from end users. Develops new database
queries and reports on supported applications in response to work orders.
Trains end users on supported applications. Stimulates efficient and effective
use, by end users, of supported applications.

III.
Provides consultative services to assigned areas and serves as a liaison between
management, users and other assigned personnel. Serves as the primary
contact for problem resolution, user interaction and status of technical effort, preparing reports as needed.

IV.
Assembles, compiles and analyzes needs and requirements from stakeholders.
Consults with other knowledgeable sources. Researches and formulates
possible solutions. Coordinates with stakeholders to select the best solution
and implements that solution.

V.
Establishes, distributes and maintains operating procedures, end user training
materials and end user documentation. Conducts end user training sessions.

VI.
Develops Requests for Proposals (RFPs) and Requests for Inquiry (RFIs) and
evaluates vendor responses to such. Recommends a course of action upon
evaluation of vendor responses to an RFP or RFI.

Qualifications

Qualifications

Education: BS Degree – REQUIRED

8+ years of IT experience

5+ years as a Technical lead

5+ years’ experience in Data Warehousing and Analytics work

Experience leading teams rolling out BI functionality using tools such as Cognos, BO, SSRS etc.

Recognized for project technical skills and possess a strong track record from project delivery stand point

Business Analysis and Project Management Experience
Conducting current state assessments and performing gap analysis and develop future state realizing stakeholder vision

Prefer experience with Healthcare data analyzing claims and patient health data
Knowledge of Healthcare industry and up to date understanding of the transformation healthcare industry is going through

Excellent communication and overall analytical skills

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com
972-961-4864

Lawson Administrator Dallas

Description
This position is responsible for the maintenance and administration of the Lawson environment and applications on UNIX-AIX/ORACLE and Windows architecture. Position requires an experienced Lawson technical professional. Designs, implements and maintains automated and manual systems. Works with users in the support of business applications.

Closely monitors the performance of specific computer/communications network components to ensure system availability and to verify smooth system operations. Implements, monitors and maintains specified systems. Defines and implements backup and recovery procedures. Conducts performance tests as necessary. Revises existing systems and procedures to correct problems. Identifies documents, resolves and communicates solutions and system problems to users. Ensures system efficiency and security.

Qualifications
• Requires a Bachelor’s degree (or equivalent work experience) in one of the following disciplines: Computer Science, Information Management, Business, Technology, or related field in order to provide consultative and technical expertise to customers.
• At least 3 years of Lawson technical experience.
• Install patches/cyclical/upgrades to the Lawson Environment, Applications and peripheral products (Lawson Business Intelligence, Mobile Supply Chain Management, etc.)
• Knowledgeable in Lawson 9.x applications (Supply Chain and Finance) is a plus.
• Must have ability be on-call 24 hours.
• Ability to maintain file systems, directories, log files, print files and work files.
• Experience in UNIX/Windows commands as well as with shell scripting.
• Experience in concepts of LDAP tools (ADAM/ADLDS).
• Administration experience with Lawson System Foundation 9 in a multi-tiered environment.
• Administration experience with Lawson peripheral products (Lawson Business Intelligence & Mobile Supply Chain Management).
• Administration experience with Business Process Management (ProcessFlow).
• Experience with ImageNow or an equivalent Document Management System integration with Lawson as well as other Host applications.
• Ability to coordinate and track patch promotion from test to production environments.
• Administration experience in IBM middleware components such as WebSphere.
• Ability to work with DBA to create Oracle instances and ongoing maintenance.
• Strong analytical abilities required to interact with customers to evaluate work and provide technical assistance.
• Good interpersonal skills required to interact with customers and clients and provide technical assistance to resolve problems.
• Good organizational skills and ability to communicate effectively.

Melanie Kirk
Empyrean Consulting, Inc.
214-457-3500
mkirk@empx.com