No more applications are being accepted for this job
- Develops and maintains databases by determining structural requirements, data integration and the means to get to the data, developing and installing solutions
- Primarily responsible for development of SQL data marts, defining database physical structure and ensuring data integrity and functional capabilities.
- Determines appropriate SQL database structural requirements by analyzing operations, applications, programming; and B.I. project objectives.
- Conceive long range Data Warehouse picture, maps the systems and interfaces used to manage data, sets standards for data management, analyzes current state and conceives desired future state, and able to emphasize methodology, modeling, and governance.
- Develops complicated views, stored procedures, implementing appropriate index strategies and query tuning to enhance database performance.
- Writing complex/ efficient SQL queries for data analysis and profiling
- Design/ provide support to create new data models on EDW.
- Develop SSIS solutions to handle external files, connect to other source SQL Server databases.
- Develop SSAS cubes, troubleshoot any issues in existing SSAS solutions.
- Provide documentation of any development work in both technical and business terms.
- Responsible for support, maintenance, training for any metadata tools.
- Maintains technical documentation for all packages, descriptions of the data and data structures including data definitions, metadata, data models, and data flow diagrams.
- Works closely with PowerBI developers and SQL DBAs to ensure database performance, by identifying/resolving production and app development issues.
- Coordinate with SQL DBAs to ensure security and backup policies are implemented and maintained on new objects in accordance with company standards.
- Provides database support by coding utilities, responding to user questions, and resolving problems.
- Supports PowerBI Citizen developers to ensure they have a thorough understanding of the available data and provide updates as needed.
- Assists with design of Business and Presentation layers.
- Performs related duties as required. This position description in no way states or implies that these are the only duties to be performed by the employee occupying this position. Employees will be required to perform any other job-related duties assigned by their supervisor or management.
- Must have a minimum of 7 years of experience in advanced SQL development for BI.
- Strong understanding of data warehouse and business intelligence concepts and best practice methodologies.
- Must have a minimum of 5 years of experience in gathering requirements and developing data warehouse solutions for Business Intelligence.
- Must have a minimum of 7 years of experience with various ETL, metadata and reporting tools.
- Strong problem solving and analytical skills are necessary for this position.
- Must have a minimum of 7 years of experience with SQL Server and allied tools.
- Must have a minimum of 5 years of experience with performance tuning & optimization.
- Must have a minimum of 7 years of experience with source control systems.
- Experience with data modeling.
- Experience with guiding development teams on T-SQL coding and best practices.
- Database administration experience is a plus
- Good working knowledge of Windows operating systems.
- Ability to express complex technical concepts effectively, both verbally and in writing.
- PowerBI experience is a plus.
- Power App's, Data Verse experience is a plus.
- Experience or conversant in emerging tools like columnar and NoSQL databases, predictive analytics, data visualization, and unstructured data a plus.
- Healthcare experience is a plus.
- Competitive compensation
- Health, dental, vision, life and disability insurance
- Pretax healthcare and dependent care flexible spending accounts
- Life insurance
- 401(k) plan with numerous investment options and generous company match
- Cancer and/or critical illness benefit
- Tuition Reimbursement
- Paid Time Off
- Employee Assistance Program
- Legal Insurance
- Roadside Assistance
- Affinity Program
Sr BI Data Architect - Hollywood, United States - VITAS Healthcare
Description
Job Description
All duties and responsibilities are to be performed in accordance with VITAS Healthcare Corporation's policies, procedures, guidelines, contractual commitments, and governmental regulations.
The individual will work with other development teams such as MS D365, Power BI to ensure maximum application performance and availability.
Must have clear communication and work alongside leadership, project managers, software engineers/architects, application developers (.NET) and end users on database development and modifications.
QUALIFICATIONS
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required.
Requirements:
Education:
Bachelor's degree in computer science or related field from an accredited college or university preferred.
Certification & Licensure:
Microsoft Certifications a plus
About Us
VITAS Healthcare is the nation's leading provider of end-of-life care, and has the resources and expertise to support your personal and professional growth.
As a member of the VITAS team, you'll find fulfillment working for a people-focused organization dedicated to making a difference in the lives of others.
You will be more than just an employee:
You will be counted on as an expert in your field, and as a valued team member whose efforts are respected and vital to our hospice mission.
All VITAS employees commit to fulfilling their duties and responsibilities with the highest regard for professionalism, collaboration and teamwork, and an eye focused constantly on growth and improvement.
Benefits Include:
Choose a Career with VITAS
#J-18808-Ljbffr