Business Intelligence Developer

1. Participate and contribute to the Agile and Project Management methodologies through planning to execution (i.e., requirements gathering; decomposition, development, etc.) in support of department or corporate projects.
2. Ability to manage multiple priority projects and shift priorities as needed as well as produce accurate and precise work, detect discrepancies, and resolve discrepancies all while meeting deadlines.
3. Be an organized individual that is willing to accept responsibility, demonstrate good judgment, initiative, and resourcefulness, and can adapt and learn quickly.
4. Participate in design sessions with organizational stakeholders and business owners to design and build data warehouse to meet business requirements.
5. Conduct or participate in meetings with organizational stakeholders to identify and build Infomart architectures that meet business requirements.
6. Conduct or participate in design sessions with key technical and business owners to design reporting and analytical applications that leverage the Infomart's.
7. Full understanding of the Structured Query Language (SQL) with the ability to create complex SQL statements within various data structures.
8. Ability to design, develop, implement, and support SQL products including SSIS packages, Agent jobs, RDLC solutions and more.
9. Lead the development and implementation of data solutions through the creation of data warehouses, data marts, and info-marts while ensuring high levels of data availability including the ETL used to populate those databases.
10. Lead the development and implementation of normalized and dimensional data models (logical and physical) to support reporting, analytics and data integration sources.
11. Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement and will produce guidelines to ensure a manageable infrastructure.
12. Design, create, or modify database tables, indexes, constraints, links, stored procedures, and functions.
13. Develop implementation plans for building target data architecture incrementally, over time.
14. Enforce the change control process for the data architecture artifacts.
15. Mentor and provide leadership to junior members of the team.
16. Develop logical and physical architectural data diagrams
17. Has a deep understanding of one or more major business disciplines with a full understanding of the processes, functions, and operations of the Managed Care Organization (MCO).
18. Able to identify and describe current technology, facilities and equipment, location, products and services for one or more major business disciplines, with an understanding of the technical architecture.
19. Understanding the influence of data, created or used by a department, on operations in the assigned department and the ability to document or investigate issues as to why a certain behavior or outcomes are exhibited through department's data or reports.
20. Strong design skills in creating data solutions, easy to understand data models and business views
21. Develop standards for best practices for data modeling and educating the company on available info-marts and business views.
22. Facilitate meetings or communications as an interface between business units, technology teams, and other support resources.
23. Strong verbal and written communication skills with the ability to interact professionally with a diverse group, executives, managers, and subject matter experts.