Business Intelligence Programmer II - Baltimore, MD (#0045)
Our client, a large healthcare insurance provider in the Mid-Atlantic region, is currently looking for a full-time Business Intelligence Programmer II to work out of their Baltimore (Canton) location.
PURPOSE: The Business Intelligence Programmer II is responsible for development, enhancement, testing, maintenance, and support of analysis & reporting solutions. Under the guidance of senior staff, this individual will work with Business Analysts and internal customers to understand and analyze more complex requirements, develop and implement analysis, reporting, BI, and ETL solutions. Ensures the accuracy and integrity of data and applications through detailed analysis, efficient coding, writing clear documentation, and prompt identification and resolution of problems as they arise. The Business Intelligence Programmer II will work under the guidance of senior staff to proactively analyze, identify, and interpret problems, and to develop and implement measures to solve them. The incumbent may lead smaller scale initiatives and/or work on multiple projects.
PRINCIPAL ACCOUNTABILITIES: Under the general direction of Manager, Business Intelligence, the incumbent’s accountabilities include, but are not limited to, the following:
Under the guidance of senior staff:
? Develop, support and maintain the enterprise data warehouse and the reporting front-end for the high quality decision support and executive information solutions.
? Engage in enterprise-level design, development and testing , including data and dimensional modeling; logical and physical table design; complex queries, stored procedures and triggers; data transformation, aggregation and enterprise application integration; high performance; scalable based designs; data partitioning and clustering; and best practice security design.
? Consult with business partners such as analysts, management and other developers to clarify program objectives, determine scope, identify problems and recommend solutions.
? Work with project lead, developers, analysts, and business users to understand business processes, understand requirements and translate specifications into BI reports/analysis and application/process enhancements.
? Develop, test, and implement efficient and maintainable program logic for existing and new applications in accordance with the technical specifications.
? Generate clear and concise documentation as required within the programs and within the application documentation repository.
? Analyze test runs of applications to correct or direct correction of coded program.
? Develop parameterized reports through from a variety of data sources.
? Maintain, support, enhance and recommend changes to multi-dimensional models while adhering to enforced development methodologies.
? Create ad-hoc queries and reports as requested and provide on-going analytical support for these requests.
? Create test plans, and evaluate testing results taking corrective action as necessary.
? May lead one small scale project/initiative and work on multiple projects/initiatives.
? Monitor performance of assigned system applications, more complex resolving operational abends
? Investigate more complex reported code defects and resolve or recommend a solution.
? Perform database maintenance, including enhancing and maintaining existing database systems to increase operating efficiency or adapt to newer requirements. Prepares documentation and manages revisions.
? Assist less experienced staff members on their assignments and provide them with information about the company business, system details, and complex technical issues.
? Researches emerging technologies, trends and benchmark data to make recommendations to management within or outside of division.
? Identifies opportunities for departmental efficiencies or process improvements and self initiates new SOPs or makes recommendations to management.
This position is also subject to being "on call" for emergency situations requiring immediate resolution. Travel between all company locations may be required.
SUPERVISORY RESPONSIBILITY: May provide coaching and/or mentoring to less experienced members of the team.
SCOPE DATA: Directly accountable for the accuracy and integrity planning, developing, and deploying the extraction, transformation, and loading routine for the data warehouse from multiple data sources. Responsible for the performance, data accuracy and maintenance of the data warehouse. Responsible for ensuring that the end product conforms to industry best practices and is high quality.
? BA/BS in Computer Science, Information Systems, or other related IT field or a certification from technical school or equivalent directly related work experience
? 5-8 years experience with database management systems, ETL systems, business intelligence tools, and systems.
? Development experience in the following: .NET Development Language (VB.NET or C#); .NET Framework (1.1, 2.0, or 3.0); SQL Development (PL/SQL or T-SQL); Technical Documentation; ETL Technologies
? Demonstrated experience solving complex scenarios utilizing SQL Language (either PL/SQL or T-SQL)
? Demonstrated experience in Data Warehouse and Business Intelligence concepts and maintenance utilizing MSSQL and Oracle databases, Business Objects Data Integrator, Informatica, SSIS or other ETL software
? Demonstrated experience in Data Warehouse development concepts (Data Modeling, Database Administration, Performance Tuning)
? Solid understanding of data retrieval, transformation, and data warehousing architectural approaches
? Experiencing training and mentoring other less experienced members of a team.
? Solid interpersonal skills including the ability to build consensus and agreement and bring resolution to contentious issues and entrenched interests.
? Proven ability to lead problem-solving discussions.
? Attention to detail and excellent analytical and problem-solving skills.
? Strong written and verbal communication skills.
? Excellent organizational skills and ability to set priorities and handle multiple projects concurrently.
? Solid PC skills including Microsoft office software such as Word, Excel, and Power Point.
Minimum 3 years experience in the following technologies:
? (MS SQL Server or ORACLE) Relational Database Development
? ETL processes
? SQL Language (either PL/SQL or T-SQL)
1+ years experience in the following technologies:
? SQL Server Integration Services (SSIS)
? SQL Server Reporting Services (SSRS)
? SQL Server Analysis Services (SSAS)
? Demonstrated experience building analysis tools and reports that take advantage of OLAP/Dimensional Modeling capabilities.
? Experience with medical claims/clinical data.
? Business Objects Web Intelligence
? Sharepoint Portal 2003/2007
Note: The incumbent is required to immediately disclose any debarment, exclusion, or other event that makes him/her ineligible to perform work directly or indirectly on Federal health care programs.
The physical demands described here are representative of those that must be met by an associate to perform the essential duties and responsibilities of the position successfully. Requirements may be modified to accommodate individuals with disabilities.
The associate is primarily seated while performing the duties of the position. Occasional walking or standing is required. The hands are regularly used to write, type, key and handle or feel small controls and objects. The employee must frequently talk and hear. The functions of this position may also require physical activity such as bending, stooping and kneeling, as well as lifting equipment of weights up to 50 lbs.
Interested and qualified candidates should apply immediately!!